Merchants often need total units sold for one SKU spanning more than a single year, e.g. checking an item across 2025–2026. Shopify's native Analytics > Reports > Total sales by product handles this on any plan, including Basic, by adding SKU as a dimension and setting a custom date range. Report Pundit's Sales by Variant report offers the same lookup as a reusable, schedulable report instead of a one-off dashboard query.
How many units of a specific SKU have I sold across multiple years?
Official answer
Shopify shows this in Admin, under Analytics, then Reports, then Total sales by product. Add Product SKU as a dimension, filter to the SKU you need, and set a custom date range. The Quantity column then shows total units sold for that SKU across the whole period, net of returns.
This works on any Shopify plan, including Basic, since Shopify's Reports section now covers all plans rather than starting at the Shopify plan tier. The quantity shown is a net figure: sold items minus returned items, so cancellations and returns are already backed out. One thing to watch is that the default "Total sales by product" view groups by product, not variant, so if the item has multiple variants under one product, add SKU as a dimension before reading the number, or the total will include every variant, not just the one you're checking.
Once the SKU and date range are set, this becomes a one-off lookup rather than something built to reuse. For checking one SKU on a recurring basis, monthly or weekly, Report Pundit's Sales by Variant report keeps SKU and net quantity as default columns, so there's no dimension to add each time, and the same date range can be saved and re-run or scheduled to arrive by email instead of being rebuilt in Shopify's dashboard each time.
Comments
Approved merchant comments appear here after review by the Report Pundit team.
Leave a comment
Comments are reviewed by the Report Pundit team before they appear publicly. Your email will not be displayed.
Thanks — your comment has been submitted for review. It will appear on this answer page only after Report Pundit approves it.