I am using the order import utility for the first time and in the process of preparing my file.
The data I have comes from another Tessitura user organization that used the order export utility to create the file for us.
I'm seeing some discrepancies in the number of seats column and I'm not sure if they're actual errors or if there is an explanation.
Here's an example:
seat start=10, seat end = 24, number of seats = 4
In this particular venue the seat numbers go up by 2 so if the start is 10 and end is 24, I count 8 seats.
For most of the rows the number of seats is correct but I'm seeing a few hundred discrepancies in a spreadsheet of several thousand rows.
Is there an explanation for this? Is this something I need to fix before the import?
Dale
I haven't dealt with this specific scenario, this is just off the top of my head and might be totally off base, but we do occasionally have some people with say 4 seats in the same row, but they're not contiguous, a pair here, a pair there. I would have expected the export to show two lines for such an order, one for each pair, but could that be the case with some of those orders? Have you checked on any specific example orders with the exporting org to see if there were actually 4 or 8 seats?
It might be a workaround to ask the org to re-export it with single seats output instead of seat ranges?
Thanks Amanda. I think I'm going to run this in our Test database to see what happens but I'm not hopeful.
Also should I be concerned that some cases the first seat number is higher than the last seat number?
My best guess is that would be due to how they have their seat map and contiguity set, but I would definitely check with whoever sent you the file.