Auto Fetch CSV

Auto import tracking numbers and order info from CSV at a specific time.

INSTALL

Key Features

  • Auto import and track all your shipments - UPS, USPS, Fedex & 340+ couriers (Free).
  • Notify customers when shipments are In Transit, Out For Delivery, Delivered or have an Exception (Premium).
  • Find out if shipments are delivered on time, and reduce enquiries about order status.

How it works

  1. Sign up AfterShip account for FREE.
  2. Go to “apps” and choose “CSV Connector”.
  3. Enter a HTTP, HTTPS, FTP link where the CSV file is located.
  4. Specify a time for AfterShip to download the CSV file.
  5. Download a CSV file sample, edit it and upload to the FTP link.

How to fill in CSV (Download Sample)

Field Description
tracking_number tracking number of the shipment (the only compulsory field)
courier the aftership built-in slugs for supporting couriers. AfterShip will automatically detect the courier if it is not filled.
title Title of shipment. Can be added in the notification message using &# x2A;&# x7C;TITLE&# x7C;&# x2A;
order_id Can be added in the notification message using &# x2A;&# x7C;ORDER_ID&# x7C;&# x2A;
order_path Can be added in the notification message using &# x2A;&# x7C;ORDER_PATH&# x7C;&# x2A;
customer_name Can be added in the notification message using &# x2A;&# x7C;CUSTOMER_NAME&# x7C;&# x2A;
email enter if you would like to send out delivery notifications. Use comma for multiple emails.
phone please enter + followed by the area code and phone number. Use comma for multiple phones.
origin_country Enter iso3 country code. Mainly for analytics purpose.
destination_country Enter iso3 country code for Origin & Destination Tracking, and also show local courier contact for DHL, UPS, FedEx and Toll Global Mail. Useful for analytics purpose as well.

Notes

  • Only tracking_number is the only compulsory field, but suggest to input courier to ensure more accurate tracking.
  • Please remember to 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.