You can upload bulk order data directly into Shippit using a CSV (comma separated values) file. This is especially useful if you have a highly customised or bespoke workflow that doesn't integrate directly with the Shippit platform. This can help to save you time, and minimises the need for manual data entry, helping to reduce errors.
You can download this sample CSV file to use as a starting point.
This article guides you through the various formats and fields to use for a successful CSV upload. For general information and best practices about using CSV, see the understanding CSV and FTP article. For instructions about using an FTP server, see the uploading from FTP article.
CSV file format
All valid CSV files are supported, with values comma separated. For each row in your CSV file, an order is created. Make sure your uploaded CSV does not have duplicate columns with the same header. If you import a file with duplicate headers, it could return an error, or you might find that the first column is uploaded, but all subsequent columns are ignored.
Fields
Field name | Example | Details | Required? |
|
| Any reference number for the order from your source system, such as an invoice number. | Optional |
|
| The full name of the person receiving the package | Required |
|
| A phone number for the person receiving the package | Optional |
| An email address for the person receiving the package | Optional | |
|
| The first line of the address to deliver the package to | Required |
|
| The second line of the address to deliver the package to | Optional |
|
| The suburb or city to deliver the package to | Required |
|
| The state to deliver the package to | Optional |
|
| The postcode of the suburb or city to deliver the package to | Required |
|
| The two-letter country code to deliver the package to | Optional |
|
| Any delivery instructions to provide to the carrier | Optional |
|
| The length of the package, in centimetres | Optional |
|
| The width of the package, in centimetres | Optional |
|
| The height of the package, in centimetres | Optional |
|
| The charged weight of the package, in kilograms | Optional |
|
| The declared value of the product being shipped, in the local currency | Optional |
|
| The description of the product being shipped | Optional |
|
| The tariff or HS code of the product being shipped | Optional |
|
| The total number of the product being shipped | Optional |
|
| Whether or not the package has authority to be left at the recipient's address | Optional |
|
| The carrier service level to use for this order | Optional |
⚠️ IMPORTANT: It is possible to use a CSV file that contains column names that do not exactly match these. In that case, make sure you map the columns appropriately when you upload the file.
Upload a CSV file to your Shippit account
When you have created your CSV file, you can upload it to your Shippit account and see your order in the New Orders page.
💡NOTE: Always use the template as your starting point. This ensures all required fields are present and correctly ordered. For more information on best practices for CSV uploads, see the understanding CSV uploads article.
Uploading a CSV file
Log in to your Shippit account, and navigate to the New Orders page.
Click Import to open the Import Orders screen.
In the Import Orders screen:
Select the store to import the orders to. You can only import a CSV file to a single store at a time.
Select the pickup location for your orders. All the orders in your CSV file must be picked up from a single location.
Click Browse and navigate to your saved CSV file. The file name and size is shown at the bottom of the Import Orders screen. If you upload a file in error, you can click the trash icon to delete it.
Click Next to continue.
Each column in your CSV file is mapped to a field in your Shippit account. Use the preview column to check that these have been mapped correctly. Click Next to continue.
Use the preview screen to double check that the data fields have been mapped correctly.
Click Import to import your orders.
When your orders have been imported, they are available for confirmation and labelling in the New Orders page.
CSV template
You can download this sample CSV file to use as a starting point: