Export Order Records

ShipStation allows you to export your order data as a CSV-formatted file. You can export a report for either the order records or the line items contained in your order records. View the export field lists for each option in the Create Custom Export formats section below.

  • Export Orders: When you select to export orders, the report will list each unique order on its own row of the report and will not include product-specific information.

  • Export Order Line Items: When you select to export order line items, the report will list each unique product in an order on its own row. A multi-product order will include multiple rows.

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

When exporting the current view from the Orders grid, ShipStation will export a report with the same columns and field names as they appear in your Orders grid.

A custom export format allows you to choose which fields you want to export in your report and what sequence the fields appear in your report. You can even rename the fields so the columns in the report have custom names. Save as many custom export formats as you need!

Export Order Data to CSV

Create a Custom Export Format

To create a custom export format from the Orders tab:

  1. Select the orders(s) you want to export, or use filters to build a list of all the orders you want to export.

  2. Click Other Actions, then Export Orders.

    Other Actions dropdown menu. Box highlights Export Orders option
  3. Click the Create a New Format button.

    Export Orders pop-up. Arrow points to Create a New Format button
  4. Name the export format.

    The Export Order popup shows Custom Export marked.
  5. Add the fields you want included on the export.

    To do this, select the field and click the right arrow button V3_ICON_ExportFormat_RightArrow.png. To remove, select the field and click the left arrow button V3_ICON_ExportFormat_LeftArrow.png.

    Box highlights left- and right-facing arrows to move selections between Available Fields & Fields to Export listings.
  6. Optional Step: Rename the column header on the exported CSV file by clicking the edit icon next to the field name.

    Export Orders popup. Box highlights Edit buttons beside selections in Fields to Export column.
  7. Click Save Export Format when you're done.

    ShipStation will save the export format to your account for you to reuse in the future.

Orders Export Field List

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

Field Name (Standard)

What does it mean?

Amount - Order Shipping

Shipping Paid for the order record.

Amount - Order Subtotal

Product Total for the order. This is the sum of Extended Price for all line items in the order.

Amount - Order Tax

Tax Paid for the order record.

Amount - Order Total

Total Order for the order record. This is the sum of the Product Total, Shipping Paid, and Tax Paid.

Amount - Paid by Customer

Total Paid for the order record.

Amount - Shipping Cost

The base cost of the estimated shipping rate based on shipment details. Does not include any additional fees.

Amount - Ship Rate Quoted

The total cost of the estimated shipping rate based on shipment details.

Bill To - Name

Buyer Name for the order record.

Carrier - Carrier Selected

The name of the Carrier selected in the shipment details.

Carrier - Service Requested

Requested Shipping Service for the order record. Usually, this is the shipping option your customer chooses when checking out.

Carrier - Service Selected

The name of Service selected in the shipment details.

Count - Number of Items

Total count of unique line items in the order record.

Count - Number of Shipments

Total count of shipments which are associated to the order record.

Customer Email

Buyer Email for the order 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.

Customs - Package Contents

Package Contents set in the Customs Declarations for the order record.

Date - Hold Until

Hold Until date for the order record.

Date - Order Date

Order Date for the order record.

Date - Paid Date

Paid Date for the order record.

Date - Shipped Date

Ship Date for the order record.

Dimensions - Height

Height set in the Shipping Info for the order record.

Dimensions - Length

Length set in the Shipping Info for the order record.

Dimensions - Width

Width set in the Shipping Info for the order record.

Gift - Flag

Indicates if the order is marked as a Gift.

Gift - Message

Gift Message for the order record.

Insurance - Cost

Cost of the additional insurance option set in the shipping details.

Insurance - Insured Value

Total insured value set in the Insurance section of the shipping details.

Insurance - Provider

Name of the insurance provider selected in the Insurance section of the shipping details.

Market - Market Order URL

Direct URL to navigate to the order details within the marketplace. Not available for all marketplaces.

Market - Marketplace Name

The name of the integration that was used to create the order record in ShipStation.

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

Market - Store Name

Store Name for store the order record was created in.

