How do I import Tracking Numbers via CSV File?

  • Created : Wednesday, April 11, 2018
  • Last Updated: Friday, July 10, 2020

Note:
The sample file "Sample_TrackingImport.csv" can be downloaded here or from your admin "Sales -> Import Tracking Numbers" look for Sample File "Sample_TrackingImport.csv"  

The Sample CSV file will contain the following columns.  Here are their descriptions:

  • OrderID
    This is the ID of the order on your store's database.  On a regular order export it is listed as "orderID" as well.
  • LineNo 
    This column should contain the order's respective item line orders if more then one item was ordered. 1st item ordered is 1 then the 2nd is 2 and so on.
  • Tracking
    Here you will input the order's respective tracking number relative to both the OrderID and lineNo.

After importing, the tracking numbers will be visible when viewing the orders in the admin and by the customer.


Keep in mind:

  • Aside from updating your orders with their respective tracking numbers; the tracking number import function will also update the order statuses to complete automatically.
  • The Customer will also be sent an email with the tracking number automatically as the import is being processed.