Breakdown of the pre-formatted reports which can be generated on the Reports section of the Insights tab.
The Reports section of the Insights page provides several pre-formatted reports you view directly in ShipStation, or export to a document such as PDF, CSV, Excel, or plain text.
Each report has various filter options to help you export only the data you need, whether that data is within a specific date range or from a specific store or carrier account.
The reports are sorted into the following categories:
Orders: Reports include Order Details, Buyer Comments, and Country Comparison.
Products: Reports include Item Demand Summary, Returned Products, and Product Sales.
Shipments: Shipment Count by User, Shipping Manifest, Shipped Items, Shipping Cost, and Batch Detail.
Accounting: Report includes Account Balance History.
-
Inventory Reports: Reports include Inventory Low Stock Report, Inventory Out of Stock Shipments, Inventory Audit Report, and Inventory Status Report.
These inventory reports relate only to ShipStation's Native Inventory Solution.
Hotkey & Barcode Scan Actions: Shipstation Legacy Layout Only. Reports include a Hotkey Reference Sheet, Barcode Scan Action Quick Reference Sheet, and a Barcode Scan Action Report.
Raw Data Exports: Reports include Customers, Shipped Items, Orders, Shipped Orders, and Product Aliases.
The sections below provide details on each of the reports within each section, including information on where ShipStation pulls the data in the reports from.
The Orders report pulls data specific to the orders that have either imported into or been created in ShipStation.
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
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)
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
The Products report pulls data specific to the products included on order records in ShipStation or products included on orders that have had returns processed in ShipStation.
The Item Demand Summary report will provide you a list of products that were ordered in the given date range, and their total revenue. This report is similar to the Product Sales report, but can be filtered based on order status.
Required Filters:
Date Range (Start Date and End Date)
Group Product By
Optional Filters:
Order Status
Order Filter
Other Options:
Sort By
Field |
What does it mean? |
|---|---|
SKU |
If the Group Product By filter is set to Marketplace Listing SKU, this will be the SKU that imported in ShipStation from the order's source. If the Group Product By filter is set to Product Record SKU or Parent Record, this will be the SKU for the product record stored in ShipStation. |
Item Name |
The Product Name for the product record. |
# Orders |
Count of orders that include the product record as a line item. |
# Items |
Sum of Quantity for the product record. |
Item Revenue |
Sum of Extended Price for the product record. |
The Product Sales report will provide you a list of products that were ordered in the given date range, and their total revenue. This report is similar to the Item Demand Summary report, but can be filtered based on store.
Required Filters:
Ordered During (Start Date and End Date)
Show Products By
Optional Filters:
Store
Field |
What does it mean? |
|
|---|---|---|
1 |
Store Name |
The Name of the store where the order product data was pulled from. If you do not use the optional Store filter, the report will populate based on store. |
2 |
SKU |
If the Show Product By filter is set to Marketplace Listing SKU, this will be the SKU that imported in ShipStation from the order's source. If the Show Product By filter is set to Product Record SKU or Parent Record, this will be the SKU for the product record stored in ShipStation. |
3 |
Description |
The Product Name for the product record. |
4 |
Category |
The Category for the product record. |
5 |
Qty Sold |
Sum of Quantity for the product record |
6 |
Total Sales |
Sum of Extended Price for the product record |
7 |
Qty Sold (Total for Store) |
Sum of Quantity for all products from the store. |
8 |
Total Sales (Total for Store) |
Sum of Extended Price for all products from the store. |
The Returned Products report will provide a list of products that were included in return shipments created for ShipStation orders. The report will also include the reason given for the return at time of shipment creation, as well as the carrier fee for both the original outbound shipping label and the return label.
Required Filters:
Date Range (Start Date and End Date)
Field |
What does it mean? |
|---|---|
SKU |
Item SKU for the return shipment line item. |
Product Title |
Item Name for the return shipment line item. |
Qty Returned |
Quantity for the return shipment line item. |
Product Cost |
Unit Price for the return shipment line item. |
Return Reason |
Return reason selected when the return was created through ShipStation or the Branded Returns Portal. |
Outbound Shipping |
Carrier Fee for the original outbound shipping label associated with the return. |
Inbound Shipping |
Carrier Fee for the return shipping label. |
Sold To |
Buyer Name for the order associated with the return. |
The Shipments reports pull data specific to shipment records in ShipStation. These reports do not include fulfillments, orders marked as shipped, or orders updated to the Shipped status via store updates.
The Shipment Count by User report will provide you with a bar graph and table that depicts the count of shipments, by each specific user, sorted by a time period you select when generating the report.
Below, the numbers in red on the screenshot correspond to their listed explanations.
Required Filters:
Date Range (Start Date and End Date)
Group By (controls the Time Period into which data will be separated.)
Optional Filters:
User
Field |
What does it mean? |
|
|---|---|---|
1 |
Shipment Count Bar Graph |
Graph depicts the total number of shipments, by each user, for each time period. |
2 |
User Legend |
List of all users who created shipments within the Start Date and End Date. Displays the color code that represents the user on the Shipment Count Bar Graph. |
3 |
Time Period |
The date or date range when the shipments were created. The time period will vary based on which Group By filter was selected when report was generated.
|
4 |
User Name |
Full Name of user who created shipments. |
5 |
User Shipments |
Count of shipments created by the specific user in the time period. |
6 |
Total Per User |
Count of shipments created by the specific user within the Start Date and End Date. |
7 |
Total Per Time Period |
Count of shipments created by any user within the time period. |
8 |
Grand Total |
Count of shipments created by any user within the Start Date and End Date. |
The Shipped Items report provides a list of items that are included in shipment records, with the total quantity shipped and total revenue of the product.
Required Filters:
Shipped During (Start Date and End Date)
Optional Filters:
Store
Field |
What does it mean? |
|
|---|---|---|
1 |
Store Name |
The Store Name for the store from which ShipStation received the orders. Even if no Store filter is selected, the report will sort based on store. |
2 |
SKU |
Imported Item SKU for shipment line item. |
3 |
Alias SKU |
SKU for ShipStation product record linked to imported Item SKU. |
4 |
Description |
Item Name for the shipment line item. |
5 |
Qty Sold |
Sum of Quantity for the all shipment line items with the imported Item SKU. |
6 |
Total Sales |
Sum of (Unit Price x Quantity) for the all shipment line items with the imported Item SKU. |
7 |
Qty Sold for store |
Sum of Quantity for the all shipment line items in the store. |
8 |
Total Sales for store |
Sum of (Unit Price x Quantity) for the all shipment line items in the store. |
The Shipping Cost Report will provide you with list of your shipments which includes a the amount the customer paid you for shipping when the order was placed in comparison to the actual cost of the shipment created in ShipStation.
Required Filters:
Shipping During (Start Date and End Date)
Optional Filters:
Store
Provider
Shipping Account
Service
Field |
What does it mean? |
|
|---|---|---|
1 |
Store Name |
The Store Name for the store that ShipStation received the orders from. Even if no Store filter is selected, the report will be sorted based on store. |
2 |
Ship Date |
Ship Date for the shipment. |
3 |
Recipient |
Ship To Name for the shipment. |
4 |
Order # |
Order # for the order linked to the shipment. |
5 |
Provider |
Name of the postage provider used to generate the label. |
6 |
Service |
Abbreviation of the shipping service used to generate the label. |
7 |
Package |
Abbreviation of the package type used to generate the label. |
8 |
Items |
Total Quantity of all line items in the shipment. |
9 |
Zone |
USPS Zone for the shipment. |
10 |
Shipping Paid |
Shipping Paid by the customer for the order linked to the shipment. |
11 |
Shipping Cost |
Carrier Fee for the shipment. |
12 |
Insurance Cost |
Insurance Fee for the shipment. |
13 |
Weight (oz) |
Total Weight in ounces for the shipment. |
14 |
Difference (+/-) |
Shipping Paid minus (Shipping Cost + Insurance Cost) |
15 |
Total Items for Store |
Sum of Items for all shipments in the store. |
16 |
Total Shipping Paid for Store |
Sum of Shipping Paid by the customer for all shipments in the store. |
17 |
Total Shipping Cost for Store |
Sum of Carrier Fee for all shipments in the store. |
18 |
Total Insurance Cost for Store |
Sum of Insurance Fee for all shipments in the store. |
19 |
Total Weight (oz) for Store |
Sum of Weight (oz) for all shipments in the store. |
20 |
Total Difference (+/-) for Store |
Total Shipping Paid for Store minus (Total Shipping Cost for Store + Total Insurance Cost for Store) |
The Shipping Manifest report will provide you with a list of all shipments created with a specific Ship Date.
Required Filters:
Shipping Date
Optional Filters:
Provider
Shipping Account (based on Provider filter selected)
Ship From Location
Field |
What does it mean? |
|
|---|---|---|
1 |
Total Packages |
Sum of Package Count for all shipments in the report. |
2 |
Total Items |
Sum of Items for all shipments in the report. |
3 |
Total Weight (lbs) |
Sum of Weight (oz) for all shipments in the report, displayed as pounds. |
4 |
Total Customs Value |
Sum of Customs Declared Value for all shipments in the report. |
5 |
Total Cost |
Sum of Carrier Fee for all shipments in the report. |
6 |
Recipient |
Ship To Name for the shipment. |
7 |
Service |
Abbreviation of the shipping service used for the shipment. |
8 |
Weight (oz) |
Weight (oz) for the shipment. |
9 |
Cost |
Carrier Fee for the shipment. |
10 |
Tracking # |
Tracking Number for the shipment. |
11 |
Order # |
Order Number for the order linked to the shipment. |
12 |
Store |
Store Name for the order linked to the shipment. |
13 |
Items |
Sum of Quantity for all line items in the shipment. |
14 |
Item Name |
Item Name for each line item in the shipment. |
15 |
Item Quantity |
Quantity for each line item in the shipment. Value will only be displayed if greater than 1. |
16 |
Service Pie Chart |
Pie Chart representing all shipments in the report, separated based on Service. |
The Batch Detail report will provide you with a list of batches which were created in ShipStation.
Required Filters:
Date Range (Ship Date) (Start Date and End Date)
Field |
What does it mean? |
|
|---|---|---|
1 |
Batch # |
Batch Number for the batch. |
2 |
Batch Notes |
Notes which were added to the batch. |
3 |
Created By |
Full Name of the agent which processed the batch. |
4 |
Processed Date |
Date which the batch was created. |
5 |
Ship Date |
The Ship Date used when creating the shipping labels in the batch. |
6 |
Ship From |
The Ship From Location used when creating the shipping labels in the batch. |
7 |
# Labels |
Count of shipping labels which were successfully created in the batch. |
8 |
# Errors |
Count of shipments which were included in the batch that encountered an error when attempting to generate the shipping label. |
The Accounting report pulls data specific to postage purchases from connected USPS shipping providers.
Note
This section will be hidden unless you have Stamps.com, Express 1, or Endicia connected to ShipStation as a shipping provider.
The Account Balance History will provide you with a transaction history of any changes made to the funds available in the postage provider account.
Required Filters:
Purchased During (Start Date and End Date)
Provider
Shipping Account (based on Provider filter selected.)
Optional Filters: (only available if Stamps.com is selected as Provider)
Filter (Transaction Type)
Additional Notes:
If Endicia is selected as the Provider, the Purchased During filter should be set to a time period no greater than 7 consecutive days. If the date range is greater than 7 days, the report will not generate.
Field |
What does it mean? |
|---|---|
Transaction Time |
Date and time when the transaction occurred. |
Activity / Tracking # |
Description of the event. Endicia and Express 1 reports will also provide tracking number related to transaction. |
Amount |
The value of the transaction. |
Balance |
Total account balance resulting from the transaction. |
The Inventory Reports pull data specific to ShipStation's internal inventory solution. These reports do not reference inventory levels maintained by connected marketplaces, selling channels, or other third-party services.
The Inventory Low Stock Report will provide you with a list of products whose stock count is at or below the reorder threshold set in the product defaults.
Required Filters:
Group Products By Parent SKU
Field |
What does it mean? |
|---|---|
SKU |
Item SKU for the product. If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item SKU instead. |
Product Name |
Item Name for the product. If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item Name instead. |
Stock |
Total Stock count for the product or Parent product. |
Allocated |
Amount of the product or Parent product placed in orders that are currently Allocated. |
Available |
Total Stock count minus Allocated. |
Re-Order Threshold |
The Reorder Threshold set in the product defaults for the product or Parent product. |
Shortage |
Available divided by Re-Order Threshold as a percentage. |
The Inventory Audit Report provides a list of any stock changes that occurred within a selected time frame.
Required Filters:
Date Range (Action Date) (Start Date and End Date)
Optional Filters:
Specific SKU
Field |
What does it mean? |
|---|---|
SKU |
Item SKU for the product. |
Product Name |
Item Name for the product. |
Event Date/Time |
Date and time when the action occurred. |
Type |
Action that occurred. |
Quantity |
Amount to which total stock count changed. |
Stock |
Total stock count after action occurred. |
User |
User who initiated the action. |
Description |
The Note entered during the action. Only available when adjusting stock manually through product defaults. |
-
Scroll down to the Inventory Reports section and choose Inventory Audit Report.
-
Choose Inventory Warehouse from the drop-down menu, set Date Range ShipDate) , and enter the Specific SKU.
Select your preference for how to receive the report (Run Report, Export to PDF, Export to Excel, Export to Text).
The Inventory Out-of-Stock Shipments report lists shipments created with out-of-stock products in the order.
Required Filters:
Date Range (Action Date) (Start Date and End Date)
Optional Filters:
Specific SKU
Field |
What does it mean? |
|---|---|
Tracking # |
Tracking Number for the shipment. |
Order # |
Order Number for the order linked to the shipment. |
Ship Date |
Ship Date for the shipment. |
User |
Full Name of the user who created the shipment. |
Action |
Action(s) taken by the user when creating the shipment. |
SKU |
Item SKU for the out-of-stock product. |
Name |
Item Name for the out-of-stock product. |
Qty |
Line Item Quantity of the out-of-stock product shipped. |
-
Scroll down to the Inventory Reports section and choose Inventory Out-of-Stock Shipments Report.
-
Choose Inventory Warehouse from the drop-down menu, set Date Range ShipDate) , and enter the Specific SKU .
Select your preference for how to receive the report (Run Report, Export to PDF, Export to Excel, Export to Text).
The Inventory Status Report provides inventory stock counts for a list of products that have an assigned inventory location.
Required Filters:
Group Products By Parent SKU
Field |
What does it mean? |
|---|---|
SKU |
Item SKU for the product. If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item SKU instead. |
Product Name |
Item Name for the product. If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item Name instead. |
Last Cost |
Cost amount entered the last time stock count was adjusted. |
Avg Cost |
Average Cost amount when stock count is adjusted. |
Stock |
Total Stock count for the product or Parent product. |
Allocated |
Amount of the product or Parent product in currently Allocated orders. |
Available |
Total Stock count minus Allocated |
Re-Order Threshold |
Reorder Threshold set in product defaults for the product or Parent product. |
-
Scroll down to the Inventory Reports section and choose Inventory Status Report.
-
Select which Inventory Warehouse(s) and choose Yes or No for the Group Products By Parent SKU drop-down menu.
Select your preference for how to receive the report (Run Report, Export to PDF, Export to Excel, Export to Text).
The Hotkey and Barcode Scan Actions reports each contain a collection of barcode and hotkey references you can use to perform actions within ShipStation.
ShipStation Legacy Layout Only
The Hotkey and Barcode Scan Action reports are currently only available when using ShipStation's Legacy Layout.
The Hotkey Reference Sheet report will generate a list of hotkey actions you can use within ShipStation.
Optional Filters:
Hotkey Type
Basic Hotkeys | |
|---|---|
General |
|
? |
List hotkeys (a.k.a. keyboard shortcuts) |
Esc |
Close window |
Shift + Click |
Select multiple rows |
Ctrl + Click |
Toggle row selection |
▼ |
Move to the next row |
▲ |
Move to the previous row |
► |
Move to the next Order Details window |
◄ |
Move to the previous Order Details window |
Ctrl + Shift + S |
Enable Barcode Listening screen to view, batch, or ship scanned orders. On a Mac, use Cmd + Shift + s instead. |
Advanced Hotkeys | |||
|---|---|---|---|
Shipping Orders |
Navigation |
||
U |
Update all stores |
/ |
Focus QuickSearch |
N |
Create new orders |
G + O |
Go to Orders |
V |
View Order Details window |
G + S |
Go to Shipments |
W |
Read weight from scale |
G + F |
Go to Shipments > Fulfillments |
R |
Get rate |
G + R |
Go to Shipments > Returns |
Q |
Toggle QuickShip |
G + B |
Go to Shipments > Batches |
S |
Create label (a.k.a. Ship Orders) |
G + E |
Go to Shipments > End of Day |
C |
Show Rate Calculator |
G + K |
Go to Shipments > Pickup |
B |
Create new batch |
G + P |
Go to Products |
O + R |
Reload Orders grid |
G + I |
Go to Products > Inventory |
P + B |
Process the currently open batch |
G + C |
Go to Customers |
G + A + M |
Go to Account Settings |
||
G + A + S |
Go to Store Setup Settings |
||
Printing Documents |
G + A + C |
Go to Carrier & Fulfillment Settings |
|
P + S |
Print Packing Slip |
G + A + P |
Go to Print Setup Settings |
P + L |
Print Pick List |
G + A + N |
Go to ShipStation Connect Settings |
O + S |
Print Order Summary |
G + A + B |
Print Order Summary |
The Barcode Scan Action Report will generate a PDF document that includes a pre-selected list of barcodes you can use to perform actions in ShipStation. For a more customized version of this report, see the Barcode Scan Action Quick Reference Sheet.
Optional Filters:
Scan Action Type
Include Hotkeys
Scan Action Type: General
Scan Action Type: Custom Shipping Presets
Note
Will generate a list of barcodes based on the Shipping Presets you've created in your account. Only Shipping Presets that have hotkeys assigned to them can be used with barcodes.
Scan Action Type: Shipping Orders
Scan Action Type: Printing Documents
Scan Action Type: Navigation
The Barcode Scan Action Quick Reference will generate a PDF document that includes up to 10 barcodes you can use to perform actions in ShipStation.
Required Filters:
Include Hotkeys
Available Scan Actions:
General
Close modal
List hotkeys (a.k.a. keyboard shortcuts)
Enable Barcode Listening screen to view, batch or ship scanned orders.
Move to the next row
Move to the previous row
Move to the next Order Detail window
Move to the previous Order Detail window
Custom Shipping Presets
Varies, based on user account
Shipping Orders
Read weight from scale
Show Rate Calculator
Update all stores
Create new order
View Order Details window
GetRate
Create label (a.k.a. Ship Order)
Create new batch
Reload Orders Grid
Process the currently open batch
Toggle QuickShip
Printing Documents
Print Packing Slip
Print Pick List
Print Order Summary
Navigation
Go to Store Setup Settings
Go to Account Settings
Focus QuickSearch
Go to Orders
Go to Shipments
Go to Shipments > Fulfillments
Go to Shipments > Returns
Go to Shipments > Batches
Go to Shipments > End of Day
Go to Shipments > Pickup
Go to Products
Go to Products > Inventory
Go to Customers
Go to Carriers & Fulfillment Settings
Go to Printing Setup Settings
Go to ShipStation Connect Settings
Go to Subscription Settings
The Raw Data Exports are reports that contain a lot of raw information related to the subject of the report, but the information is not formatted or sorted in any particular fashion. You would then
use the information found in the file to build your own reports.
The Customers Raw Data Export provides a list of customer records created in ShipStation within a selected date range that also have order records in ShipStation. Please note that customer records that do not have any orders yet will not appear on this report.
Required Filters:
Date Range (Start Date and End Date)
Field |
What does it mean? |
|---|---|
Address 1 |
Address Line 1 for the customer record. |
Address 2 |
Address Line 2 for the customer record. |
City |
City for the customer record. |
Company |
Company for the customer record. |
Country |
Two-character Country code for the customer record. |
Created |
Date the customer record was created in ShipStation. |
Customer ID |
ShipStation's internal identification number for the customer record. |
Email for the customer record. |
|
Last Order |
Order Date for the most recent order linked to the customer record. |
Modified |
Date the customer record was last changed in ShipStation. |
Name |
Name for the customer record. |
Orders |
Count of orders linked to the customer record. |
Phone |
Phone for the customer record. |
State |
State for the customer record. |
Zip |
Zip (Postal Codes) for the customer record. |
The Orders Raw Data Export provides a list of orders created within a date range. The export does include products, and each unique product in an order will receive its own row on the report.
Required Filters:
Date Range (Start Date and End Date)
Optional Filters:
Store
Field |
What does it mean? |
|---|---|
OrderActive |
If TRUE, the order is active in ShipStation. Inactive orders are not accessible in ShipStation. |
OrderAdditionalHandling |
If TRUE, the Other Shipping Option This shipment requires Additional Handling is enabled for the order. |
OrderAddressVerified |
0 - Address has not been verified. 1 - Address was verified successfully. 2 - Address was verified, but there is a warning or error. |
OrderAmountPaid |
Total Paid for the order record. |
OrderBuyerEmail |
Buyer Email for the order record. |
OrderConfirmation |
Confirmation Type set in the Shipping Info on the order record. |
OrderConfirmationCost |
Confirmation cost for most recent estimated rate for the order record. |
OrderCreateDate |
Date the order record was created in ShipStation. |
OrderCustomer |
Buyer Name for the order record. |
OrderCustomField1 |
Custom Field 1 for the order record. |
OrderCustomField2 |
Custom Field 2 for the order record. |
OrderCustomField3 |
Custom Field 3 for the order record. |
OrderCustomsContents |
Package Contents set in the Customs Declarations for the order record. |
OrderDate |
Order Date for the order record. |
OrderExternalPaymentID |
The marketplace's internal identifier for the payment associated with the order data. Only available for ChannelAdvisor and Sears. |
OrderExternalURL |
URL leading to the order's record on the marketplace. |
OrderHeight |
Height set in the Shipping Info for the order record. |
OrderHoldUntil |
Hold Until date for the order record. |
OrderID |
ShipStation's internal identifier for the order record. |
OrderImportBatch |
ShipStation's internal identifier for the action that created the order record. |
OrderImportKey |
The identifier that ShipStation will use to match imported order data to order records. Usually, this is the marketplace's internal identifier for the order, or the order number. |
OrderInsuranceCost |
Insurance cost for most recent estimated rate for the order record. |
OrderInsuranceProvider |
Name of Insurance option set in the Shipping Info for the order record. |
OrderInsuredValue |
Value for Insurance option set in the Shipping Info for the order record. |
OrderInternalNotes |
Internal Notes for the order record. |
OrderItemCreateDate |
Date the item within the order record was created in ShipStation. |
OrderItemDescription |
Name for the item within the order record. |
OrderItemExtendedPrice |
Extended Price for the item within the order record. |
OrderItemExternalID |
The marketplace's identifier for the item within the order record. |
OrderItemID |
ShipStation's internal identifier for the item within the order record. |
OrderItemISBN |
ISBN for the item within the order record. |
OrderItemItemURL |
orderitem.itemurl (based on order.orderid) |
OrderItemModifyDate |
Date that the item within the order record was last changed in ShipStation. |
OrderItemOptions |
Item Options for the item within the order record. |
OrderItemOrderId |
ShipStation's internal identifier for the order record. |
OrderItemQuantity |
Quantity for the item within the order record. |
OrderItemShippingAmount |
Shipping Amount for the item within the order record. |
OrderItemSku |
SKU for the item within the order record. |
OrderItemTaxAmount |
Tax Amount for the item within the order record. |
OrderItemThumbNailUrl |
Image URL for the item within the order record. |
OrderItemUnitCost |
Unit Cost for the item within the order record. |
OrderItemUnitPrice |
Unit Price for the item within the order record. |
OrderItemUPC |
UPC for the item within the order record. |
OrderItemWarehouse |
Warehouse Location for the item within the order record. |
OrderItemWeight |
Weight for the item within the order record. |
OrderItemWeightOz |
Weight (in ounces) for the item within the order record. |
OrderLength |
Length set in the Shipping Info for the order record. |
OrderMarketplaceName |
The name of the integration that was used to create the order record in ShipStation. Examples: eBay, Shopify, StitchLabs, Custom Store, ShipStation |
OrderModifyDate |
Date that the order record was last changed in ShipStation. |
OrderNonDelivery |
If Non-Delivery set in the Customs Declarations for the order record. |
OrderNonMachinable |
If TRUE, the Other Shipping Option This order is non-machinable is enabled for the order. |
OrderNotesFromBuyer |
Notes from Buyer for the order record. |
OrderNotesToBuyer |
Notes to Buyer for the order record. |
OrderNumber |
Order Number for the order record. |
OrderOtherCosts |
Additional Charges for most recent estimated rate for the order record. |
OrderPackageType |
Package set in the Shipping Info for the order record. |
OrderPayDate |
Paid Date for the order record. |
OrderProvider |
Name of postage provider for Service set in the Shipping Info for the order record. |
OrderRateError |
Error message text for most recent estimated rate for the order record. |
OrderRequestedShippingService |
Requested Shipping Service for the order record. Usually, this is the shipping option your customer chooses when checking out. |
OrderResidentialIndicator |
C - Order was verified as a Commercial address. R - Order was verified as a Residential address. |
OrderSaturdayDelivery |
If TRUE, the Other Shipping Option Saturday Delivery is enabled for the order. |
OrderService |
Service set in the Shipping Info for the order record. |
OrderShipCity |
Ship To City for the order record. |
OrderShipCompany |
Ship To Company for the order record. |
OrderShipCountryCode |
Ship To Country for the order record. |
OrderShipDate |
Ship Date for the order record. |
OrderShipName |
Ship To Name for the order record. |
OrderShipPhone |
Ship To Phone for the order record. |
OrderShippingAmount |
Shipping Paid for the order record. |
OrderShipPostalCode |
Ship To Postal Code for the order record. |
OrderShipState |
Ship To State for the order record. |
OrderShipStreet1 |
Ship To Address Line 1 for the order record. |
OrderShipStreet2 |
Ship To Address Line 2 for the order record. |
OrderShipStreet3 |
Ship To Address Line 3 for the order record. |
OrderShowPostage |
If TRUE, the Other Shipping Option Print postage on the shipping label for this order is enabled for the order. |
OrderStatus |
Status of the order record. |
OrderStoreName |
Store Name for store the order record was created in. |
OrderTotal |
Total Order for the order record. This is the sum of the Product Total, Shipping Paid, and Tax Paid. |
OrderUserName |
Buyer Username for the order record. |
OrderWarehouse |
Ship from set in the Shipping Info for the order record. |
OrderWeight |
Weight set in the Shipping Info for the order record. |
OrderWeightOz |
Weight (in ounces) set in the Shipping Info for the order record. |
OrderWidth |
Width set in the Shipping Info for the order record. |
TaxAmount |
Tax Paid for the order record. |
Zone |
USPS Zone for the order record, based on the Ship To Postal Code and the Ship From set in the Shipping Info |
The Shipped Orders Raw Data Export provides a list of shipments created within a date range.
Required Filters:
Date Range (Start Date and End Date)
Optional Filters:
Store
Field |
What does it mean? |
|---|---|
Amount Paid |
Amount Paid for the order used to create the shipment record. |
Batch ID |
ShipStation's internal identifier for the batch in which the shipment was created. |
Buyer Email |
Buyer Email for the order used to create the shipment record. |
Buyer Notified |
If TRUE, ShipStation sent a shipment confirmation email to the Buyer Email on the order used to create the shipment record. |
Buyer User ID |
Buyer Username for the order used to create the shipment record. |
Carrier |
Name of the Carrier used to create the shipping label for the shipment record. |
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 Transaction |
The postage provider's internal identifier for the shipping label for the shipment record. |
Confirmation |
Confirmation Type used to create the shipping label for the shipment record. |
Created By |
Full Name of the ShipStation user who created the shipment record. |
Date Paid |
Paid Date for the order used to create 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 Provider |
Insurance Provider used to create the shipping label for the shipment record. |
Insurance Transaction |
The insurance provider's internal identifier for the insurance purchase linked to the shipment record. |
Insurance Voided |
If TRUE, the insurance purchase was cancelled. |
Insured |
If TRUE, the shipment was insured. |
Insured Value |
Insurance Amount used to create the shipping label for the shipment record. |
Label Create Date |
Date the shipping label for the shipment record was created in ShipStation. |
Label Message |
Label Messages used to create the shipping label for the shipment record. |
Label Voided |
If TRUE, the shipping label for the shipment record was cancelled. |
Marketplace Notified |
If TRUE, ShipStation sent an update to the order's marketplace to update the marketplace order data to include shipment details. |
Order Date |
Order Date for the order used to create the shipment record. |
Order ID |
ShipStation's internal identifier for the order used to create the shipment record. |
Order Number |
Order Number for the order used to create the shipment record. |
Order Total |
Total Order for the order used to create the shipment record. |
Package Height |
Height used to create the shipping label for the shipment record. |
Package Length |
Length used to create the shipping label for the shipment record. |
Package Type |
Package used to create the shipping label for the shipment record. |
Package Width |
Width used to create the shipping label for the shipment record. |
Qty Shipped |
Sum of Quantity for all items in the order used to created the shipment record. |
Ship City |
Ship To City used to create the shipping label for the shipment record. |
Ship Company |
Ship To Company used to create the shipping label for the shipment record. |
Ship Country |
Ship To Country used to create the shipping label for the shipment record. |
Ship Date |
Ship Date used to create the shipping label for the shipment record. |
Ship Name |
Ship To Name used to create the shipping label for the shipment record. |
Ship Phone |
Ship To Phone used to create the shipping label for the shipment record. |
Ship Postal Code |
Ship To Postal Code used to create the shipping label for the shipment record. |
Ship State |
Ship To State used to create the shipping label for the shipment record. |
Ship Street 1 |
Ship To Address Line 1 used to create the shipping label for the shipment record. |
Ship Street 2 |
Ship To Address Line 2 used to create the shipping label for the shipment record. |
Shipment ID |
ShipStation's internal identifier for the shipment record. |
Shipping Paid |
Shipping Paid for the order used to create the shipment record. |
Shipping Service |
Abbreviation of the Service used to create the shipping label for the shipment record. |
Store Name |
Store Name for the order used to create the shipment record. |
TaxAmount |
Tax Paid for the order used to create the shipment record. |
Tracking Number |
Tracking Number of the shipping label for the shipment record. |
Void Date |
Date the shipping label for the shipment record was voided in ShipStation. |
Warehouse |
Name of the Ship From used to create the shipping label for the shipment record. |
Weight |
Weight used to create the shipping label for the shipment record. |
Weight Oz |
Weight (in ounces) used to create the shipping label for the shipment record. |
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. |
The Shipped Orders Raw Data Export provides a list of products within shipment records created within a date range.
Required Filters:
Date Range (Start Date and End Date)
Show Products By
Optional Filters:
Store
Field |
What does it mean? |
|---|---|
Carrier |
Name of the Carrier used to create the shipping label for the shipment record. |
Extended Price |
Extended Price of the item within the shipment record. |
Item Description |
Item Name of the item within the shipment record. |
Order # |
Order Number for the order used to create the shipment record. |
Order ID |
ShipStation's internal identifier for the order used to create the shipment record. |
Provider |
Name of the Shipping Postage Provider used to create the shipping label for the shipment record. |
Quantity |
Quantity of the item within the shipment record. |
Service |
Abbreviation of the Service used to create the shipping label for the shipment record. |
Ship Date |
Ship Date used to create the shipping label for the shipment record. |
Shipment ID |
ShipStation's internal identifier for the shipment record. |
SKU |
Item SKU of the item within the shipment record. |
Store Name |
Store Name for the order used to create the shipment record. |
Tracking # |
Tracking Number of the shipping label for the shipment record. |
Unit Price |
Unit Price of the item within the shipment record. |
Warehouse |
Name of the Ship From used to create the shipping label for the shipment record. |
The Product Aliases Raw Data Export will provide you with a list of products that have alias SKUs.
Required Filters:
Show Product Aliases For
Optional Filters:
Store
Field |
What does it mean? |
|---|---|
Product SKU |
The SKU for the product record. |
Product Alias |
The Alias SKU associated with the Product SKU |
Store Name |
The Store Name for the store that uses the Product Alias. |
Store ID |
ShipStation's internal identifier for the store that uses the Product Alias. |