Shopify Product Profit Analytics: Which Products Actually Make You Money
- Your best-selling product might be your worst investment
- What does this mean for a Shopify store doing £20k–£150k per month?
- Three things high-margin Shopify operators do differently
- How AskBiz shows you which products are actually earning — not just selling
- Warning signs your product mix is quietly destroying your margins
- Your action plan for this week
Most Shopify sellers optimise for revenue — but revenue and profit are not the same number. Shopify's built-in Profit By Product report shows which SKUs are actually earning after cost of goods, and most founders have never opened it. Pull it today, rank your products by gross margin — not gross sales — and you'll almost certainly find 20% of your SKUs are draining cash while looking healthy on the surface.
- Your best-selling product might be your worst investment
- What does this mean for a Shopify store doing £20k–£150k per month?
- Three things high-margin Shopify operators do differently
- How AskBiz shows you which products are actually earning — not just selling
- Warning signs your product mix is quietly destroying your margins
Your best-selling product might be your worst investment#
Here's a number that should stop you mid-scroll: Shopify merchants who analyse profit per product — not just revenue — regularly discover that their top-selling SKU by volume delivers a gross margin below 15%. That's not unusual. That's the norm for sellers who've grown fast without stopping to separate revenue from profit. Shopify's native analytics includes a Profit By Product report. It lives inside your Reports section, under Finances. It shows gross profit per product after cost of goods sold (COGS) — provided you've entered your COGS correctly in the product settings. If you haven't, every number in that report is wrong. The distinction matters more than most founders realise. You can be doing £80,000 a month in revenue and be cash-negative on 30% of your product range. It happens constantly. A product moves well because you've discounted it, or bundled it cheaply, or run paid ads that cost more than the margin supports. The revenue line looks healthy. The profit line is quietly bleeding. Blackbelt Commerce, which has worked with over 1,000 Shopify clients at the £1M–£5M annual revenue tier, flags Shopify's native analytics as the non-negotiable starting point before any third-party tool. Not because it's the most sophisticated — it isn't — but because it's the source of truth for product-level profit before you layer anything else on top. The core question isn't 'which products sell?' You already know that. The question is: which products earn? Those are often very different lists. Pull the Profit By Product report and sort by gross profit descending. The gap between column one and column ten will almost certainly surprise you.
What does this mean for a Shopify store doing £20k–£150k per month?#
Take a real scenario: a Shopify homeware seller doing £65,000/month in revenue across 47 SKUs. On the surface, the business looks healthy — revenue is up 18% year-on-year, repeat customer rate sits at 34%. But when profit by product is properly analysed, three SKUs — all high-volume, heavily advertised — are generating under 8% gross margin after COGS. Two of those three have a return rate above 12%, which the revenue dashboard doesn't show. Once those three products are stripped out of the ad spend and the promotional discounting is stopped, overall revenue drops by £11,000/month. But gross profit goes up by £4,200/month. That's the counterintuitive reality of product-level profit analytics. For stores in the £20k–£150k/month range, the levers are specific: First, COGS entry accuracy. If your Shopify product costs are not updated to reflect current supplier pricing — including any post-tariff increases in 2025–2026 — your Profit By Product report is showing you stale numbers. A 10% supplier price increase that hasn't been updated in Shopify will make a 22% margin product look like a 32% margin product. That's a material misread. Second, returns are not deducted by default in the standard Profit By Product view. A product with a 19% gross margin and a 14% return rate — once restocking, repackaging, and fulfilment costs are factored in — may net closer to 6%. Shopify's native report won't show you this without additional filtering or a connected analytics layer. Knowing which products to scale and which to quietly retire is the highest-leverage decision you make in ecommerce. The data to make it is sitting in your Shopify account right now.
Three things high-margin Shopify operators do differently#
Stores consistently running 35%+ gross margins on Shopify share three behaviours that most sub-scale operators skip entirely. **1. They rank products by gross profit per order — not by units sold or revenue.** Shopify's Profit By Product report gives you gross profit in absolute pounds per product. Sort by this column every Monday. If a product that moved 400 units last month generated £1,200 in gross profit, and a product that moved 80 units generated £3,100, you already know where to point your ad spend. Blackbelt Commerce's analytics consultants flag this as the single most underused native report among stores below £2M annual revenue. **2. They use predictive analytics to avoid the backorder trap.** Shopify's own published example is instructive: a sunscreen brand saw a 20% quarter-on-quarter revenue drop in Q2 — not because demand fell, but because their highest-margin product, mineral sunscreen, was backordered for most of the quarter. Diagnostic analytics confirmed the correlation. The fix isn't complex — it's setting reorder points based on actual velocity data, not gut feel. Shopify's native demand forecasting tools and third-party tools like Glew.io both support this. **3. They build bundles around high-margin anchors, not high-volume ones.** If resistance bands have a 44% gross margin and a foam roller has 18%, the bundle pricing logic should protect the resistance band margin — not average the two down. Founders who build bundles based on sales volume often accidentally bundle their way into lower blended margins. Build bundles starting from the product with the highest margin, then price accordingly.
How AskBiz shows you which products are actually earning — not just selling#
A founder running a Shopify fitness accessories store connects her Shopify and Xero accounts to AskBiz. She types: *'Which of my products has the best gross margin after returns last quarter?'* AskBiz pulls her Shopify sales data, matches it against her COGS records and Xero expenses, and surfaces a ranked table: resistance bands — 41% gross margin after a 4.2% return rate. Weighted jump ropes — 38%. Foam rollers — 11%, dragged down by a 17.3% return rate and a supplier cost increase in March that wasn't reflected in her pricing. She didn't know about the foam roller problem. Her Shopify dashboard showed foam rollers as the third highest revenue product last quarter. That looked like a success. The margin-adjusted view tells a different story. AskBiz's CFO Dashboard then flags a second signal: foam roller ad spend over the same period was £2,100. Net contribution after returns, COGS, and advertising: £340. She was spending £2,100 to make £340. The decision is immediate: pause foam roller paid ads, reprice or discontinue, reallocate budget to resistance bands. That's a decision that would have taken three separate reports, a spreadsheet, and probably two weeks to surface manually. It took one question. For Shopify sellers, AskBiz connects directly to your store data — no SQL, no exports, no analyst needed.
Warning signs your product mix is quietly destroying your margins#
Watch for these four signals in the next 30 days: **Revenue growing but cash not improving.** If your monthly revenue is up but your bank balance is flat or falling, product-level margin erosion is the most common culprit. Pull the Profit By Product report immediately. **Your top 3 revenue products are also your top 3 discounted products.** Discounting drives volume. It also compresses margin. If your best sellers are only selling because you're promoting them at 20–30% off, the underlying margin may already be sub-10%. **COGS hasn't been updated since 2024.** Supplier prices shifted significantly in 2025 for any business sourcing from Asia or the US following tariff changes. If your Shopify COGS fields still reflect pre-2025 costs, every margin report you're reading is overstating profit. **Return rate above 10% on any single SKU.** Shopify doesn't automatically net returns against product profit in the standard view. A 10%+ return rate on a product with a 20% gross margin can push net contribution below zero once restocking and fulfilment costs are included.
Your action plan for this week#
**Before Friday:** Open Shopify Analytics, go to Reports, filter for the Profit By Product report, and sort by gross profit descending. Identify your bottom five products by gross margin percentage. Cross-reference each against current supplier costs — if COGS hasn't been updated in the last 90 days, update it now before drawing any conclusions. **Set up once:** Create a saved filter in your Shopify Reports for Profit By Product, filtered to show only products with a gross margin below 20%. Review this list every Monday morning alongside your weekly revenue summary. High revenue and low margin in the same row is the flag. **Track monthly:** Blended gross margin across your entire catalogue — total gross profit divided by total revenue. For a healthy Shopify store in the £20k–£150k/month range, target above 35%. If your blended margin is below 28%, you have a product mix problem, a pricing problem, or a returns problem — and the Profit By Product report will tell you which.
People also ask
how to find which products are most profitable on shopify
Open Shopify Analytics, go to Reports, and filter for the Profit By Product report under Finances. Sort by gross profit descending — not by units sold or revenue. This shows which SKUs earn the most after cost of goods. Ensure your COGS are up to date in each product's settings or the figures will be inaccurate.
what is shopify profit by product report
Shopify's Profit By Product report is a native analytics report that shows gross profit per product after deducting cost of goods sold (COGS). It's accessible under the Reports section in Shopify Analytics. It only reflects accurate margins if COGS are correctly entered per product — sellers who skip this step get misleading data.
why is my shopify revenue high but profit low
High revenue with low profit usually means your top-selling products have thin margins — often caused by heavy discounting, rising supplier costs that haven't been reflected in pricing, or high return rates eating into margin post-sale. Pull the Profit By Product report and sort by gross margin percentage to identify which SKUs are the culprits.
what is product profit margin in ecommerce
Product profit margin is gross profit divided by revenue for a specific SKU — expressed as a percentage. It shows what you keep after paying for the product itself, before overheads like shipping, ads, or staff. In ecommerce, a healthy product gross margin is typically 35–50%. Below 20%, most products become unprofitable once ad spend and returns are factored in.
how does AskBiz help with shopify product profit analysis
AskBiz connects directly to your Shopify store and accounting tools like Xero or QuickBooks. You ask a plain-English question — 'which product has the best gross margin after returns?' — and AskBiz returns a ranked breakdown by product, adjusted for return rates and COGS. It surfaces margin problems that Shopify's standard dashboard doesn't show automatically.
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