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.
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.
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
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.
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
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
Thank you!