Web Promo Codes

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

  • Hi

    This is my quick How To list that I refer to if I think I've missed a step, hopefully it should point you in the right direction:

     

    1.    Create a source code in Appeals, ‘Outside’ type. Ensure the end date is either blank, or the end of the promotion.

    2.    The price type you use for the promotion must not be available in the default web MOS otherwise everyone will be able to access it.

    3.    Create your promotional MOS for the web if it is not yet created.

    4.    Link the price type to the promotional web MOS in TX_MOS_PRICE_TYPE.

    5.    Enable the price type and MOS for the web user.

    6.    Assign the promotional MOS to the Allocation map if it hasn’t already been assigned.

    7.    Add the price type and MOS to the performance as usual.

    8.    Add the MOS to the fee rules if a fee should be added.

    9.    Enable the MOS for the relevant Extras/Dining performance.

    10.    Link TR_WEB_SOURCE_NO to the Source Code created and the MOS you want it the promotional code to be available in. Then name the promotional code – this will be the word or number that should be typed in on the website to access the special MOS. The parent key is Tessitura Web.   

     

    Good luck!


    Siobhan x

  • We're using web offers now, but I remember creating my own checklist from a solution Bob Bell provided to someone who submitted a ticket on this a few years ago.  I can't find my checklist, but found Bob's pearls of wisdom (below):

    “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.



    Kevin Hahn wrote:

    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.

  • I have a few things to add to the discussion.

     

    First, the document in question is Mode of Sale:

    http://www.tessituranetwork.com/~/media/Documentation/Ticketing/Mode_of_Sale.ashx

    This document explains both setting up web promotions (change mode of sale based on source) and offers (unlock price based on source).

     

    The tips from Bob Catherine sited are a little out of date.  The big thing that has changed is that you can now add offers to multiple performances from Season Maintenance, so now it is easy to use offers for discounts on many performances.

     

    A small thing in Siobhan’s post I wanted to touch on is that you don’t have to use an outside source for web promotions or offers.  Both in-house and outside sources can be used.  Great tips though on troubleshooting everything else about the web promotion setup process, though.

     

    Using offers and promo codes (words associated with sources) both require that the appropriate Web API calls are used on your website.  If your website is older (maybe four or more years old) and has not been updated as new features were added, you may not be able to use offers or promo codes.

     

    Finally, promo codes (words associated with sources) can be used with both web promotions and offers.  If you don’t want to change the mode of sale when someone enters a source but do want to associate a source with a word, just add a row to TR_WEB_SOURCE_NO for the source in question with the default web mode of sale selected.  Oh, and a nice new v9 feature is that your ticketing operators can now use that word to find the source in the application; there is a new promo code search field on the source selection window.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

  • Thanks for all your help! I've got it up and running..

  • Former Member
    Former Member $organization

    Hi Kim

     

    One thing that comes to mind. Is the price type associated with the Web users group in Security?

     

    Rich

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kimberly Kornegay
    Sent: 08 August 2012 17:05
    To: Richard Surgay
    Subject: [Tessitura Ticketing Forum] Web Promo Codes

     

    I am trying to set up a web promo code but when I go out to test the code and purchase tickets on the web, it's not working. I added the offer in the MOS tab in the performance. I selected the price type, appeal and source associated with the code. The start and end dates are entered and I linked the price type to the MOS in the TX_MOS_PRICE_TYPE table. I also linked TR_WEB_SOURCE_NO to the source code created and the MOS i want the promo code to be available in. Is there anything else I'm missing? 

     

    Kim Kornegay

     




    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!



    Nottingham Playhouse - World Class Theatre Made in Nottingham
    Wellington Circus
    Nottingham
    NG1 5AF

    Tel: 0115 947 4361 (Admin)
    Tel: 0115 941 9419 (Box Office)
    Fax: 0115 947 5759

    Find us online: - www.nottinghamplayhouse.co.uk
    Follow us on Twitter - @SkyMirror
    Like us on Facebook - facebook.com/nottinghamplayhouse

    Nottingham Playhouse Theatre Company Coming Soon:

    Grandpa in my Pocket - Teamwork!
    13 July - 11 August
    The popular CBeebies television series comes to the stage for the first time - can Grandpa save the day?

    The Importance of Being Earnest
    31 August - 22 September
    A timeless and much-loved comic masterpiece from Oscar Wilde with some of the wittiest wordplay ever volleyed over cucumber sandwiches!

    Diary of a Football Nobody
    5 - 20 October
    A frank and funny warts-and-all tale of football in the 1970s.

    See our full programme at www.nottinghamplayhouse.co.uk/whats-on/

    Consider the environment - don't print this email unless really necessary
    http://www.ivaluethearts.org.uk/

    This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information that is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily represent the views of Nottingham Playhouse.

    ANY OFFER CONTAINED WITHIN THIS EMAIL DOES NOT CONSTITUTE A CONTRACT

  • Security access for the Web API user to the MOS and the price type?

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

  • Former Member
    Former Member $organization

    And the Start & End Dates are within range on the Source, the MOS, and the Price Type?

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Richard Surgay
    Sent: Wednesday, August 08, 2012 12:19 PM
    To: Nicole Keating
    Subject: RE: [Tessitura Ticketing Forum] Web Promo Codes

     

    Hi Kim

     

    One thing that comes to mind. Is the price type associated with the Web users group in Security?

     

    Rich

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kimberly Kornegay
    Sent: 08 August 2012 17:05
    To: Richard Surgay
    Subject: [Tessitura Ticketing Forum] Web Promo Codes

     

    I am trying to set up a web promo code but when I go out to test the code and purchase tickets on the web, it's not working. I added the offer in the MOS tab in the performance. I selected the price type, appeal and source associated with the code. The start and end dates are entered and I linked the price type to the MOS in the TX_MOS_PRICE_TYPE table. I also linked TR_WEB_SOURCE_NO to the source code created and the MOS i want the promo code to be available in. Is there anything else I'm missing? 

     

    Kim Kornegay

     




    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!

     


    Nottingham Playhouse - World Class Theatre Made in Nottingham
    Wellington Circus
    Nottingham
    NG1 5AF

    Tel: 0115 947 4361 (Admin)
    Tel: 0115 941 9419 (Box Office)
    Fax: 0115 947 5759

    Find us online: - www.nottinghamplayhouse.co.uk
    Follow us on Twitter - @SkyMirror
    Like us on Facebook - facebook.com/nottinghamplayhouse

    Nottingham Playhouse Theatre Company Coming Soon:

    Grandpa in my Pocket - Teamwork!
    13 July - 11 August
    The popular CBeebies television series comes to the stage for the first time - can Grandpa save the day?

    The Importance of Being Earnest
    31 August - 22 September
    A timeless and much-loved comic masterpiece from Oscar Wilde with some of the wittiest wordplay ever volleyed over cucumber sandwiches!

    Diary of a Football Nobody
    5 - 20 October
    A frank and funny warts-and-all tale of football in the 1970s.

    See our full programme at www.nottinghamplayhouse.co.uk/whats-on/

    Consider the environment - don't print this email unless really necessary

    http://www.ivaluethearts.org.uk/

    This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information that is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily represent the views of Nottingham Playhouse.

    ANY OFFER CONTAINED WITHIN THIS EMAIL DOES NOT CONSTITUTE A CONTRACT




    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!

  • I followed your instructions and now the offer is available to everyone on the site. I want them to be able to put in a code word in order for them to access this price type. Any suggestions?

  • In order for a price to be available on the web, the API user must have security access to it.  From there, you use offers and/or modes of sale to control who has access to the price.

     

    To lock price type with an offer, you must add the offer to whichever modes of sale the price type should be accessible from.  The offer dates must span the entire time price type is active; outside of the offer active dates the price type will be accessible without having to enter the source for the offer.  Also, if you aren’t shifting modes of sale, when setting up your promo code, be sure to select the default web mode of sale.

     

    If you have multiple web modes of sale and you only want the offer to be accessible from some of them, you must either not associate the price type with those other modes of sale or add a different offer to those modes of sale that locks the price types with a source code that your constituents don’t have access to.

     

    You may want to check out the Tessitura and the Web document for more instructions.

     

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com