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
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
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!
Thank you guys for this. Just got us out of a jam... 2 years later!
Julie StantonMarketing Director, Chicago Shakespeare Theater
2 years and 3 months later and this post is still getting Chicago Theaters out of jams!
Can anyone report back on how long it should take to see donated seats available online after making the change?I just added Best Seat Donated Seats to T_DEFAULTS and set it to Yes. I rushed straight to our website to see if it worked, and it hasn't yet. Do I have more work to do or do I just need to calm down for a little while?