Insights Reports: Products

Describes the reports available in the Products section of the Insights > Reports page in ShipStation.

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.

INS_Reports_ProductsSection_MRK.png

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

Product sales report with number annotations.

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.