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

This article covers these topics :

  1. Logistics reports creation
  2. Logistics report fields description

1. Logistics reports creation

Here are the steps to follow to build a periodic report with your data:

  1. Click on "Package reports" or click directly HERE
  2. Click on "Create periodic report"
  3. Choose the start date of the analysis.
  4. Choose the periodicity (you will receive the report every day/week/month/quarter)
  5. Choose the covered period. ⚠️⚠️Only packages imported into Shipup during this period will be in the report
  6. Choose the data you want on your report (choose "custom" to select the columns you need)
  7. Send it

2. Logistics report fields description

  • tracking_number: Tracking number of the package
  • carrier_code: Carrier code of the package
  • delivery_status: Tracking number of the package
  • order_number: Order name of the package
  • order_date: Order date of the package
  • email: Email of the receiver of the package
  • first_name: First name of the receiver of the package
  • last_name: Last name of the receiver of the package
  • address_country: Address country code of the package
  • address_zip: Address zip of the package
  • estimated_delivery: Estimated delivery date of the package
  • 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 the carrier
  • carrier_pickup_date: Date when the package is physically processed for the first time by the carrier, i.e. when the package is in the hands of the carrier for the first time
  • pickup_point_arrival: Date when the package arrived at the pickup point
  • 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 on if the package has been delivered
  • failed_delivery: 0 or 1 depending on if the package has failed delivery attempts
  • other_incident: 0 or 1 depending on if an incident, other than a failed delivery attempt, occurred
  • return: 0 or 1 depending on if the package has been returned
  • went_to_pickup_point: 0 or 1 depending on 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 the order date and pickup event
  • time_to_pickup_point_retrieval: Time in hours between pickup point arrival and delivered the event
  • time_to_possession: Time in hours between the order date and delivered event

Did this answer your question?