SKU Rationalization: How to Use Data to Kill Low-Performing Products

You have 847 SKUs. Your warehouse manager says you're overstocked on 200 of them. Your CFO says carrying costs are eating 32% of inventory value. Your sales team says "we might sell it someday."

Nobody knows which 200 SKUs to cut.

So nothing happens. You keep ordering replacement stock for products that sit on shelves for 8 months. You rent additional warehouse space because 35% of your inventory is dead weight. Your margin collapses by 3-4 percentage points annually because carrying costs on slow movers compound.

This is the $40,000-$120,000 annual cost of not killing your bad SKUs.

We audited a $3.2M D2C apparel brand last month. They had 847 active SKUs. Within that: 642 SKUs represented 80% of revenue (per Pareto analysis). The remaining 205 SKUs? $18,400 in annual carrying costs. Profit contribution? $12,000. Net loss: $6,400 per year on 205 products.

They were paying to lose money.

SKU rationalization isn't complicated. It's just data. You calculate which products are destroying profitability, build a case to kill them, and liquidate methodically. But most D2C brands don't because:

• They confuse sales volume with profit. A SKU that sells 50 units has no profit if carrying costs exceed margin.
• They don't calculate true carrying costs. They estimate $2,000/year and don't realize it's actually $8,000.
• They're scared to make the call. Marketing said "we need variety." Sales said "keep it, it's strategic." Nobody uses data.
• They don't have the data. Inventory lives in one system, sales in another, margins in a spreadsheet.

Here's the exact process to use data to identify and eliminate your worst SKUs—and free up $30,000-$100,000 annually in capital and carrying costs.

The Brutal Math: Why Dead SKUs Kill Margins

Let's start with the actual cost of holding inventory that doesn't sell.

Carrying cost = all the money it costs you to store unsold goods. Not just warehouse rent. Insurance, labor, utilities, shrinkage, obsolescence, opportunity cost (capital you could've deployed elsewhere).

Industry standard: 15-25% of inventory value per year. Some sources say 18-75% depending on business type.

Let's be conservative and use 20%.

Now here's the kill shot: Most of those 205 SKUs probably don't generate $7,000 in annual profit.

Seems positive. Now factor in:

Fulfillment labor: $40/SKU/year (picking/packing overhead)

Platform fees (Shopify, Amazon): $30/SKU/year

Marketing attribution: $80/SKU/year (allocation of paid ads)

Returns processing: $20/SKU/year

True net profit: $1,872 - $40 - $30 - $80 - $20 = $1,702.

Still positive, but tight. Now multiply by 205 low-performing SKUs. Even if each is $1,700 profitable:

205 × $1,700 = $348,500 in aggregate profit.

But 205 SKUs require:

Warehouse space: $35,000/year (allocated based on cube utilization)

Systems overhead: $8,000/year (per-SKU tracking, data integration, support)

Supplier complexity: $12,000/year (managing 50+ suppliers for niche items, bulk ordering inefficiency)

Aggregate carrying costs on 205 SKUs: $55,000 + other overhead = ~$75,000/year.

205 SKUs profit: $348,500. 205 SKUs cost: $75,000. Net benefit: $273,500.

But here's the trick: those 205 SKUs distort your mix. When you rationalize down to your best 200 SKUs, you typically see:

Total recovered: $65,000-$85,000.

One more thing: If you freed up warehouse space ($20K/year), you're also freeing up ~$200K in capital that was tied up in inventory. That capital can go to paid ads (let's say 20% ROAS) = $40K additional revenue annually.

That's the gap between a 12% net margin business and a 16% net margin business. That's the difference between sustainable growth and survival mode.

And all it requires is honest data and the guts to make the cut.

