Sales by Product Variant (existing SKUs)
Report for Shopify

Detailed breakdown of your store’s sales performance for currently available products. This report provides insights into net sales and net quantity sold, helping you better understand how each product contributes to your store’s overall revenue.

Star

5 from 1,800+ merchants

2,000+ data fields

Trusted by 40,000+ Shopify stores

Updated June 2026

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 the Sales by Channel Report matters

Most Shopify stores sell on three or more channels. The average merchant on Shopify Plus runs Online Store, POS, at least one social channel, and one marketplace. Yet Shopify's native "Sales by channel" report stops at gross numbers. It doesn't break POS out by location, doesn't show net margin per channel, doesn't filter by product tag or collection, and doesn't let you compare channels against a previous period in the same view.

That gap matters because channel decisions are budget decisions. If POS in your flagship store is producing $80 in net sales per order while Facebook Shop is producing $22 with a 31% return rate, you don't just want to know it — you want to know it weekly, by SKU, in a Google Sheet your CFO already has open.

The Sales by Channel Report in Report Pundit gives you a unified view across every channel, with every metric Shopify exposes (and several it doesn't — channel-specific return rate, channel-specific AOV trend over time, net profit when COGS is set). It's the single report most multi-channel Shopify merchants check first thing every Monday morning.

What's included in the report

The report ships with the columns below by default. Every column is optional, and you can add 50+ more from the Report Pundit field library.

Sales Channel

The channel name as Shopify records it. Examples: online_store, pos, facebook, instagram, tiktok_shop, amazon, shop, buy_button, draft_order, or the name of a third-party app. Un-named apps appear as Other.

Common added columns

AOV · Items per order · Channel return rate % · Period-over-period change % · Net profit (with COGS)

All available from the 2,000+ field library — add to any pre-built report in one click.

Who uses this report — 4 real-world scenarios

Concrete situations where this report drives a decision. Pick the one closest to your business.
01

Multi-channel apparel and lifestyle brands

Situation
You sell on Online Store, Shop, Instagram Shopping, and TikTok Shop. You're running paid budget on all four.
Look at
Net Sales and AOV per channel against your blended CAC. Watch the Returns column — discovery channels (TikTok, Instagram) often have 2–3× the return rate of branded search.
Decision
Shift budget toward channels with the highest contribution margin, not the highest gross sales.
02

Shopify POS retailers preparing for Q4

Situation
You run 3 retail locations plus an online store. November and December decisions need to be made in October.
Look at
Last 90 days, each POS location head-to-head with Online Store. How have shipping and tax patterns shifted YoY?
Decision
Pre-allocate inventory and staff to the locations and channels showing strongest net sales growth. Schedule the report to email every Monday at 7 a.m. through December.
03

DTC brands testing a new marketplace

Situation
You've listed your top SKUs on Amazon or eBay. Leadership wants to know if it's pulling its weight in 90 days.
Look at
Filter to the new channel only. Compare Net Sales against the prior period. Check the Returns column — marketplace returns often run higher.
Decision
Expand the SKU list, pull back, or invest in marketplace-specific creative — but make the call from data, not guesswork.
04

Finance teams running monthly close

Situation
You need a clean monthly view of revenue by channel for QuickBooks, Xero, or Sage.
Look at
Schedule on the 1st of each month, in CSV or QuickBooks-compatible format, segmented by channel and tax jurisdiction.
Decision
Reconcile against bank deposits and payouts. Pairs naturally with the Finance Summary and Monthly Tax Summary reports for full close workflows.

How to read the Sales by Channel Report

Four patterns experienced merchants look for first:
  • Discount-to-Gross ratio per channel. If one channel's discount % is double the others, you're either training customers to wait for a sale on that channel or your channel-specific promo is mis-tuned.
  • Returns-to-Gross ratio per channel. Discovery channels (paid social, TikTok) almost always run higher. If they're 3× your other channels, look at fit guidance, photography, or product/audience match.
  • AOV gap. POS and Online Store AOV usually diverge by 20–40%. A surprise convergence often means your in-store team isn't upselling — or your online experience is.
  • The "Other" row. If Other is more than 5% of orders, you have unnamed third-party apps creating sales. Worth tracking down.

Report Pundit vs Shopify's native Sales by Channel report

Shopify ships a basic version. Here's where it stops — and what Report Pundit adds.
Capability Shopify Built-in Report Pundit
Available on every Shopify plan Shopify plan+
Break out POS by location ×
Filter by tag / collection / vendor Limited
Add custom columns (AOV, return %, profit) × ✓ 2,000+ fields
Schedule automatic email delivery ×
Export to Google Sheets in real time ×
Multi-store reporting ×
Period-over-period comparison Limited
Free custom report support × ✓ Within 24h
Sales by Product Variant (existing SKUs)

Product Title

Name of unsold product.

Vendor

The supplier of the specific product.

Product Type

Type of product you are selling; for example, pants, shirts, or shoes.

Net Quantity

Equates to number of sold items – number of returned items

Gross Sales

Gross sales amount of a region. Calculated as Product Price x Ordered Quantity.

Discount

Any discounts applied to the product or the order.

Returns

The value of any returned items.

Net Sales

Equates to gross sales - discounts - returns.

Taxes

Total taxes collected at each billing location. Includes Shopify-specific ones like shipping taxes.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Benefits

Track SKU performance

Track SKU performance

With this report, you can know the existing SKU performance.
Holistic SKU View

Holistic SKU View

It provides you with a holistic view of each active SKU
Current Product Insights

Current Product Insights

Get insights into current product variants without the need for historical sales data.

Sales by Existing Product

The Sales by Product (Existing Products) report breaks down your sales performance by product currently in your inventory. It packs a ton of crucial data like Product Type, Vendor, Returns, Discount and relevant financial data. With this report, you can sell the right product at the right time for the right price.

All Products Report

Our All Products report provides details for each variant Stock Keeping Unit (SKU). It tracks changes made to all SKUs in real-time. This report is packed with detailed data fields for each product variant, offering in-depth insights into your store. Analyze it to fully understand your pricing strategy, costs, inventory status, marketing efforts, and more.

Best Selling Collections

The Best Selling Collection report gathers data on your collections and presents them in an easy-to-understand table. Find out which collection’s sales are going through the roof and which ones are barely getting off the ground.

Never Sold Products

The Never Sold Products Report in Report Pundit identifies products in your Shopify store that have not been sold within a specified date range.

Products by Product Type

A product report organized by custom product types or categories, providing insights into the current quantity available for each variant in the store.

Product Combinations

Use it to uncover popular product pairs, track their purchase frequency, and gain valuable insights. This data is perfect for fine-tuning your product lineup, understanding customer behavior, and identifying cross-selling/upselling opportunities.

Best Selling Products

The Best Selling Products Report in Report Pundit provides a comprehensive analysis of your top-performing products over a specified period. This report ranks products based on sales volume, offering insights into customer preferences. Examining metrics such as units sold and total sales revenue, merchants can identify which products are driving the most revenue

Product Return Rate

This report lists the return rates of your products along with related data. Analyze it to find out the reason(s) behind a product’s return rate, identify an acceptable rate, evaluate vendors and more. Use the insights to improve customer satisfaction, efficiency, and profitability.

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.