TL;DR
- SKU-level profitability is the contribution margin of each individual product after COGS, freight, payment fees, fulfillment, returns, and attributed ad spend.
- Formula: Net price − Landed COGS − Payment fees − Fulfillment − Returns allowance − Attributed ads = SKU contribution margin.
- Most ecommerce brands find 20–30% of SKUs destroy margin at the unit level once all variable costs are allocated honestly.
- Use the volume-vs-margin matrix (Stars, Cash Cows, Hidden Gems, Drains) to decide what to keep, reprice, or kill.
- Fairview rebuilds SKU profitability automatically once Shopify, Stripe, Meta Ads, Google Ads, and QuickBooks or Xero are connected.
SKU-level profitability analysis is the most honest margin view an ecommerce operator can run. Most brands can tell you which products sell the most. Very few can tell you which products actually make money after every variable cost is allocated. The gap between those two answers is where cash quietly leaks.
The pattern shows up in almost every catalog under $50M GMV: a hero SKU with great revenue and terrible margin, a long tail that looks dead but prints cash, and a dozen items that survive because nobody has ever pulled their true unit economics.
This spoke gives you the SKU-level margin formula, a worked example, the decision matrix, the benchmarks, and the mistakes that break the analysis. It is a companion to profit leak detection, contribution margin by channel, true ROAS, and CAC payback period.
What is SKU-level profitability?
Definition
SKU-level profitability: the contribution margin of a single stock-keeping unit after subtracting every variable cost associated with selling it — landed COGS, payment processing, fulfillment, shipping, returns, and attributed advertising. Expressed as dollars per unit or as a percentage of net revenue.
Gross margin is a reporting number. SKU contribution margin is an operating number. The difference is whether you subtract only COGS, or every cost that scales with the sale of that specific unit.
A $58 hair serum that looks 62% gross margin can land at 11% contribution margin once you add $3 payment fees, $6 fulfillment, $4 shipping subsidy, a 9% return rate, and $14 of attributed Meta ad spend. Same product, two entirely different stories. The second story is the one that drives cash.
The SKU contribution margin formula
Formula:
SKU contribution % = SKU contribution $ ÷ Net price
Each input matters, and each one is where operators make the analysis lie. Worth defining them carefully.
- Net price. Gross selling price minus discounts, promo codes, and loyalty credits actually used on that unit. Not MSRP.
- Landed COGS. Unit cost from the supplier plus inbound freight, duties, and inspection. A SKU made in Guangzhou is not just the factory invoice.
- Payment fees. Stripe, Shopify Payments, PayPal, or Amazon. Typically 2.4–2.9% plus 30¢ per transaction — higher on international cards.
- Fulfillment. Pick, pack, box, and insert. Use your 3PL’s actual per-unit pick cost, not the blended warehouse invoice divided by units.
- Returns allowance. SKU-specific return rate applied to both lost revenue and reverse logistics. Apparel can hit 25–30%; supplements sit closer to 2–4%.
- Attributed ads. Ad spend traced back to conversions of that SKU. The hardest input to get right; see the true ROAS post for the attribution logic.
Key insight
If the formula lets you win every argument, the formula is wrong. Honest SKU profitability always shows losers. The brands that refuse to see losers usually have the most of them.
The volume-vs-margin matrix
Once every SKU has a contribution number, plot it against 90-day unit volume. The four quadrants drive four different actions.
- Stars (high volume, high margin). Protect these with life. Every stockout here is pure cash left on the table. Put the best photography, the paid-media budget, and the bundle logic around them.
- Cash Cows (high volume, low margin). Workhorses. Audit for repricing, COGS renegotiation, or packaging changes that lift margin without touching demand. A 3-point margin lift on a cash cow often beats a new hero launch.
- Hidden Gems (low volume, high margin). Merchandising opportunities. These are the items buried on page 4 of the catalog that nobody has ever put in a bundle, an email, or a landing page. Surface them and they often double volume.
- Drains (low volume, low margin). Kill, reprice, or consolidate. Every drain ties up working capital, warehouse slots, and ops attention that a star would reward you for.
The honest version of this exercise always surprises. Expect two or three drains to be items the founder personally loves. Data wins. Cut the drains; the SKUs left will do better.
Benchmarks for SKU contribution margin
| Category | Healthy | Strong | Intervene below |
|---|---|---|---|
| Beauty & skincare (D2C) | 30–40% | > 45% | < 20% |
| Supplements / consumables | 35–50% | > 55% | < 25% |
| Apparel & footwear | 20–30% | > 35% | < 12% |
| Home goods & furniture | 18–28% | > 30% | < 10% |
| Amazon / marketplace seller | 25–35% | > 40% | < 15% |
| Food & beverage | 15–25% | > 28% | < 8% |
Benchmarks are a sanity check, not a target. A 22% contribution SKU in supplements is a problem; a 22% contribution SKU in home goods is healthy. Always read the number against the category norm before deciding what to do with it.
Five mistakes that break SKU profitability analysis
- Using gross margin as the input. Skipping fulfillment, returns, and ad attribution makes the Drain quadrant disappear. That is not good news; it is bad data.
- Allocating ad spend blended. A flat allocation hides which SKUs carry ad load. Attribute per product using last-click at minimum, MMM when you can.
- Ignoring return rate variance. A single apparel SKU with a 34% return rate destroys more margin than three low-return SKUs combined. Apply SKU-level return rates, not catalog averages.
- Missing inbound freight in landed COGS. Ocean freight spikes in 2021–2022 taught every commerce operator that landed cost shifts a lot. Refresh landed COGS quarterly.
- Reviewing SKUs only quarterly. Media mix, promo cadence, and supplier pricing move monthly. Quarterly reviews catch leaks a full quarter late.
How Fairview calculates SKU profitability automatically
Fairview connects natively to Shopify, Stripe, QuickBooks, Xero, Google Ads, and Meta Ads. Once connected, Margin Intelligence joins order lines with fees, fulfillment cost, return history, and attributed ad spend so every SKU has a live contribution number, updated daily.
When a SKU’s contribution slips below its historical band, Fairview writes a named next-best action: "Ceramide Serum 50ml contribution dropped from 32% to 17% over the last 14 days. Driver: Meta prospecting spend attributed to this SKU rose 38% while AOV stayed flat. Consider pausing the underperforming ad set or raising the price."
See pricing and tiers for the plan that fits your catalog size.
Per SKU
True contribution, not gross margin
Daily
Refresh across the catalog
10
Native integrations live today
Key takeaways
- SKU profitability = Net price − Landed COGS − Fees − Fulfillment − Returns − Attributed ads.
- Gross margin hides the real answer. Contribution margin reveals it.
- Plot every SKU on the volume-vs-margin matrix; act on the quadrant, not the average.
- D2C healthy: 30–40% contribution per SKU. Supplements 35–50%. Apparel 20–30%.
- Refresh monthly at minimum; weekly during promo or media shifts.
See true SKU profitability across your catalog.
Connect Shopify, Stripe, and your ad platforms. Fairview returns a live SKU contribution table and flags the drains on day one. 14-day trial, no card required.
Frequently asked questions
SKU-level profitability analysis calculates the true contribution margin of each individual product after subtracting COGS, inbound freight, payment processing, fulfillment, returns, and attributed ad spend. It separates items that make money from items that only look profitable at the gross-margin line.
SKU contribution margin equals net selling price minus landed COGS minus payment fees minus fulfillment and shipping minus a returns allowance minus attributed advertising spend. Divide by net revenue to express it as a percentage. Net price excludes discounts actually used; landed COGS includes inbound freight and duties.
For D2C beauty and skincare, 30–40% is healthy and over 45% is strong. Supplements run higher at 35–50%. Apparel sits lower at 20–30% because of returns. Marketplace sellers on Amazon typically need 35%+ to absorb promotional pressure and fees. Always read the number against your category norm.
A 2x2 grid that plots SKUs by unit volume and contribution margin. Stars (high/high) get protected, Cash Cows (high/low) get margin work, Hidden Gems (low/high) get merchandising, and Drains (low/low) get cut or repriced. The matrix replaces gut-feel assortment decisions with a defensible framework.
Weekly during promo periods and major ad shifts. Monthly as a standard operating cadence. Quarterly at the SKU-family roll-up for assortment decisions. Anything less frequent than monthly lets a leaking SKU run for most of a quarter before anyone notices.
Yes, and at the SKU level. Apply each SKU’s return rate to both lost revenue and reverse-logistics cost. Apparel and footwear can see 15–30% return rates that completely reshape the profitability picture, while supplements and consumables typically return at 2–4%. Using a catalog-wide average masks the worst offenders.