Unseated subs-prevent overselling?

You'd need someone with sql skills, but you could have a scheduled job that runs nightly (however frequently deemed appropriate to prevent overselling) that checks how many total sublineitems are booked both seated and unseated, and if it passes a certain threshold ends the applicable mode of sale on the pkg. Or if the concern is really zone specific, that puts holds on all the seats in a given zone so that the web couldn't sell it. Something like that.

We are working toward going live with TNEW and encountered an issue.  We will sell subscriptions as unseated so the ticket office can assign seats but doing this allows for unlimited sales per zone and sales beyond capacity.  Does anyone have a creative solution?  Any non-manual ideas would be greatly appreciated.

Thanks

You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

You'd need someone with sql skills, but you could have a scheduled job that runs nightly (however frequently deemed appropriate to prevent overselling) that checks how many total sublineitems are booked both seated and unseated, and if it passes a certain threshold ends the applicable mode of sale on the pkg. Or if the concern is really zone specific, that puts holds on all the seats in a given zone so that the web couldn't sell it. Something like that.

We are working toward going live with TNEW and encountered an issue.  We will sell subscriptions as unseated so the ticket office can assign seats but doing this allows for unlimited sales per zone and sales beyond capacity.  Does anyone have a creative solution?  Any non-manual ideas would be greatly appreciated.

Thanks

You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!