CSV Upload & CSV Auto-Fetch
Upload CSV for bulk import of trackings to AfterShip Tracking for auto tracking and notifications. You can upload CSV manually or use auto-fetch for importing trackings at a specific time from the remote server, e.g. FTP server.
- Login to your AfterShip account (Sign up free)
- Download a CSV sample:
- Manually upload a CSV file, or setup an Auto-fetch
Please ensure your CSV follows the RFC 4180 standard.
Requied Parameter
| Parameter | Description | Example |
|---|---|---|
| tracking_number | The tracking number of a shipment. (Note: Duplicate tracking numbers or tracking numbers with invalid formats will not be accepted.) | 9400111206213642173009 |
Optional Parameters
| Parameter | Description | Example |
|---|---|---|
| courier | Unique courier code. Get courier codes here. | fedex |
| order_id | A globally-unique identifier for the order. | 6845a095a27a4caeb27487806f058add |
| title | By default this field shows the tracking_number, but you can customize it as you wish with any info (e.g. the order number). | #123456 |
| order_path | The URL for the order in your system or store. | https://www.aftership.com/my-orders/6845a095a27a4caeb27487806f058add |
| origin_country | The ISO Alpha-3 code (3 letters) for the origin country/region. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. Also the additional field required by some carriers to retrieve the tracking info. The destination country/region of the shipment. Refer to our article on additional tracking fields for more details. | USA |
| destination_country | The ISO Alpha-3 code (3 letters) for the destination country/region. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. Also the additional field required by some carriers to retrieve the tracking info. The destination country/region of the shipment. Refer to our article on additional tracking fields for more details. | USA |
| {custom_field} | One of the key of the custom fields of the tracking. e.g. store_name. Supports up to 25 keys. In order to protect the privacy of your customers, do not include any personal data in custom fields. | my-store-1 |
| tracking_postal_code | (Legacy) Replaced by destination_postal_code. Additional field required by some carriers to retrieve the tracking info. The postal code of the recipient’s address. Refer to our article on additional tracking fields for more details. | 90213 |
| tracking_ship_date | Additional field required by some carriers to retrieve the tracking info. The date the shipment was sent, using the format YYYYMMDD. Refer to our article on additional tracking fields for more details. | 20220101 |
| tracking_account_number | Additional field required by some carriers to retrieve the tracking info. The shipper’s carrier account number. Refer to our article on additional tracking fields for more details. | 86f058add |
| tracking_key | Additional field required by some carriers to retrieve the tracking info. A type of tracking credential required by some carriers. Refer to our article on additional tracking fields for more details. | 86f058add |
| tracking_destination_country | (Legacy) Replaced by destination_country_iso3. Additional field required by some carriers to retrieve the tracking info. The destination country/region of the shipment. Refer to our article on additional tracking fields for more details. | USA |
| order_date | The date and time the order was created in your system or store. It uses the format: YYYY-MM-DDTHH:mm:ssZ based on whichever timezone you provide. | 2022-01-20T15:56:12+08:00 |
| order_number | A unique, human-readable identifier for the order. | 162654659775 |
| language | The recipient’s language. If you set up AfterShip notifications in different languages, we use this to send the recipient tracking updates in their preferred language. Use an ISO 639-1 Language Code to specify the language. | en |
| shipment_type | The carrier service type for the shipment. If you provide info for this field, AfterShip will not update it with info from the carrier. | FedEx SmartPost |
| order_promised_delivery_date | The promised delivery date of the order. It uses the format YYYY-MM-DD. This has no timezone and uses whatever date you provide. | 2022-01-01 |
| shipment_tags | Used to add tags to your shipments to help categorize and filter them easily. Comma separated for multiple values. | "tag1,tag2" |
| courier_connection_id | If you’ve connected multiple accounts for a single carrier on AfterShip, you can now use the courier_connection_id field to tell AfterShip which carrier account you’ve used to handle a shipment so we can track it. (Get your courier connection id) | 8e1261bde336436abbc7cb3eee8cd707 |
| origin_state | The state of the sender’s address. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. | Beijing |
| origin_city | The city of the sender’s address. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. | Beijing |
| origin_postal_code | The postal of the sender’s address. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. | 065001 |
| origin_address | The sender address that the shipment is shipping from. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. | "Lihong Gardon 4A 2301, Chaoyang District, Beijing, BJ, 065001, CHN, China" |
| destination_state | The state of the recipient’s address. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. Also the additional field required by some carriers to retrieve the tracking info. The state/province of the recipient’s address. Refer to our article on additional tracking fields for more details. | New York |
| destination_city | The city of the recipient’s address. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. | New York City |
| destination_postal_code | The postal of the recipient’s address. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. Also the additional field required by some carriers to retrieve the tracking info. The postal code of the recipient’s address. Refer to our article on additional tracking fields for more details. | 10001 |
| destination_address | The shipping address that the shipment is shipping to. This can help AfterShip with various functions like tracking, carrier auto-detection and auto-correction, calculating an EDD, etc. | "13th Street, New York, NY, 10011, USA, United States" |
| customer_name_1(2)(3) | Customer name associated with the tracking. | "Steve Young" |
| customer_role_1(2)(3) | The customer's role, indicating whether they are an individual or a company. | "sender" |
| customer_phone_number_1(2)(3) | The phone number to receive SMS notifications. Phone numbers should begin with a + sign and include the area code. | "+8613800138000" |
| customer_email_1(2)(3) | Email address to receive email notifications. | "example@aftership.com" |
| customer_language_1(2)(3) | The customer's preferred language for receiving tracking updates. AfterShip will send updates in this language. | "en" |
Update customer Notice:
When updating customers via CSV import, please ensure to include all customers (e.g., customer 1, 2, and 3) in the file. Updating only a portion of your customers without including the others might result in the unintended removal of those not included in the upload.
CSV Auto-Fetch Outgoing IPs
If your service restricts reception by public IPs, please add all the following IPs to the allow list.
preparing...