max tickets per performance

Yes, please.

Janna

Sent from my iPhone

On Oct 26, 2011, at 5:42 PM, "Patrick Drew" > wrote:


Hi Amanda,

This is a challenge for my organisation as well, could you please share with me too?

Thanks,

Patrick.


From: Adrienne Steer >
Sent: 10/26/2011 3:50:40 PM
Thanks Amanda.

That sounds like a great workaround. Any chance you’d be willing to share the script?

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amanda Freeman
Sent: Wednesday, October 26, 2011 4:07 PM
To: Adrienne Steer
Subject: Re: [Tessitura Ticketing Forum] max tickets per performance


We've done this in the past by having a sql job that runs really frequently and checks how many were purchased and if it's at or past the threshold it changes the end date on the offer for the perf in question to the current time. It's not perfect since technically in between someone could make one purchase that puts the whole thing over the limit, but we've been lucky enough so far that people haven't all purchased in a mad rush at once, and I don't think it's ever actually gone over. It's better than nothing.
From: Adrienne Steer >
Sent: 10/26/2011 2:39:21 PM

I have seen this question asked a few times but don't see an answer to it.

Does anyone know if it is possible to set a max number of tickets that can be purchased through an offer for a performance overall? I have a sponsor that gets 20 tickets per performance at a special discount, and they want to be able to offer this as a promo code to their employees. I know how to block how many a particular person can purchase, but don't see a way to set a max for a performance.

Any help is appreciated!

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
Adrienne Steer | Patron Services Manager
Kitchener-Waterloo Symphony | kwsymphony.ca
Conrad Centre for the Performing Arts
36 King St W | Kitchener ON N2G 1A3
519.745.4711 x 278
asteer@kwsymphony.on.ca



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!



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!

Yes, please.

Janna

Sent from my iPhone

On Oct 26, 2011, at 5:42 PM, "Patrick Drew" > wrote:


Hi Amanda,

This is a challenge for my organisation as well, could you please share with me too?

Thanks,

Patrick.


From: Adrienne Steer >
Sent: 10/26/2011 3:50:40 PM
Thanks Amanda.

That sounds like a great workaround. Any chance you’d be willing to share the script?

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amanda Freeman
Sent: Wednesday, October 26, 2011 4:07 PM
To: Adrienne Steer
Subject: Re: [Tessitura Ticketing Forum] max tickets per performance


We've done this in the past by having a sql job that runs really frequently and checks how many were purchased and if it's at or past the threshold it changes the end date on the offer for the perf in question to the current time. It's not perfect since technically in between someone could make one purchase that puts the whole thing over the limit, but we've been lucky enough so far that people haven't all purchased in a mad rush at once, and I don't think it's ever actually gone over. It's better than nothing.
From: Adrienne Steer >
Sent: 10/26/2011 2:39:21 PM

I have seen this question asked a few times but don't see an answer to it.

Does anyone know if it is possible to set a max number of tickets that can be purchased through an offer for a performance overall? I have a sponsor that gets 20 tickets per performance at a special discount, and they want to be able to offer this as a promo code to their employees. I know how to block how many a particular person can purchase, but don't see a way to set a max for a performance.

Any help is appreciated!

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
Adrienne Steer | Patron Services Manager
Kitchener-Waterloo Symphony | kwsymphony.ca
Conrad Centre for the Performing Arts
36 King St W | Kitchener ON N2G 1A3
519.745.4711 x 278
asteer@kwsymphony.on.ca



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!



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!