Remove Donated Ticket Seat Status

We had something similar happening and received the following answer which helped.  This is a setting in your T_DEFAULTS table and is easy to fix.

========================

This might be the issue?  From the T_Defaults documentation:

BEST SEAT DONATED SEATS

This optional setting allows seats donated back for resale to be considered as Available for the Best Seating procedures.  A value of 'Yes' will make such seats available.  The default setting, 'No' will ensure that the system works as it did previously, ignoring Donated for Resale seats for Best Seating.

================================

Hope it helps.  We also had to make a change to the TR_SEAT_STATUS table to make sure that donated seats that we actually wanted to hold were not sold online.  We had to follow these instructions from an earlier posting:

===============================

From the Hold Codes document:

By default the Donated for Resale status takes precedence over the Held status, so that if a hold code is applied to a Donated for Resale seat, the seat will not appear held.  This also means that if a hold seat is sold and then Donated for Resale, it will not appear as held on the seat map.  This setting can be changed, if desired, from the TR_SEAT_STATUS table.

To allow seats donated for resale to be held, change the status priority for “Donated for Resale” (id 18) from “75” to “15”.

You should never make any other changes in the TR_SEAT_STATUS table, though.

================================

Good luck,

Elizabeth Carlock

Director of Ticketing Services

The Granada Theatre 

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Maurice Nounou
Sent: Thursday, October 18, 2012 4:22 PM
To: Elizabeth Carlock
Subject: [Tessitura Ticketing Forum] Remove Donated Ticket Seat Status

Hey,

We have some seats which were donated, however our website doesn't show these tickets for sale because their seat status shows as donated. Is there a way to remove this status and revert the tickets back to available. I do not want to reverse the donation itself, just simply the status.

Thanks,
Maurice

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Casey –

Having never done this before, I’m grasping at straws just a little bit, but I would check two things:

·         If your website uses a different Parent Table, you might make sure the entry in T_DEFAULTS references that correct table (we’re in a consortium, but we have a “First Stage” parent table that affects things in the client, and a “FSCT WEB” parent table that  affects things online).

·         If your website caches Tessitura data like ours does, there might be a cache page that you have to clear. Ours does and sometimes changes don’t seem to take effect until that happens. Your web team would know about this.

If neither of those helps, I wish you best of luck to find the solution! J

-p.

Patrick Schley
Academy Services Manager

FIRST STAGE

Transforming Lives Through Theater

325 West Walnut Street | Milwaukee, WI 53212
(414) 267-2942 direct | (414) 267-2976 fax

Thanks again, Patrick!

We needed to tell our API to recognize seats with status 18 (Donated for Resale, found  in TR_SEAT_STATUS) as available.

Hopefully in another 2 years, knowing that will save someone some time J

-Casey