Ticket Ballot - Restricting Tickets to Ballot Winners via Web

Hi All We are holding a ballot for one of our most popular productions but have yet to find a solution to restricting web tickets to ballot winners only. The solution we are looking for should restrict tickets for purchase by using the winners' web login/constituent account only. There can be no promo code or link that they can share with their friends and families. They've won the tickets therefore they must purchase them using their National Theatre web log-in or lose out. I've being exploring the use promotions via Extractions (which we are using to select our winners) but without pricing rules (we are on 12.1) I can not find a way to use promotions or indeed source codes without providing a code or link. Has anyone else been in a similar situation and found a solution for this? Or know a way around this? Very many thanks in advance Lee-Anne
Parents
  • We do something similar for when people win the ballot for LNOP which might work. At a really basic level they sign up via an Interest, and then we do a SQL select to get a random selection of people who "win". We then (via SQL) add a ranking to their account, which triggers a MOS swap to enable the MOS for the relevant performance. We remove the ranking once they've booked/ when the time period they can book for expires. If it sounds like something you want to look into further, then let me know and I can give you more info. Caryl
Reply
  • We do something similar for when people win the ballot for LNOP which might work. At a really basic level they sign up via an Interest, and then we do a SQL select to get a random selection of people who "win". We then (via SQL) add a ranking to their account, which triggers a MOS swap to enable the MOS for the relevant performance. We remove the ranking once they've booked/ when the time period they can book for expires. If it sounds like something you want to look into further, then let me know and I can give you more info. Caryl
Children
No Data