Hi, I'm trying to import orders via template. How do I format this if I want to import orders that have multiple order lines?
I haven't actually tried it, but give this a go!
You want one row per line item. Any fields which are part of the order itself (like Shipping Address) should be repeated for each line item. You can specify an Order ID column, in which case that will be used to link together line items for the same invoice. But it's usually easier to have your own column with a sequential number (so 1 for all the line items in the first invoice, 2 for all the lines in the next etc), in which case you map that column to "Group Orderlines By" on the import and Neto will generate the Order ID itself.
There are a heap of useful settings on the import template controlling how Neto handles new or invalid products, customers and other fields. Have a look through those to tailor the import how you want.
Do small test imports first!
