Order Import with Duplicate Customers

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?

Parents
  • 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. 



    [edited by: Ryan Rowell at 12:15 PM (GMT -6) on 5 Mar 2013]
Reply
  • 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. 



    [edited by: Ryan Rowell at 12:15 PM (GMT -6) on 5 Mar 2013]
Children
No Data