Hello,
In order to combat scalpers we are severely restricting our print at home options - this way we can check tickets before mailing. This is good to combat scalpers but is expensive for us and incoveniant for customers.
I read a PDF about Delayed Digital Delivery https://www.tessituranetwork.com/en/Files/anztruc/2019/Pres/Onsellers-Resellers-and-Scalpers - didn't know if this was an actual function in Tessitura or a fancy customization that was developed for a specific box office.
Would appreciate any feedback.
Hi RJ,
As Heath has mentioned, I developed this as a part of Sydney Opera House’s war or fraud and scalping.
It works by using a dummy PAH delivery method online and a simple SQL script. Happy to share if you are interested.
The initial implementation was quite simple. We built a delivery method called delayed digital delivery which is not a PAH delivery method and enabled this online and for our other sales channels. Then we developed a sql script that on the morning of the event flips the delivery method on all the orders to PAH and send them out.
Further to this we built 2 attributes a white list attribute and a black list attribute. When we applied the whitelist attribute it meant those patrons would get there tickets within 30 minutes of booking them no matter what the date of performance. Used for concierges, VIP's etc. The blacklist meant that no matter what a person with the blacklist would never be sent their PAH. The sql script was then added to to adhere to these new rules and was run every 30 minutes on the database.
After working with this for several months we were able to move some of the rules into the standard workings of our custom website. This now controls what delivery option is available for our white and black list people and we run the sql script once per day at 5am.
Happy to send the SQL script to anyone who wants to explore it, just let me know.
Hi Krystal,
I would love to get those SQL scripts, thanks for being willing to share! We'd probably start with the simpler one too, for just the flipping the delivery method part, although the whitelist/blacklist sounds like a great service as well. My email is scovie@porttix.com.
Thanks again,Sarah
Krystal - would also appreciate some additional info 1) any information on how day of PAH is communicated with customers. The info during the buying process is extremely clear (I took a screen shot for us to refer to) - just wondering if customers still contact you with questions and how you handle that.
2) Any info you can provide on methods that you use for checking for scalpers who order via print at home - particularly interested in how much manpower it takes to do this well. Know it may not be an apples to apples comparison between our box offices but any info you can provide would give us a starting point. Thanks again!