Export Shipment Records

How to export shipment records from the Shipments tab based on displayed columns.

ShipStation allows you to export shipment data as a CSV-formatted file. You can export a report for either Shipments or Shipment Line Items.

Type of Export

Details

Export Shipments

Lists each unique shipment on it's own row and will not include product-specific information.

Export Shipment Line Items

Lists each unique product in a shipment on it's own row. A multi-product shipment will include multiple rows.

Export shipment data from any Shipped section on the Shipments tab, or when you're viewing a batch in the Batches section of the Shipments tab.

The data in the CSV file will either be based on the current view on the Shipments grid, or you can create a custom export format.

Export Shipment Data to CSV

Create a Custom Export Format

Shipped Orders Export Field List

The following fields are available in the Shipped Orders export from the Shipments tab. The table includes descriptions of what data the field will contain or where that data is pulled from in ShipStation.

Field

What does it mean?

Amount - Order Shipping

Shipping Paid for the order used to create the shipment record.

Amount - Order Subtotal

Sum of Extended Price for all the line items in the order used to create the shipment record.

Amount - Order Tax

Tax Paid for the order used to create the shipment record.

Amount - Order Total

Total Order for the order used to create the shipment record.

Amount - Shipping Cost

The base cost of the shipment, without added fees.

Bill To - Account

If using Third Party or Recipient Billing, the Account # set in the Other Shipping Options for the shipment.

Bill To - Country

If using Third Party or Recipient Billing, the Billing Country set in the Other Shipping Options for the shipment.

Bill To - Party

The Shipping Account set in the Other Shipping Options for the shipment.

Bill To - Postal Code

If using Third Party or Recipient Billing, the Billing Zip set in the Other Shipping Options for the shipment.

Carrier - Fee

The cost of the shipping label for the shipment record, based on the Shipping Info that was used to create the label.

Carrier - Name

Name of the Carrier used to create the shipping label for the shipment record.

Carrier - Service Selected

Name of the Service used to create the shipping label for the shipment record.

Count - Number of Line Items

Number of unique line items in the order used to create the shipment record.

Customer - Email

Buyer Email for the order used to create the shipment record.

Custom - Field 1

Custom Field 1 for the order record.

Custom - Field 2

Custom Field 2 for the order record.

Custom - Field 3

Custom Field 3 for the order record.

Date - Label Create Date

Date the shipping label for the shipment record was created in ShipStation.

Date - Order Date

Order Date for the order used to create the shipment record.

Date - Shipped Date

Ship Date used to create the shipping label for the shipment record.

Delivery - Date

If the shipment has been delivered, the Delivery Date.

Delivery - Message

The most recent tracking message received from the shipping carrier.

Gift - Flag

Indicates if the order used to created the shipment record is marked as a Gift.

Gift - Message

Gift Message for the order used to created the shipment record.

Insurance - Cost

Insurance Fee of the shipping label for the shipment record, based on the Shipping Info that was used to create the label.

Insurance - Insured Value

Insurance Amount used to create the shipping label for the shipment record.

Insurance - Provider

Insurance Provider used to create the shipping label for the shipment record.

Insurance - Purchased Flag

Indicates if additional insurance was purchased for the shipment.

Market - Marketplace Name

The name of the integration that was used to create the order associated to the shipment record.

Examples: eBay, Shopify, StitchLabs, Custom Store, ShipStation

Market - Store Name

Store Name for the order used to create the shipment record.

Operations - Batch ID

ShipStation's internal identifier for the batch in which the shipment was created.

Operations - Batch Number

Batch Number for the batch the shipment was created in.

Operations - User Name

Username of the ShipStation user who created the shipment.

Operations - Warehouse

Name of the Ship From used to create the shipping label for the shipment record.

Order - Number

Order Number for the order used to create the shipment record.

Order - Source

Source for the order used to create the shipment record.

This field is typically used by Inventory and Order Management partners to define the original store or marketplace the order was placed on.

Order - Status

Current Status of the order used to create the shipment record.

Return - Date Received

If the shipment is for a return label, the date the return was marked as received.

Return - Return Label Flag

