← Shopify Reporting Community
Sales Reports

How can I create a Shopify sales report by product?

✓ Report Pundit Answer
1820
5
August 22, 2026
QUICK ANSWER

Group sales by product to compare revenue, quantity sold, discounts, returns, and net sales across your catalog.

Official answer

Create the report at product level and group order line items by product. The most useful measures are usually Quantity Sold, Gross Sales, Discounts, Returns, and Net Sales.

If you need to distinguish sizes, colors, or SKUs, switch the grouping to variant level instead of product level. This avoids combining variants that perform very differently.

For comparison over time, use the same sales definitions and date basis across periods. Mixing order date with refund date, for example, can make product performance appear inconsistent.

Follow-up questions

Can I break the product report down by variant?

Yes. Use Variant Title, Variant ID, or SKU as the grouping level when size, color, or other variants need separate performance rows.

Which sales metric should I compare across products?

Net Sales is often the most useful starting point because it reflects discounts and returns, while Gross Sales is useful for understanding demand before those adjustments.