We're looking at running an order import and curious about what happens when a customer has more than one set of contiguous seats. Anyone know off-hand if we will end up with a new order for every row in our import file, or will the utility put all seats for a given customer in a single order?
We'd prefer to end up with different orders in the case when we have more than one row for a given customer. Anyone know if that's the default behavior?
Hi Brian,
I believe from past exp. that separate orders are only created if the import data for that constituent has different order numbers associated to each line in the import file.The documentation seems to suggest this as well.
Data rows are grouped so that multiple rows for the same constituent are added to the same order. If the import_ref_no column (outside order number) is populated, only rows with the same import_ref_no are added to the same order; a constituent with two rows that have different import_ref_nos will have two orders created. If one data row for an order cannot be imported due to failed matches no data rows for that order are imported. When data rows are combined into the same order, only order header data from the first data row is used.
By default, all data rows for the same constituent will go into a single order unless import_order_no has multiple values for the constituent. To break the single order paradigm, you can add this number for real (if you are indeed coming from a third party system) or artificially (if you are just bulk creating orders). If import_order_no is used, orders will be created for each unique constituent and import order no.
+Ryan Creps
+Tessitura Network
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Brian Graham Sent: Tuesday, March 5, 2013 12:29 PM To: Ryan Creps Subject: [Tessitura Ticketing Forum] Order Import with Duplicate Customers
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Thanks Ryans!
I like that work-around of using an artificial import_order_no to explicitly group or un-group orders.