Notes - From Buyer

Notes from Buyer for the order record.

Notes - Internal

Internal Notes for the order record.

Notes - To Buyer

Internal Notes for the order record.

Order - CustomerID

ShipStation internal identifier for the customer who placed the order.

Order - Number

Order Number for the order record.

Order - Pay Method

Payment Method for the order record.

Order - Status

Status of the order record.

Service - Confirmation Type

Confirmation Type set in the Shipping Info on the order record.

Service - Package Type

Package set in the Shipping Info for the order record.

Ship To - Address 1

Ship To Address Line 1 for the order record.

Ship To - Address 2

Ship To Address Line 2 for the order record.

Ship To - Address 3

Ship To Address Line 3 for the order record.

Ship To - City

Ship To City for the order record.

Ship To - Company

Ship To Company for the order record.

Ship To - Country

Ship To Country for the order record.

Ship To - Name

Ship To Name for the order record.

Ship To - Phone

Ship To Phone for the order record.

Ship To - Postal Code

Ship To Postal Code for the order record.

Ship To - Residential Flag

Indicates if the order's address was validated as a Residential address.

Ship To - State

Ship To State for the order record.

Ship To - Verified Flag

Indicates if the order's address was verified.

Ship To - Zone

USPS Zone for the order record, based on the Ship To Postal Code and the Ship From set in the Shipping Info

Source

Source for the order record.

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

Tags

Name(s) of Tag(s) which are currently applied to the order.

Username

Username shows the primary username associated with the ShipStation account.

Weight

Weight set in the Shipping Info for the order record.

Weight - TotalOz

Total Weight (in ounces) set in the Shipping Info for the order record.

Weight - WeightLbs

Weight (in pounds) set in the Shipping Info for the order record. Value is rounded down and will not include ounces. Works best when used with Weight - WeightOz export field.

Weight - WeightOz

Weight (in ounces) set in the Shipping Info for the order record. Value does not include pounds. Works best when used with Weight - WeightLbs export field.

The price paid for the item itself (unit cost, retail price), plus any additional costs associated with acquiring it. Such costs may include shipping, customs duties, levies, delivery costs, shipping insurance, legal fees, etc. Add all these ancillary acquisition costs to the price of the item itself to get its Extended Price, as it appears on a receipt or invoice.

An extended price can show the price of the quantity purchased (so should you purchase only one of something, the ‘price’ and ‘extended price’ can be the same). It can show a discounted price due to a wholesale deal, a sale percentage from the regular price, or it can be some other price an individual seller sets.

Order Items Export Field List

The following fields are available in the Order Line Items export in the Orders 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 record.

Amount - Order Tax

Tax Paid for the order record.

Amount - Order Total

Total Order for the order record. This is the sum of the Product Total, Shipping Paid, and Tax Paid.

Amount - Paid by Customer

Total Paid for the order record.

Amount - Shipping Cost

The base cost of the estimated shipping rate based on shipment details. Does not include any additional fees.

Bill To - Name

Buyer Name for the order record.

Carrier - Carrier Selected

The name of the Carrier selected in the shipment details.

Carrier - Service Requested

Requested Shipping Service for the order record. Usually, this is the shipping option your customer chooses when checking out.

Carrier - Service Selected

The name of Service selected in the shipment details.

Customer Email

Buyer Email for the order 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.

Customs - Package Contents

Package Contents set in the Customs Declarations for the order record.

Date - Hold Until

Hold Until date for the order record.

Date - Order Date

Order Date for the order record.

Date - Paid Date

Paid Date for the order record.

Date - Ship By Date

Ship By Date for the order record.

Date - Shipped Date

Ship Date for the order record.

Gift - Flag

Indicates if the order is marked as a Gift.

Gift - Message

Gift Message for the order record.

Insurance - Cost

Cost of the additional insurance option set in the shipping details.

Insurance - Insured Value

Total insured value set in the Insurance section of the shipping details.

Insurance - Provider

Name of the insurance provider selected in the Insurance section of the shipping details.

