In the Report: Gift Certificate Batch Printing, I am trying to find a way to label the gift cards that are being sent via e-mail, to eliminate them from being reprinted and used twice. Are there any indicators that I can use to segregate between the e-gift cards and the gift cards being printed? Thank you in advance!
Hi Heather,
In our online shopping cart, we do have a specification of a delivery method (see attached). I guess my question is how can I make this delivery method appear in Tessitura?
Thanks!
Matthew Cohen | Web Developer | matthew.cohen@strazcenter.org
David A. Straz, Jr. Center for the Performing Arts | STRAZCENTER.ORG
P.O. Box 518 | Tampa, Florida 33601-0518
O: 813.222.1091 F: 813.222.1057
Follow us: strazcultureshock.blogspot.com | twitter.com/strazcenter | facebook.com/StrazCenter
From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Heather Kraft Sent: Wednesday, November 14, 2012 2:38 PM To: Cohen, Matthew Subject: Re: [Tessitura Shared Reports Forum] Gift Card sent by E-mail indicator in Reports
Hi Matthew -
Well then, I'd definitely look at using Delivery Method on an order to indicate they want it emailed -- assuming this is the same way you mark mailed vs picking up at the box office.
Do note - you'd still have to create a way to pull them in a list via a custom keyword.
HTH,
Heather
From: Matthew Cohen <bounce-matthewcohen4792@tessituranetwork.com> Sent: 11/14/2012 12:51:36 PM
In the past we only had the options of mailing a gift card, or, picking it up at the box office. The e-gift card is a new concept, which is currently in place, and we will be using this feature, along with the other gift card options moving forward. We are currently not flagging an order as email deliverable if the gift card is being e-mailed. I am looking for some way to flag the e-gift card orders so our Box Office can see this.
Thank you for your help!
- Matthew
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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!
Ah - well the delivery method that would be up to your Web API code. In theory, if you do it right, your web code should mark a gift certificate as printed if you automatically email them from your system at time of purchase online. If that is the case then when you are running that gift certificate report you could run for reprint 'No' and it should exclude any previously printed (or emailed) gift certificates.
Again, this is all stuff that would have to be handled by your web API and could either be questions directed to the TNEW forum group if you are a TNEW client or to your web implementor.
When I run the gift certificate report with reprint 'No' selected, it is including the e-gift certificates. I just need a way to determine whether it is an e-gift card or if the gift card is being picked up at the box office. We can determine the gift card is being mailed when a shipping fee is added to the order. Before the e-gift card came into effect, we could determine the gift card was being picked up at the box office because there were no shipping fees added to the order, but now the e-gift card is showing up the same way as pick up at box office due to no shipping fees being applied to the order. Help? I hope this all makes sense!
Thanks,
Matthew
It makes sense - however, most of what you are asking for should be handled by web code. Since it sounds like it isn't, then you do have some fun involved.
What you would hope happens in your web code (it sounds like) is two-fold:
1. If they ask for email delivery it would flip the delivery method in the order to a new delivery method
2. It would mark those gcs as printed
Of course, this all takes time, effort and most likely money. However, if your website isn't marking these gift certificates in ANY way in Tessitura as having something different about them you are obviously not going to be able to distinguish those GCs.
Does that make sense? This question should be first posed to whomever is in charge of your website to find out if they flag the order in any way.... Without that flag there's not much you can do from the Tessitura end.
- Heather
It looks like our web code is not flagging the orders in Tessitura. The only way Box Office determines gcs are being shipped is if a shipping fee was added to the order.
Out of curiousity, does your organization offer the functionality I am looking for? I am in charge on our website and might be helpful if I spoke to your colleague who is responsible for your companies website. If not, no worries I'll try to research further :)
Thank you for steering me in the right direction.
We do have a similar functionality, but we built it around older functionality that involves CSIs for our box office (which you could do as well, but is not the way I'd recommend if I were doing this from a clean slate).
The other place you could look is to see if when you email the gift certificate it flags the email in the Alt Address area on the order. If it did that you could possibly look for orders GC with that set.
I'm the website liaison gal for our org - we use an outside company for our integration (not POP or TNEW).
Good luck!
The Alt Address area on the order is being flagged with an e-mail address, however, it is being flagged on all transactions, even the non-email gift cards.
What about the delivery field in the order details? They are all showing up mail. Any idea on how to change that to e-mail for an e-gift card order?
Hey Matthew -
Delivery option would be handled by a web api call in your web code. I don't know the particular call off the top of my head, but you could poke around in the documentation or wander over to the web forum and ask there.
Cool, thanks Heather