Cross-posted to ticketing/technical
Hi all,
I have a "fun" conundrum: for a number of our upcoming productions, we are selling some tickets through a third party organization, which sends us compiled manifests after they sell the tickets. I then used the manifest data and import the orders with the order import utility. After that, I used the automated seating utility (no documentation in this, but it works great!) to seat them. I've been doing for the last couple of weeks and we now have about 200 orders with about 300 tickets in the system from this third party.
Yesterday, though, we got an unpleasant surprise: the third party had been sending us the wrong price the whole time ($36 and it should have been $38). All the orders imported so far were imported at $36 per ticket, so now the revenue numbers are about $600 off.
Aside from smacking these guys upside the head, does anyone have an idea for some simple options to fix this en masse, without manually editing each one?
Thanks,
Sheila