Her Best Seller Was Losing $1.80 a Unit: Dana's SKU Nightmare
Dana runs a 24-SKU outdoor-gear store on Shopify. Her star product is a camping headlamp: 900 units a month, more than double any other SKU, and the product she pours most of her ad budget into.
Then she ran the numbers SKU by SKU for the first time. That headlamp lost $1.80 on every unit sold. Her best-selling product was costing her $1,620 a month, while three "boring" products, a $9 carabiner, a repair kit, and a tarp stake set, were carrying the entire store's profit.
This is the most common blind spot in ecommerce: store-level profit hides product-level losses. On the Shopify Community forums, a seller described the exact same method that caught it: pick one SKU that feels like a winner, start with the actual net sale after discounts and refunds, subtract landed COGS, Shopify and payment fees, packaging, and real shipping, then allocate the ad spend that actually drove that SKU and include a return allowance even before returns happen. His conclusion: "That often changes the answer from 'this product has a 50% gross margin' to 'this product only keeps 12–18% after ads + shipping + returns.'"
So how do you find the losing-money products hiding in your own Shopify store, before they take the profitable ones down with them?
Store-Level Profit Lies. SKU-Level Profit Tells the Truth.
Shopify's "profit by product" report is dangerously incomplete. It shows revenue minus product cost per SKU and quietly ignores ad attribution, return costs, shipping variances, and fees. A SKU can look like your cash cow while bleeding $500 a month.
Every SKU carries its own stack of costs:
- Landed cost per unit. Product price plus freight, duties, and customs fees. Using the supplier invoice instead is how stores build losses in at the source. We broke down the full landed cost math in a previous guide.
- Shipping and fulfillment per unit. Size and weight change this a lot; a headlamp and a lantern are not the same number.
- Ad spend per SKU. Pulled from UTM tags and Shopify attribution, never guessed from the total.
- Return rate per SKU. Headlamps came back at 11%, carabiners at 2%. Store-wide averages hide exactly this difference.
- Refund processing and restocking cost per return. The hidden refund costs we quantified before.
- App and payment fees, allocated by revenue share.
One real thread on the Shopify Community asked whether very low-priced products, like $3 greeting cards, could ever be genuinely profitable. The answer that thread converged on: judge products by total profit contribution and profit per order per SKU, not by markup alone. A low-cost item with steady volume can outperform a higher-priced item with fewer sales. Revenue is not the score; net profit per SKU is.
The SKU Profit Audit Table: 6 Products, One Silent Leaker
Here is Dana's audit after 90 days of data. This is the exact template: copy it, swap in your own SKUs, and fill the columns.
| SKU | Units (90 days) | Revenue | Landed/unit | Shipping/unit | Ads/unit | Return rate | Return loss/unit | Fees/unit | Net profit/unit | Verdict |
|---|---|---|---|---|---|---|---|---|---|---|
| HL-01 Headlamp | 2,700 | $67,500 | $10.90 | $4.20 | $7.70 | 11% | $2.20 | $1.80 | -$1.80 | Reprice or kill |
| CB-04 Carabiner | 1,600 | $14,400 | $1.60 | $2.20 | $0.50 | 2% | $0.15 | $0.55 | +$4.00 | Scale ads |
| RK-02 Repair Kit | 600 | $21,000 | $14.50 | $4.90 | $3.10 | 4% | $0.85 | $1.75 | +$9.90 | Keep, upsell |
| TS-07 Tarp Stake Set | 830 | $12,450 | $3.10 | $3.40 | $3.60 | 4% | $0.55 | $0.90 | +$3.45 | Keep |
| LC-03 Lantern | 390 | $19,500 | $27.00 | $6.20 | $9.40 | 14% | $7.10 | $2.10 | -$1.80 | Kill or redesign |
| BW-01 Water Bottle | 1,120 | $15,680 | $3.40 | $4.80 | $1.20 | 6% | $1.10 | $1.10 | +$2.40 | Keep |
The headlamp is the store's best seller by revenue and its biggest cash incinerator. The lantern loses the same $1.80 a unit with a tenth of the volume, the definition of dead weight. Meanwhile the repair kit, $35 with a 4% return rate, prints $9.90 per unit. That is the product Dana should have been scaling the whole time.
How to Run a Shopify SKU Profit Audit (7 Steps)
- Export 90 days of orders with product line items. Shopify Admin, Orders, Export. Keep SKU, quantity, revenue, and shipping per line.
- Build the per-SKU P&L. Reuse the table above, one row per SKU, every cost column filled.
- Pull real ad spend per SKU. Export from Meta Ads Manager and Google Ads with UTM parameters, then map spend to SKUs through Shopify attribution. Guessing breaks the whole audit.
- Split returns by SKU. Count every return's full cost: shipping both ways, the refund fee, and restocking labor. An 11% return rate adds $2.20 to the cost of every headlamp sold.
- Allocate app and payment fees by revenue share. $480 in app fees across $150,000 of revenue is small; across a $15,000 SKU it changes the verdict.
- Compute net profit per unit and monthly contribution. Monthly contribution equals units times net profit per unit. That column decides everything.
- Act on a kill-or-fix threshold. If a SKU loses money for two straight months, reprice it with the product pricing formula, cut its ad budget, bundle it with winners, or delist it before inventory holding costs eat the margin you thought you had.
Double-check each row with a Shopify profit calculator; it takes about five minutes per SKU.
5 Misconceptions About Product Profitability
Misconception 1: "If it sells, keep it."
Volume is not profit. Dana's headlamp sold 2,700 units in a quarter and lost money on every single one. Revenue is vanity; net profit per unit is the score.
Misconception 2: "Shopify's product profitability report is accurate."
It is revenue minus product cost. It ignores ads, returns, and fees, the three biggest levers you control. That is why the community consensus on profit tracking threads keeps coming back to the same line: a "50% gross margin" product often keeps only 12–18% once ads, shipping, and returns are counted. Trusting the default report is how a $1.80-a-unit loser stays in your store for a year.
Misconception 3: "Returns average out across the store."
An 11% return SKU and a 2% return SKU are different businesses. Blend them and you will scale the one that is bleeding you.
Misconception 4: "Cut the lowest-revenue products first."
Revenue does not measure profit. The $50 tarp stake set at +$3.45 a unit beats a $100 product losing $1.80. Cut by net profit, never by sales rank.
Misconception 5: "Every SKU must be profitable."
Loss leaders are legitimate, but only if you track the subsidy consciously. The moment you stop knowing which SKU is subsidizing which, you have a hidden tax on your profit, and if your bank balance still disagrees with your dashboard, read Shopify profit vs. cash flow next.
FAQ: Shopify SKU Profit Audit
How do I find which products are losing money on my Shopify store?
Run the 7-step audit above: export 90 days of orders, add landed cost, shipping, real ad spend, per-SKU return costs, and fees, then sort by net profit per unit. The negative rows are your leakers.
What is a SKU profit audit?
It is a per-product profit calculation that includes every cost a SKU actually carries, landed cost, shipping, ads, returns, and fees, instead of relying on store-wide or dashboard averages.
Why is my best-selling product not profitable?
Best sellers usually carry the most ad spend and the highest return rates. High volume multiplies a small per-unit loss into a large monthly loss, exactly like Dana's headlamp at $1,620 a month.
How do I calculate profit per SKU on Shopify?
Price per unit minus landed cost, shipping, ads, expected return loss, and allocated fees. Net profit per unit times units sold equals the SKU's monthly contribution.
Should I delete products that lose money?
Only after you check price, ads, and returns. If raising the price or cutting ad spend cannot make it positive in two months, delist it. A losing SKU is not inventory; it is an expense.
Stop Funding Your Best Seller With Your Profitable Products' Money
Dana's store was not broken. It was just never measured. The fix took one spreadsheet and one honest look at per-SKU numbers.
Run every SKU through MerchCalc's free Shopify profit calculator: product cost, shipping, ads, and fees per unit in, real net profit out. Five minutes per SKU will show you which products are actually paying you, and which ones have been hiding in your store, losing money all along.