Step 1. Download our template
If you’re sending parcels domestically download our domestic only template. If you’re sending parcels internationally or both internationally and domestically, download our domestic and international template.
Step 2. Open our template as an XLSX file
Open the template using a spreadsheet program like MS Excel, Numbers or Google Sheets. Save and rename it, so it is still an XLSX file (e.g. myorders.xlsx).
Step 3. Open your eCommerce platform’s CSV file
Step 4. Match the field labels in your file to those in our template
Copy the relevant column data from your eCommerce CSV file to the corresponding columns in your newly created XLSX file (myorders.xlsx).
Note: Make sure you don't overwrite or change the first row in your renamed XLSX file - this contains the column names we need to import your orders.
As eCommerce platforms use a variety of naming conventions, you'll need to map the data in your eCommerce CSV file to the correct columns in our template. For example, your CSV file may have a column called ‘Customer Address’, so you'll need to copy and match that data across the following fields: Deliver To Address Line 1, Deliver To Suburb, Deliver to State, and Deliver To Postcode fields in the renamed XLSX file (e.g. myorders.xlsx).
Use our CSV guides to help you match each column:
Make sure your XLSX file (e.g. myorders.xlsx) doesn't contain blank rows and that each column header is unchanged from our template.
If you don’t want to import certain rows of data, insert a hash symbol (#) as the very first character in the rows to be skipped.
Step 5: Upload the updated XLSX file and upload it for import
Once you've copied the relevant data from your ecommerce CSV file to your renamed XLSX file, you'll need to save it as a CSV file (e.g. myorders.csv). You're now ready to upload the file into the system.