1. Home
  2. Docs
  3. Advanced Shipment Tracking
  4. Import tracking from CSV

Import tracking from CSV

With the bulk upload feature you can use CSV file to add tracking information to multiple orders at once. This is useful as you can update many orders at the same time with tracking numbers rather than having to go into each order individually to add tracking info.

Preparing the CSV file

The CSV file contains 5 columns, you must use the same column headers names and include all columns:

  • order_id – WooCommerce order id
  • tracking_provider – Shipment Provider – the provider names must match the name in the shipping providers settings.
  • tracking_number – Tracking code / number
  • date_shipped (Optional) Shipping date – Date format DD/MM/YYYY – if not added, we set the upload date.
  • status_shipped (0=no,1=shipped,2=partial shipped(if partial shipped order status is enabled)) (Optional) Change order status to “Shipped” (completed) or “Partial Shipped” – if this field in null, we will treat it as 0.

We recommend using the following CSV editors:

  • Online spreadsheet editor Google Drive / Docs
  • Free spreadsheet app in OpenOffice
  • Free Calc app in LibreOffice

If possible, avoid Microsoft Excel due to formatting and character encoding issues that will fail your upload.

You can download a sample CSV file for example of the correct formatting:

Download the CSV FIle
CSV File Format

Uploading the CSV file

Import CSV file from computer (browse button)

Replace tracking info if exists? (checkbox – optional) please note! If checked, we will delete all other tracking records from this order and replace them with the new tracking info, (if not checked, the tracking info will be added)

You can choose Date Format for CSV import

  • dd/mm/YYYY
  • mm/dd/YYYY

Bulk Upload with the Tracking per item add-on

If you are using Tracking Per Item Add-onTracking Per Item Add-on you can Bulk Import tracking info using Product SKU and Quantity, for detailed instructions, check the Tracking Per Item docs

Bulk Upload and Custom Order Numbers

Some plugins do not use the WooCommerce order_id (post id) and use custom fields instead for the order numbers.  we added compatibility and you can use the custom order numbers in the CSV file in the order_id column for the following WooCommerce custom order numbers plugins:

1.) Custom Order Numbers for WooCommerce

If this plugin is activated and from WooCommerce settings options is enabled for WooCommerce Custom Order Numbers than you can use custom order number in bulk import instead of default order id.


2.) WooCommerce Sequential Order Numbers

If this plugin is activated than you can use custom order number generated by this plugin in bulk import instead of default order id.

3.) WP-Lister Pro for Amazon

If this plugin is activated and Use Amazon Order Number is set as Yes in Amazon settings than you can use custom order number generated by this plugin in bulk import instead of default order id.

Was this article helpful to you? Yes 1 No 2

How can we help?