CSV Import

Our CSV import tool enables you to easily bulk import tracking information to orders from CSV files. To utilize this tool, simply follow these steps:

Fulfillment > CSV import

Preparing the CSV file

The CSV file requires 5 mandatory columns, with column header names that must be followed exactly. In addition, there are 2 optional columns that may also be included. It is essential to ensure that all the mandatory columns are present in the file.

ATTRIBUTETYPEVALUEDESCRIPTION
order_idstringWooCommerce Order ID (i.e 12345)compatible with a few Custom Order Numbers plugins
tracking_numberstringTracking number
tracking_providerstringShipping Provider Namethe name must match the provider name on the shipping providers list.
date_shippeddateDD-MM-YYYY or MM-DD-YYYYDate when the package was shipped. Optional – keep Blank to use the import date.
status_shippedintDo Not Change – 0 (null) Completed (Shipped)/Shipped – 1 Partially Shipped – 2Update the order status and send the shipping confirmation email
sku*stringLine item (product) SKUThe product or variation SKU – The SKU must exactly match and be unique per product/variation
qty*intLine item (product) quantityThe quantity of the product SKU that was shipped

*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:

blank

You can download a sample CSV file:

Import the CSV file

  1. Upload the CSV file from your computer
  2. 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
  3. Choose the Date Format in the CSV file, you can choose between 2 formats – dd-mm-YYYY or mm-dd-YYYY
  4. 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:

blank

The import will begin and will display the status of the imported tracking numbers:

blank

Once the import completes you will get a detailed report of any issues in the import:

blank

Import Tracking per item from CSV

The AST PRO allows you to Import tracking numbers per item and adds 2 columns in the CSV file, the product SKU and the quantity shipped.

For example, if we received an order #12345 with 4 items:

  1. T-shirt (TSHIRT) x 2
  2. Blue-jeans (BJEANS) x 2

Lets assume that you ship these products in 2 boxes, each has its own tracking number, one tracking number for the T-Shirts and one for the Blue Jeans:

blank

and if you ship the T-Shirts and the Blue Jeans as a set, each set in a package, the CSV File should be formatted this way:

blank

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

$129.00

Billed annually

Buy Now

On this page