Unseated subs-prevent overselling?

Former Member
Former Member $organization

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

  • Hi Jeri,

     

    I’ve sometimes used a general admission/unreserved facility as a fake show, then exchanged into seats later on...  Maybe something like that would work (though it probably is slightly labor intensive)? 

     

    Cheers,

    Kathleen

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Jeri Henderson
    Sent: 25 January 2012 17:46
    To: Kathleen Smith
    Subject: [Tessitura Web Forum] Unseated subs-prevent overselling?

     

    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



    --
    View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/6474/20448.aspx#20448 or reply to this message
    --
    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!

     


    Royal & Derngate’s spring season is on sale, featuring the spectacular The King and I, gripping drama in Mogadishu and the No.1 greatest feel-good musical, Grease.
    Click here to discover more about Royal & Derngate’s 2012 Made In Northampton Subscription Season.


    Book your tickets now by calling 01604 624811 or visit www.royalandderngate.co.uk.

     

    The Northampton Theatres Trust Ltd. Registered in England and Wales. Company Registration No. 3640915. Registered Office: Royal & Derngate, Guildhall Road, Northampton NN1 1DP

     

    Royal & DerngateMission

     

  • Former Member
    Former Member $organization
    Hi Kathleen,
    We considered that initially and might revisit.  Thanks for responding.

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Kathleen Smith
    Sent: Wednesday, January 25, 2012 1:05 PM
    To: Jeri Henderson
    Subject: RE: [Tessitura Web Forum] Unseated subs-prevent overselling?

    Hi Jeri,

     

    I’ve sometimes used a general admission/unreserved facility as a fake show, then exchanged into seats later on...  Maybe something like that would work (though it probably is slightly labor intensive)? 

     

    Cheers,

    Kathleen

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Jeri Henderson
    Sent: 25 January 2012 17:46
    To: Kathleen Smith
    Subject: [Tessitura Web Forum] Unseated subs-prevent overselling?

     

    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



    --
    View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/6474/20448.aspx#20448 or reply to this message
    --
    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!

     


    Royal & Derngate’s spring season is on sale, featuring the spectacular The King and I, gripping drama in Mogadishu and the No.1 greatest feel-good musical, Grease.
    Click here to discover more about Royal & Derngate’s 2012 Made In Northampton Subscription Season.


    Book your tickets now by calling 01604 624811 or visit www.royalandderngate.co.uk.

     

    The Northampton Theatres Trust Ltd. Registered in England and Wales. Company Registration No. 3640915. Registered Office: Royal & Derngate, Guildhall Road, Northampton NN1 1DP

     

    Royal & DerngateMission

     




    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.

  • Former Member
    Former Member $organization
    Great idea, thanks Amanda.


    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Wednesday, January 25, 2012 10:26 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Web Forum] 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.

    From: Jeri Henderson <bounce-jerihenderson2389@tessituranetwork.com>
    Sent: 1/25/2012 11:43:10 AM

    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!