Shopify Product Profitability: Which Products Actually Make Money?
- Your top-selling product might be your worst investment
- What does poor product margin visibility cost a Shopify store doing £500k/year?
- How do you identify which Shopify products are actually profitable?
- How AskBiz shows you which products are making money — without building a spreadsheet
- Warning signs your product mix is quietly destroying your margins
- Your action plan for this week
Your best-selling Shopify product and your most profitable one are rarely the same. Revenue hides returns, ad spend, and fulfilment costs that quietly destroy margin. Audit your top 10 SKUs by net margin this week — not gross sales — and you'll almost certainly find at least two products you should stop promoting immediately.
- Your top-selling product might be your worst investment
- What does poor product margin visibility cost a Shopify store doing £500k/year?
- How do you identify which Shopify products are actually profitable?
- How AskBiz shows you which products are making money — without building a spreadsheet
- Warning signs your product mix is quietly destroying your margins
Your top-selling product might be your worst investment#
Shopify's native analytics will tell you which products generated the most revenue last month. It will not tell you which ones made you money. That distinction costs merchants thousands of pounds a year. Here's the problem: Shopify Analytics tracks total orders, top-selling items, and gross revenue. Clean, fast, easy to read. But it doesn't natively factor in return rates, ad spend per SKU, fulfilment costs, or supplier price changes. A product doing £18,000/month in revenue with a 34% return rate and £6.20 average shipping cost is not a winner — it's a drain. According to ZIK Analytics, the categories dominating Shopify sales — fashion, beauty, fitness gear, tech accessories — are precisely the categories with the highest return rates and the most volatile sourcing costs. Fashion return rates in UK ecommerce sit around 25–30%. Tech accessories see rapid margin compression as products commoditise within 90 days of launch. Shopify's own blog identifies four types of analytics: descriptive (what happened), diagnostic (why it happened), predictive (what will happen), and prescriptive (what to do). Most merchants stop at descriptive. They see that mineral sunscreen sold 400 units in Q1. They don't see that it was backordered for six weeks of Q2, that predictive models showed 5% quarterly growth before the stockout, and that the margin on that SKU dropped 11 points when their supplier raised MOQ pricing. The gap between what your dashboard shows and what's actually happening to your profitability is where most Shopify stores quietly lose money. Closing that gap starts with asking a different question — not 'what sold most?' but 'what earned most after every cost is accounted for?'
What does poor product margin visibility cost a Shopify store doing £500k/year?#
Take a Shopify fashion store based in Birmingham, doing £42,000/month in revenue across 80 SKUs. On the surface: healthy top line. In practice: six of those SKUs are responsible for 61% of their return volume, each return costing £4.80 in reverse logistics plus restocking time. Three of those six are in the top 10 by revenue. The store owner has been running paid social to all three because 'they sell well.' The real picture: those three SKUs are generating negative contribution margin once you strip out Meta ad spend (averaging £9.40 cost-per-purchase), a 28% return rate, and £3.10 average fulfilment cost. They're paying to lose money at scale. Glew.io, one of the advanced analytics platforms built specifically for Shopify merchants, is designed to surface exactly this. It goes beyond top-line sales data to show product-level profitability, inventory drag, and which SKUs drive repeat purchases versus one-time buyers. The platform explicitly tracks what product combinations lead to higher lifetime value customers — because a £30 skincare item that triggers three repurchases is worth more than a £90 gadget with 22% returns and zero repeat rate. Amplitude takes a different angle — it's built for customer journey analysis with deep cohort tools, but as BlackBelt Commerce notes honestly, it requires developer resource to implement correctly. Without a technical hire, the free plan becomes difficult to extract value from. For a store at £500k/year, the cost of running ad spend against low-margin or negative-margin products is rarely visible in a standard Shopify report. But it compounds fast. At £42k/month revenue, shifting 15% of ad budget from negative-margin SKUs to proven winners typically recovers £1,800–£2,600/month in contribution margin. That's not a projection — that's the arithmetic of removing waste.
How do you identify which Shopify products are actually profitable?#
Three moves that separate merchants who know their numbers from those who guess. **Build a true unit economics sheet for your top 20 SKUs.** Pull your Shopify revenue per product. Then subtract: COGS (landed cost including shipping from supplier), returns cost (return rate × reverse logistics cost per unit), fulfilment cost, and allocated ad spend per unit sold. What's left is your contribution margin per SKU. Do this in a Google Sheet if you have to — but do it. Most merchants who run this exercise discover their margin league table looks nothing like their revenue league table. **Separate your analytics by traffic source per product.** TapClicks and Attribution App both flag this: Shopify Analytics and Google Analytics measure different things. Shopify tells you what sold; Google Analytics tells you where buyers came from. Running both in parallel lets you see that your fitness gear converts at 3.8% from organic search but only 1.1% from paid social — meaning every paid social sale costs you 3.4× more to acquire. That changes the margin picture entirely. **Set a 90-day SKU review cadence.** Tech accessories and trending consumer goods commoditise fast — ZIK Analytics notes competition intensifies within weeks of a product gaining traction on Shopify. A product with 38% margin in January can be at 19% by April as competitor pricing drops. A quarterly SKU audit with updated landed costs and current ad spend figures is the minimum operating standard. If you're reviewing annually, you're flying blind for nine months at a time.
How AskBiz shows you which products are making money — without building a spreadsheet#
A Shopify seller connects their store, Xero account, and Google Sheets COGS tracker to AskBiz. They type: 'Which of my top 10 products by revenue has the lowest net margin after returns and fulfilment?' AskBiz pulls live data across all three sources. It surfaces a ranked table: product name, gross revenue, return rate, estimated fulfilment cost, COGS, and calculated net margin per unit. The answer comes back in seconds. Product seven on the revenue list — a trending tech accessory doing £6,200/month — has a net margin of 4.1% after a 19% return rate and £5.80 fulfilment cost. Product two on the revenue list, a private-label beauty item, is running 31% net margin with a 6% return rate. The founder had been allocating equal ad budget to both. AskBiz flags the disparity and shows the margin impact: redirecting £800/month in Meta spend from the tech accessory to the beauty SKU would add approximately £248/month in contribution margin at current conversion rates. That's the ASK feature working against your actual connected data — not a generic answer, but a calculation grounded in your Shopify orders, your Xero costs, and your real return rates. No SQL. No analyst. No waiting for a monthly report that's already three weeks stale by the time you read it.
Warning signs your product mix is quietly destroying your margins#
Four signals worth checking this week. **Your return rate is climbing but your revenue isn't falling.** This means you're replacing returned units with new sales — burning fulfilment cost twice on the same revenue line. Check your Shopify returns report against last quarter. **Your average order value is rising but your cash position isn't improving.** Higher AOV with flat cash usually means higher COGS, more expensive fulfilment, or both. Run a margin check across your bundle and upsell products specifically. **You're spending more on ads for a product than you were 60 days ago with no increase in volume.** Cost-per-purchase creeping up while units sold stay flat means the market is getting competitive on that SKU. Your margin is being compressed from both sides. **Supplier invoice amounts are up but your retail price hasn't moved.** Landed cost increases that aren't passed to customers are silent margin killers. If your COGS sheet is more than 60 days old, it's probably wrong.
Your action plan for this week#
Before Friday: Pull your top 10 SKUs by revenue from Shopify. Add a column for return rate (available in Shopify's returns report) and one for fulfilment cost per unit. Calculate gross margin minus those two costs. Rank by result — not by revenue. You'll have your real league table in under an hour. Set up once: Connect your Shopify store and accounting tool to a single analytics source that can cross-reference sales data with cost data. Whether that's Glew.io, AskBiz, or a disciplined Google Sheet, the point is one source of truth — not three tabs you're reconciling manually each month. Track monthly: Net margin per SKU, not gross revenue. Set a floor — any product running below 15% net margin after all costs goes on a 60-day watch list. If it doesn't improve, you either reprice it, renegotiate with your supplier, or cut it. Revenue without margin is just expensive activity.
People also ask
How do I find out which Shopify products are most profitable?
Pull your top SKUs by revenue, then subtract return costs, fulfilment costs, and allocated ad spend per unit to get true contribution margin. Shopify Analytics shows gross sales — it doesn't account for these costs. Tools like Glew.io or connecting your store to a cross-source analytics platform will surface net margin per product automatically.
What is the difference between Shopify Analytics and Google Analytics for ecommerce?
Shopify Analytics tracks in-store performance — orders, top products, conversion rate within your store. Google Analytics tracks traffic behaviour — where buyers came from, which channels convert, what they did before purchasing. You need both. Shopify tells you what sold; Google tells you what it cost to acquire that sale by channel.
Why is my Shopify revenue increasing but my profit is not?
Rising revenue with flat profit usually means one of three things: return rates are climbing, fulfilment costs have increased, or ad spend per sale is up. Check your net margin per SKU — not total revenue. In UK fashion ecommerce, return rates of 25–30% are common and can wipe margin entirely on high-volume products.
What is product profitability analysis in ecommerce?
Product profitability analysis calculates the true net margin of each SKU after every cost — COGS, returns, fulfilment, and attributed marketing spend. It's distinct from gross revenue reporting. A product doing £10,000/month in sales with a 30% return rate and high ad costs can deliver negative contribution margin despite strong headline numbers.
How does AskBiz help Shopify sellers find their most profitable products?
AskBiz connects to Shopify, Xero, and Google Sheets simultaneously. You type a plain-English question — 'Which of my top 10 products has the lowest net margin after returns?' — and it cross-references live sales, cost, and returns data to rank your SKUs by actual profitability. No spreadsheet required, no SQL, no analyst.
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.
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.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes