What Is the Total Products Sold Report?
The Total Products Sold report brings Shopify product sales into one view. It shows Net Quantity Sold and Total Net Sales alongside Product Title, Variant Title, SKU, Product Sales Channel, Tags, and Product Cost for the date range you choose.
Instead of looking only at an overall store sales figure, you can see which products and variations sold, how much net sales they generated, and which sales channels are associated with the results. Use the product identifiers and tags to focus on the parts of your catalog that matter to your team.
This is a sales-performance report, not a current inventory balance or a profit report. Net quantity sold does not tell you how many units are in stock, and recorded product cost alone does not calculate profit after other expenses.
Report Overview
- Report type
- Product & Variant Reports.
- Reporting period
- Select the date range when reviewing or exporting sales results.
- Data included
- Product and variant identifiers, SKU, product sales channel, tags, net quantity sold, recorded product cost, and total net sales.
- Best for
- Reviewing product-level sales, comparing variations, checking channel context, and planning follow-up product decisions.
- Exports and delivery
- Excel, CSV, TXT, or PDF; schedule email delivery daily, weekly, or monthly, or use supported Google Sheets, Google Drive, or FTP destinations.
What Can You Learn from Total Products Sold?
1. See Which Variants Are Selling
Compare Product Title, Variant Title, and Net Quantity Sold to see whether customers prefer one variation over another. This is especially helpful when products have several sizes, colors, or options.
Example: In a hypothetical apparel store, the medium black shirt sells more units than the small black shirt.
What you can do: Use the variant-level pattern to prioritize a stock review or a product-promotion decision.
2. Compare Units Sold with Net Sales
Net Quantity Sold and Total Net Sales answer different questions: how many units sold and how much net sales value those sales represent. A product leading on units may not be the leader on net sales.
Example: In a hypothetical store, a low-priced accessory sells more units while a premium product contributes more net sales.
What you can do: Sort by each metric separately before deciding which products to highlight.
3. Review Sales with Channel Context
Use Product Sales Channel to examine where product sales are associated with different channels. Product Title and SKU help you keep the same item identifiable while reviewing the results.
Example: In a hypothetical store, a gift set appears in sales-channel results for two storefront touchpoints.
What you can do: Filter the channel field and compare the reported net quantity and net sales for the period.
4. Find Products That Need Follow-Up
Sort Net Quantity Sold and Total Net Sales to find rows with comparatively low activity, then use Tags and Product Title to group related items. The report does not confirm current stock levels or product profitability.
Example: In a hypothetical beauty store, several tagged skincare products have low net quantities for the month.
What you can do: Check those products against actual inventory and merchandising information before changing pricing or reordering.
What Should You Check First in This Report?
Start with the fields that answer the immediate product-sales questions:
- Net Quantity Sold: Rank the rows to find the products and variants moving the most or least units.
- Total Net Sales: Compare the monetary contribution of products; avoid treating it as profit.
- Product Title, Variant Title, and SKU: Make sure you are comparing the right items and variations.
- Product Sales Channel and Tags: Narrow the review to the channel or product group relevant to your decision.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing product sales for a chosen period | See which products contributed units and net sales during a chosen period. |
| Planning product placement or promotions | Compare variations and tags before changing promotions or product placement. |
| Reviewing unit demand before checking stock | Use net units sold as a demand signal, then verify actual stock levels separately. |
| Checking product sales-channel context | Focus on sales-channel context for a particular product or group. |
| Preparing a product-sales reporting handoff | Receive a consistent product-sales export with clear SKU and net sales fields. |
For example, after a seasonal promotion, a merchant can review Net Quantity Sold by variant and Total Net Sales by product to decide which items deserve a closer stock or merchandising check.
How to Create This Report in Data Export
The Total Products Sold premade report already includes the core product-sales columns.
- Open Data Export and select the premade Total Products Sold report under Product & Variant Reports.
- Review Product Title, Variant Title, SKU, Product Sales Channel, Tags, Net Quantity Sold, Product cost, and Total Net Sales.
- Set the reporting date range. If helpful, sort by quantity or net sales and filter by product, channel, or a supported field.
- Click Save to keep the report, then export it in Excel, CSV, TXT, or PDF when needed.
- For recurring reporting, set a daily, weekly, or monthly schedule and choose an available email or other supported delivery destination.
If you prefer to build the same view from scratch, open Custom Reports and add the eight listed fields before saving.
Make the Most of This Report
Use these four practical checks to get more from each export.
01 / PERIOD
Compare like for like: Use consistent date ranges when reviewing sales changes so a longer period does not look stronger simply because it includes more days.
02 / VARIANTS
Keep the SKU in view: When several variants share a product name, use Variant Title and SKU to avoid mixing up the items.
03 / QUANTITY
Read the metric carefully: Net Quantity Sold is a sales measure, not the amount of stock currently available.
04 / DELIVERY
Send the right version: Save the chosen columns and filters, then schedule the report for the people who need the product-sales figures.
Frequently Asked Questions
What does the Total Products Sold report show?
It shows net quantity sold and total net sales with product titles, variants, SKUs, sales-channel context, tags, and recorded product cost for the period you select.
Can I see sales for a specific product variant?
Yes. The premade report includes Variant Title and SKU, so you can identify variations and review their reported sales figures. Use available filters to focus on an item.
Is Net Quantity Sold the same as current inventory quantity?
No. Net Quantity Sold describes sales activity during the selected reporting period. It does not show how many units are currently available in inventory.
Can I calculate profit from this report?
Not reliably from the eight premade fields alone. Product cost and Total Net Sales are included, but this starting report does not provide a complete profit calculation or account for all expenses.
Can I export and schedule the report?
Yes. Data Export supports Excel, CSV, TXT, and PDF exports for this report, as well as recurring schedules such as daily, weekly, or monthly delivery using an available destination.
