Articles on: Shopping carts/Apps/CSV

CSV Upload & Auto-fetch

Upload a CSV file to import shipments in bulk or pass us a ftp link, and AfterShip will automatically download the CSV file at the time you specify.

1. How to upload CSV

Go to your AfterShip account's Shipments page > Click CSV import to see the Import by CSV option

Duplicate tracking numbers or tracking numbers that are not supported by AfterShip will not be imported to your AfterShip account.

2. How to set up CSV auto-fetch

With CSV auto-fetch, you don't have to upload a CSV file every time because we will automatically fetch shipment details as per your import rule and time. Here's how to set up CSV auto-fetch:

Log in your AfterShip account and Go to Shipments

Click CSV import to see the CSV Auto Fetch option

Once you click on the CSV Auto Fetch option, you will be asked to set the import rule

For the same, you need to pass an HTTP, HTTPS, FTP or SFTP link that points directly to the CSV file you want AfterShip to download at the time you specify. If the URL is password protected, please also fill in the username and password. With this, you can simply update the CSV file at the URL you specify, and AfterShip will automatically download the file and import the shipments.

Click Save to finish the procedure

How to fill in CSV file

tracking_number: Add Tracking number of the shipment (the only compulsory field)
courier: Mention AfterShip built-in slugs for supporting couriers. If you leave it blank, AfterShip will automatically detect the courier based on tracking number format, and courier priority at your account
title Specify the title of shipment. It can be added in the notification message using *|TITLE|*
order_id: It can be added in the notification message using *|ORDER_ID|*
order_path: It can be added in the notification message using *|ORDER_PATH|*
customer_name: It can be added in the notification message using *|CUSTOMER_NAME|*
email: Enter the email address if you would like to send out delivery notifications. Use comma for multiple emails
phone: Enter  +  followed by the area code and phone number. Use comma for multiple phones
destination_country: Enter iso3 three-letter or 2-letter country code or country names (e.g. United States) for Destination Tracking.

✍️ Notes

Only  tracking_number  is the only compulsory field, but it would be better if you input courier to ensure more accurate tracking

Keep the header untouched.

If you are using excel for editing the CSV, please make sure you change format of the cells into text before editing. Otherwise, the tracking number will be truncated or the phone number "+" sign will be identified as a formula.

Make sure you save the file as a CSV.

For help, contact our support team right away

Updated on: 07/06/2022

Was this article helpful?

Share your feedback


Thank you!