Your Store Has 200 Products and 5 Pay the Bills

Twenty percent of your products generate 80% of your revenue. That's the standard Pareto stat everyone quotes. But revenue isn't profit. A proper Shopify product profitability analysis — one that accounts for ad spend, returns, shipping, and transaction fees — tells a much uglier story. Most stores with 200+ SKUs have somewhere between 5 and 15 products that actually put money in the bank. The rest are breaking even or quietly losing money on every sale.

The problem isn't that you have too many products. It's that you've never done the math on each one. A product that sells 50 units a month looks healthy in your Shopify dashboard. But if it has a 25% return rate, eats $12 in shipping per order, and you're spending $30 in ads to sell each unit — that "bestseller" is a net negative. And it's pulling budget, attention, and warehouse space away from the 5 products that actually fund your business.

Revenue Rankings Hide Your Real Profitability

Shopify's built-in reports sort products by total sales or units sold. That ranking is misleading because it treats a $75 apparel sale and a $75 electronics sale as equal — even though the apparel item has a 24-30% return rate that collapses its net margin to around 4%, while the electronics item might net 12%.

A breakdown from DTC benchmarking data shows what really happens to a $75 apparel order: after COGS (35%), ad spend (25%), shipping and returns (17%), platform fees (2.9%), and payment processing (3.3%), you're left with $6.59. That's 8.8% net margin — before you account for app subscriptions, customer service time, or the cost of processing that return.

Your top-line revenue report doesn't show any of this. It shows $75 and marks it green.

The Shopify Product Profitability Audit: Calculate True Per-Product Profit

SKU rationalization is the process of analyzing every product in your catalog by net profit — not gross revenue — and cutting the ones that cost more to sell than they earn. For Shopify merchants, this means calculating per-product margin after COGS, ad spend, returns, shipping, and transaction fees. It takes about two hours and a spreadsheet.

1. Export your orders from the last 90 days. Shopify's built-in export gives you line items with product titles, variants, quantities, and gross revenue.
2. Add a COGS column. Pull your actual cost per unit from supplier invoices. If you're dropshipping, include the supplier price plus any handling fees.
3. Add shipping cost per order. Use your average outbound shipping cost. If you offer free shipping, this comes straight out of your margin.
4. Add return cost per product. Multiply your return rate for each product category by the cost per return (typically $15-30 for processing, restocking, and return shipping). Average ecommerce return rates hit 20.8% in 2026 — apparel runs 20-30%, electronics around 11%, beauty products 4-10%.
5. Allocate ad spend. If you run product-specific campaigns, assign the spend directly. If you run broad campaigns, allocate proportionally by revenue. Many Shopify merchants spend 25-40% of revenue on Facebook and Google ads — this is usually the number that turns "profitable" products into losers.
6. Subtract transaction and processing fees. Shopify's payment processing (2.4-2.9% + $0.30) plus any app fees that scale with order volume.

The formula per product: Net Profit = Revenue − COGS − Shipping − (Return Rate × Return Cost) − Allocated Ad Spend − Transaction Fees

Sort by net profit per unit. The ranking will look nothing like your revenue ranking.

Three Buckets: Keep, Kill, and Investigate

Once you have per-product net profit, every SKU falls into one of three categories:

• Keep (top 15-20%): Positive net margin after all costs. These are your real business. Double down on ad spend, improve their product pages, and make sure they're always in stock.
• Kill (bottom 20-30%): Negative net margin with no strategic value. They don't drive repeat purchases, don't act as entry points to higher-margin products, and don't build brand equity. Remove them.
• Investigate (middle 50-60%): Breakeven or slightly positive. Some of these can be saved by cutting ad spend, raising prices, or bundling them with high-margin products. Others are zombie SKUs that need to go.

The "investigate" bucket is where most merchants stall. They keep marginal products alive because "it still sells." But a product that breaks even after costs isn't free — it consumes inventory capital, warehouse space, and catalog complexity. Carrying costs alone account for roughly 30% of total inventory costs across the industry.

Why Does Removing Products Increase Profit?

This is counterintuitive, but the data supports it. One FMCG company that went through a structured SKU rationalization improved profit by 6% with zero revenue loss. The products they cut weren't generating meaningful demand — they were generating costs.

Here's why fewer products means more money:

• Ad spend concentrates. Instead of spreading $3,000/month across 80 products, you're spending it on 20 proven winners. Your cost per acquisition drops because the algorithm has more data per product to optimize against.
• Inventory capital frees up. Money tied up in slow-moving stock becomes working capital you can reinvest in your top sellers or hold as cash flow buffer.
• Operations simplify. Fewer SKUs means fewer supplier relationships, fewer customer service questions about product differences, and fewer returns to process.

A smaller, curated catalog also helps customers decide faster. When you offer 200 products in a category, you create choice paralysis. When you offer 30 — the ones you know convert and satisfy — buyers move through your store with less friction.

The Products That Lose Money but Earn Their Spot

Not every negative-margin product should be cut. Some earn their place through indirect value:

Entry-point products that bring first-time buyers into your ecosystem. A $15 product with a -$2 net margin is worth keeping if 30% of those buyers come back within 90 days and purchase a $60 high-margin item.

Catalog completeness products that customers expect you to carry. If you sell phone cases for every iPhone model, removing the low-selling iPhone SE case might signal to customers that your catalog is incomplete — even though it barely sells.

Bundle anchors that are unprofitable alone but profitable when sold together with complementary items. A $10 accessory with negative standalone margin becomes profitable when it's bundled with a $50 main product at a combined 25% margin. Tools like EasySell let you add quantity discounts and one-click add-ons directly on the product page, making it easier to move those anchors as part of a higher-margin package.

The key distinction: these products have a documented, measurable reason to exist. "It might sell better next quarter" is not a reason.

Run This Audit Every Quarter

Product profitability shifts constantly. A product that netted $8/unit in Q1 might net $2 in Q3 because ad costs climbed. Facebook and Google CPMs have increased 30-50% since 2020 and they're still rising. Seasonal demand, supplier price changes, and shipping rate adjustments all move the numbers.

Set a quarterly calendar reminder. Re-export your orders, recalculate the per-product margin, and re-sort. Products move between buckets. Last quarter's winner can become this quarter's breakeven SKU if your return rate spikes or your ad costs climb.

The merchants who do this consistently make better decisions about what to promote, what to reorder, and what to sunset. The merchants who don't keep funding their worst products with revenue from their best ones — and wonder why net profit stays flat while revenue grows.

Start With Your Bottom 10 Products Today

You don't need to audit all 200 products this week. Start with the bottom 10 by revenue and calculate their true cost. Most merchants who do this for the first time find at least 3-4 products that are actively losing money on every sale. Kill those first. The savings are immediate — less ad spend wasted, less inventory capital locked up, fewer returns to process.

Then work your way up the catalog. By the time you've audited your top 50 products, you'll have a clear picture of which ones deserve more investment and which ones have been coasting on the assumption that "more products = more revenue." It doesn't. More profitable products equals more revenue. Everything else is overhead wearing a disguise.