Articles on: Tracking & Status

Guide to Export Shipments Data

Plans: All plans Platforms: All platforms

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:

How to export shipments data in CSV format
Parameters for exporting AfterShip shipment data

Export shipments data in CSV format




Go to 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 registered 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.

PARAMETERDESCRIPTIONEXAMPLE
idTracking ID.my2uktymyz72xld1f7l3h01z
created_atThe 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.2023-01-18T08:47:10+08:00
updated_atThe date and time the shipment was updated. It uses the format YYYY-MM-DDTHH:mm:ssZ for your organization settings timezone.2023-01-18T08:47:10+08:00
tracking_numberTracking number.61293150000079650811
slugUnique courier code.fedex
{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.my-store-name
customer_nameCustomer name of the tracking.Steve Young
transit_timeTotal 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.9
destination_addressThe shipping address that the shipment is shipping to.13th Street, New York, NY, 10011, USA, United States
destination_country_nameThe ISO Alpha-3 code (3 letters) for the destination country/region. E.g. USA for the United States.USA
destination_country_iso3The ISO Alpha-3 code (3 letters) for the destination country/region. E.g. USA for the United States.USA
destination_stateThe state of the recipient’s address.New York
destination_cityThe city of the recipient’s address.New York City
destination_zipThe postal code of the recipient’s address.10001
destination_raw_locationThe shipping address that the shipment is shipping to.13th Street, New York, NY, 10011, USA, United States
origin_addressThe sender address that the shipment is shipping from.Lihong Gardon 4A 2301, Chaoyang District, Beijing, BJ, 065001, CHN, China
origin_country_nameThe ISO Alpha-3 code (3 letters) for the origin country/region. E.g. USA for the United States.CHN
origin_country_iso3The ISO Alpha-3 code (3 letters) for the origin country/region. E.g. USA for the United States.CHN
origin_stateThe state of the sender’s address.Beijing
origin_cityThe city of the sender’s address.Beijing
origin_zipThe postal code of the sender’s address.065001
emailsEmail address(es) to receive email notifications."example@aftership.com"
smsesThe phone number(s) to receive sms notifications. Phone number should begin with + and Area Code before phone number."+8613800138000,+8613800138001"
noteText field for the note.note
order_idA globally-unique identifier for the order.6845a095a27a4caeb27487806f058add
order_id_pathThe URL for the order in your system or store.https://www.aftership.com/my-orders/6845a095a27a4caeb27487806f058add
order_store_idThe store id of the order.my-store
order_tagsThe tags of the order."Exception,Lost"
order_numberA unique, human-readable identifier for the order.162654659775
shipment_package_countNumber of packages under the tracking.1
shipment_pickup_dateThe date and time the shipment was picked up by the carrier.2022-01-21T15:00:00
shipment_delivery_dateThe date and time the shipment was delivered. It uses the shipment recipient’s timezone.2022-01-21T15:00:00
scheduled_delivery_dateThe estimated delivery date provided by the carrier.2022-01-21T15:00:00
shipment_typeThe carrier service type for the shipment.FedEx SmartPost
shipment_weightShipment weight value provided by carrier.0.7
shipment_weight_unitWeight unit provided by carrier.kg
signed_bySigned by information for delivered shipment.Steve Young
tagCurrent status of tracking. (See tag definition)Delivered
subtagCurrent subtag of tracking. (See subtag definition)Delivered_002
titleBy default, this field shows the tracking_number, but you can customize it as you wish with any info (e.g. the order number).61293150000079650811
last_checkpoint_timeThe date and time of the last checkpoint event, provided by the carrier.2022-01-01T18:47:10-05:00
last_checkpoint_country_nameCountry/Region ISO Alpha-3 (three letters) of the last checkpoint.USA
last_checkpoint_country_iso3Country/Region ISO Alpha-3 (three letters) of the last checkpoint.USA
last_checkpoint_cityCity of the last checkpoint.New York city


PARAMETERDESCRIPTIONEXAMPLE
last_checkpoint_stateState of the last checkpoint.New York
last_checkpoint_zipPostal code of the last checkpoint.10011
last_checkpoint_messageCheckpoint message of the last checkpoint.Package delivered
return_to_senderWhether or not the shipment is returned to sender.true
user_marked_as_completedWhether the shipment status updated by yourself manually.true
pickup_locationShipment pickup location for receiver.13th Street, New York, NY 10011, USA, United States
sourceSource of how this tracking is added.api
order_dateThe 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
pickup_noteShipment pickup note for receiver.No notes
first_attempted_atThe date and time of the carrier’s first attempt to deliver the package to the recipient.2022-01-01T17:00:00-05:00
tracking_account_numberAdditional field required by some carriers to retrieve the tracking info. The shipper’s carrier account number.86f058add
tracking_origin_country(Legacy) Replaced by origin_country_iso3. Additional field required by some carriers to retrieve the tracking info.CHN
tracking_destination_country(Legacy) Replaced by destination_country_iso3. Additional field required by some carriers to retrieve the tracking info.USA
tracking_keyAdditional field required by some carriers to retrieve the tracking info. A type of tracking credential required by some carriers.86f058add
tracking_postal_code(Legacy) Replaced by destination_postal_code. Additional field required by some carriers to retrieve the tracking info.90213
tracking_ship_dateAdditional field required by some carriers to retrieve the tracking info. The date the shipment was sent, using the format YYYYMMDD.20220101
tracking_state(Legacy) Replaced by destination_state. Additional field required by some carriers to retrieve the tracking info.CA
on_time_statusWhether the tracking is delivered on time or not.late
on_time_differenceThe difference in days of the on time.3
shipment_tagsUsed to add tags to your shipments to help categorize and filter them easily."Exception,Returned"
courier_connection_idThe courier connection id tells which carrier account you’ve used to handle a shipment so we can track it.8e1261bde336436abbc7cb3eee8cd707
next_courier_slugThe next courier code for getting the second carrier information from user or AfterShip.usps
next_courier_tracking_numberThe next courier tracking number for getting the second carrier information from user or AfterShip.61293150000079650811
next_courier_sourceThe next courier source for getting the second carrier information from user or AfterShip.system
estimated_delivery_datetime_sourceThe source of the most recently calculated estimated delivery date. It could be provided by the carrier, AfterShip AI, or based on your custom settings.Carrier EDD
estimated_delivery_datetime_minThe lower end of the range of the most recently calculated estimated delivery date.2022-01-03
estimated_delivery_datetime_maxThe most recently calculated estimated delivery date.2022-01-07
estimated_delivery_datetimeThe upper end of the range of the most recently calculated estimated delivery date.2022-01-05
first_estimated_delivery_datetime_sourceThe source of the shipment’s original estimated delivery date. It could be provided by the carrier, AfterShip AI, or based on your custom settings.Custom EDD
first_estimated_delivery_datetime_minThe lower end of the range of the shipment’s original estimated delivery date.2022-01-03
first_estimated_delivery_datetime_maxThe upper end of the range of the shipment’s original estimated delivery date.2022-01-07
first_estimated_delivery_datetimeThe shipment’s original estimated delivery date. It could be provided by the carrier, AfterShip AI, or based on your custom settings.2022-01-05
aftership_estimated_delivery_date_minThe lower end of the range of the estimated delivery date of the shipment provided by AfterShip’s AI and shown to the recipients.2022-01-02
aftership_estimated_delivery_date_maxThe upper end of the range of the estimated delivery date of the shipment provided by AfterShip’s AI and shown to the recipients.2022-01-04
aftership_estimated_delivery_dateThe estimated delivery date of the shipment provided by AfterShip’s AI and shown to the recipients.2022-01-03
custom_estimated_delivery_date_minThe lower end of the range of the estimated delivery time of the shipment based on your custom EDD settings.2022-01-02
custom_estimated_delivery_date_maxThe upper end of the range of the estimated delivery time of the shipment based on your custom EDD settings.2022-01-04
custom_estimated_delivery_dateThe estimated delivery time of the shipment based on your custom EDD settings.2022-01-03
order_promised_delivery_dateThe 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
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.9

If you have any queries, feel free to reach out to our support team for quick help.

Updated on: 09/04/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!