Greetings!
So here is my problem and I hope someone out there in the Tessitura world can assist me.
We perform at different venues each year. We have our 4 mainstage productions every year that we are able to roll our subscribers into. We also perform a couple of productions at different smaller venues each year.
What my leadership team wants is to build our season with all 6 productions into a super package and invoice our subscribers for all.
My issue runs into the variety of venues. I'm building new facilities every season.. new houses. So I don't have anything to roll from.
Example:
Next season we are going to be performing once again at a brand new venue. I don't currently have the specifics to build the new facility and probably won't have them until mid October.
We will be announcing our new season in January so that is a very short time period for me to complete this.
Is there anyone out there who might be able to put me in the right direction with a plan and a how to?
Thank you in advance!
~Renee Smiley
Atlanta Opera
Kevin Sheehan Tagging you in this because I found a post from 14 years ago you responded to! Wanted to see if there was anything more current you might be able to assist with
Hi Renee,
I'm currently assisting one of our consortia members on this right now. There are a few options that depend on your org's business practices and at what point in the process you want your subs to determine their seating.
You can: 1) Complete an order import in advance of your rollover seating the patrons into a "dummy" performance that you then use as the source for your rollover. The order import process is pretty straightforward, so it reduces the friction of having to load each order and seat.
2) Roll the patrons into dummy performances. As they renew, you confirm their date/time/seats for the real performance and exchange them out of the dummy and into the real.
3) Roll the superpackages and let them fail. In the application, it will load the additional SLIs needed and you can seat from there. Note, this means the renewal will be incomplete and I have no idea what this will do on the web. But it works in the applicationI think there might be some other creative solutions, but I'd recommend either 1 or 2. Happy to help answer any additional questions!
Best,
Katina
Hey Katina,
I have considered the dummy order, however since I don't currently have the new facility --- and won't for another 6-8 weeks -- not sure if that will work for me. Your #1.. complete an order import in advance of rollover seating... can you elaborate on that?
Then the order import probably isn't going to help either, but the idea is that instead of manually seating each patron, you use the Order Import utility to create "dummy" orders in the facility that assigns their seating so you have a source for your rollover. However, since you don't have the facility yet, this option probably isn't helpful...How does the Atlanta Opera decide what seats folx get year over year if the venue changes? Is that decided by you/your team or does the patron pick seating when they renew?
Regarding #3, it is definitely possible to roll over things that fail, seat them, and then reset them for online ordering. We do that every season for a some orders. However, it DOES require a little bit of SQL. At least, that is the only way I know how to do it. Assuming you are using hosted services, you might be able to get support to reset those orders for you, but I have never asked.
They select the section and we seat them (into the new facility). They renew their same seats at the mainstage venue.
Good to know! We have a custom site in Pittsburg and I always forget to mention that...
I don't have anything new to add, unfortunately. You may want to open a help ticket just to see if support has some ideas for you.