Hi!
I'm in a pickle. We have several local community groups who we have created separate promo codes assigned to them all with the same source number. We are now trying to track who bought what and finding it difficult. Basically, we want to know the promo they entered, not the source code.
We had each unique promo code trigger the same mode of sale switch and activate the same price type, all of which are called the same thing and again do not tell us the unique promo code that was entered and our only way of tracking the group that made the purchase.
Aside from creating multiple sources, one for each group and having the box office go crazy trying to find the right code to match the right group in case someone calls to buy tickets on the phone, is there another way of doing this?
We have a cool custom report that shows us the comp codes connected to price types and use this frequently, but it doesn't help us track online sales at all since none of them have comp codes.
Thanks in advance. I will personally hug you at the conference if you can help me get this figured out!
Hi Tiffany
Unfortunately for what you're trying to do, I think Beth is absolutely correct here. The promo code is really just a sort of alias for the source code, as far as the system is concerned. When a web user logs on with a promo code, the website will just use it to look up the matching source code, and then throw the promo code away and use the source code from then on. It doesn't bother remembering what the promo code was. Unless you wrote code into your website to record the promo code itself into the order notes, or one of the custom order fields, it will no longer exist anywhere.
But really, that's what source codes are supposed to be for - to identify the source of the transaction - so even though they might blow up a bit, using them to report is deeply built into Tess, so it makes sense to use them in the way they're intended to be used, and thereby get the full benefit from them.
Ken
From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com> Sent: 8/6/2014 5:33:35 PM
Hi Tiffany,
I'm sorry to say I don't have a solution for your current dilemma. As far as i know, only the source number is stored and not the specific promo code they entered. I hope that I'm wrong and someone is able to provide some assistance!
What I can say is that having multiple sources doesn't need to be a huge hassle. We do it very often here. As long as the promo code is entered in TR_WEB_SOURCE_NO (which it sounds like you're doing if you offer them online) then your box office staff can search for that specific promo code and choose that specific source. When you open the source window in the order screen there is a Promo Phrase Like box at the bottom. If you enter the promo code there it will remove all sources that are not attached to that promo code. No digging through trying to find the right one!
It does take a bit of extra setup from the source code side of things but it's not too terrible and we haven't had any problems with this method so far.
Hope that helps and good luck!