GIFT CERTIFICATE BATCH PRINTING

Hello,

Over the holidays we had some issues with patrons not receiving gift certificates purchased over the web. We noticed that this was due to the fact that the gift certificates were not printing out in our web batch prints. Currently, we have our gift certificates setup without an order line item. Instead, we handle gift certificates through a gift certificate payment method.

How do other organizations setup their gift certificates in Tessitura? Does anyone use a line item method? Does anyone know a way to have non-line-item gift certificates that are strictly handled with payment methods only print out with web batch prints?

Thanks for the help!

 

Mike

SBCPA

  • We had the same thing. The only way I know of web gc purchases is by viewing the online confirmation emails that are copied to me.  Then I manually open that order and print ‘All’ receipts.  Our volume is small enough to handle this way.  But I’d love to know of a more foolproof manner as well.

     

    Shelley Osburn

    Systems Services Manager

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Mike Below
    Sent: Tuesday, January 13, 2015 2:17 PM
    To: Shelley Osburn
    Subject: [Tessitura Ticketing Forum] GIFT CERTIFICATE BATCH PRINTING

     

    Hello,

    Over the holidays we had some issues with patrons not receiving gift certificates purchased over the web. We noticed that this was due to the fact that the gift certificates were not printing out in our web batch prints. Currently, we have our gift certificates setup without an order line item. Instead, we handle gift certificates through a gift certificate payment method.

    How do other organizations setup their gift certificates in Tessitura? Does anyone use a line item method? Does anyone know a way to have non-line-item gift certificates that are strictly handled with payment methods only print out with web batch prints?

    Thanks for the help!

     

    Mike

    SBCPA




    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, Shelley! This has been our method in the past – but it’s not always as fool proof as we’d like. Thanks for the input!

     

    Mike

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Shelley Osburn
    Sent: Tuesday, January 13, 2015 1:10 PM
    To: Michael Below
    Subject: RE: [Tessitura Ticketing Forum] GIFT CERTIFICATE BATCH PRINTING

     

    We had the same thing. The only way I know of web gc purchases is by viewing the online confirmation emails that are copied to me.  Then I manually open that order and print ‘All’ receipts.  Our volume is small enough to handle this way.  But I’d love to know of a more foolproof manner as well.

     

    Shelley Osburn

    Systems Services Manager

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Mike Below
    Sent: Tuesday, January 13, 2015 2:17 PM
    To: Shelley Osburn
    Subject: [Tessitura Ticketing Forum] GIFT CERTIFICATE BATCH PRINTING

     

    Hello,

    Over the holidays we had some issues with patrons not receiving gift certificates purchased over the web. We noticed that this was due to the fact that the gift certificates were not printing out in our web batch prints. Currently, we have our gift certificates setup without an order line item. Instead, we handle gift certificates through a gift certificate payment method.

    How do other organizations setup their gift certificates in Tessitura? Does anyone use a line item method? Does anyone know a way to have non-line-item gift certificates that are strictly handled with payment methods only print out with web batch prints?

    Thanks for the help!

     

    Mike

    SBCPA




    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!




    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!

  • You may try having a CSI generated when a gift certificate is ordered. In the past that has worked for me assuming you have someone making sure to check regularly and resolve the CSI's after they've been printed.

  • We've created a custom report that is scheduled and runs over night that shows all GC's purchased in a ticket order that does not contain any tickets.  Since these don't get picked up by our normal batch printing process, we needed a way to find all of these.  The box office lead hand on duty goes through the list each morning and prints them all for mailing.

    Michele

  • For sure.  I'll ask our report writer to gather all the info and will post when I have it.

    Michele

  • Michele,

    Would you be interested in sharing this report?

     

    Thanks,

    Janna

    Janna.ellis@yale.edu

     

    Janna Ellis

    Director, Yale Tessitura Consortium

    203-432-8822

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch
    Sent: Thursday, January 15, 2015 9:08 AM
    To: Ellis, Janna
    Subject: RE: [Tessitura Ticketing Forum] GIFT CERTIFICATE BATCH PRINTING

     

    We've created a custom report that is scheduled and runs over night that shows all GC's purchased in a ticket order that does not contain any tickets.  Since these don't get picked up by our normal batch printing process, we needed a way to find all of these.  The box office lead hand on duty goes through the list each morning and prints them all for mailing.

    Michele

    From: Maurice Nounou <bounce-mauricenounou6335@tessituranetwork.com>
    Sent: 1/14/2015 1:46:02 PM

    You may try having a CSI generated when a gift certificate is ordered. In the past that has worked for me assuming you have someone making sure to check regularly and resolve the CSI's after they've been printed.




    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!

  • We would be interested in checking out the report as well, if it's not too much to ask! :)


    Thanks!
    Short 

  • Michele, this sounds great!  Could I also get in on the sharing?  Thanks!

  • I would also like to see this one.

    Sadie

     

    Sadie Prater
    Business Intelligence Analyst
    214.443.1024 office | 214.443.1060 fax

    The Dallas Opera | dallasopera.org | 214.443.1000 ticket office
    Winspear Opera House | 2403 Flora Street, Suite 500 | Dallas, TX 75201

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher Short
    Sent: Tuesday, March 03, 2015 12:32 PM
    To: Sadie Prater
    Subject: RE: [Tessitura Ticketing Forum] GIFT CERTIFICATE BATCH PRINTING

     

    We would be interested in checking out the report as well, if it's not too much to ask! :)


    Thanks!
    Short 

    From: Janna Ellis <bounce-jannaellis6942@tessituranetwork.com>
    Sent: 1/15/2015 3:03:01 PM

    Michele,

    Would you be interested in sharing this report?

     

    Thanks,

    Janna

    Janna.ellis@yale.edu

     

    Janna Ellis

    Director, Yale Tessitura Consortium

    203-432-8822

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch
    Sent: Thursday, January 15, 2015 9:08 AM
    To: Ellis, Janna
    Subject: RE: [Tessitura Ticketing Forum] GIFT CERTIFICATE BATCH PRINTING

     

    We've created a custom report that is scheduled and runs over night that shows all GC's purchased in a ticket order that does not contain any tickets.  Since these don't get picked up by our normal batch printing process, we needed a way to find all of these.  The box office lead hand on duty goes through the list each morning and prints them all for mailing.

    Michele

    From: Maurice Nounou <bounce-mauricenounou6335@tessituranetwork.com>
    Sent: 1/14/2015 1:46:02 PM

    You may try having a CSI generated when a gift certificate is ordered. In the past that has worked for me assuming you have someone making sure to check regularly and resolve the CSI's after they've been printed.




    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!




    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 all,

    I've added the pbl and the sql files to my profile:

    http://www.tessituranetwork.com/Community/members/michelekeutsch5100/files/default.aspx

  • Thanks, Michele.  Any chance you can include a screenshot of the report?  I'll need to build this in SSRS so seeing what you've produced would be awesome!

  • Hi Jenny,

    I've added a screen grab this morning.

    Michele