Indicates if a shipping label created for the shipment is a return label.

Return - RMA Number

If the shipment is for a return label, the RMA Number for the return.

Service - Confirmation Type

Confirmation Type used to create the shipping label for the shipment record.

Service - Package Type

Package used to create the shipping label for the shipment record.

Shipment - Carrier

Name of the Carrier used to create the shipping label for the shipment record.

Shipment - Declared Value

Insurance Amount used to create the shipping label for the shipment record.

Shipment - Height

Height used to create the shipping label for the shipment record.

Shipment - Length

Length used to create the shipping label for the shipment record.

Shipment - Package Count

When using multi-package shipping, the total count of packages in the shipment.

Shipment - Package Type

Package used to create the shipping label for the shipment record.

Shipment - Tracking Number

Tracking Number of the shipping label for the shipment record.

Shipment - Void Date

Date the shipping label for the shipment record was voided in ShipStation.

Shipment - Void Flag

Indicates if the shipping label for the the shipment record is voided.

Shipment - Weight

Weight used to create the shipping label for the shipment record.

Shipment - Weight (Oz)

Weight (in ounces) used to create the shipping label for the shipment record.

Shipment - Width

Width used to create the shipping label for the shipment record.

Shipment - Zone

USPS Zone for the shipment record, based on the Ship To Postal Code and the Ship From used to create the shipping label for the shipment record.

Ship To - Address 1

Ship To Address Line 1 used to create the shipping label for the shipment record.

Ship To - Address 2

Ship To Address Line 2 used to create the shipping label for the shipment record.

Ship To - Address 3

Ship To Address Line 3 used to create the shipping label for the shipment record.

Ship To - City

Ship To City used to create the shipping label for the shipment record.

Ship To - Company

Ship To Company used to create the shipping label for the shipment record.

Ship To - Country

Ship To Country used to create the shipping label for the shipment record.

Ship To - Name

Ship To Name used to create the shipping label for the shipment record.

Ship To - Phone

Ship To Phone used to create the shipping label for the shipment record.

Ship To - Postal Code

Ship To Postal Code used to create the shipping label for the shipment record.

Ship To - Residential Flag

Indicates if the address used to created the shipment record was validated as a Residential address.

Ship To - State

Ship To State used to create the shipping label for the shipment record.

Ship To - Verified Flag

Indicates if the address used to created the shipment record was verified.

Sum - Total of Line Items

Total Quantity of all line items in the order used to create the shipment record.

Shipped Items Export Field List

The following fields are available in the Shipped Line Orders export in the Shipments tab. The table includes descriptions of what data the field will contain or where that data is pulled from in ShipStation.

Field Name

What does it mean?

AmountPaid

Total Paid for the order used to created the shipment record.

BatchID

ShipStation's internal identifier for the batch in which the shipment was created.

BatchNumber

Batch Number for the batch the shipment was created in.

This is an advanced option. Tick the See Advanced Options checkbox if you wish to add this field to your report.

BillDutiesToSender

Indicates if the Bill duties and taxes to payor of shipping charges Other Shipping Option was enabled for the shipment.

BillToAccount

If using Third Party or Recipient Billing, the Account # set in the Other Shipping Options for the shipment.

BillToCountryCode

If using Third Party or Recipient Billing, the Billing Country set in the Other Shipping Options for the shipment.

BillToParty

The Shipping Account set in the Other Shipping Options for the shipment.

BillToPostalCode

If using Third Party or Recipient Billing, the Billing Zip set in the Other Shipping Options for the shipment.

BuyerEmail

Buyer Email for the order used to create the shipment record.

Carrier

Name of the Carrier used to create the shipping label for the shipment record.

The carrier is the vendor who will actually pick up, transport, and deliver the shipment.

CarrierFee

The cost of the shipping label for the shipment record, based on the Shipping Info that was used to create the label.

CarrierID

ShipStation's internal identifier for the carrier used to create the shipment.

CarrierTransactionID

The postage provider's internal identifier for the shipping label for the shipment record.

City

Ship To City used to create the shipping label for the shipment record.

Company

Ship To Company used to create the shipping label for the shipment record.

ConfirmationServiceID

