If you run a print-on-demand store with real order history, you already know the Sales by product report by heart. You open it after a good week to see which designs moved. The problem is not accessing it — it's that the number it ranks on is the wrong number for deciding what to scale.
What the Shopify sales by product report actually shows
You reach it from your admin: open Analytics, click Reports, then find Sales by product under the Sales category. According to Shopify's own reports documentation, the report is built from order line items and gives you a per-product breakdown over whatever date range you pick.
The default columns you get are revenue-side only:
- Gross sales — product price times quantity, before anything is deducted.
- Discounts — code and automatic discounts applied to that product.
- Returns — refunded value (shown as sales reversals).
- Net sales — gross sales minus discounts minus returns.
- Net quantity — units sold minus units returned.
Note what Shopify's documentation spells out: shipping is excluded, because one order can hold several products but carries a single shipping charge that can't be split cleanly across line items. That exclusion is the first crack. The report quietly drops one of your largest variable costs before you even start reading.
One more access note. Shopify's documentation on plan availability ties the fuller report set to the Shopify plan and above, with the most granular reports reserved for Advanced. If you're on the entry tier and don't see every report, that's why.
Where the report stops: revenue, not profit
Here's the trap. The Sales by product report sorts your catalog by gross or net sales, and your eye naturally reads the top row as "the winner." But two products with identical revenue can have wildly different take-home, because the report never touches the cost side.
It does not know your blank garment and print cost from Printify, Printful, or Gelato. It does not net out the roughly four percent you pay in payment processing. It does not subtract the shipping it already told you it excluded, and it has no idea what you spent on Meta or Google Ads to sell the thing.
So the report answers "what sold the most dollars?" when the question that actually runs your store is "what kept the most dollars?" Those are different lists, and acting on the first one is how operators pour ad budget into a popular, barely-profitable SKU.
How to read it like an operator: a worked example
Say you sell a tee at a thirty-four dollar price. Your Printify cost on the blank plus print is fourteen dollars. Pull the per-order math the report refuses to do:
- Price: $34.00
- Product cost (Printify): −$14.00
- Shipping (carrier): −$4.50
- Payment processing (about 4% of $34): −$1.36
- Contribution before ads: $14.14
That $14.14 is your margin before a single ad dollar. The Sales by product report shows you the $34.00 and the net sales — never the $14.14. Now layer ads on. If your blended acquisition cost on that tee is nine dollars, you keep $5.14 per order. If it's thirteen dollars, you keep $1.14 and you're one return away from losing money on it.
Scale that to a month. Say the tee sold one hundred eighty units. The native report proudly shows $6,120 in gross sales. Your real contribution after ads, at $5.14 a unit, is $925.20 — about fifteen percent of the headline number. A second product at the same $6,120 in revenue but a twenty-dollar product cost might clear only $300. Same row height in Shopify's chart, triple the profit difference. For more on why the after-ad margin is the number that should drive every scaling decision, see our guide to ecommerce performance analytics.
Build the profit column the report is missing
You can approximate the missing column yourself. Export the Sales by product report to CSV, then add four columns per product and subtract them from net sales.
- Product cost — your supplier's blank-plus-print charge per unit. For POD this is known before you ever make a sale, straight from your Printify, Printful, or Gelato catalog.
- Shipping — the carrier cost per order, the line Shopify's report dropped.
- Payment fees — roughly four percent of the sale price, give or take your gateway.
- Allocated ad spend — your channel spend divided by the orders it drove for that product.
What's left is true per-product contribution. Rank your catalog on that column and the order almost always reshuffles. The design with middling revenue and a cheap blank often out-earns the flashy bestseller that needed an expensive garment and a high CPC to move.
A faster rank: contribution per unit, not gross sales
If you only do one thing, compute contribution-per-unit for your top ten products and re-sort. A SKU doing eighty units at eleven dollars contribution ($880) beats one doing a hundred forty units at five dollars ($700), even though the native report lists the second one higher. That single re-sort tells you where the next thousand dollars of ad budget should actually go. This is the core move behind real ecommerce business intelligence — judging products on what they keep, not what they gross.
What native Shopify reporting can't do
Even rebuilt in a spreadsheet, the report has structural blind spots. It's a snapshot of Shopify data alone, so it can't see the two numbers that decide profit: your supplier cost and your ad spend. Those live in Printify and in Meta Ads Manager, not in Shopify.
That's why operators reach for third-party apps or hand-built sheets to stitch the picture together. It's the same reason the data and analytics growth strategies that separate scaling stores from stalled ones all start by uniting order data, supplier cost, and channel spend in one view. The report in your admin only ever holds one-third of that.
Let Victor build the profit view for you
PodVector AI puts an AI employee named Victor on your store. Victor connects to Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo, so he sees every order, every ad dollar, and every supplier cost together — and computes the true per-order profit on each product, not just its revenue.
From there Victor does the work the report can only hint at. He reprices the thin-margin SKUs in Shopify, pauses the losing ad set in Meta when a "bestseller" stops clearing its CAC, and shifts Google Ads budget toward the products that actually keep their dollars. He delivers the profit-by-product report to your Google Drive and drafts the customer-support email when a return threatens a tight-margin order. Victor is not a dashboard you log into — he's the operator who acts on the numbers.
Put Victor on your store and see the real margin behind every product you sell.
Want to see how the profit angle shapes your whole reporting stack before you commit? Compare approaches in our breakdown of the best ecommerce subscription analytics tools.
FAQs
Where is the Sales by product report in Shopify?
Open Analytics in your admin, click Reports, then select Sales by product under the Sales category. You can set any date range and compare it to a prior period. If the report isn't visible, check your plan — per Shopify's documentation, the full report set requires the Shopify plan or higher.
Does the Shopify sales by product report show profit?
No. It shows gross sales, discounts, returns, and net sales — all revenue-side figures. It never subtracts product cost, shipping, payment fees, or ad spend, so it can't tell you which products are actually profitable. You have to add those costs yourself or use a tool that unites Shopify, supplier, and ad data.
Why doesn't the report include shipping?
Because an order can contain several products but carries a single shipping charge, and Shopify doesn't split that charge across line items. So shipping — often four to six dollars an order — is left out of every per-product number, which understates your true cost on each sale.
What's the difference between gross sales and net sales in the report?
Gross sales is price times quantity before deductions. Net sales subtracts discounts and returns from gross. Both are still revenue figures — neither one touches your product cost or ad spend, so a high net-sales product can still lose money once you account for what it took to make and market it.
How do I find my most profitable product instead of my bestseller?
Export the report to CSV, add columns for product cost, shipping, payment fees, and allocated ad spend, then subtract them from net sales to get contribution per product. Re-sort on that column. The ranking usually changes, because the cheapest-to-make, cheapest-to-advertise products often out-earn the ones with the biggest revenue line.
Can I get product-level profit automatically?
Yes. Because POD product costs are known from your Printify, Printful, or Gelato catalog before the first sale, a tool that also reads your Shopify orders and ad spend can compute per-order profit without you touching a spreadsheet. That's what Victor does, then he acts on it by repricing and reallocating budget across your channels.