The Orders reports pull data specific to the order records that have either imported into or been created in ShipStation.
Export Order Records
You can export your current orders from the Orders tab into a CSV file. By exporting directly from the Orders tab, you can apply additional filters to your report, such as order status, destination, line items, and more.
The Order Detail report will generate a block of information for each order that matches the parameters of the filter. Below, the numbers in red on the screenshot correspond to their listed explanations.
Required Filters:
-
Date Range (Start Date and End Date)
Optional Filters:
-
Store
Other Options:
-
Include product images on order details report
|
Image # |
Field |
What does it mean? |
|---|---|---|
|
1 |
Recipient Name |
Ship To Name for the order. |
|
2 |
Recipient Address |
Ship To Address 1 & 2 for the order. |
|
3 |
Recipient City |
Ship To City for the order. |
|
4 |
Recipient State Code |
Ship To State for the order. |
|
5 |
Recipient Postal Code |
Ship To Post Code for the order. |
|
6 |
Recipient Country Code |
Ship To Country for the order. |
|
7 |
Date Paid |
The date the order was paid for, according to the order source. |
|
8 |
Amt Paid |
The amount the customer paid for the order, according to the order source. |
|
9 |
Record # |
Order Number for the order. |
|
10 |
Store |
The Name of the store where the order was created. |
|
11 |
Marketplace |
The marketplace or selling channel the store is connected to. |
|
12 |
Buyer Comments |
Notes from Buyer for the order. |
|
13 |
Internal Notes |
Internal Notes for the order. |
|
14 |
Item Image Thumbnail |
Thumbnail image generated using the Product Image URL. Will only be displayed if Include product images on order details report option is selected. |
|
15 |
Item ID |
Product SKU for each unique line item in the order. |
|
16 |
Title |
Product Name for each unique line item in the order. |
|
17 |
Options |
Product Options for each unique line item in the order. |
|
18 |
Unit Price |
Individual Unit Price for each unique line item in the order. |
|
19 |
Quantity |
Quantity for each unique line item in the order. |
|
20 |
Extended Price |
Multiply Unit Price x Quantity for each unique line item in the order. |
The Country Comparison report will generate a chart and breakdown of orders based on the Ship To Country.
Required Filters:
-
Date Range (Start Date and End Date)
|
Image # |
Field |
What does it mean? |
|---|---|---|
|
1 |
Sales by Country Graph |
Pie chart representing the sum of all product Quantities for orders with an Order Date within the date range, organized by Ship To Country. |
|
2 |
Items Sold Country Graph |
Pie chart representing the sum of all Order Totals for orders with an Order Date within the date range, organized by Ship To Country. |
|
3 |
Country Name |
Country name for each unique Ship To Country for orders with an Order Date within the date range |
|
4 |
Country Abbreviation |
The 2-digit country code for each unique Ship To Country for orders which have an Order Date within the date range |
|
5 |
Items Sold |
Sum of all product Quantities for orders going to the Ship To Country with an Order Date within the date range |
|
6 |
Total Sales |
Sum of all Order Totals for orders going to the Ship To Country with an Order Date within the date range |
The Buyer Comments report will provide you a list of orders that include a Note from Buyer as well as the text of the note.
Required Filters:
-
Date Range (Start Date and End Date)
Optional Filters:
-
Order Status