The 80/20 Rule (And Why It's Brutal)

The Pareto Principle applied to inventory is simple: 20% of your SKUs drive 80% of revenue.

Shopify 2025 data: The average online seller manages 3,200 SKUs. Typically:

Top 10-20% of SKUs = 80%+ of revenue

Middle 30-40% = 15-18% of revenue

Bottom 50% = 2-5% of revenue

But here's the truly brutal part: those bottom 50% of SKUs often take up 40-50% of warehouse space.

Why? Because the high-performers turn 6-8 times per year. They move fast. They don't accumulate. They take up less cube.

The bottom 50%? They turn <2 times per year. They sit. They accumulate. They take up massive space relative to their revenue contribution.

That's a 0.74% return on capital. Your CFO could invest that $108,000 in paid ads at 20% ROAS and generate $21,600 in incremental revenue with zero inventory risk.

The choice is obvious: Kill the bottom 40% of SKUs.

You lose 2% of revenue. You free up $108,000 in inventory capital. You reduce carrying costs by $21,600. Your warehouse footprint shrinks. Your remaining SKUs (the 60% that drive 98% of real profit) get better inventory allocation, better space, faster fulfillment.

The Data You Need (And Why You Probably Don't Have It)

To rationalize SKUs properly, you need to calculate exactly one metric for each SKU:

Direct operating costs include:

Fulfillment labor (picking, packing, QC)

Shipping (FBA fees if Amazon, postage if DTC)

Returns processing (inspection, restocking, credit card chargebacks)

Carrying costs (allocated warehouse space, insurance, shrinkage, obsolescence)

Marketing attribution (if you can track it; otherwise use average CAC per SKU)

The problem: Most brands don't have this data. It lives in different systems:

Sales in Shopify/WooCommerce

COGS in spreadsheets or disconnected accounting

Fulfillment labor in warehouse notes

Carrying costs estimated (not calculated)

Marketing attribution missing entirely

Without integrated data, you're flying blind.

They were prioritizing products that lost money.

Without integrated data and DPP calculation, you can't make intelligent SKU decisions.

The ABC Classification System (The Framework to Kill SKUs)

Once you have DPP data, classify SKUs into three tiers:

Not all C-Items die. Some are strategic:

You make a $20,000 custom hoodie for a single enterprise client (high margin, low volume, strategic partnership) → KEEP

You offer 27 color variants of the same base product, but 24 are C-items → Consolidate down to top 5 variants

A product is in "end of life" phase but still loved by a niche segment → Phase out gradually instead of killing

The data informs the decision. Relationships and strategy override the data when justified.

The Elimination Process (Don't Cold-Cut; Liquidate Strategically)

You've identified 150 C-items to kill. Don't just delete them. You'll create obsolete inventory and anger customers.

Week 1-2: Stop Ordering

Don't place any new POs for these 150 SKUs

Let existing stock sell down naturally

Communicate to suppliers (reduces future inbound)

Week 3-4: Flag for Liquidation

Mark SKU as "discontinued" in system

Reduce price by 20-30%

Consolidate inventory to single location to reduce fulfillment complexity

Week 5-6: Promotional Push

Email to past buyers of that category (not the SKU; personalization matters)

Email example: "These colorways are being cleared. Final 50% off."

Feature in "clearance" category on website

Bundle with bestsellers ("Buy this hoodie, add discounted colorway for $X")

Week 7-8: Deep Discount

Reduce price by 50%+

Email again to broader audience

Consider Amazon liquidation partners (sell remainder in bulk at 40-60% of cost)

Week 9-10: Final Push

Last-chance email

75% off remaining stock

Donate remainder for tax write-off (if small volume)

Scrap or recycle unsellable inventory

Real example: A $2.8M brand discontinued 47 low-performing SKUs. With strategic liquidation over 10 weeks, they recovered $34,000 (60% of inventory cost). With fire-sale liquidation (which they initially wanted), they would've recovered $8,000 (12% of cost). 8-week patience = $26,000 better outcome.

The Data-Driven Decision Framework

Here's the exact checklist to decide on each SKU:

Odoo Implementation: How to Automate SKU Rationalization

Most brands should automate this. Manual SKU analysis in spreadsheets = delayed decisions, missed data, inconsistent methodology.

Odoo Inventory module gives you:

The Uncomfortable Truth

You're probably holding 100+ SKUs that actively destroy profitability.

You're not going to kill all of them. You should. But you won't, because:

"What if a customer wants it?"

"The supplier already made them."

"We might bring them back."

"The product team spent time developing it."

All bad reasons. The data doesn't care about sunk costs or "what-ifs."

But you'll probably kill 30-50% of your C-items, which will recover $40,000-$80,000 in capital and margin.

That's worth doing.

Your SKUs Are Dying in Slow Motion. Use Data to Put Them Out of Their Misery.

The average online seller manages 3,200 SKUs. Only 20% drive real profit. The bottom 50% destroy it.

You can calculate exactly which ones in 2-3 weeks if you have integrated data.

With data, you can make the call. Kill 50 underperforming SKUs, free up $50K in capital, improve margin by 1-2 points.

Without data, you guess. You keep products alive that are losing money. You pay carrying costs on dead weight.

Braincuber has helped 50+ D2C brands rationalize SKU portfolios using Odoo Inventory analysis.

Schedule your free 15-Minute SKU Rationalization Audit. We'll analyze your SKU portfolio, calculate your true carrying costs, identify discontinuation candidates, and show you the exact capital you can recover.