Help !!!
Just been asked about 40mins ago to set up an offer on the web - and we have hardly
read the documentation let alone got our collective heads around this BUT so far I have managed to set it all up following the documentation and our website now recognises
the promotion code but will not take me to the performance. If enter our website and
ignore the promotion code I can proceed to buy tickets. Whether I login or not, if I use the
promotion code i get the message "although ... is on sale, the performance is not currently available ..." or words to this effect. I checked all the dates, appeals, source codes pricetype_MOS etc and the price type is available in security - any other suggestions please
Darrell
Hi Darrell,
Good day.
Maybe you need to setup source (in appeal from Campaign).
I am not very clear about this part.
If you don't have souce_no or source is expired, promotion code wouldn't work.
good luck.
Ben
DOH !!!
just found that the promo code works with the source code ID number but NOT with the name of the promo code !! any simple way to reverse that?
HI Darrell,
What do you get from WP_GET_SOURCE_NO?
This sql statement can be captured by sql profiler.
source_no is int type. you cannot do anything.
web api WP_GET_SOURCE_NO
ALTER PROCEDURE [dbo].[WP_GET_SOURCE_NO] @sessionKey varchar(64) = null,@promo_code varchar(80) = null,@source_no int = null
You need to confirm @promo_code get the value, not the @source_no.
ben
Hi
Have you connected the source number to the promotion code in TP_WEB_SOURCE_NO? And have you made sure your promotional web MOS is available in allocations?
Siobhan
As Siobhan said, you have to make sure the source code (the number) is associated with the promo code (the word) in TR_WEB_SOURCE_NO. The other thing you should check is to see if your website is coded to use promo codes (words). They can’t be passed directly to the login methods. The GetPromoCode method must be used to translate the word to the number.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com