Guide to Export Shipments Data
Overview
Download AfterShip tracking data to get a complete account of shipments tracked in AfterShip Tracking for further analysis. Get details like order ID, shipment delivery date, origin/destination and country name to name some. You can also define filters to customize the export results.
What youâll learn
In this article, we will show you:
Export shipments data in CSV format
- Go to the Shipments dashboard in your AfterShip Tracking admin.
- Click on Export from the top of the page.
- Select the file type: CVS or Excel.
- Select the format in which you want to download the file.
a. Standard: The data will be exported with all the default fields.
b. Custom: The data will be exported with the fields you will select from the list below. Get more details on How to Export Shipment Reports in Custom Format.
- Click Export. The CSV file will be sent to the account owner's email address.
Parameters
The table below outlines the various parameters available for exporting AfterShip tracking data. You can customize your export by selecting specific fields based on your preferences.
PARAMETER | DESCRIPTION | EXAMPLE |
|---|---|---|
id | Tracking ID. | |
created_at | The date and time the shipment was imported or added to AfterShip. It uses the format YYYY-MM-DDTHH:mm:ssZ for your organization settings timezone. | |
updated_at | The date and time the shipment was updated. It uses the format YYYY-MM-DDTHH:mm:ssZ for your organization settings timezone. | |
tracking_number | Tracking number. | |
slug | Unique courier code. | |
{custom_field} | One of the key of the custom fields of the tracking. e.g. store_name. If you have multiple custom fields, we will export them all in separate columns. | |
customer_name | Customer name of the tracking. | |
transit_time | Total transit time in days. For delivered shipments: Transit time (in days) = Delivered date - Pick-up date. For undelivered shipments: Transit time (in days) = Current date - Pick-up date. Value as null for the shipment without pick-up date. | |
destination_address | The shipping address that the shipment is shipping to. | |
destination_country_name | The ISO Alpha-3 code (3 letters) for the destination country/region. E.g. USA for the United States. | |
destination_country_iso3 | The ISO Alpha-3 code (3 letters) for the destination country/region. E.g. USA for the United States. | |
destination_state | The state of the recipientâs address. | |
destination_city | The city of the recipientâs address. | |
destination_zip | The postal code of the recipientâs address. | |
destination_raw_location | The shipping address that the shipment is shipping to. | |
origin_address | The sender address that the shipment is shipping from. | |
origin_country_name | The ISO Alpha-3 code (3 letters) for the origin country/region. E.g. USA for the United States. | |
origin_country_iso3 | The ISO Alpha-3 code (3 letters) for the origin country/region. E.g. USA for the United States. | |
origin_state | The state of the senderâs address. | |
origin_city | The city of the senderâs address. | |
origin_zip | The postal code of the senderâs address. | |
emails (Legacy) | Email address(es) to receive email notifications. | |
smses (Legacy) | The phone number(s) to receive sms notifications. Phone number should begin with + and Area Code before phone number. | |
note | Text field for the note. | |
order_id | A globally-unique identifier for the order. | |
order_id_path | The URL for the order in your system or store. | |
order_store_id | The store id of the order. | |
order_tags | The tags of the order. | |
order_number | A unique, human-readable identifier for the order. | |
shipment_package_count | Number of packages under the tracking. | |
shipment_pickup_date | The date and time the shipment was picked up by the carrier. | |
shipment_delivery_date | The date and time the shipment was delivered. It uses the shipment recipientâs timezone. | |
scheduled_delivery_date | The estimated delivery date provided by the carrier. | |
shipment_type | The carrier service type for the shipment. | |
shipment_weight | Shipment weight value provided by carrier. | |
shipment_weight_unit | Weight unit provided by carrier. | |
signed_by | Signed by information for delivered shipment. | |
tag | Current status of tracking. (See tag definition) | |
subtag | Current subtag of tracking. ( See subtag definition) | |
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). | |
last_checkpoint_time | The date and time of the last checkpoint event, provided by the carrier. | |
last_checkpoint_country_name | Country/Region ISO Alpha-3 (three letters) of the last checkpoint. | |
last_checkpoint_country_iso3 | Country/Region ISO Alpha-3 (three letters) of the last checkpoint. | |
last_checkpoint_city | City of the last checkpoint. | |
last_checkpoint_state | State of the last checkpoint. | |
last_checkpoint_zip | Postal code of the last checkpoint. | |
last_checkpoint_message | Checkpoint message of the last checkpoint. | |
return_to_sender | Whether or not the shipment is returned to sender. | |
user_marked_as_completed | Whether the shipment status updated by yourself manually. | |
pickup_location | Shipment pickup location for receiver. | |
source | Source of how this tracking is added. | |
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. | |
pickup_note | Shipment pickup note for receiver. | |
first_attempted_at | The date and time of the carrierâs first attempt to deliver the package to the recipient. | |
tracking_account_number | Additional field required by some carriers to retrieve the tracking info. The shipperâs carrier account number. | |
tracking_origin_country (Legacy) | Replaced by origin_country_iso3. Additional field required by some carriers to retrieve the tracking info. | |
tracking_destination_country (Legacy) | Replaced by destination_country_iso3. Additional field required by some carriers to retrieve the tracking info. | |
tracking_key | Additional field required by some carriers to retrieve the tracking info. A type of tracking credential required by some carriers. | |
tracking_postal_code (Legacy) | Replaced by destination_postal_code. Additional field required by some carriers to retrieve the tracking info. | |
tracking_ship_date | Additional field required by some carriers to retrieve the tracking info. The date the shipment was sent, using the format YYYYMMDD. | |
tracking_state (Legacy) | Replaced by destination_state. Additional field required by some carriers to retrieve the tracking info. | |
on_time_status | Whether the tracking is delivered on time or not. | |
on_time_difference | The difference in days of the on time. | |
shipment_tags | Used to add tags to your shipments to help categorize and filter them easily. | |
courier_connection_id | The courier connection id tells which carrier account youâve used to handle a shipment so we can track it. | |
next_courier_slug | The next courier code for getting the second carrier information from user or AfterShip. | |
next_courier_tracking_number | The next courier tracking number for getting the second carrier information from user or AfterShip. | |
next_courier_source | The next courier source for getting the second carrier information from user or AfterShip. | |
estimated_delivery_datetime_source | The source of the most recently calculated estimated delivery date. It could be provided by the carrier, AfterShip AI, or based on your custom settings. | |
estimated_delivery_datetime_min | The lower end of the range of the most recently calculated estimated delivery date. | |
estimated_delivery_datetime_max | The most recently calculated estimated delivery date. | |
estimated_delivery_datetime | The upper end of the range of the most recently calculated estimated delivery date. | |
first_estimated_delivery_datetime_source | The source of the shipmentâs original estimated delivery date. It could be provided by the carrier, AfterShip AI, or based on your custom settings. | |
first_estimated_delivery_datetime_min | The lower end of the range of the shipmentâs original estimated delivery date. | |
first_estimated_delivery_datetime_max | The upper end of the range of the shipmentâs original estimated delivery date. | |
first_estimated_delivery_datetime | The shipmentâs original estimated delivery date. It could be provided by the carrier, AfterShip AI, or based on your custom settings. | |
aftership_estimated_delivery_date_min | The lower end of the range of the estimated delivery date of the shipment provided by AfterShipâs AI and shown to the recipients. | |
aftership_estimated_delivery_date_max | The upper end of the range of the estimated delivery date of the shipment provided by AfterShipâs AI and shown to the recipients. | |
aftership_estimated_delivery_date | The estimated delivery date of the shipment provided by AfterShipâs AI and shown to the recipients. | |
custom_estimated_delivery_date_min | The lower end of the range of the estimated delivery time of the shipment based on your custom EDD settings. | |
custom_estimated_delivery_date_max | The upper end of the range of the estimated delivery time of the shipment based on your custom EDD settings. | |
custom_estimated_delivery_date | The estimated delivery time of the shipment based on your custom EDD settings. | |
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. | |
delivery_time (Legacy) | Total delivery time in days. Difference of 1st checkpoint time and delivered time for delivered shipments. Difference of 1st checkpoint time and current time for non-delivered shipments. | |
first_scan_address | Address where the shipment was first scanned by the carrier. | |
first_scan_country_iso3 | ISO Alpha-3 country code of the first scan location. | |
first_scan_state | State/region of the first scan. | |
first_scan_city | City of the first scan. | |
first_scan_zip | Postal code of the first scan location. | |
scheduled_delivery_date_min | Earliest estimated delivery date provided by the carrier. | |
scheduled_delivery_date_max | Latest estimated delivery date provided by the carrier. | |
original_carrier_estimated_delivery_date | Delivery date initially estimated by the carrier. | |
original_carrier_estimated_delivery_date_min | Earliest original estimated delivery date from the carrier. | |
original_carrier_estimated_delivery_date_max | Latest original estimated delivery date from the carrier. | |
subtag_message | Detailed message corresponding to the shipment substatus. | |
events | List of tracking events for the shipment journey. | |
event_reasons | Reasons associated with tracking events (e.g., delays). | |
carbon_emissions | Estimated carbon emissions generated by the shipment. | |
carbon_emissions_unit | Unit of carbon emissions measurement. | |
failed_delivery_attempts | Number of failed delivery attempts made by the carrier. | |
shipping_method | Shipping method selected for the shipment. | |
first_mile_transit_time | Time taken from shipment pickup to first processing hub. | |
last_mile_transit_time | Time taken from local hub to final delivery. | |
return_shipment_tracking_number | Tracking number for the return shipment. | |
return_shipment_slug | Carrier slug for the return shipment. | |
signature_requirement | Indicates if a signature is required upon delivery. | |
delivery_location_type | Type of delivery location (e.g., residential, locker). | |
latest_edd_revised_type | Type of latest estimated delivery date revision. | |
latest_edd_revised_reason | Reason for the latest delivery estimate revision. | |
last_mile_status | Current delivery status in the last-mile phase. | |
last_mile_substatus | Detailed substatus of last-mile delivery. | |
last_mile_substatus_message | Message describing last-mile substatus. | |
last_mile_tracking_number | Tracking number used by last-mile carrier. | |
pending_time | Total time shipment spent in the | |
last_mile_pending_time | The time last mile shipment spent in pending state. | |
shipment_direction | Direction of shipment (forward/return). | |
is_multi_piece_shipment | Indicates if shipment contains multiple packages. | |
customer_email_1 | Email of the first customer associated with shipment. | |
customer_role_1 | Role of the first customer (e.g., buyer, sender). | |
customer_phone_number_1 | Phone number of the first customer. | |
customer_language_1 | Preferred language of the first customer. | |
customer_email_2 | Email of the second customer. | |
customer_role_2 | Role of the second customer. | |
customer_phone_number_2 | Phone number of the second customer. | |
customer_language_2 | Preferred language of the second customer. | |
customer_email_3 | Email of the third customer. | |
customer_role_3 | Role of the third customer. | |
customer_phone_number_3 | Phone number of the third customer. | |
customer_language_3 | Preferred language of the third customer. | |
If you have any queries, feel free to reach out to our support team for quick help.
Updated on: 25/03/2026