Good Morning!
Due to the rest of our season being cancelled, there have been many ticket returns. We have been giving our patrons 3 options:
1. Donate tickets
2. Receive Box Office credit for a future performance
3. Refund tickets
Option 1 - Patrons receive an acknowledgement letter thanking them for the donation
Option 2 - Patrons receive our word that the money has been put on their account as credit
Option 3 - Patrons are notified that the refund will show in their bank account within 5-7 business days
As you can see, option 2 has no official communication to indicate the money is on their account as credit. Does Tessitura have the capability to issue Box Office credit receipts? Similar to ticket confirmation receipts, that can be sent to patrons automatically?
Thank you in advance for your help/feedback.
We have also been putting ticket credit On Account rather than issuing gift certificates, just so we could have a bit more control of eligibility and expiration of those funds. Our creative solution to generate 'receipts' for that credit was to create an attribute that auto-calculates nightly with the value of a constituent's On Account balance for that particular payment method, and then we use a custom output set to bring that in as a dynamic value to Wordfly (we also set up attributes to crunch the value of donated tickets and refund amounts since COVID began). Then using Wordfly's conditional blocks we could set up a single email template that pulls in the various donation/credit/refund values and presents them neatly to a patron with instructions on how to use their credit, tax info for donations, and so on.
That's clever!
Would you be willing/able to share the sql for the nightly calculation and the output set elements you used? I'd love to see the wordfly template too!
A couple of my colleagues tackled the actual coding of things - I'll see if I can bundle things up in a nice shareable format!