Check which products sold best in Shopify
When you need to know what is selling, the Total sales by product report breaks the week down product by product, without shipping. This tutorial reads the week of 3 to 9 November 2026 for a three-product store.
Written · Shopify admin, desktop steps · 6 minutes read
The worked example
| Period | 3 to 9 November 2026 |
| Top product | Trail Crew Tee, 42 units, $1,176.00 |
| Total sales | $2,536.00 |
| Units sold | 85 |
| Products in the report | 3 |
Download the record: sales-by-product.csv (145 bytes).
A product sales record for the worked example week. Each row is units times price, and the rows sum to $2,536.00.
1Open the reports list
From your Shopify admin, go to Analytics then Reports. Click the Category filter and click Sales to show only the sales reports.
2Open Total sales by product
Click Total sales by product. The report breaks down product sales, excluding shipping. Each row is one product, with its total sales for the date range.
3Set the date range
Set the date range to 3 to 9 November 2026. The report covers the orders placed in that range, and sales appear on the order date.
4Sort by total sales
Sort the table by total sales so the best seller sits at the top. In the worked example, the Trail Crew Tee leads with $1,176.00, ahead of the Summit Hoodie at $810.00 and the Canvas Tote at $550.00.
5Read units with the money
Read the units beside the money. The tee sold 42 units, the hoodie 18 and the tote 25. A product with a high total but few units is a high-price seller, not a high-volume seller, and the restock decision is different for each.
6Check the product variant split
If one product outsells the others, open Total sales by product variant next. It breaks gross sales down by variant, so you can see whether one size or colour is doing the work.
7Export the report
Click Export to download the report as a CSV file. When you open a sales report, the data is up to date, give or take about 1 minute.
The arithmetic
| Product | Units | Total sales |
|---|---|---|
| Trail Crew Tee, $28.00 | 42 | $1,176.00 |
| Summit Hoodie, $45.00 | 18 | $810.00 |
| Canvas Tote, $22.00 | 25 | $550.00 |
| Total | 85 | $2,536.00 |
Shares of the $2,536.00 total are 46.37% for the tee, 31.94% for the hoodie and 21.69% for the tote. The three shares add to 100.00%.
Held at the counter
Product sales exclude shipping. Shipping is charged once per order, so it cannot be split fairly between the products in that order. If you need shipping in the totals, read the Total sales over time report instead.
A renamed product shows as two lines. Reports capture the product details as they were at the time of the sale. A title change between two orders can put the same product on two rows, which makes it look like two weaker products.
Gift card sales are not in this report. Selling a gift card product is not counted as a sale in any sales report. Only the amount paid when a customer spends a gift card on goods counts as sales.
Sources
- Sales reports — Shopify's help pages: the Total sales by product report, the product variant report, and the gift card rules.
- Shopify analytics — Shopify's help pages: the Analytics dashboard and the Reports page.