Data-Driven Decisions eCommerce Analytics

Shopify Analytics: Which Products Actually Make You Money?

Written by Alice Watson·21 January 2026·12 min read·GuideIntermediate

In this article

Your bestselling product might be your worst investment
What does the Profit by Product report actually show Shopify sellers?
How do you find your most profitable products on Shopify without a data team?
How AskBiz tells you which SKUs are worth restocking — before you place the order
Warning signs your Shopify data is hiding a profitability problem
Your action plan for this week

Key Takeaways

Most Shopify stores optimise for revenue — but revenue hides which products are quietly destroying your margins. Shopify's native Profit by Product report, plus tools like Triple Whale and Polar Analytics, show the real picture. Stop restocking your bestsellers until you know their actual margin after returns, shipping, and ad spend.

Your bestselling product might be your worst investment
What does the Profit by Product report actually show Shopify sellers?
How do you find your most profitable products on Shopify without a data team?
How AskBiz tells you which SKUs are worth restocking — before you place the order
Warning signs your Shopify data is hiding a profitability problem

Your bestselling product might be your worst investment#

Shopify's own data shows the single most common mistake among stores generating $1M–$5M annually: optimising for top-line revenue while ignoring per-product profitability. A product can rank number one in units sold and still drain cash — through high return rates, heavy ad dependency, or tight sourcing margins that evaporate once shipping costs land. Shopify's native Profit by Product report exists precisely to close this gap. It breaks down gross profit per SKU, factoring in cost of goods sold against net sales. Blackbelt Commerce, which has worked with over 1,000 Shopify clients, consistently flags this as the starting point for any serious product audit — not Google Analytics, not Meta attribution dashboards. Here's the tension most founders miss. Last year, a resistance band listing might have had a 60% gross margin. This year, with freight costs up and a crowded market pushing you toward paid acquisition to maintain volume, that same SKU might be sitting at 28% — if you've even bothered to check. The ZIK Analytics data is clear on which categories carry the strongest structural margins on Shopify right now: fashion, beauty products, fitness gear, home décor, and tech accessories. But 'fashion' is not a margin strategy. A poorly sourced basics range competes on price and gets crushed. A well-branded skincare bundle with a strong repeat purchase rate prints cash. The point isn't which category you're in. It's whether you know — at the SKU level, not the store level — which specific products are putting money in your pocket and which ones are quietly eating it. Most founders don't. That's the problem this article solves.

What does the Profit by Product report actually show Shopify sellers?#

Shopify's Profit by Product report is a native analytics feature available in the Reports section of your Shopify admin. You filter your Reports list to isolate profit margin reports — no third-party tool required to get started. The report surfaces gross profit per product by comparing your recorded cost of goods sold (COGS) against net sales after discounts and returns. That's the quick answer: it shows you gross profit per SKU, so you can see which products generate real margin — not just revenue volume. What it doesn't show you by default: ad spend attribution per product, return rate impact over time, or fulfilment cost per unit. Those gaps matter. A fashion seller doing £55,000/month on Shopify might see their embroidered hoodies sitting at 42% gross margin in the native report — but once you factor in the £8.40 per unit average Meta ad cost to sell each one and a 19% return rate on that product specifically, the real margin is closer to 17%. That's not a bestseller. That's a liability dressed up in dashboard green. For stores in the $1M–$5M revenue band, Blackbelt Commerce recommends layering three tools on top of Shopify native: Google Analytics 4 for channel attribution (free), Triple Whale or Polar Analytics for paid ad attribution per product (paid), and Microsoft Clarity for behavioural analysis (free). Together, they answer the question native Shopify analytics can't fully answer alone: not just which products sell, but which products are profitable after every cost that touches them. Glew.io goes further still — it's built specifically to show what's driving or draining profitability at the inventory and customer behaviour level. For stores with large SKU counts or high SKU variability, it's worth evaluating.

How do you find your most profitable products on Shopify without a data team?#

