How to export order records from the Orders tab.
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!
To export your order data as a CSV, go to the Orders tab and follow the steps below:
-
Select the orders(s) you want to export, or use filters to build a list of all the orders you want to export.
-
Click Other Actions, then Export Orders.
-
Select whether you want to export all orders in view, or just the selected order(s).
-
Select whether you want to Export Orders or Export Order Line Items.
-
Select whether you want to export the file based on the current view which is displayed, or use a custom export format.
-
Click Export.
ShipStation will export the CSV file and initiate a download through your browser.
To create a custom export format from the Orders tab:
-
Select the orders(s) you want to export, or use filters to build a list of all the orders you want to export.
-
Click Other Actions, then Export Orders.
-
Click the Create a New Format button.
-
Name the export format.
-
Add the fields you want included on the export.
To do this, select the field and click the right arrow button
. To remove, select the field and click the left arrow button
.
-
Optional Step: Rename the column header on the exported CSV file by clicking the edit icon next to the field name.
-
Click Save Export Format when you're done.
ShipStation will save the export format to your account for you to reuse in the future.
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 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.
If you are using ShipStation's Legacy Layout, follow the instructions below to export order information.
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.
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.
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.
Once you have opened the export pop-up for your report, do the following to create a custom export:
-
Click the Create a New Format button.
-
Add the fields you wish to export.
To do this, select the field and click the right arrow button
. To remove, select the field and click the left arrow button
.
-
Optional Step: Rename the column header on the exported CSV file by clicking the icon to the right of the field name.
-
View additional available fields by checking the Show Advanced Options checkbox.
-
Click Save Export Format when you're done.
ShipStation will save the export format to your account for you to reuse in the future.