Knowledgebase

How do I import Tracking Numbers via CSV?

 

Once a customer has placed an order and you have contacted the shipping carrier to setup a shipping label for the order, you can import a list of tracking numbers to multiple orders at the same time. 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 update. Simply download the provided sample file to get the correct formatting and then add the invoice numbers along with their respective tracking numbers.

Note:
The sample file can be downloaded by going to your Online Store Manager's left hand navigation and clicking on Orders >Manage Orders, followed by the "Export/Import" button located along the top right.

Next, look to the right hand side of the page and click on the "Tracking Number" link where you will see the "Sample File" link.

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

  • orderid -
    This is the catalog id of the order on your store's database.  On a regular order export it is listed as "orderid" as well.
  • invoicenum -
    This column should contain the order's respective invoice number (without the prefix)
  • tracking -
    Here you will input the order's respective tracking number.
  • shipment
    Use this optional field for when the order is split into multiple shipments.
  • shippeddate
    specify the order's shipped date.  Correct format to use will be m/d/yyyy

Important
Please be aware that the import function has a limit of 30 megabytes. If the CSV you are trying to import is larger than this, please split it up into separate, smaller files no larger than 30MB each.

After importing, the tracking numbers will be visible when viewing the orders.

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 shipped automatically!


Help Desk Software by Kayako fusion