ShipStation's internal identifier for the confirmation type used to create the shipment.

CountryCode

Ship To Country used to create the shipping label for the shipment record.

CreateDate

Date the order record associated to the shipment record was created in ShipStation.

DeclaredValue

Retired field, no longer used in ShipStation.

Delivered

Indicates if the shipment has been marked as Delivered.

DeliveryDate

If the shipment has been delivered, the Delivery Date.

DeliveryMessage

The most recent tracking message received from the shipping carrier.

DeliveryStatusDate

The date most recent tracking message received from the shipping carrier was received.

Description

Item Name of the item within the shipment record.

EmailErrorMessage

If an error was encountered when sending the shipment confirmation email, the text of the error.

EmailNote

The Tracking URL used for shipment notification emails.

EmailNotificationRequested

Indicates if the order used to create the shipment shipment record is set to send shipment confirmation emails.

EmailNotificationSent

Indicates if ShipStation sent a shipment confirmation email for the shipment.

ExtendedPrice

Extended Price of the item within the shipment record.

ExternalID

The postage provider's internal identification number for the shipping label associated to the shipment record.

ExternalTrackingID

The postage provider's internal identifier for the tracking information for the shipping label.

ForwardTo

If the shipment is for a return label, the email address ShipStation sent the return to.

Height

Height used to create the shipping label for the shipment record.

HidePostage

Indicates if the Print postage on the shipping label for this order Other Shipping Option was enabled for the shipment.

InsuranceBillingTransactionID

The insurance provider's internal identifier for the charge made to purchase insurance.

InsuranceClaimCode

If ShipSurance was used to purchase insurance, the claim code number needed to file a claim.

InsuranceClaimDate

If ShipSurance was used to purchase insurance, and a claim was started, the date the claim was filed.

InsuranceClaimFiled

If ShipSurance was used to purchase insurance, indicates if a claim has been filed.

InsuranceClaimNumber

If ShipSurance was used to purchase insurance, and a claim was started, ShipSurance's internal identifier for the claim.

InsuranceErrorMessage

If an error was encountered when purchasing insurance, the text of the error.

InsuranceFee

Insurance Fee of the shipping label for the shipment record, based on the Shipping Info that was used to create the label.

InsuranceProviderID

ShipStation's internal identifier for the insurance provider used to create the shipment.

InsurancePurchased

Indicates if additional insurance was purchased for the shipment.

InsuranceRequested

Indicates if additional insurance was requested when creating the shipment.

InsuranceTransactionID

The insurance provider's internal identifier for the additional insurance for the shipment.

InsuranceVoided

Indicates if the insurance purchasel for the the shipment record is voided. Insurance purchases are voided at the same time as the label.

InsuranceVoidErrorMessage

If an error was encountered when voiding the insurance purchase, the text of the error.

InsuredValue

Insurance Amount used to create the shipping label for the shipment record.

InternalTransactionID

ShipStation's internal identifier for the communication made to the postage provider which resulted in a shipping label being created for the shipment.

IsReturnLabel

Indicates if a shipping label created for the shipment is a return label.

Items

Total Quantity of all line items in the order used to create the shipment record.

LabelCreateDate

Date the shipping label for the shipment record was created in ShipStation.

LabelErrorMessage

If label could not be created by the postage provider, the error message returned by the postage provider.

LabelInfoMessage

If changes were made by the postage provider when the label was created, the message received from the postage provider.

LabelMessage

Label Messages used to create the shipping label for the shipment record.

Length

Length used to create the shipping label for the shipment record.

MarketplaceNotified

Indicates if ShipStation attempted to notify the order's marketplace with the shipment information.

ModifyDate

The date the shipment was list modified in ShipStation.

Name

Ship To Name used to create the shipping label for the shipment record.

NonMachinable

Indicates if the This order is non-machinable Other Shipping Option was enabled for the shipment.

NoPostage

Indicates if the Do not prepay postage for this order Other Shipping Option was enabled for the shipment.

NotifyErrorMessage

If error was encountered when attempting to notify the order's marketplace, the error message from the marketplace.

OrderDate

Order Date for the order used to create the shipment record.

