Data-Driven DecisionseCommerce Analytics

Shopify Product Profitability: Which Products Actually Make Money?

Written by Alice Watson·15 July 2025·12 min read·GuideIntermediate
Share:PostShare

In this article
  1. Your best-selling product might be your worst investment
  2. How to use Shopify's Profit By Product report without an analyst
  3. What should you do after finding your most profitable products?
  4. How AskBiz answers 'which of my products actually makes money?' in seconds
  5. Warning signs your product mix is quietly destroying your margin
  6. Your action plan for this week
Key Takeaways

Most Shopify sellers know their best-selling products — very few know their most profitable ones. Shopify's native Profit By Product report closes that gap for stores under £400k/year, but above that threshold, attribution and margin visibility break down fast. Pull the report this week, kill or bundle your bottom-three SKUs, and start tracking contribution margin, not just revenue.

  • Your best-selling product might be your worst investment
  • How to use Shopify's Profit By Product report without an analyst
  • What should you do after finding your most profitable products?
  • How AskBiz answers 'which of my products actually makes money?' in seconds
  • Warning signs your product mix is quietly destroying your margin

Your best-selling product might be your worst investment#

Shopify's own data shows that stores under $500,000 per year — roughly £400k — can get sufficient profit visibility from native analytics alone. Above that number, according to Blackbelt Commerce's 2026 review of Shopify analytics tools, the gaps in attribution, profit visibility, and advanced segmentation become expensive enough to justify third-party tools. That threshold matters because it's where the illusion breaks. Below £400k, your top-selling product usually is your most profitable one. Cross that line, and you're likely running SKUs that generate volume but quietly bleed margin — tied up in returns, storage, and ad spend that never shows up next to the revenue number. Here's a real pattern: a Shopify seller doing £45k/month in activewear finds that leggings account for 38% of orders. Pull the Profit By Product report and the story changes. After returns (which run 22% on that SKU), shipping upgrades, and the Meta ad spend concentrated on that product, the contribution margin drops to 9%. Meanwhile, resistance bands — 11% of orders — run at 34% margin with a 4% return rate. Same store. Completely different business depending on which number you look at. Shopify Analytics shows sales reports, product performance, and ecommerce metrics like total orders and top-selling items. What it doesn't do automatically is put those numbers side by side with your actual costs. That's the work you have to do — and the Profit By Product report is where you start.

How to use Shopify's Profit By Product report without an analyst#

The Profit By Product report lives inside Shopify Admin under Analytics > Reports. Filter the Reports list to surface it directly. It pulls gross profit per SKU based on your cost of goods sold (COGS) as entered in Shopify — which means it's only as accurate as the cost data you've put in. That's the first thing most sellers get wrong. If you haven't updated your COGS figures since onboarding, the report is decorative. Go to Products, check that every variant has a cost per item entered, and update anything that's shifted with supplier price changes or currency moves. Once your data is clean, sort the report by gross profit (not gross revenue). The divergence between those two columns is your real business intelligence. Products sitting in the top five by revenue but outside the top ten by profit are candidates for margin surgery — bundle restructure, price increase, or ad spend reduction. Shopify Analytics and Google Analytics work differently here. Shopify tells you what happened inside your store: which products sold, at what price, with what margin. GA4 tells you how customers got there — which traffic source, which funnel step, what they did before converting. Both matter. But when the question is "which products make money", start in Shopify, not GA4. For stores doing over £400k per year, Glew.io adds depth that Shopify's native reports don't have — specifically, which products drive repeat purchases, how bundles affect average order value, and what product combinations produce the highest lifetime value customers. At roughly £200/month for the relevant tier, that's worth modelling once you're past £50k/month in revenue.

What should you do after finding your most profitable products?#

Three moves that high-margin Shopify operators make once the Profit By Product report is sorted. First: cut ad spend on your high-volume, low-margin SKUs immediately. Not gradually — this week. If a product is generating 30% of your revenue at 8% margin and you're spending £2,000/month promoting it, you're effectively paying to stay busy. Reallocate that budget to the products where margin exceeds 25%. Your revenue number will dip slightly. Your bank account won't. Second: build bundles anchored on your high-margin products. If resistance bands run at 34% margin and leggings at 9%, create a bundle where the band is the hero and the legging is the add-on. Price the bundle so the combined margin lands above 22%. Shopify's native bundling is limited, but apps like Bundler or Frequently Bought Together let you test this in an afternoon. The data from funnel.io's Shopify analytics guide specifically cites this tactic — increase stock on what sells out and build bundles to upsell. Third: set a monthly margin review date, not a weekly one. Checking Profit By Product every week creates noise — returns take 14-21 days to process and skew recent data. Monthly cadence, fixed date, same filter settings each time. That's how you build a trend line instead of reacting to a snapshot. The one thing not to do: use revenue rank as a proxy for inventory planning. Ordering more of your best-selling product without checking its margin first is how cash gets trapped in the wrong stock.

How AskBiz answers 'which of my products actually makes money?' in seconds#