Three moves. Do them in this order. **Run the Profit by Product report this week.** Go to Shopify Admin → Analytics → Reports → filter for 'Profit'. Sort by gross profit descending, not revenue. The product ranking will likely shift significantly. Screenshot both views — the revenue ranking and the profit ranking. The gap between them is your blind spot. **Cross-reference your top 10 margin earners against their return rates.** Shopify's native returns data lives in Orders — pull a manual export if you need to. Any product with a gross margin above 35% but a return rate above 15% needs recalculating. Use this formula: Adjusted margin = Gross margin − (return rate × average unit cost) − (average ad spend per unit sold). A beauty supplement selling at £34 with 40% gross margin, 12% return rate, and £6.20 average Meta cost per purchase has an adjusted margin of roughly 19.8%. Know that number before you restock. **Set up one paid attribution layer before your next ad campaign.** Triple Whale starts at around $129/month for smaller stores. Polar Analytics has a comparable entry point. Both connect to your Shopify and Meta/Google Ads data and tell you, at the product level, what your blended cost of sale actually is per SKU. That's the number your native Shopify report can't give you. For a store spending £8,000/month on paid ads across 30 SKUs, attribution data will typically reveal that 6–8 products account for 80%+ of profitable return on ad spend — and 5–6 products are spending budget at a loss. Stop the bleed before the next restock.

How AskBiz tells you which SKUs are worth restocking — before you place the order#

A founder running a Shopify beauty store connects her Shopify and Xero accounts to AskBiz. Before placing her next inventory order — £12,000 across 14 SKUs — she types one question into the ASK interface: *'Which of my products have the highest margin after returns and shipping costs over the last 90 days?'* AskBiz pulls her Shopify sales data, her Xero COGS entries, and her recorded fulfilment costs. It returns a ranked list: her vitamin C serum is her true margin leader at 44.3% adjusted gross margin. Her bestselling face wash — the one she was planning to double her order on — sits at 18.1% after a 22% return rate drags it down. She realises she was about to spend £3,800 restocking a product that's barely covering its costs. She reweights the order toward the serum and two mid-tier performers she'd under-indexed. That's one question. Thirty seconds. A materially different buying decision. AskBiz's CFO Dashboard also tracks her working capital cycle — so she can see how that restock decision affects her cash position over the next 45 days, not just her margin today. No SQL. No consultant. No waiting until month-end to find out.

Warning signs your Shopify data is hiding a profitability problem#

Four signals to check this week. **Revenue is growing but cash is flat or falling.** This is the clearest sign you're selling volume at thin or negative margin on too many SKUs. Check your Profit by Product report immediately. **Your top 3 revenue products don't appear in your top 5 profit products.** A gap of more than two positions between your revenue ranking and profit ranking signals structural margin erosion — usually from ad costs, returns, or COGS creep. **You've raised ad spend in the last 60 days without rechecking per-product attribution.** Scaling spend on a low-margin product accelerates the loss. If you've increased budget without running attribution data first, pause and audit before the next billing cycle. **Your average order value is rising but gross profit per order isn't.** This often means customers are bundling or upselling into your lower-margin items — a product mix problem that looks like a win in your revenue dashboard but isn't.

Your action plan for this week#

**Before Friday:** Open Shopify Admin → Analytics → Reports. Filter for Profit by Product. Sort by gross profit, not revenue. Identify the three products where the revenue rank and profit rank diverge most sharply. Those three are your immediate audit targets. **Set up once:** Record your actual COGS in Shopify for every active SKU if you haven't already — the Profit by Product report is only as accurate as the cost data you've entered. This takes 30–60 minutes for most stores with under 50 SKUs and unlocks every downstream margin analysis. **Track monthly:** Adjusted gross margin per SKU — gross margin minus your average fulfilment cost per unit minus your average paid acquisition cost per unit sold. Set a floor. Any product running below 20% adjusted margin for two consecutive months either gets repriced, rebranded, or cut from the next restock. That single discipline, applied consistently, is what separates stores that scale profitably from those that grow themselves into a cash crisis.

📊 By The Numbers

$1$560%28%£55,000