Logistics reports fields

Overview

Shipup allows you to generate periodic and instantaneous logistic reports on all your packages imported in shipup.
Reports are then sent via email or directly synchronized in your FTP server.
Depending on the chosen configuration during the import, part or all of the below will be present in the CSV report.

Report fields description

CSV HEADER

DESCRIPTION

tracking_number

Package Tracking number

carrier_code

Package Carrier code

delivery_status_code

Package delivery status

order_number

Order number

order_date

Order date

email

Customer email

first_name

Customer first name

last_name

Customer last name

address_country

Destination country code (ISO 2)

address_zip

Destination post code

estimated_delivery_merchant_date

Estimated delivery date of the package provided by the merchant

estimated_delivery_merchant_datetime

Estimated delivery date of the package provided by the merchant in timestamp format

estimated_delivery_promise_date

Estimated delivery date of the package compute from the Shipup account configuration

estimated_delivery_carrier_date

Estimated delivery date of the package provided by the carrier

estimated_delivery_merchant_datetime

Estimated delivery date of the package provided by the carrier in timestamp format

added_to_shipup

Date of the creation of the package in shipup ecosystem

label_created_date

Date when the package label is created in the carrier’s systems, i.e. when the package data is received by carrier

carrier_pickup_date

Date when the package is physically processed for the first time by carrier, i.e. when the package is in the hands of carrier for the first time

pickup_point_arrival

Date when the package arrived at the pickup point (if applicable)

first_delivery_attempt

Date of the first delivery attempt by the carrier. It can be at the pickup point or at the address of the receiver

return_date

Date when a return, a cancelation or a refusal occurs

delivered

0 or 1 depending if the package has been delivered

failed_delivery

0 or 1 depending if the package has failed delivery attempts

other_incident

0 or 1 depending if an incident, other than a failed delivery attempt, occurred

return

0 or 1 depending if the package has been returned

went_to_pickup_point

0 or 1 depending if the package went at some point to a pickup point or not

time_to_delivery

Time in hours between pickup event and delivered event

time_to_first_presentation

Time in hours between pickup event and first delivery attempt event

time_to_ship

Time in hours between order date and pickup event

time_to_pickup_point_retrieval

Time in hours between pickup point arrival and delivered event

time_to_possession

Time in hours between order date and delivered event


Did this page help you?