OrderID

ShipStation's internal identifier for the order used to create the shipment record.

OrderItemID

OrderNumber

Order Number for the order used to create the shipment record.

OrderTotal

Total Order for the order used to create the shipment record.

Package

Package used to create the shipping label for the shipment record.

PackageCount

When using multi-package shipping, the total count of packages in the shipment.

PackageTypeID

ShipStation's internal identifier for the package used to create the shipment.

PayDate

Paid Date for the order used to create the shipment record.

PaymentMethod

Payment Method for the order used to created the shipment record.

Phone

Ship To Phone used to create the shipping label for the shipment record.

PostalCode

Ship To Postal Code used to create the shipping label for the shipment record.

ProductID

ShipStation's internal identifier for the ShipStation product record associated to the line item in the shipment.

ProviderID

ShipStation's internal identifier for the postage provider used to create the shipment.

ProviderName

Name of the Postage Provider used to create the shipping label for the shipment record.

The postage provider is the vendor who sells the postage used for the shipment, may be different than the carrier.

Quantity

Quantity of the item within the shipment record.

ReturnRecievedDate

If the shipment is for a return label, the date the return was marked as received.

RMANumber

If the shipment is for a return label, the RMA Number for the return.

SellerID

ShipStation's internal identifier for the ShipStation account which created the shipment.

ServiceCode

Abbreviation of the Service used to create the shipping label for the shipment record.

ShipDate

Ship Date used to create the shipping label for the shipment record.

ShipmentID

ShipStation's internal identifier for the shipment record.

Shipped

Indicates tracking information for the shipping label shows movement beyond label creation.

ShippingContentTypeID

For international shipments, the Package Contents type selected in the customs declaration.

ShippingPaid

Shipping Paid for the order used to create the shipment record.

ShippingServiceCode

ShipStation API code for the Service used to create the shipping label for the shipment record.

ShippingServiceID

ShipStation's internal identifier for the shipping service used to create the shipment.

ShowPostage

Indicates if the Print postage on the shipping label for this order Other Shipping Option was enabled for the shipment.

SKU

Item SKU of the item within the shipment record.

State

Ship To State used to create the shipping label for the shipment record.

StoreName

Store Name for the order used to create the shipment record.

Street1

Ship To Address Line 1 used to create the shipping label for the shipment record.

Street2

Ship To Address Line 2 used to create the shipping label for the shipment record.

Street3

Ship To Address Line 3 used to create the shipping label for the shipment record.

TaxAmount

Tax Paid for the order used to create the shipment record.

TrackingNumber

Tracking Number of the shipping label for the shipment record.

UnitPrice

Unit Price of the item within the shipment record.

UserID

ShipStation's internal identifier for the ShipStation user who created the shipment.

Username

Buyer Username for the order used to created the shipment record.

VoidDate

Date the shipping label for the shipment record was voided in ShipStation.

Voided

Indicates if the shipping label for the the shipment record is voided.

WarehouseID

ShipStation's internal identifier for the Ship From used to create the shipping label for the shipment record.

WarehouseName

Name of the Ship From used to create the shipping label for the shipment record.

WeightOz

Weight (in ounces) used to create the shipping label for the shipment record.

Width

Width used to create the shipping label for the shipment record.

Shipment Record Exports Legacy Layout

If you are using ShipStation's Legacy Layout, follow the instructions below to export shipment information.

Custom Shipment Reports

You can build custom shipments reports that export only the fields you specify.

Access the export options for shipments in the Shipments tab under the Export menu.

Shipments tab highlighted with arrow pointing to Export drop-down menu options: Shipped Orders and Shipped Line Items.

There are two options for shipment export reports:

  • Shipped Orders Export

  • Shipped Items Export

The difference between the two export options has to do with what fields are available to each. Only the Line Items option provides item-specific fields like Item Name or SKU.

At this time, there is not a way to combine these two types of reports in ShipStation. However, you can export both types of reports and then merge them yourself in your spreadsheet program.

Create a Custom Export Report

Exports are available on the Orders and Shipments tabs and can be customized to pull the specific data you need from ShipStation into a CSV-formatted file.