What is the Best Selling Products Report?
The Best Selling Products report shows which products generate the most sales for a selected period. It brings Product Title, Net Quantity, and Total Sales into one view, with products ranked by Total Sales so the leading contributors are easy to find.
Use it to see whether your strongest products lead on sales value, units sold, or both. This is useful when deciding which items deserve more attention in promotions, merchandising, and replenishment planning.
Open the ready-made report in Data Export, choose the period you want to review, and save it. You can export the results or schedule them for your team instead of rebuilding the same view each time.
Report Overview
- Report period
- A date range selected for your sales review.
- Fields included
- Product Title, Net Quantity, and Total Sales.
- Best for
- Finding products that lead by sales value and comparing them with unit demand.
- Available exports
- Excel, CSV, TXT, and PDF.
- Scheduled delivery
- Daily, weekly, or monthly; email, Google Sheets, Google Drive, and FTP are listed delivery options.
What Can You Learn from Your Best Selling Products?
1. Which products bring in the most sales
The default ranking puts products with the highest Total Sales at the top. It gives you a quick shortlist of the items contributing most to product sales value.
Example: In a sample month, a travel bag appears first with $12,000 in Total Sales.
What you can do: Review your top-ranked products before choosing what to feature on the storefront.
2. Whether sales value and unit demand tell the same story
A product can lead by Total Sales without leading by Net Quantity. Looking at both fields prevents you from treating sales value and unit volume as the same measure.
Example: A sample lamp sells 40 units for $8,000, while a notebook sells 300 units for $4,500.
What you can do: Sort by Net Quantity as well as Total Sales before planning a promotion or reorder.
3. How your leading products change over time
Run the report for comparable periods to see whether the same products stay near the top. The report displays the chosen period, so trends require comparing separate periods.
Example: A sample skincare set ranks first in October but third in November.
What you can do: Compare monthly exports to spot shifts in which products customers are buying.
4. Which listed products may need a closer look
Products near the bottom of the returned list contribute less sales value than the leaders for that period. This is a starting point for review, not proof that a product is overstocked or unprofitable.
Example: A sample candle appears well below the store’s top-selling items for the quarter.
What you can do: Check those products alongside inventory and costs before deciding to discount or reorder them.
What Should You Check First in This Report?
Start with these four checks before taking action:
- Total Sales ranking: Identify the products at the top for the date range you selected.
- Net Quantity: See whether those products also sell the most units, or mainly generate a higher sales value.
- Reporting period: Use comparable date ranges before drawing conclusions about a rise or fall in demand.
- Product titles and filters: Confirm that the products and any applied filters match the assortment you intended to review.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing the week’s strongest-selling products | See the products contributing the most sales value during the week. |
| Choosing products to feature in the store | Choose candidates for homepage or collection promotion based on recent sales. |
| Checking unit demand before replenishment | Use Net Quantity as a demand signal before checking current inventory separately. |
| Comparing product results across campaign periods | Compare product performance during a campaign period against another period. |
| Scheduling product-performance updates | Share the same product-performance view with teammates on a schedule. |
For example, before a seasonal campaign, a merchant can compare last month’s top products with the previous month’s results to decide which items deserve more visibility.
How to Create This Report in Data Export
Start with the premade Best Selling Products report; its core columns are already selected.
- Open the report: In Data Export, find and open the premade Best Selling Products report.
- Review the columns: Confirm Product Title, Net Quantity, and Total Sales; change columns only if your needs are different.
- Set the scope: Choose your date range and add relevant filters if you want to narrow the results.
- Save your report: Keep the default Total Sales ranking or sort by Net Quantity for a different view, then select Save.
- Export or schedule: Download in a supported format, or set daily, weekly, or monthly delivery to the required recipient or destination.
Make the Most of This Report
A few small checks will make the product ranking more useful for day-to-day decisions.
01 / PERIOD / Compare like with like: Use the same length of time when comparing weeks or months; avoid judging a partial month against a full one.
02 / RANKING / Check both measures: Sort by Total Sales and Net Quantity separately to see whether value and demand produce different leaders.
03 / VISUALS / Use a quick bar chart: Where chart view is available, compare the top products by units or sales value for an at-a-glance ranking.
04 / DELIVERY / Share the right snapshot: Schedule a regular export to your team and double-check recipients before sending sales figures.
Frequently Asked Questions
How do I find my best selling products in Shopify?
Open Data Export’s premade Best Selling Products report, select a date range, and review the products ranked by Total Sales. Sort by Net Quantity if you want to focus on units sold instead of sales value.
Which fields are included in this premade report?
The default columns are Product Title, Net Quantity, and Total Sales. Other details, such as variants, costs, or inventory, would require a different or customized view.
Does Total Sales show my most profitable products?
No. Total Sales represents product sales value, not profit. You would need relevant cost information to assess profitability.
Can I download the results or view them as a chart?
You can export the results in Excel, CSV, TXT, or PDF. A chart view also lets you use a bar graph to compare products by units or sales value.
Can I receive a best selling products report automatically?
Yes. After saving the report, use Data Export scheduling to send it daily, weekly, or monthly. Delivery options include email, Google Sheets, Google Drive, and FTP.