Connect your Shopify store to AskBiz and type: "Which of my products has the best margin after returns this quarter?" AskBiz pulls your Shopify sales data, cross-references it with your COGS and returns data, and surfaces a ranked margin table by SKU — not by revenue. If you've also connected Xero or QuickBooks, it factors in fulfilment costs and any expenses tagged to specific product lines. The output looks like this: "Your top 3 products by gross margin this quarter are [SKU A] at 41%, [SKU B] at 33%, and [SKU C] at 29%. Your top 3 by revenue — [SKU D], [SKU E], [SKU F] — average 11% margin after returns. You are currently running Meta ads on [SKU D] and [SKU E]." That last line is the one that changes decisions. A founder running a Shopify homeware store used exactly this question in AskBiz's Growth plan (£19/month, with three months free on trial) and discovered that her two most heavily promoted products accounted for 61% of ad spend but 14% of total gross profit. She reallocated budget the same day. You don't need an analyst for this. You need your data connected and one plain-English question.

Warning signs your product mix is quietly destroying your margin#

Four signals to check in the next 30 days. Revenue is growing but cash isn't accumulating. If your monthly revenue is up 15% year-on-year but your end-of-month cash balance is flat or falling, you're likely selling more of the wrong things — high volume, low margin, high fulfilment cost. Your return rate on top sellers exceeds 15%. Returns don't just erase the sale — they generate a return shipping cost, a restocking cost, and often a markdown. A product with a 20% return rate needs a 40%+ gross margin just to stay profitable. Your average order value is rising but average profit per order isn't. This happens when customers are adding low-margin items to hit free shipping thresholds. Check whether your free shipping trigger is inadvertently subsidising your worst SKUs. You haven't updated COGS in Shopify since supplier prices changed. If your cost data is six months old and your suppliers raised prices in Q1 2026 — which most did, given ongoing freight volatility — every margin figure in your reports is overstated.

Your action plan for this week#

Before Friday: open Shopify Admin, go to Analytics > Reports, pull the Profit By Product report, sort by gross profit descending, and screenshot the bottom five SKUs. Those are your candidates for price increases, bundle repositioning, or culling. Set up once: update COGS for every product variant in Shopify. Block two hours, do it properly, and set a calendar reminder to review supplier costs every quarter. Every margin report you run after this will be materially more accurate. Track monthly: contribution margin by SKU — gross profit minus the ad spend directly attributable to that product. This is the number that tells you whether your marketing investment is working at the product level, not just the store level. If you're on AskBiz, set up a monthly margin briefing and it will flag any SKU where margin has dropped more than 5 percentage points month-on-month before you even think to check.

📊 By The Numbers
$500,000£400k£45k38%22%

People also ask

How do I find which products are most profitable on Shopify?

Use Shopify's Profit By Product report under Analytics > Reports. Sort by gross profit, not revenue. The gap between the two columns is where your real business intelligence lives. Make sure COGS is entered for every variant first — without it, the report is inaccurate. Stores over £400k/year typically need a third-party tool like Glew.io for deeper margin attribution.

What is the Profit By Product report in Shopify?

Shopify's Profit By Product report shows gross profit per SKU based on your cost of goods sold data. It's available inside Shopify Admin under Analytics > Reports. You can filter the report list to surface it directly. It's sufficient for stores under $500k/year in revenue; beyond that, attribution gaps typically require additional analytics tools.

Why is my Shopify revenue growing but profit not increasing?

Usually because your growth is concentrated in high-volume, low-margin SKUs. Pull the Profit By Product report and sort by gross profit, not revenue. Check your return rate on top sellers — anything above 15% is eroding margin significantly. Also verify your COGS data is current; outdated cost figures make every margin report misleading.

Should I use Shopify Analytics or Google Analytics for product performance?

Both serve different purposes. Shopify Analytics shows what sold, at what price, and at what margin — the right tool for product profitability analysis. Google Analytics (GA4) shows how customers found your store and navigated the funnel. Start in Shopify when the question is about product profit. Use GA4 to understand traffic quality and conversion drop-off points.

How does AskBiz help identify profitable Shopify products?

AskBiz connects to your Shopify store and lets you ask plain-English questions like 'Which of my products has the best margin after returns this quarter?' It cross-references sales, COGS, and return data to surface a ranked margin table by SKU — flagging where your ad spend is concentrated on low-margin products. Available from £19/month with a three-month free trial.

AW
Alice Watson
Head of Market Intelligence

Alice Watson is AskBiz's Head of Market Intelligence. She tracks regulatory shifts, pricing trends, and growth signals across global SME markets — and turns them into briefings founders can act on before their competitors notice.

14-day free trial · No credit card needed

Make every business decision with data behind it

AskBiz connects all your business data and answers your questions in plain English — no SQL, no analyst needed.

Start making data-driven decisions →See pricing

Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes

Share:PostShare
Next →
Dubai Hotel Increases Room Service Revenue with AskBiz, +52%
8 min read

Learn the concepts

Business Intelligence Basics
What Is Business Intelligence?
4 min · Beginner
Business Intelligence Basics
Metrics vs Data: What's the Difference?
3 min · Beginner
Business Intelligence Basics
What Is Data-Driven Decision Making?
4 min · Beginner
Business Intelligence Basics
What Is an Anomaly in Business Data?
3 min · Beginner