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
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.