What Is a Fake-Profitable SKU? (And How to Find Yours)

Your Shopify reports say a product has 70% gross margin. Your spreadsheet agrees. But when you add up every cost it takes to actually sell and deliver that product, the real margin is 6%. That product is a fake-profitable SKU — and most Shopify stores have several of them hiding in plain sight.

What is a fake-profitable SKU?

A fake-profitable SKU is a product that looks profitable in simple reporting — Shopify analytics, a basic spreadsheet, or your accounting software — but turns weak or negative once you load in every variable cost required to sell it.

The gap comes from one place: most reporting tools only subtract COGS (cost of goods sold) from revenue. They call the result "gross profit" and stop there. But COGS is only one of six or seven cost lines that eat into every sale. The rest are invisible unless you deliberately track them.

The result is a number that feels safe — 50%, 60%, 70% margin — while the real per-unit contribution to your business is a fraction of that. Sometimes it is negative, meaning every sale of that product loses you money.

The anatomy of a fake-profitable SKU

Let's make this concrete. Take a product you sell for $40.00 with a $12.00 landed cost. Shopify shows a $28.00 gross profit and a 70% margin. That looks excellent. Now add the costs Shopify does not track:

After loading every variable cost, the product earns $2.50 per unit. The margin is 6.3% — not 70%. That $25.50 gap between gross profit and true contribution is the cost of actually selling and delivering the product.

At $2.50 per unit, a single $3 increase in shipping rates or CAC flips this product to a net loss. That is what makes fake-profitable SKUs dangerous: they are fragile. They look fine until a cost shifts — and then they quietly bleed cash.

Why Shopify reports create fake profitability

Shopify is a great sales platform, but its built-in profit reports are designed for simplicity, not accuracy. The "Cost per item" field in Shopify tracks one number: COGS. That is the cost to manufacture or source the product. Shopify then calculates gross profit as revenue minus COGS.

The problem is that COGS is often the minority of your total variable cost in a direct-to-consumer business. Here is what Shopify includes and what it leaves out:

For many DTC brands, the costs Shopify does not track add up to 40-60% of the sale price. That means the "profit" Shopify shows you is overstated by 2-10x, depending on the product.

This is not a bug. Shopify is a commerce platform, not a margin analytics tool. But if you make pricing or ad-spend decisions based on Shopify gross profit alone, you are working with incomplete data.

The 5 cost categories that create fake profitability

1. Customer acquisition cost (CAC)

This is the biggest margin killer for most DTC brands. If you spend $10,000 on Meta ads and sell 800 units, your blended CAC is $12.50 per unit. On a $40 product, that is 31% of revenue eaten by acquisition alone. Most sellers track total ad spend at the account level but never allocate it down to individual SKUs — which means high-CAC products hide behind low-CAC ones.

2. Shipping

If you offer free or subsidized shipping, that cost comes out of margin. A $7 shipping cost on a $40 item is 17.5% of revenue. And shipping is not flat across SKUs — heavier, bulkier, or further-shipped products cost more. A single flat shipping estimate across your catalog masks the real margin on each product.

3. Returns and refunds

The average e-commerce return rate is 15-30% depending on category (apparel is the worst). Returns cost you the refund amount, return shipping, restocking labor, and often the product itself if it cannot be resold. A 10% return rate with a $20 return cost on a $40 product adds $2 in expected cost per unit sold. Shopify does not factor this into per-SKU profitability.

4. Payment processing fees

Shopify Payments charges 2.9% + $0.30 per transaction. On a $40 sale, that is $1.46. On a $15 product, it is $0.74 — which is a larger percentage hit (4.9%) because the fixed $0.30 component weighs more. Low-priced SKUs are disproportionately affected by payment fees.

5. Fulfillment and packaging

Pick-pack labor, boxes, poly mailers, tissue paper, inserts, tape. For a 3PL, this might be $2-5 per order depending on complexity. For in-house fulfillment, it is your labor cost divided by units shipped. Either way, it is a per-unit cost that most sellers treat as overhead rather than allocating to each SKU.

How to find your fake-profitable SKUs

You do not need special software to start. Here is the manual process:

Step 1: Export your product list

Pull your SKUs from Shopify with sale price and COGS. If you do not have COGS entered for every SKU, start there — you cannot calculate margin without it.

Step 2: Add real variable costs per SKU

For each product, estimate or look up: shipping cost (use average weight and zone), payment processing (2.9% + $0.30 or your actual rate), CAC (total ad spend divided by units sold, ideally per-SKU if you run product-specific ads), return cost (return rate times cost per return), and packaging/fulfillment (per-unit cost from your 3PL invoice or your own labor calculation).

Step 3: Calculate true contribution margin

Subtract all variable costs from the sale price. This gives you the dollar contribution per unit. Divide by sale price for the percentage.

Step 4: Compare to gross margin

Put gross margin and contribution margin side by side for every SKU. Sort by the gap between them. The products with the biggest gap are your fake-profitable SKUs — the ones where simple reporting overstates profitability the most.

Step 5: Flag the danger zone

Any SKU with a true contribution margin under 10% deserves immediate attention. Under 5% is a red flag. Negative means you are paying customers to take your product.

What to do about fake-profitable SKUs

Finding them is step one. Here is how to act on what you find:

Reprice

If the product has strong demand and low price sensitivity, raise the price. A $5 increase on a $40 product with a $2.50 contribution margin triples your per-unit profit to $7.50. Price increases are the highest-leverage fix because every additional dollar drops straight to contribution.

Cut

If the product has negative or near-zero contribution and no strategic value (like driving repeat purchases or cross-sells), discontinue it. Every unit you sell at a loss is subsidized by your profitable SKUs. Cutting a money-losing product instantly improves blended margin.

Bundle

Pair a low-margin product with a high-margin one. A $40 tote bag at 6% margin bundled with a $15 accessory at 40% margin creates a $55 bundle that earns $8.50 instead of $2.50. Bundling also amortizes shipping and packaging costs across a higher revenue base.

Pause ads

If CAC is the primary margin killer, stop running paid ads for that SKU. Let it sell organically or through email. The contribution margin without CAC might be healthy — in our tote bag example, removing the $11 CAC brings contribution from $2.50 to $13.50 (33.8%). Not every product needs to be advertised.

Renegotiate shipping

If shipping is eating margin, shop for better carrier rates, move to a regional 3PL closer to your customer base, or adjust your free-shipping threshold to encourage higher-AOV orders that spread shipping cost across more revenue.

Stop guessing. See the real numbers.

The manual process works, but it is slow and breaks every time your costs change. MarginCaptain automates the entire calculation — it loads every variable cost per SKU, computes true contribution margin, and flags fake-profitable products automatically.

Try the interactive demo to see how a 10-SKU catalog breaks down when you load in real costs. Most sellers find at least one product that is not earning what they thought it was.