[starcentral]

What is the trick to get sales orders imported via CSV?

To import one sales order with two line items I’ve tried setting my Line ID to 1 for the first item, and 2 for the second item but I end up with two different sales orders for this customer?

Any help would be great.

thanks,
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

Set the External ID field of the Sales Order. All lines for the same SO should use the same External ID.

[hbeltejar]

This can be achieved by using multiple files for the upload.

on the csv file, set the External ID field of the on both files, ensure that the links for the items is using the same external ID

> Import the file using Multiple Files upload for Import Type = Transaction, Record Type = Sales Order

> Choose the primary file for “Primary File – Sales Order”

> Choose the secondary file for “Linked File (Optional) – Sales Order Items”

> under File Mapping stage, ensure that you have set the correct PRIMARY FILE KEY COLUMN

[Author]

Posts