Shopify Product Analytics: Which Products Actually Make You Money
- Revenue is vanity. Here's what your Shopify dashboard isn't showing you.
- What does contribution margin per SKU mean for a store doing $500k–$2m a year?
- How do you identify your most profitable Shopify products without an analyst?
- How AskBiz shows you which Shopify products are quietly draining your margin
- Warning signs your Shopify product mix is eroding profit right now
- Your action plan for this week
Most Shopify sellers optimise for revenue, but revenue hides the products quietly destroying their margins. Tracking contribution margin per SKU — not just sales volume — is the shift that separates growing stores from ones that burn cash at scale. Pull your margin by product this week, cut the bottom 20%, and redirect spend to the SKUs with the highest repeat purchase rate.
- Revenue is vanity. Here's what your Shopify dashboard isn't showing you.
- What does contribution margin per SKU mean for a store doing $500k–$2m a year?
- How do you identify your most profitable Shopify products without an analyst?
- How AskBiz shows you which Shopify products are quietly draining your margin
- Warning signs your Shopify product mix is eroding profit right now
Revenue is vanity. Here's what your Shopify dashboard isn't showing you.#
The average Shopify merchant tracks two numbers obsessively: total revenue and conversion rate. Neither one tells you which products are making you money. Shopify Analytics does offer sales reports broken down by product, location, and time period. It tracks returning customer rate, average order value (AOV), and lifetime value (LTV). All useful. But the default view optimises for volume — units sold, revenue generated — not margin contribution per SKU. Here's the problem. A product doing £8,000/month in revenue with a 12% net margin after returns, shipping, and ad spend contributes £960. A product doing £3,000/month at 41% margin contributes £1,230. Most dashboards show you the first product as your top performer. This isn't a data gap — it's a framing gap. Shopify's native reporting stops at gross revenue. It doesn't automatically factor in your cost of goods, your return rate by SKU, your fulfilment cost per unit, or the ad spend attribution that drove each sale. Platforms like Glew.io were built specifically to go deeper — connecting Shopify data to inventory insights, customer behaviour, and what Glew calls 'what's driving or draining your profitability.' The key metrics they surface: which products drive the most repeat purchases, how bundling affects AOV, and which product combinations produce the highest LTV customers. Those three questions are worth more than your total revenue figure. A Bristol-based homewares Shopify store doing £65k/month found, after proper SKU-level analysis, that four products accounted for 71% of their returns. Stripping out return costs flipped their apparent top seller into a net loss item. They'd been scaling ad spend on a product that was costing them money at volume.
What does contribution margin per SKU mean for a store doing $500k–$2m a year?#
Contribution margin per SKU is the revenue a product generates minus every variable cost directly tied to selling it: COGS, return processing, fulfilment, payment processing fees (Shopify Payments charges 2.5–2.9% + 30¢ per transaction on the Basic plan), and the portion of ad spend attributable to that product. For a Shopify store doing $900k annually — roughly $75k/month — the maths get uncomfortable fast. Say you're running 80 active SKUs. Pareto says 20% of those drive 80% of your revenue. But contribution margin analysis typically reveals a different 20% driving 80% of your actual profit. Take a US fitness accessories store at that revenue level. Their resistance bands sell 600 units/month at $24.99 — $14,994 in revenue. Looks strong. But landed cost is $7.20/unit, return rate is 9%, fulfilment is $4.10/unit, and Meta ad attribution runs $5.80 per unit sold. Contribution margin: $24.99 minus $7.20 minus $2.25 (returns) minus $4.10 minus $5.80 = $5.64/unit. That's a 22.6% contribution margin. Their foam rollers sell 180 units/month at $34.99 — $6,298 in revenue. Landed cost $8.40, 3% return rate, fulfilment $4.80, ad spend $3.20/unit. Contribution margin: $34.99 minus $8.40 minus $1.05 minus $4.80 minus $3.20 = $17.54/unit. That's 50.1%. The resistance bands look like the hero product. The foam roller is the business. Shift your ad budget, your homepage placement, and your email sequences toward the high-margin SKU — and you've just changed your trajectory without acquiring a single new customer. This is the analysis most Shopify sellers never do. Not because it's hard. Because their dashboard doesn't show it by default.
How do you identify your most profitable Shopify products without an analyst?#
Three moves. Each one builds on the last. **1. Export your Shopify product sales report and add a contribution margin column this week.** Go to Analytics > Reports > Sales by product in Shopify. Export to CSV. Add columns for: unit COGS, average return rate per SKU (check your Orders > Returns data), fulfilment cost per unit, and your blended CAC for that product from your ad platform. The formula: Revenue minus (COGS + Returns Cost + Fulfilment + Ad Spend) divided by Revenue. Do this for every SKU generating more than $500/month. You'll find at least two products in your top ten that are margin-negative after ad spend. **2. Flag your repeat-purchase rate by product — not just revenue.** Shopify Analytics shows returning customer rate at store level. You need it at product level. A $19.99 consumable with a 38% 90-day repurchase rate is worth more than a $89.99 one-time item with zero LTV. Tools like Glew.io and Triple Whale surface this natively. If you're not using them, filter your customer purchase history in Shopify and manually tag your top 200 customers' first-purchase SKU. The patterns will be obvious. **3. Run a 30-day ad spend moratorium on your three lowest-margin SKUs.** Don't kill the products. Kill the paid acquisition for them. Redirect that exact budget to your top two contribution-margin SKUs. Measure revenue impact after 30 days. Most stores see a net margin improvement of 3–6 percentage points from this single reallocation — without touching conversion rate, pricing, or operations. None of this requires a data team. It requires 90 minutes and a spreadsheet — or a tool that does it in real time.
How AskBiz shows you which Shopify products are quietly draining your margin#
Connect your Shopify store and Xero (or QuickBooks) to AskBiz. Then type: *'Which of my products has the lowest contribution margin after returns and shipping this quarter?'* AskBiz pulls your Shopify sales data by SKU, matches it against your COGS from your accounting integration, factors in your return rate per product, and ranks every active SKU by contribution margin percentage — not gross revenue. The output isn't a chart you have to interpret. It's a direct answer: your bottom five margin products, the exact margin percentage for each, and a flag on any SKU where ad spend (pulled from connected Google or Meta data) is eroding margin below a threshold you set. For a Shopify seller doing $60k/month with 45 active SKUs, AskBiz might return: *'Your scented candle gift set has the lowest contribution margin at 8.3%. Return rate is 14.2% — double your store average. Ad spend attribution is $11.40 per unit sold. At current volume, this SKU is margin-negative after fulfilment.'* That's the decision. Not a dashboard to explore. A specific answer to a specific question, grounded in your actual connected data — not an estimate. AskBiz also sends proactive daily briefings via email or WhatsApp — so if your margin on a product shifts week-over-week (a supplier increases cost, returns spike, ad CPCs jump), you know before it compounds. You don't wait for month-end to find the damage.
Warning signs your Shopify product mix is eroding profit right now#
Four signals worth checking today. **Revenue is growing but cash isn't.** If monthly revenue is up 15% and your bank balance is flat or falling, margin erosion by SKU is the most common cause. Growth is masking a mix problem. **Your return rate has climbed above 8%.** Industry average for apparel is 20–30%, but for most other Shopify categories, a return rate above 8% starts eating margin fast. Check which specific SKUs are driving it — Shopify's Orders > Returns report breaks this down. **Your AOV is rising but repeat purchase rate is flat.** This often means customers are buying higher-ticket items once and not coming back. That signals a product-market fit problem in your highest-revenue SKUs. **Ad spend as a percentage of revenue has crept above 22%.** That's the level at which most Shopify stores with a 35–40% gross margin start running at break-even or below on paid acquisition. If you're at 25%+ and not tracking contribution margin by SKU, you have a problem you can't see yet.
Your action plan for this week#
**Before Friday:** Export your Shopify sales-by-product report for the last 90 days. Add your COGS and return rate for every SKU generating more than $300/month. Calculate contribution margin for each. Identify the bottom three. These are the products you stop paying to acquire customers for — immediately. **Set up once:** Connect Shopify to a margin-tracking tool — AskBiz, Glew.io, or even a structured Google Sheet pulling via the Shopify API. The setup takes under an hour. Once live, you get SKU-level margin data without building a new report every month. **Track monthly:** Contribution margin by product category, not just total store margin. A single category shifting 4 points downward month-over-month is an early warning you can act on. Catch it in month two, not month six.
People also ask
how do I find out which Shopify products are most profitable
Export your Shopify sales-by-product report, then subtract COGS, fulfilment cost, return cost, and ad spend attribution per unit from revenue. The result is contribution margin per SKU. Most stores find their actual top-margin product is not their top-revenue product. High-margin operators review this monthly, not annually.
what is contribution margin in ecommerce
Contribution margin is the revenue a product generates minus every variable cost tied to selling it — cost of goods, fulfilment, returns processing, and paid acquisition spend. Expressed as a percentage, it tells you how much of each sale actually flows toward profit and fixed costs. It's the number that matters more than gross revenue per SKU.
why is my Shopify revenue growing but profit not increasing
Revenue growth without profit growth usually means a product mix problem. High-volume SKUs with poor contribution margins — driven by high return rates, rising ad costs, or low pricing — scale losses, not profit. Calculating margin per SKU rather than tracking total store revenue is the fix most growing Shopify stores skip too long.
what Shopify analytics metrics should I track for profit
Track contribution margin per SKU, repeat purchase rate by product, return rate by SKU, and ad spend as a percentage of product-level revenue. Shopify's native analytics covers sales volume and AOV — but margin-level insight requires layering in your COGS and ad attribution data, either manually or through a connected analytics tool.
how does AskBiz help identify profitable Shopify products
AskBiz connects to your Shopify store and accounting software, then answers plain-English questions like 'which product has the lowest margin after returns this quarter?' It returns a ranked SKU list with contribution margin percentages and flags any product where ad spend is making it margin-negative — no dashboard interpretation required.
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