How to export order records from the Orders tab.
ShipStation allows you to export order data as a CSV-formatted file. You can export a report for either Orders or Order Line Items.
Type of Export |
Details |
|---|---|
Export Orders |
Lists each unique order on it's own row and will not include product-specific information |
Export Order Line Items |
Lists each unique product in an order on it's own row. A multi-product order will include multiple rows. |
The data in the CSV file will either be based on the current view on the Orders grid, or you can create a custom export format.
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:
-
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 the Orders tab. The table includes descriptions of what data the field will contain or where that data is pulled from in ShipStation.
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.