Optimizer Exports

Premium Feature

Optimizer Premium allows you to download comprehensive shipment data for in-depth analysis and reporting. Export your data to CSV format for use in spreadsheets, business intelligence tools, or custom analytics workflows.

Export Types

Optimizer offers two export types designed for different monitoring and analysis needs:

1. Processed Shipments

This export includes all shipments with tracking updates indicating an actual transit of the order. Shipments with 1000 Information Received tracking status are excluded. Use this export to:

Monitor carrier performance and transit times
Identify undelivered shipments and delivery exceptions
Track shipments with issues during transit
Analyze key events throughout the shipment lifecycle

This export is ideal for operational reporting, carrier KPI analysis, and identifying delivery performance trends.

2. Not Picked Up Shipments

This export includes all shipments with a generated label but no tracking updates except for status code 1000 (Information Received). This status typically indicates that shipment information has been transmitted to the carrier, but the package has not yet entered the carrier's physical network.

This export helps you:

Identify shipments not picked up by the carrier
Monitor Return Label in the Box labels (return labels included in packages, not yet activated)
Detect potential issues before shipments enter transit
Track labels that may have been generated but never used

This export is useful for proactive issue detection, warehouse operations monitoring, and ensuring label usage efficiency.

Column Reference

Below is a comprehensive reference for all columns included in each export file.

Processed Shipments Export

All columns available in the Processed Shipments export.

Shipment Identification

Column Name	Description
Order ID	Unique identifier for the order in ShippyPro
Transaction ID	Order reference number in your system and shared with ShippyPro at the moment of the label generation
Tracking code	Carrier tracking number assigned to the shipment
Return tracking code	Tracking number for return shipments, if applicable

Marketplace Information

Column Name	Description
Marketplace name	Name of the marketplace (e.g., Amazon, eBay, Shopify, or Manual shipment for shipments shipped via API or manually created)
Marketplace ID	Internal identifier for the connected marketplace or sales channel.

Carrier Information

Column Name	Description
Carrier name	Name of the shipping carrier (e.g., DHL, UPS, FedEx)
Carrier Id	ShippyPro identifier for the specific carrier connection
Carrier service	Specific service level used (e.g., Express, Standard, Economy, Ground)

Address Information

Column Name	Description
Origin Country	ISO 2-letter country code for the shipment origin
Origin ZIP Code	Postal code for the shipment origin
Destination Country	ISO 2-letter country code for the delivery destination
Destination ZIP Code	Postal code for the delivery destination

Recipient Information

Column Name	Description
Recipient name	Full name of the shipment recipient
Recipient phone	Contact phone number for the recipient
Recipient email	Email address for the recipient

Sender Information

Column Name	Description
Sender name	Name of the person or company sending the shipment
Sender company	Company name of the sender
Sender street	Street address of the sender
Sender city	City of the sender
Sender state	State or province of the sender
Sender ZIP code	Postal code of the sender
Sender country	ISO 2-letter country code for the sender
Sender phone	Contact phone number for the sender
Sender email	Email address for the sender

Shipment Details

Column Name	Description
Items Descriptions	Description of the items in the shipment
Order value	Total declared value of the order
Shipment cost	Estimated cost charged for shipping
Shipment cost Currency	Currency code for the shipment cost (e.g., EUR, USD, GBP)
Cash on delivery	Amount to be collected from the recipient upon delivery (if applicable)
Cash on delivery Currency	Currency code for the cash on delivery amount
Insurance	Declared insurance value for the shipment
Insurance Currency	Currency code for the insurance value
Parcels count	Number of parcels in the shipment (for multi-parcel shipments)

Shipment Flags

These boolean fields indicate specific shipment characteristics. Values are True or False.

Column Name	Description
IsReturn	Indicates if this is a return shipment (True) or outbound shipment (False).
IsDelivered	Indicates if the shipment was successfully delivered (True) or not (False).
HasException	Indicates if the shipment encountered an exception or issue during transit (True) or completed normally (False).
isPUDO	Indicates if the delivery method was to a Pick-Up/Drop-Off (PUDO) location such as a parcel locker or collection point (True) or direct home delivery (False).

Timestamp Information

All timestamp columns are in UTC format: YYYY-MM-DD HH:MM:SS

Column Name	Description
Label creation time	Date and time when the shipping label was created
Manifest number	Unique identifier for the carrier manifest that includes this shipment
Manifest date	Date when the shipment was added to a carrier manifest
First in transit status date	Date and time when the shipment first received a 2000 status (In Transit), indicating the parcel has been picked up and is en route
First scan hub status date	Date and time of the first scan at a carrier hub or sorting facility (status codes 2300, 2310, 2320, 2330)
First customer drop off status date	Date and time when the customer dropped off the package at a carrier location (status code 2100)
First available in PUDO status date	Date and time when the shipment first became available for pickup at a PUDO location (status code 3200)
First out for delivery status date	Date and time when the shipment was first marked as out for delivery (status codes 3000 and 3100)
First failed delivery attempt date	Date and time of the first unsuccessful delivery attempt (status code 4000)
First success delivery status date	Date and time when the shipment was successfully delivered (status code 6000)
First is returning status date	Date and time when the shipment entered return-to-sender status (status code 5630)
Last tracking status date	Date and time of the most recent tracking update

See the Tracking Mapping System for complete status code reference.

Tracking Status

Column Name	Description
Last tracking status	Human-readable description of the current shipment status (e.g., Delivered, In Transit, Exception)
Last tracking status code	Numeric code representing the tracking status. ShippyPro uses standardized codes: 1000 = Information received, 2000+ = In transit, 6000 = Delivered. See the Tracking Mapping System for complete status code reference.
Last tracking status message	Detailed message from the carrier about the current status

Performance Metrics

These columns provide metrics for analyzing carrier performance and delivery efficiency. Transit times exclude Saturdays and Sundays for accurate business-day performance measurement.

Column Name	Description
Transit time (days)	Total number of calendar days from first in-transit status (2000) to successful delivery (6000). Calculated as: DeliveryTime - FirstInTransitTime
Transit time without weekends (days)	Transit time excluding both Saturdays and Sundays
Transit time without Saturdays (days)	Transit time excluding Saturdays only
Transit time without Sundays (days)	Transit time excluding Sundays only
First delivery attempt time (days)	Number of calendar days from first in-transit status (2000) to first delivery attempt (successful delivery 6000 OR failed attempt 4000). Calculated as: (DeliveryTime OR FailedAttemptTime) - FirstInTransitTime
First delivery attempt time without weekends (days)	First delivery attempt time excluding both Saturdays and Sundays
First delivery attempt time without Saturdays (days)	First delivery attempt time excluding Saturdays only
First delivery attempt time without Sundays (days)	First delivery attempt time excluding Sundays only
Delivery attempts	Total number of delivery attempts made by the carrier before successful delivery

Not Picked Up Shipments Export

All columns available in the Not Picked Up Shipments export.