Hello all - I'm faced with a situation where a new fee needs to be added post haste (the money train continues to roll on each day) to all tickets going forward. We've established here that the easiest thing to do is to add $1 to an already exiting fee on all our tickets.
I tested it via a sql update on one performance on one zone and things were promising. However, expanding that to an entire production season seems to crash our database. Once the update is done, I cannot access any performances. I've also tried using the Season Manager - Season Maintenance way to update the prices - but that seems to throw an error when updating a goodly number of performances even across just one price type. I've heard rumors of a bug in v12.1 regarding Season Maintenance, so I've dropped that avenue since we cannot upgrade to 12.5 anytime soon due to productions in progress and a relatively new website still undergoing revisions.
This is all done in TEST, mind you - so it's not an emergency.
However, we have 291 performances we need to update with 21 different zones using 30 different price types. Is there a programmatic way to do this or should I just send the box office flowers and have them update the prices manually?
Any ideas? I have a script I've written for the test database - that seems to update the necessary table - which I'd be happy to send to anyone that might be able to help in case there is something in the script that is foul. Any assistance or input is greatly appreciated, all. Thanks!
RJ
Could you use Season Manager - Season Maintenance to add a whole new price layer of your $1 fee to everything? It might seem like a little much to add a whole new price layer to everything just for $1, but it seems like that would work better than updating existing prices as you could just add the layer with all the existing price types and calculate it all up $1 (excluding the comps).
That is just off the top of my head; I am sure there are other solutions.