• Replies 10 replies
  • Subscribers 414 subscribers
  • Views 335 views
  • Users 0 members are here
Related

Bulk print gift certificates - Event Cancellation Utility

Katherine Beaulieu (Past Member)
$organization

Hi Everyone, 

I know this seems like an old issue, but it has just become a very big one for us and maybe someone out there has found a work-around...

With the new Event Cancellation Utility we are now able to return tickets in the original order and put the amount on a gift certificate, which is amazing! However, we now have almost 2000 gift certificates which need to be printed and no way to do this in bulk (we are on TNEW v6, have our gift certificates as receipts and don't use InfoMaker, so the bulk gift certificate utility will not work for us). This is a lot to do order-by-order!

Has anyone out there come up with a super clever way to batch print receipts or mass re-send email confirmations?

Thanks!

Parents
  • $organization

    Hi - 

    If you use an email marketing application such as Wordfly, Mail2/Prospect2, or MailChimp, you can export the information from Tessitura (email address and gift certificate number) and email it to members in bulk, merging the GC_no field into the email. 

    There are a couple ways to get this information out of Tessitura -

    1. The Event Cancellation Utility can save the results of a run to a CSV, and that can include the email and GC_no. 

    2. You can still use the Batch GC Print Utility to mark them as printed and export the results to CSV, which you could have include email address as well. https://www.tessituranetwork.com/Help_System_v151/Content/Gift%20Certificates/Batch%20Printing%20Gift%20Certificates.htm

    Lastly, in the next service pack being released in the next day or so (15.1.9/15.0.16) there will be a bulk HTML Email utility that will allow you to bulk send things like this with HTML templates. If that is an option, keep your eyes open for the announcement about 15.1.9/15.0.16 in the next 1-2 days (based on current progress). 

    Thanks, 

    Chris Szalaj

    Tessitura Network

  • $organization in reply to Chris Szalaj

    Hi Is there a way to exclude certain gift certificates from being printed in the Batch Gift Certificate Print Utility? We are using this utility in the way suggested in option 2 above (saving as CSV and sending through WordFly) in order to send gift certificates to patrons who opt to have their cancellation funds applied to a gift certificate. The problem we are running into is that if someone purchases a gift certificate online, they are also showing up in this report. When a gift certificate is purchased on our website, the PDF of the gift certificate is sent automatically but the gift certificate is not marked "printed" in Tessitura. We have been manually reviewing the report every week to remove anyone who already received their gift certificate but would love to find a way to automate.

    Thanks
    Jess Levy
    San Francisco Opera

  • $organization in reply to Jess Levy

    Hi , unfortunately there is not. I entered an enhancement that would allow a GC to be marked printed when purchased and emailed via the API so that it would be excluded from the Batch Print function. There may be a way to identify GCs purchased via a web batch, and to subsequently mark them printed so they don't get scooped up with the utility - this would be a custom job though as a bridge until we have functionality to actually mark them printed when purchased via the web. 

    Thanks

    Chris

Reply
  • $organization in reply to Jess Levy

    Hi , unfortunately there is not. I entered an enhancement that would allow a GC to be marked printed when purchased and emailed via the API so that it would be excluded from the Batch Print function. There may be a way to identify GCs purchased via a web batch, and to subsequently mark them printed so they don't get scooped up with the utility - this would be a custom job though as a bridge until we have functionality to actually mark them printed when purchased via the web. 

    Thanks

    Chris

Children