CSV Import
The CSV import tool allows you to bulk import tracking information to orders from CSV files. To use the CSV import tool, navigate to:
WooCommerce > Shipment Tracking > CSV import
Preparing the CSV file
The CSV file contains 5 mandatory columns and 2 optional, you must use the same column headers names and include all the mandatory columns:
The CSV file contains 5 mandatory columns, you must use the same column headers and include all columns:
| ATTRIBUTE | TYPE | VALUE | DESCRIPTION |
|---|---|---|---|
| order_id | string | WooCommerce Order ID (i.e 12345) | compatible with a few Custom Order Numbers plugins |
| tracking_number | string | Tracking number | |
| tracking_provider | string | Shipping Provider Name | the name must match the provider name on the shipping providers list. |
| date_shipped | date | DD/MM/YYYY or MM/DD/YYYY | Date when package was shipped. Optional – keep Blank to use the import date. |
| status_shipped | int | Do Not Change – 0 (null) Completed (Shipped) – 1 Partially Shipped – 2 Shipped – 4 | Update the order status and send the shipping confirmation email |
*The Tracking Per Item feature is available in the AST Pro
Please avoid Excel when you create or edit the CSV files since it adds formatting and character encoding to the CSV files and that can cause issues on the import. We recommend using the following CSV editors:
- Google spreadsheets (Google Drive)
- Free spreadsheet app in OpenOffice
Example of CSV file:
You can download a sample CSV file:
Import the CSV file
- Upload the CSV file from your computer
- Choose if you would like to override the existing tracking details for the orders or to add the tracking in addition to existing tracking numbers
- Choose the Date Format in the CSV file, you can choose between 2 formats – dd/mm/YYYY or mm/dd/YYYY
- Click continue to start the import process, once the import completes you will get a detailed report of any issues in the import.
Upload the CSV file, choose import settings and click continue to start the import:
The import will begin and will display the status of the imported tracking numbers:
Once the import completes you will get a detailed report of any issues in the import: