We're in the middle of our renewal period and our first production of next season cancelled their tour. The bulk of our subscriptions are flex packages. I have a 2 part question.
1. How do I pull a list of patrons who selected that production, even though half of the orders are still unseated and have not created a ticket history record?
2. We have a replacement show. What's the best way to change the production and assign all patrons to the new show? Could I just change the name/date/perf code within the same Production Title/Season/Performance line I have for the original show?
Thanks for your help!
Shelley
I actually found the list by running a T-Stats report and saving it as a list. I remembered it didn’t rely on the ticket history.
So I’m going to test my theory of changing the production name in Tessitura Test. Wish me luck!
Shelley Salinas
Box Office Manager
COCA
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Shelley SalinasSent: Saturday, May 24, 2014 11:08 AMTo: Shelley SalinasSubject: [Tessitura Ticketing Forum] Pull list w/ unseated tickets
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 Shelley,
I've never had a problem with changing date/time/name for performances in those circumstances so you should be right!
With unseated orders, you can also use Order Search (click the chiclet next to Order No field in Ticket Orders) then you can select your filters including unseated/unpaid and then save as a List.
Cheers,
Kevin
Good morning,
I also find the Order Export Utility to be very useful in instances like this.
Cheers!Short
Another thought, although I’m coming to the conversation a bit late (save it for next time, maybe?) –
Use the Order Search screen to return all the paid, unseated orders for that production, filtering by MOS if needed. Save the results of the Order Search as a list. If need be, you can use Cumulative Search to find multiple sets of constituents and append them to one result set.
Coming to this late, but we had a similar issue. We're in the middle of our initial, and unseated, package sales period. We have all flex packages this year, although some times we have a mix of flex and fixed NFS packages, but also we allow the purchase of single ticket "Sub Add-on" tickets with a package purchase, and also certain constituencies are able to buy single tickets. This year we had three performances change time/date after the initial on-sale.
What I did was create manual query dynamic lists for our patron outreach staff to use with extractions. They are very simple, but I think safe for these purposes:
select distinct o.customer_no from T_SUB_LINEITEM as sli inner join T_ORDER as o on o.order_no = sli.order_no where sli.perf_no = [performance number here] -- [Name of Performance for future reference] and sli.sli_status not in (4,7,8,13) -- filter out returns
This allows the staff to build an extraction that manages different contact methods, and have the query run dynamically at the moment the extraction runs to sweep up all the buyers.