The Products reports pull 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 a list of products 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) of the Order 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 is 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 a list of products 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 the store.
Required Filters:
-
Ordered During (Start Date and End Date)
-
Show Products By
Optional Filters:
-
Store
Image # |
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 select a store from the optional Store filter, the report will include product sales for all stores, grouped by 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 included in return shipments created for ShipStation orders. The report will also include the reason for the return at the 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. |