Item - Category

Category for the product record associated with the line item in the order record.

Item - Cost

Unit Cost for the line item in the order record.

Item - Cost Extended

Extended Price for the line item in the order record.

Item - Fill SKU

Fulfillment SKU for the line item in the order record.

Item - Image URL

Image URL for the line item in the order record.

Item - ISBN

ISBN for the line item in the order record.

Item - Location

Warehouse Location for the line item in the order record.

Item - Name

Item Name for the line item in the order record.

Item - Options

Item Option for the line item in the order record.

Item - Origin Country Code

Customs Origin Country for the product record associated with the line item in the order record.

Item - Qty

Quantity for the line item in the order record.

Item - SKU

SKU for the line item in the order record.

Item - UPC

UPC for the line item in the order record.

Item - Weight

Weight for the line item in the order record.

Item - Weight (oz)

Weight (in ournces) for the line item in the order record.

Market - Market Order URL

Direct URL to navigate to the order details within the marketplace. Not available for all marketplaces.

Market - Marketplace Name

The name of the integration that was used to create the order record in ShipStation.

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

Market - Store Name

Store Name for store the order record was created in.

Notes - From Buyer

Notes from Buyer for the order record.

Notes - Internal

Internal Notes for the order record.

Notes - To Buyer

Internal Notes for the order record.

Order - Number

Order Number for the order record.

Order - Pay Method

Payment Method for the order record.

Order - Status

Status of the order record.

Order - Weight

Weight set in the Shipping Info for the order record.

Service - Confirmation Type

Confirmation Type set in the Shipping Info on the order record.

Service - Package Type

Package set in the Shipping Info for the order record.

Ship To - Address 1

Ship To Address Line 1 for the order record.

Ship To - Address 2

Ship To Address Line 2 for the order record.

Ship To - Address 3

Ship To Address Line 3 for the order record.

Ship To - City

Ship To City for the order record.

Ship To - Company

Ship To Company for the order record.

Ship To - Country

Ship To Country for the order record.

Ship To - Name

Ship To Name for the order record.

Ship To - Phone

Ship To Phone for the order record.

Ship To - Postal Code

Ship To Postal Code for the order record.

Ship To - Residential Flag

Indicates if the order's address was validated as a Residential address.

Ship To - State

Ship To State for the order record.

Ship To - Verified Flag

Indicates if the order's address was verified.

Ship To - Zone

USPS Zone for the order record, based on the Ship To Postal Code and the Ship From set in the Shipping Info

Source

Source for the order record.

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

The price paid for the item itself (unit cost, retail price), plus any additional costs associated with acquiring it. Such costs may include shipping, customs duties, levies, delivery costs, shipping insurance, legal fees, etc. Add all these ancillary acquisition costs to the price of the item itself to get its Extended Price, as it appears on a receipt or invoice.

An extended price can show the price of the quantity purchased (so should you purchase only one of something, the ‘price’ and ‘extended price’ can be the same). It can show a discounted price due to a wholesale deal, a sale percentage from the regular price, or it can be some other price an individual seller sets.

Export Order Record - Legacy

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

Custom Order Reports

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

Access the export options for orders in the Orders tab under the Other Actions menu.

Orders tab. Red arrow points to Other Actions dropdown. Red I-beam braces Export Orders & Export Order Line Items

There are two options for order export reports:

  • Orders Export

  • Order 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.

The price paid for the item itself (unit cost, retail price), plus any additional costs associated with acquiring it. Such costs may include shipping, customs duties, levies, delivery costs, shipping insurance, legal fees, etc. Add all these ancillary acquisition costs to the price of the item itself to get its Extended Price, as it appears on a receipt or invoice.

An extended price can show the price of the quantity purchased (so should you purchase only one of something, the ‘price’ and ‘extended price’ can be the same). It can show a discounted price due to a wholesale deal, a sale percentage from the regular price, or it can be some other price an individual seller sets.

Was this article helpful?
0 out of 0 found this helpful

Can’t find what you’re looking for?

Contact our technical support team.
Contact us