Synopsis
What is the file format for importing shipping tracking numbers in the admin site?
Procedure
In order to import tracking numbers through the Orders->Shipping Import/Export option in the admin site, the CSV file has to be properly formatted. The file should be 3 columns, with no headers.
- The first column should be either Y or N, indicating whether or not the order has been voided.
Note: This will not appear on ML 7.1.1.0+ and can be ignored.
- The second column is the order number *
- The third column contains the tracking number from the shipping carrier
Examples:
This applies to ML 7.1.0.0 and below
Y 100004 234987234234311
N 100031 923498723423312
N 100032 122342374230117
While this applies to ML 7.1.1.0+
100004 234987234234311
100031 923498723423312
100032 122342374230117
* The software appends a "-#" to the end of order numbers if you do a shipping export (ex: 100004-1). The extra number is the record ID of the shipping address for that order, from the Address table. The import file will work with or without that appended value.