You know your overall margin. But do you know which products actually contribute to it — and which ones are quietly draining it? Most mid-market product companies can’t answer that question at the SKU level. That’s the gap that kills profitability at scale.
Every product company has a revenue-by-SKU report. It shows your top sellers, your long tail, and the obvious dogs. It feels like useful data. It isn’t — not for profitability decisions.
Revenue tells you what customers buy. It does not tell you what makes money. And the gap between those two things is where most mid-market companies lose control of their margins.
Here’s the trap, and it plays out constantly with Amazon FBA sellers. A company has a hero product selling 2,000 units a month at $29.99. That’s $59,980 in monthly revenue from a single SKU. It’s the top of every report. It gets the biggest ad budget. It’s the product the team rallies around. And it’s losing money.
Not at the gross margin level — the product costs $14.50 to manufacture and land, so it looks like a 52% gross margin product. But after FBA fulfillment fees ($5.80), Amazon referral fees ($4.50), allocated ad spend ($3.85 per unit based on Amazon PPC driving traffic to that listing), return processing costs ($0.42 per unit at a 12% return rate), and customer service allocation ($0.18 per unit) — the real margin is $0.74 per unit. That’s 2.5%.
Meanwhile, a low-volume SKU selling 200 units a month at $44.99, buried on page three of the revenue report, is running a 19% fully-loaded margin. Nobody is optimizing it. Nobody is allocating ad budget to it. It’s the quiet winner subsidizing the noisy loser.
This is what per-SKU profitability analysis reveals: the actual economic contribution of every product in your catalog after every cost has been allocated. It’s the foundation of the profit intelligence framework at the product level.
The reason most companies don’t do per-SKU profitability analysis is that the cost stack is deep and the data lives in multiple systems. Here’s every layer you need to allocate to each SKU:
1. COGS (cost of goods sold). Manufacturing or wholesale cost per unit, including inbound freight to your warehouse or 3PL. This is the one number most companies track at the SKU level. It’s necessary but wildly insufficient.
2. Shipping and fulfillment. Outbound shipping cost per unit, pick-and-pack fees from your 3PL, FBA fulfillment charges, packaging materials. For FBA products, Amazon bundles this into a single fee that varies by product size and weight. For DTC, it’s your 3PL rate plus carrier cost. This layer typically runs $3–$8 per unit for standard-size products.
3. Marketplace fees. Amazon referral fees (8–15% depending on category), Walmart referral fees (6–15%), payment processing fees for DTC orders (2.9% + $0.30). These are directly attributable to each unit sold on each channel.
4. Ad spend allocation. How much advertising spend is driving sales of this specific SKU? This is the hardest cost to allocate and the one most companies skip. We’ll cover the methodology below.
5. Returns and refund costs. Not just the revenue lost from returns — the return shipping cost, restocking labor, inventory depreciation on returned units, and the payment processing fees you don’t recover. For the full framework, see how returns, refunds, and chargebacks eat margin.
6. Customer service time. Some products generate more support tickets than others. A product with a high defect rate or confusing instructions creates support costs that should be attributed to that SKU, not spread across the entire catalog.
Stack all six layers against the selling price and you have your fully-loaded per-unit margin. For most companies running this analysis for the first time, the number is dramatically lower than their gross margin suggested.
Direct costs are straightforward — COGS, shipping, and marketplace fees map cleanly to individual SKUs. The hard part is shared costs: ad spend, warehouse overhead, and customer service. Here’s how to handle each one without overcomplicating the model.
Ad spend allocation. If you run SKU-specific ads (Amazon Sponsored Products, Google Shopping campaigns targeting individual products), the attribution is direct. Pull spend by campaign, map each campaign to the SKU it’s promoting, and divide by units sold. For brand-level advertising (Meta brand awareness campaigns, Google brand search), allocate proportionally by revenue contribution. If a SKU generates 8% of total revenue, it gets 8% of brand ad spend. This isn’t perfect, but it’s directionally correct and far better than not allocating at all.
Warehouse overhead. Rent, utilities, warehouse management labor, and storage costs that aren’t billed per-pick. Allocate by cubic feet of storage space multiplied by months stored. A bulky product that sits for 90 days consumes more warehouse overhead than a compact product that turns in 30 days. If you’re on FBA, Amazon charges long-term storage fees that make this layer explicit — which is one of the few advantages of FBA pricing transparency.
Customer service. Tag support tickets by SKU in your help desk. Most support platforms (Zendesk, Gorgias, Freshdesk) support product tagging. After 30 days of tagging, you’ll have a distribution. Multiply tickets per SKU by your average cost per ticket (total CS spend divided by total tickets) and you have a per-SKU customer service allocation.
Don’t let perfect allocation kill the analysis. Allocate direct costs exactly. Allocate the two or three largest shared costs (ad spend and warehouse overhead) using the methods above. For everything else — software subscriptions, insurance, office overhead — allocate proportionally by revenue. The goal is directional accuracy on every SKU, not forensic precision on allocation methodology. A rough SKU P&L is infinitely more useful than no SKU P&L.
Almost every product company has one: the hero SKU. It’s the best-seller. It’s the product the brand is known for. It drives the most traffic, gets the most ad budget, and dominates internal conversations. And in a startling number of cases, it’s your worst-margin product.
The dynamics are predictable. The hero SKU attracts the most competition, which drives up ad costs. It has the highest review volume, which means the highest return volume in absolute numbers. Its price gets anchored by competitive pressure — you can’t raise it without losing the Buy Box or dropping in search rankings. And because it’s the flagship, it gets the promotional discounts and bundle deals that further erode margin.
Take a real example. A company selling kitchen products has a silicone spatula set at $19.99. It sells 5,000 units a month. COGS is $4.20. Gross margin: 79%. Looks spectacular. But the Amazon PPC cost to maintain top-of-search position is $3.80 per unit (ACoS of 19%), FBA fulfillment is $4.65 (oversized tier because of packaging), the referral fee is $3.00, returns cost $0.95 per unit at a 15% return rate, and allocated warehouse overhead is $0.40. Fully-loaded margin: $2.99 per unit — 15%. Not terrible, but a fraction of the gross margin number.
Now compare that to their ceramic utensil holder at $34.99, selling 400 units a month. COGS is $7.80. The product faces less competition, so PPC costs are $1.90 per unit. Lower return rate (6%) means $0.32 per unit in return costs. Fully-loaded margin: $8.47 per unit — 24.2%. This product makes almost three times the margin per unit and nobody is investing in growing it.
The hero SKU problem isn’t that the hero is bad — it’s that volume creates a false sense of importance. A product that generates $100K in revenue and $3K in profit is less valuable than a product that generates $14K in revenue and $3.4K in profit. The second product needs growth investment. The first needs margin repair.
Your highest-revenue SKU is not necessarily your most profitable one. Volume creates competitive pressure on ad costs, pricing, and return rates that compress margin. Run the fully-loaded numbers before deciding where to invest your next dollar of growth spend. The product that deserves more budget is often buried in the middle of the revenue report.
A SKU P&L is a spreadsheet where each row is a SKU and each column is a cost layer. Here’s the structure:
Column A: SKU / product name. Every active product in your catalog gets a row.
Column B: Units sold (for the period — monthly or quarterly).
Column C: Gross revenue. Units sold multiplied by average selling price. Use actual average selling price, not list price — account for promotions and discounts.
Column D: COGS. Per-unit landed cost multiplied by units sold.
Column E: Gross profit. Revenue minus COGS. This is where most reporting stops.
Column F: Fulfillment costs. 3PL fees, FBA fees, outbound shipping, packaging.
Column G: Marketplace fees. Referral fees and payment processing.
Column H: Allocated ad spend. Direct campaign spend plus proportional brand spend.
Column I: Return costs. Return rate multiplied by units sold, multiplied by per-return cost (return shipping + restocking + depreciation + unrecovered processing fees).
Column J: Other allocations. Customer service, storage overhead, software.
Column K: Fully-loaded profit. Revenue minus the sum of columns D through J.
Column L: Fully-loaded margin %. Column K divided by column C. This is the number that matters.
Sort by column L descending. Your most profitable products are at the top. Your money-losers are at the bottom. The distance between the top and the bottom is your opportunity.
Once you have per-SKU margins, build the portfolio view: a ranked list of every SKU by contribution margin, with cumulative profit contribution.
This view typically reveals a pattern. The top 20–25% of SKUs generate 80–100% of total profit. The middle 40–50% are marginally profitable — they cover their variable costs but don’t meaningfully contribute to overhead. And the bottom 20–30% are actively destroying value — every unit sold loses money after all costs are allocated.
That bottom tier is the urgent problem. These SKUs are consuming ad budget, warehouse space, customer service time, and management attention while generating negative contribution margin. Every unit you sell costs you money. Growing these products doesn’t fix the problem — it makes it worse.
The middle tier is the strategic opportunity. These SKUs are close to meaningful profitability. A small price increase, a supplier renegotiation, or a reduction in return rate could move them into the top tier. This is where targeted operational improvements have the highest ROI.
This portfolio view connects directly to your margin waterfall. The waterfall tells you which cost layers are largest in aggregate. The SKU portfolio tells you which products are most affected by each layer. Together, they show you exactly where to intervene.
If your overall margin looks healthy but individual SKUs are underwater, you have a cross-subsidy problem: profitable products are masking unprofitable ones. This is dangerous because it means your margin is concentrated in a small number of products. If any of those top performers hit a problem — supplier price increase, competitive pressure, platform algorithm change — your entire margin structure collapses. Diversified profitability across the catalog is more resilient than concentrated profitability in a few heroes.
A SKU P&L is only useful if it drives decisions. Here are the seven actions you can take on any SKU based on its fully-loaded margin:
Kill it. If a SKU has negative margin and no strategic value (it doesn’t drive traffic to better products, doesn’t complete a collection, and isn’t a loss leader with proven upsell conversion), stop selling it. Liquidate remaining inventory and redirect the ad budget to profitable products.
Raise the price. If the product has strong demand and low price sensitivity, a 10–15% price increase might move it from breakeven to profitable. Test it. Monitor unit volume over 30 days. If volume drops less than the margin gain, keep the increase.
Renegotiate the supplier. If COGS is the dominant cost layer for a high-volume SKU, go back to the supplier with a volume commitment in exchange for a lower per-unit price. A 5% COGS reduction on a high-volume product can shift the fully-loaded margin by 3–4 points.
Bundle it. If a low-margin product pairs naturally with a high-margin product, create a bundle. The blended margin is higher, the AOV increases, and shipping costs per unit often decrease because you’re sending one package instead of two.
Reposition the channel. A product that’s unprofitable on Amazon (high referral fees, high PPC costs) might be profitable on your DTC site (lower fees, higher AOV from cross-sells). Shift ad spend to drive DTC traffic for that SKU instead.
Fix the return rate. If return costs are the margin killer for a specific SKU, the problem is upstream. Better product photos, accurate sizing guides, improved packaging, or quality control fixes can reduce the return rate and recover margin. A product with a 20% return rate that drops to 10% typically gains 2–4 points of fully-loaded margin.
Reduce ad dependency. If allocated ad spend is the largest post-COGS cost, work on organic ranking. Improve the listing SEO, build review velocity, and optimize conversion rate so the product can sustain sales without the current PPC spend. Reducing ACoS from 25% to 15% on a $30 product recovers $3 per unit.
For each underperforming SKU, pick the one action most likely to move the needle. Don’t try all seven at once. One intervention, measured over 30–60 days, with a clear target margin. Then move to the next SKU. This cadence connects directly to sustainable growth economics — you’re improving the margin that your payback period depends on.
A SKU P&L that’s six months old is worse than useless — it gives you confidence in numbers that may no longer be accurate. Costs change. Ad efficiency shifts. Return rates fluctuate seasonally. Your update cadence should match your decision cycle.
Monthly minimum. Pull updated data from all systems, refresh the SKU P&L, and review the bottom 20% for kill/fix decisions. This takes 3–4 hours once you’ve built the initial model. Most of that time is data extraction, not analysis.
Weekly for high-volume SKUs. If you have products selling more than 50 units per day, you need weekly visibility on their fully-loaded margin. Ad costs and return rates can shift fast enough to turn a profitable SKU negative within two weeks. A weekly P&L cadence catches these shifts before they compound.
Real-time for launches. In the first 30 days of a new product launch, costs are volatile. Ad spend is high because you’re building ranking. Return rates are uncertain because you don’t have enough data. Fulfillment costs may be higher if you haven’t optimized packaging dimensions. Track daily during launch to avoid burning cash on a product that won’t reach profitability at scale.
The companies that treat SKU profitability as a living document — updated regularly, reviewed in ops meetings, tied to decisions — consistently outperform those that check it once a quarter. The data isn’t the competitive advantage. The cadence is.
Per-SKU profitability analysis is not a one-time project. It’s an operational discipline. Build the model once, update it monthly at minimum, and tie every SKU to a clear action: grow, fix, or kill. The spread between your best and worst SKU margins is your single largest lever for improving overall profitability without adding a dollar of revenue.
30-minute discovery call. We’ll help you see which SKUs are driving profit and which are draining it.
Schedule Call