Insights Reports – ShipStation

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 will have varying 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. Click the link to jump to the details for that section:

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: 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.

Orders

The Orders report pulls data specific to the orders that have either imported into or been created in ShipStation.

Order Detail

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.

Country Comparison

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

Buyer Comments

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

	Field	What does it mean?
1	Marketplace	Marketplace or selling channel from which the order imported into ShipStation.
2	Order #	Order Number for the order
3	Recipient	Ship To Name for the order.
4	Note	Notes from Buyer for the order.

Products

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.

Item Demand Summary

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.

Product Sales

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.

Returned Products

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.

Shipments

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.

Shipment Count by User

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. Day: Each time period will be one day. Week: Each time period will be one week, beginning the Sunday of the week. Month: Each time period will be one month, beginning the 1st of the month. Year: Each time period will be one year, beginning January 1st.
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.

Shipped Items

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.

Shipping Cost

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)

Shipping Manifest

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.

Batch Detail

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.

Accounting

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.

Account Balance History

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.

Inventory Reports

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.

Inventory Low Stock Report

The Inventory Low Stock Report will provide you with a list of products whose stock count is 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.

Run an Inventory Low Stock Report

Scroll down to the Inventory Reports section and choose Inventory Low Stock Report.
Choose Yes or No for the Group Products By Parent SKU drop-down menu, and select your preference for how to receive the report (Run Report, Export to PDF, Export to Excel, Export to Text).

Inventory Audit Report

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.

Run an Inventory Audit Report

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).

Inventory Out-of-Stock Shipments

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.

Run an Inventory Out-of-Stock Shipments Report

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).

Inventory Status Report

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.

Run an Inventory Status Report

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).

Hotkey and Barcode Scan Actions

The Hotkey and Barcode Scan Actions reports each contain a collection of barcode and hotkey references you can use to perform actions within ShipStation.

Hotkey Reference Sheet

The Hotkey Reference Sheet report will generate a list of hotkey actions you can use within ShipStation.

Optional Filters:

Hotkey Type

Basic Hotkey
	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 Hotkey
	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 form 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 + b	Go to Shipments > End of Day
c	Show Rate Calculator	g + e	Go to Shipments > Pickup
b	Create new batch	g + k	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
p + s	Print Order Summary	g + a + b	Print Order Summary

Barcode Scan Action Report

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

Barcode Scan Action Quick Reference Sheet

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

Raw Data Exports

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.

Customers

The Customers Raw Data Export provides a list of customers who created an order within a date range.

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

Orders

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

Shipped Orders

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.

Shipped Items

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.

Product Aliases

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.

Orders

Order Detail

Country Comparison

Buyer Comments

Products

Item Demand Summary

Product Sales

Returned Products

Shipments

Shipment Count by User

Shipped Items

Shipping Cost

Shipping Manifest

Batch Detail

Accounting

Note

Account Balance History

Inventory Reports

Inventory Low Stock Report

Run an Inventory Low Stock Report

Inventory Audit Report

Run an Inventory Audit Report

Inventory Out-of-Stock Shipments

Run an Inventory Out-of-Stock Shipments Report

Inventory Status Report

Run an Inventory Status Report

Hotkey and Barcode Scan Actions

Hotkey Reference Sheet

Barcode Scan Action Report

Note

Barcode Scan Action Quick Reference Sheet

Raw Data Exports

Customers

Orders

Shipped Orders

Shipped Items

Product Aliases

Related articles

Didn’t Find What You Were Looking For?