Hi all,
Today's question is about ticket limits. Can you tell me if there is a way to enforce ticket limits - either by line item, order or constituent? The only place I can think of that asks for a limit is in an offer, but are there others? I think I know that we need custom code to make this work on the website, but can limits be enforced through the application?
Thanks in advance for your wisdom.
Lesley
Hi Lesley,
The only way to enforce ticket limits in the application is through offers. So if an offer is on the MOS and Price Type and a ticket limit set your users won’t be able to reserve more tickets per line item. To use this functionality you must also make a change to the T_DEFAULTS table by adding an entry of ENFORCE_SEAT_LIMIT_FOR_ORDERS with the value set to Yes.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
I don’t know if you received an answer about this or not, but the ticket limits are enforced at the time of seating. Unseated orders can be created and saved with quantities that would violate the limit.
Gregg Stickney
Application Support Specialist/Manager Knowledgebase
+1 (888) 643-5778, ext. 318
+1 (330) 835-4507
+1 (888) 643-5778, ext. 201 (Support Line)
www.tessituranetwork.com
gstickney@tessituranetwork.com
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lesley Chaney Sent: Thursday, September 09, 2010 5:01 PM To: Gregg Stickney Subject: RE: [Tessitura Ticketing Forum] Ticket limits?
Hi Kevin,
That's what I thought. So, what am I not doing right??
I set up an offer, attach it to the performance and add it to the TR_WEB_SOURCE_NO table with all of the appropriate MOSs. If I enter the source code before processing anything else on the order, and then add a lineitem, it defaults to the correct pricetype for the offer (which implies to me that the offer is working). However, if the limit for the offer is 4, I can still purchase 6 or more tickets. I did check the Enforce_Seat_Limit table, and it is set to yes. What have I missed?
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin Sheehan Sent: Wednesday, September 08, 2010 12:20 PM To: Lesley Chaney Subject: RE: [Tessitura Ticketing Forum] Ticket limits?
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 actually had not replied yet, but that’s exactly what I was going to say. The only other thing to add is that the T_DEFAULTS entry has to be ENFORCE_SEAT_LIMIT_FOR_ORDERS. Lesley, you wrote that what you have ENFORCE_SEAT_LIMIT. That might have just been a time saving abbreviation for your post, but I figured I should double check just in case.
According to the version 9 release notes, “the web API code does not enforce this limit automatically.” I tested and found that with everything set up as you described, the limits are enforced through the application, but not on the web. If your issue is with web orders, I think you will need to contact your web developers.
Lisa
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Gregg Stickney Sent: Friday, September 10, 2010 10:42 AM To: llindvall@cfl.rr.com Subject: RE: [Tessitura Ticketing Forum] Ticket limits?
The v10 release now enforces ticket limits through the Web API as well:
1476
Internet
The ticket limits functionality that was added to the Tessitura client application in v9.0 has now been added to the web API. Methods that reserve seats, change mode of sale or change price type will now return an error if the change would violate one of the ticket limit rules set up in Offers. (Network 2009 Enhancement #3696)
Enhancement
(hoping the formatting carries through from email to the forum)
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lisa LindvallSent: Wednesday, September 15, 2010 4:17 PMTo: Ryan CrepsSubject: RE: [Tessitura Ticketing Forum] Ticket limits?
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Gregg StickneySent: Friday, September 10, 2010 10:42 AMTo: llindvall@cfl.rr.comSubject: RE: [Tessitura Ticketing Forum] Ticket limits?
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lesley ChaneySent: Thursday, September 09, 2010 5:01 PMTo: Gregg StickneySubject: RE: [Tessitura Ticketing Forum] Ticket limits?
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin SheehanSent: Wednesday, September 08, 2010 12:20 PMTo: Lesley ChaneySubject: RE: [Tessitura Ticketing Forum] Ticket limits?
In the meantime, the limit value configured on the offer is returned via the API - just not enforced, so you could create front end code to limit the user entry based on the limit value returned.
Hello Kevin -
We would like to create an offer whereby the first 30 people who order tickets to a performance receive a free cd.
We would like to send out an email notifying people of the offer and perhaps have them enter a promo code.
Would that be the best way to achieve this?
Is there a way - via a Promo code - to cutoff such orders after the first 30 orders have been done?
And is it possible to pull a list of just these orders - ordered with the promo code.
Finally is there anyway to craft and send an automatic message to the people who have ordered with the promo code confirming the winning of the cd with any special instructions.
thank you,
Sure - all of that is posssible:
1. Create an offer - set the limit and make sure you use a unique appeal and source2. Run your list to look for orders with the appeal / source3. You can create and send order confirmation emails (see appendix of API documentation). These are highly customizable.4. The automatic email may require some custom website work - namely determining if the promo code was used and if so send the appropriate confirmation email from step 3.Those are the broad strokes Good luck!
There is no way to cut off an offer after a certain number of tickets has been sold. The ticket limits functionality on offers is applied per order (technically per line item), not across a performance as a whole. If you set it to 30 that means you could purchase a max of 30 tickets per order with that offer. Beside all of that, your offer is for the first 30 people who purchase, not the first 30 tickets. I was thinking about adding a CD performance that has only 30 seats that gets unlocked with the promo code, but there wouldn’t be a way to enforce that they also buy tickets to the real performance, at least not without custom web coding.
The only way I can think of to handle this without some custom web coding is to manage the CDs after the fact. So create and promote your source, let however many people want buy tickets, and then go back and generate a list of the first 30 people who bought tickets and manually send them an email saying they won the CD. To get your list of the first 30 people to respond, I would create a list of people who have the promotion for the source and who purchased tickets to the performance. Then stick that list into the Single Sale Order Listing report for the performance in question and sort the results by Created Date. Then just note the first 30 constituent IDs and stick them into a new list to pull the contact data for your email. (If you have a SQL resource it would also be pretty easy to run a query to get you the first 30 all in one step) Unless there is a special price involved with this deal, there really is no need to create an offer and force the constituents to enter a promo code. As long as you promote the source, you can use that promotion to pull the list of people who received the offer. This also assures that you don’t miss anyone who forgets to enter the promo code, which people will if there is no consequence to not entering it (i.e. you don’t get the right price or access to the right performance).
There may be more sophisticated, automated ways of doing this, but they will require custom web coding which is out of my area of expertise and may require more time and money than you have.
+1 888 643 5778 x 329
I'm pretty sure I stole this from someone else a couple conferences ago but I don't remember who. When we've wanted to cut off a promo after a certain number of responses, we've just had a scheduled job that runs periodically, checks how many customers have used the source, and if it's at or higher than the limit it changes the end date on the offer and the pricetype (if it involved a special pricetype) so neither will be available anymore. It's not perfect, since depending on how frequently the job runs and how quickly people respond you might end up slightly over your limit, but it's handy and easy and does not require custom web coding.