• Replies 7 replies
  • Subscribers 416 subscribers
  • Views 171 views
  • Users 0 members are here
Related

Ticketing for Online event accessed by unique codes

Donald Graham
$organization
Hi all,

We are looking for anyone who can offer help or advice for a request we have got from our programming team.

We are looking to sell for a online event on Tess/TNEW which we can sell as a normal general admission event. We then need to somehow get to customers who has bought a place a unique, special 16 digit code so they can access the event online. What is tricky is that the codes we need to send to customers are provided by the producers of the event. I.e. they can't be something that comes directly from Tess automatically (like a ticket number). The producers provide the codes in advance of the event going on sale.

We also want to get the code to the customer asap after they have made the purchase, although the event itself is at a set time and date. We want to be able to sell right up until the event starts (ideally until 30 min before).

If anyone has found a good way to do this, or something similar, for any events they are ticketing for it would be great to hear a rough outline of how you did it!

Many thanks,

Donald
Parents
  • $organization

    Hi Donald,

    We are doing something extremely similar! We are about to go live with this tomorrow actually. What we have done to solve this is that I created a couple of custom tables in the database to store the codes given to us and to store their assignments to patrons. I then created a custom procedure that takes in a lineitem id, checks to see if a code has already been assigned to that lineitem, and if not, maps it to the next available code. Then to get this procedure to execute as soon as possible after a patron purchases a ticket, I call it from within the order confirmation (we are using the new HTML template format) and it then returns the code for the patron to see in the order confirmation. Since most of this is done in SQL, you'll need to have some proficiency (or someone else in your organization) to set this up. Let me know if you have questions or want to talk further!

    Sara

Reply
  • $organization

    Hi Donald,

    We are doing something extremely similar! We are about to go live with this tomorrow actually. What we have done to solve this is that I created a couple of custom tables in the database to store the codes given to us and to store their assignments to patrons. I then created a custom procedure that takes in a lineitem id, checks to see if a code has already been assigned to that lineitem, and if not, maps it to the next available code. Then to get this procedure to execute as soon as possible after a patron purchases a ticket, I call it from within the order confirmation (we are using the new HTML template format) and it then returns the code for the patron to see in the order confirmation. Since most of this is done in SQL, you'll need to have some proficiency (or someone else in your organization) to set this up. Let me know if you have questions or want to talk further!

    Sara

Children
No Data