Advanced Order Export CSV fields
CSVs exported via Advanced Order Export are a little bit different from those you may be familiar with. Most headers in the CSV file are self-explanatory: There are columns for Order ID, Date, Time, etc.
There are some new fields in this file to note, though. The ItemData fields contain bar (|) delimited data for each item in the order.
- Item name
- Item ID
- Code
- Quantity
- Price
- Page ID (which is almost always the same as the item ID)
If one item was in the order, only ItemData_1 will contain data. If two items were in the order, ItemData_1 and ItemData_2 will contain data, and so on.