Hi.. I'm trying to build my first Web Promo Code, and am running into problems left and right. Does anyone know if there is a document out there that lists the steps to building a successful Web Promo Code.. I have not been able to locate one in the Knowledgebase.. and am getting pretty desperate..
Thanks in advance
“There are two primary ways that discounts are offered via the Tessitura web API. The first is Promotions (a source code entered upon login triggers a MOS shift which then exposes alternate/discount price types to web) which is what you are are describing. While you can use promotions for a small number of performances or packages, they most lend themselves to broad, season-wide types of discounts. This is for a few reasons. First, you can use Season Maintenance to quickly apply the promo MOS en masse to performances and packages whereas you cannot yet do this "broadcast" application with Offers (discussed below). The second is that MOS controls visibility of performances and packages on the web so if you apply the promo MOS to only a few discounted events, the calendar will be sparsely populated, which you found out. If you are discounting a lot of events, promotions make sense. As one example, you might offer 10% off of all summer concerts. This could be a good use of Promotions because it involves many performances and it will be easy to set up via Season Maintenance. Another reason to use a promotion/ MOS shift is if you are offering special seating allocations via source code or perhaps access to performances not offered under the general web MOS. Offers are the other primary way discounts are created online. Offers also respond to source code entered upon login but in this case, they trigger a price type change within a given MOS. This means a lot less set-up work for you if you are going to be discounting a few performances... for an email blast for instance. This means that the constituent can go to the website, log in with promo code, then be eligible to get the discounted price type on specific performances while still shopping in the regular web MOS and therefore the regular web calendar. Offers are set up at the Production Elements level for a particular performance (Offers button in the MOS tab) or at the Package level (again, at the MOS tab). Important to note with Offers: you will need to work with your web development team to implement Offers because they require the use of GetPerformanceDetailWithDiscounting/ GetPackageDetailWithDiscounting API methods to return the Offer price types and your web app may not currently be set up to use these. There is nothing to preclude you from using Offers for even the season-wide discounts if you wanted to. Currently applying offers through Season Maintenance is not available so you need to set up each performance/package Offer individually. Refer to the Tessitura Web API Planning and Management documentation located in the "Documentation- Web API" folder for more details about these options.”
2. QUESTION ABOUT “OFFERS”
Q: I'm having some difficulties figuring out how to make the "offers" button work for the web without turning on the price type for the whole MOS. From what I understand here is what we have to do to add an "offer" promotion to the web MOS:
-1. Create a source code. Add that source code to TR_WEB_SOURCE_NO
-2. This is the step that I think is confusing things. In order to be able to click on the web MOS in a performance and add a new price type (say half off for this example) I have to add it to TX_MOS_PRICETYPE. However, when I do this, it suddenly makes the pricetype available for anyone buying with the web MOS. So confusion aside, we add the price type to tx_mos_pricetype. -3. Go into an individual performance, click on the web MOS and click on the offers button. -4. Add the price type (from the drop down that lists pricetypes associated in tx_mos_pricetype), appeal, source, offer info if we have it, etc. But now we're stuck. Because the offer is there, but we see it whether or not we use the promotion code. I've read all the docs I could find on this, and it seems like I am missing a critical piece.
A: You are doing the steps correctly. Two things, first, if this is the first time you are using the "offers" button to create online promotions, your website may need to be adjusted to accommodate this. "Offers" uses two different web methods than does the standard way of offering discounts online. Here are the web methods used: GetPerformanceDetailwithDiscounting GetPackageDetailwithDiscounting. Just so I understand your specific problem, you say that as soon as you add the price type to the TX_MOS_PRICETYPE table, it becomes available online. Since what secondary price types display on your website is determined by your web code as well, it sounds like it may be worth contacting your web integrator. All price types associated with a given MOS will be returned in the GetPerformanceDetail and GetPackageDetails web methods, and it is up to how your site is coded to either display these prices or not.
3. WEB PROMOTION - HOW TO:
To utilize the Web API promotion code feature, you will need to add a row in the TR_WEB_SOURCE_NO table which associates the promotion (source) code with the MOS that the use of this source code will place the web customer in. You would add this entry through Tessitura system tables, entering in the source code number for the promo code in the 'Source No' column and selecting the MOS from the MOS dropdown that use of the promo code will place the customer in. When a customer logs in with a promo code, this table is checked, and the subsequent order will be made with the promo code's MOS, overriding the default Web MOS. I would suggest that you search the AIM Knowledgebase for 'TR_WEB_SOURCE_NO' which will return one entry addressing this table and the use of rankings on the Web. I suggest this only as additional background in how customers can be given access to special seats and pricing. The promo code feature will work as long as the entry in the TR_WEB_SOURCE_NO table is made as described. While perhaps supplying more information than was asked for, I will add that if a new MOS is added to Tessitura for use with the Web promo code, you will need to allocate seats to the new MOS in order that seats can be sold using it. Below are instructions for performing this task: 1) Go to Ticketing Setup/Facility Manager. 2) Select the Holds/Alloc Maps tab. 3) Press the Maintain Allocation Codes button. 4) In the top part of the window that opens, click on the row that says "Default" (it's probably the only row.) 5) In the bottom part of the window, hit the Add button and in the new row that appears select the new MOS you have added. 6) Hit the save button and close the window. This procedure must be done each time a new MOS is added in Tessitura. I will close this ticket, but should you have further questions, please feel free to reopen the ticket.
Hi.. I'm trying to build my first Web Promo Code, and am running into problems left and right. Does anyone know if there is a document out there that lists the steps to building a successful Web Promo Code.. I have not been able to locate one in the Knowledgebase.. and am getting pretty desperate.. Thanks in advance -- View this message online at: http://www.tessituranetwork.com/COMMUNITY/forums/p/1092/3564.aspx#3564 Catherine Goodwin Ticket Operations Harbourfront Centre 235 Queens Quay West Toronto, Ontario M5J 2G8 Office: (416) 973-4000 x 4850 Fax: (416) 954-0366 cgoodwin@harbourfrontcentre.com www.harbourfrontcentre.com heart of toronto's waterfront Harbourfront Centre A 10-acre public trust powered by the creative cultures of Canada and the world.