Shopify Sales by All Product Report

Identify your top-selling and underperforming items with the Sales by Product report in Report Pundit. Analyze product performance, improve inventory decisions, and drive profitable growth using real-time Shopify sales data.
mdi_eye-outline
January 17, 2024
mdi_eye-outline
2 min Read
Shopify Sales by All Product Report
Keep up with Shopify reports
We promise we won’t spam you.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Why Sales by all Product Matters More Than You Think

Not every product you sell contributes equally to your success. According to the Pareto Principle, 20% of your products likely generate 80% of your store’s profits. Yet, most Shopify merchants struggle to distinguish between high-impact and low-performing items using native reporting alone.

That’s where the Sales by All Product Report from Report Pundit changes the game. It gives you an organized, easy-to-understand breakdown of your sales by product  including types, vendors, quantities sold, returns, and net performance  helping you decide what to promote, restock, or discontinue.

Whether you’re launching new SKUs, managing seasonal inventory, or analyzing sales by location, this report gives you the visibility you need to grow with confidence.

What Does the Sales by All Product Report Show?

The report consolidates all product-level sales activity over a selected period. Even if a product title was renamed mid-sale or has been deleted/unlisted since the transaction, Report Pundit ensures it’s still tracked accurately under a unified product title.

You can quickly answer questions like:

  • What are my best-selling products this month?

  • Which vendors consistently perform well?

  • Are there any products dragging down my revenue or margins?

This clarity allows you to avoid overstocking the wrong products or underestimating the winners in your catalog.

Bundle Sales Simplified

Bundle or combo sales are notoriously messy in native Shopify reports. One order might appear under multiple fragmented product titles or IDs, making it difficult to track what actually sold.

Report Pundit solves this by consolidating bundle sales under a single Product Title field, making it easy to monitor total units sold and associated revenue without needing to decode multiple fields.

Why Your Shopify Store Needs the Sales by All Product Report

With the Sales by Product Report, you can:

  • Identify top-selling and underperforming products at a glance

  • Maintain optimal inventory levels by aligning stock with real demand

  • Detect pricing or return issues by tracking discounts and refunds per item

  • Validate product-market fit and remove poor performers from your catalog

  • Compare historical trends by product type, vendor, or sales region

  • Track renamed or deleted products to avoid misleading gaps in performance data

Example:
Say you sold “Wireless Earbuds Black” on March 10. You then renamed the product to “Black Wireless Earbuds” on March 11 and sold it again on March 15. In native reports, this might show as two separate items. But with Report Pundit, both are combined into a single, clear product line, preserving accurate totals.

Important Notes

  • This report does not include shipping amounts. Shipping data is excluded for clearer product-level focus.

  • It includes both active and deleted/unlisted products that had sales during the selected time frame.

  • Product field data (like title, type, or vendor) may show a dash (—) if the info was missing at the time of order.

Data Fields in the Sales by Product Report

Here are the key data points included by default:

  • Product Title: Name of the currently listed (or sold) product

  • Vendor: Brand or supplier name

  • Product Type: Category like clothing, electronics, etc.

  • Net Quantity: Units sold minus any returns

  • Gross Sales: Units sold × product price (before discounts/refunds)

  • Discounts: Total product-specific discounts applied

  • Refunds: Value of refunds (partial or full) related to the product

  • Net Sales: Gross Sales – Discounts – Refunds

  • Tax: Applicable tax on each product’s Net Sales

Beyond the Basics – Advanced Sales Insights

For high-volume sellers or subscription-based stores, this report supports advanced decision-making by:

  • Showing order fulfillment status and shipping stage, aiding ops teams

  • Tracking total order value over time, helping you spot sales trends

  • Offering real-time filtering by vendor, collection, product type, and more

And it gets even better with automation: merchants can schedule this report to run daily, weekly, or monthly, making it part of your routine performance check.

 Conclusion 

Your products are the backbone of your store’s success but without the right reporting, it’s impossible to know which ones are really pulling their weight.

With Report Pundit’s Sales by All Product Report, you can finally see the full picture. From renamed SKUs to bundled products, this report tracks it all, giving you the insight you need to grow smarter, not harder.

Unlock deeper sales performance of all your products with Report Pundit – track, compare, and grow smarter.

Report Pundit

Custom Shopify reports, on autopilot.

Reviewed on

Star
shopify_logo_whitebg

1.6 K Reviews

Sgopify_Icon

Build and automate your Shopify Reporting

Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.