Super Packages & renewals

Hi.

My question is specifically for those organizations who have at one time been dealing with a single house, Fixed Seat Package and are now using multiple venues in a Super Package season.

What tips or suggestions can you provide since we cannot rollover our Super Packages from season to season - how do you function and structure your renewal data so that it is accurate for the Renewal Invoices since we can't use Tessitura.

I am continuing a practice that I started last year, our first moving from Fixed to Super.  I run a list of all current subscribers and populate it in the Customer Data Export Utility - this gives me their patron information as well as their previous seating information for the season in each different configuration.

I take that and save it into an Excel spreadsheet.  I have to manually go in and clean the list so that seating information from the current season will be correct for the upcoming season.  I also manually add pricing information, since it will change from current to the upcoming season.  Then once I have all that information in a spreadsheet I do a simple mail merge onto a Word document so that the fields I want populate where I want on a blank renewal document.

This is EXTREMELY time consuming, especially since our sub base has grown so much.  Is there an easier way to do this?  Maybe a way that utilizes Tessitura that I am not aware of?

It was so much nicer to have the rollover functionality, but since it's not available with Super Packages it makes it difficult to be accurate and precise with our renewals.

Also, do you still utilize a paper renewal or do you also utilize the Online Renewal functionality even though with a Super Package, non-rolled over renewal it would appear that patrons are purchasing a new subscription online?