HomeBlogBlog Details

How to Run a Shopify Sales by Product Report (Step by Step)

How to Run a Shopify Sales by Product Report (Step by Step)

"Which products actually drive our revenue?" sounds like a simple question, and Shopify does have a report for it. The step-by-step is straightforward — the limitations show up once you want to slice that data any further than the default view allows.

Step 1: Open the Sales by Product Report

In Shopify Admin, go to Analytics → Reports and open the Sales by product report. On entry-level plans, some report types — including this one — may not be available; fuller reporting is included on higher-tier Shopify plans.

Step 2: Set Your Date Range

Choose the period you want to analyze — this week, last month, a custom range. The report recalculates gross sales, net sales, and units sold per product for whatever range you select.

Step 3: Read the Columns

The default view shows product title, units sold, gross sales, discounts, returns, and net sales. Sort by net sales to find your actual top performers, not just your highest unit-volume products — those aren't always the same thing.

Step 4: Export If You Need to Share It

Use the export option to download a CSV for anyone who needs the raw numbers outside Shopify Admin.

Where the Native Report Falls Short

Three limitations show up quickly: you can't filter by product category, vendor, or tag alongside the sales columns in one view; you can't cross-reference this with which customer segment bought which product; and there's no way to schedule the report to arrive in your inbox automatically every week.

The SnapDash Alternative

SnapDash's no-code report builder starts from the same idea — sales by product — but lets you filter by category, vendor, or tag, group and aggregate however you need, and save the report so it's ready with current data any time, no manual re-export required. See our full breakdown of Shopify's 14 report templates for what else is available out of the box.

Frequently Asked Questions

Full reporting, including product-level sales reports, is available on higher-tier Shopify plans. If you're on an entry-level plan, check Analytics → Reports in your Admin to confirm which report types are included.

Shopify's native report doesn't support filtering by product category or collection alongside sales columns. A no-code report builder like SnapDash's lets you add that filter directly.

Shopify's native report exports to CSV, which opens in Excel but isn't formatted as a polished spreadsheet. SnapDash's report builder exports the same underlying data directly to CSV, Excel, or PDF.