Facilities with reserved and GA sections

We are wanting to setup a map that would offer reserved seating in a main floor and loge sections, but then we would want to offer general admission tickets to a balcony section if possible. Our original thought was just to create a third screen on the map with a block section, the same way we would setup a GA house. However, we would only be able to use a single best seating map for said performance,and we wouldn't want to check off the GA Ind. box for it. I'm assuming this would create an issue if we wanted to sell the GA tickets online. Has anyone done this before? Do you know of any problems this might cause? How would TNEW handle it, if was wanted to sell the reserved on an SYOS but GA through the best seating section?

Our other concern is that we use different ticket designs for reserved seating as compared to GA. The reserved, of course, displays all seating info on the side of the ticket. The GA simply says General Admission in the seating section area of the ticket. The only way we could think of to sell 2 different ticket types for one performance is using different price types each associated to a different ticket design. Does anyone know of another way to use a single price type to display one ticket design when sold in a certain section and another design when sold in a different section?

Parents
  • Thanks for the advice. It seems like everyone somewhat does them the same way. We are new to Tessitura, so we're still on TNEW, but we may look into a custom ticketing site in the future. We might just contact TNEW ourselves to see what options we have in regards to the SYOS map on the website.

    However, I did have one more question about the ticket designs. Like I said, we're new and we haven't had a chance to play around with masks and custom design elements, with exception to the custom tab from the orders, but we only use that for headers. The documentation on the website is not very extensive on the masking for ticket designs. We use Section Additional Text1 and Section Additional Text2 for the section design elements. Our plan was that when the Section Additional Text1 said General Admission, it would leave the Seat Row and Seat Number elements Null. Would anyone have any pointers on how to accomplish this, or know where we can get more information on how the custom maskings work?

     

  • Hi Jesse,

    I thought I'd share some of the code from our LP_TICKET_ELEMENTS stored procedure.

    If @ude_no = 4 and @customer_no > 0 and @design_type = 'T'
    select  @ude_value =
    (case when(select s.seat_row from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) in ('U','UU','TBC') then ''
    else (select s.seat_num from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) end)

    If @ude_no = 5 and @customer_no > 0 and @design_type = 'T'
    select  @ude_value =
    (case when(select s.seat_row from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) in ('U','UU','TBC') then 'Unres'
    else (select s.seat_row from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) end)

    If you (or a systems admin) can add this to your procedure then, if the row letter is U, UU or TBC...

    • 'User Defined Element 4' on your ticket design will be blank (for any other value it'll display the row letter)
    • 'User Defined Element 5' on your ticket design will show 'Unres' (for any other value it'll show the seat number)

    You could amend this so that it looks at the section text and change what is displayed based on that.

    Let me know if you need any further help.

    Graeme

     

Reply
  • Hi Jesse,

    I thought I'd share some of the code from our LP_TICKET_ELEMENTS stored procedure.

    If @ude_no = 4 and @customer_no > 0 and @design_type = 'T'
    select  @ude_value =
    (case when(select s.seat_row from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) in ('U','UU','TBC') then ''
    else (select s.seat_num from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) end)

    If @ude_no = 5 and @customer_no > 0 and @design_type = 'T'
    select  @ude_value =
    (case when(select s.seat_row from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) in ('U','UU','TBC') then 'Unres'
    else (select s.seat_row from T_SEAT s join T_SUB_LINEITEM l on l.seat_no = s.seat_no where l.sli_no = @cur_sli_no) end)

    If you (or a systems admin) can add this to your procedure then, if the row letter is U, UU or TBC...

    • 'User Defined Element 4' on your ticket design will be blank (for any other value it'll display the row letter)
    • 'User Defined Element 5' on your ticket design will show 'Unres' (for any other value it'll show the seat number)

    You could amend this so that it looks at the section text and change what is displayed based on that.

    Let me know if you need any further help.

    Graeme

     

Children
No Data