Sarah's 6,700 SKUs: 73% Barely Moved, and the Winners Paid for All of It
Sarah runs an apparel brand on Shopify. Her t-shirts come in 8 colors, 6 sizes, and 3 fabric types, 144 possible variants per design, and across 47 products that meant managing over 6,700 SKUs. On paper everything looked fine: sales were good, traffic was steady, margins were slowly eroding, and she could not figure out why.
When the variant data came out, it wasn't subtle. 73% of her variants had sold fewer than 5 units in six months. Some had never sold at all. Just 18% of variants generated 82% of revenue, and those winners were subsidizing the other 82% that barely moved. Her average visitor looked at 2.1 color options before buying, not 8. And the three hero colors, black, white, and navy, took 91% of sales, while specialty colors she had special-ordered at a 144-unit minimum generated $580 in revenue against $4,300 spent.
"I thought offering more choices would increase sales," she told her analyst. "Isn't that what customers want?"
It is the most common variant mistake in Shopify, and it hides a second, sneakier problem: even when a variant sells, its cost may be wrong. So how do you find the variants that are secretly losing money before the parent product's average hides them?
One Product Name Is Not One Cost
If you record one cost for a whole product, Shopify's profit report is not just incomplete. It is actively lying about which variants make money.
Every variant carries its own economics. A t-shirt in size 2XL costs more fabric, more labor, and more shipping than a Small. A premium fabric costs more than the blend. When you enter one average COGS for the whole product, the report overstates some variants and understates others, and you make the wrong decisions in both directions.
Real numbers make it concrete. A store selling a shirt at $50 with five sizes had actual costs of Small $12, Medium $14, Large $16, XL $19, and 2XL $23. The merchant recorded one universal cost: $15 for all. The result: Small's profit was understated by $3 a unit, and 2XL's profit was overstated by $8 a unit. The dashboard made Small look worse than it was and 2XL look far better. So the merchant discounted XL, poured ads into 2XL, reordered more 2XL, and only later found out the "high-margin" variant was the one leaking.
The same distortion scales like compound interest. A $2 cost error is invisible on one order and becomes a $20,000 margin distortion at 10,000 units. Shopify's own profit reports only calculate profit for products and variants where a cost per item was recorded, and if you recorded one average for the parent, every variant inherits the error.
The Variant Profit Table: What the Report Never Showed
Here is the corrected table from that five-size shirt. Copy it, swap in your variants, and fill the columns:
| Variant | Units (90 days) | Actual COGS | Recorded COGS | Price | Reported profit/unit | True profit/unit | Error/unit | Verdict |
|---|---|---|---|---|---|---|---|---|
| Small | 1,100 | $12 | $15 | $50 | $35 | $38 | +$3 hidden upside | Scale |
| Medium | 1,400 | $14 | $15 | $50 | $35 | $36 | +$1 | Keep |
| Large | 1,200 | $16 | $15 | $50 | $35 | $34 | -$1 | Watch |
| XL | 620 | $19 | $15 | $55 | $40 | $36 | -$4 | Fix or reprice |
| 2XL | 340 | $23 | $15 | $60 | $45 | $37 | -$8 | Investigate |
Read the 2XL row: the dashboard said $45 a unit, reality was $37, $8 of phantom profit on every sale, 340 units a quarter, roughly $900 a month of fake margin funding ads that should never have run. Meanwhile Small, the actual profit hero, looked average, so it never got the ad budget it deserved.
How to Calculate Profit Per Variant on Shopify (6 Steps)
- Enter cost per item on every variant. Shopify Admin, Products, open each variant, set Cost per item. Stop using one average for the parent. Use landed cost, not the supplier invoice; the full math is in our landed cost guide.
- Pull the variant profit report. Analytics, Reports, Profit by product variant, or ask Sidekick: "Show gross profit by product variant for the last 90 days." The report is only as good as step 1.
- Add the costs Shopify never shows. Per-variant shipping, heavier sizes cost more, ad spend per variant, and the return rate per size or color. Returns run 2% on some variants and 14% on others; the difference decides the verdict.
- Charge the complexity tax. Every variant option carries real overhead: storage, management, photography, data entry. One analysis put it near $2.40 per variant per month. Across Sarah's 6,700 SKUs that was over $16,000 a month in complexity overhead alone.
- Apply the purge framework. Keep any variant that sold 10+ units in 90 days. Keep any variant with margin above 40% regardless of volume. Discontinue variants with fewer than 5 sales in 180 days AND margin under 30%. Sarah went from 6,700 SKUs to 1,840, a 72% cut.
- Re-run quarterly, and reprice with the product pricing formula before you cut ads or inventory.
Then run each surviving variant through a Shopify profit calculator to double-check the per-unit math.
What Sarah's Purge Actually Did (Real Results)
Three months after cutting from 6,700 to 1,840 variants:
- Carrying costs dropped from $16,000 to $4,400 a month
- $38,000 of cash freed from liquidated slow movers
- Gross margin up 6.2 percentage points
- Fulfillment time dropped from 3.8 to 1.2 days
- Returns down 18%, conversion up 4.3%
- Estimated annual impact: $210,000+
The customers she feared losing? They bought more, complained less, and her Net Promoter Score went up. "I thought I was being customer-centric by offering everything," she said. "But I was actually making them do the work of figuring out what I should be selling."
5 Misconceptions About Variant Profit
Misconception 1: "One cost per product is close enough."
A $3 average error on a shirt hides a $3 understatement on Small and an $8 overstatement on 2XL. Average costs create phantom winners and invisible losers.
Misconception 2: "More variants mean more sales."
Sarah's shoppers looked at 2.1 color options, not 8. 73% of her variants sold fewer than 5 units in six months. Choice without margin is just overhead.
Misconception 3: "The best-selling variant is the most profitable."
Volume and margin are different numbers. The best-selling size can be the one losing the most per unit, exactly like the SKU profit audit catches at product level.
Misconception 4: "Shopify's profit report is accurate."
It only knows the costs you entered. One average COGS on the parent product means every variant inherits the same wrong number.
Misconception 5: "Killing variants hurts customers."
Sarah's conversion went up 4.3% and returns dropped 18% after the cut. Fewer, in-stock, correctly priced variants beat a sprawling catalog of dust collectors. And if you are not sure whether to kill or fix a losing SKU, the losing product remediation guide walks through the decision.
FAQ: Shopify Variant Profit
How do I calculate profit per variant on Shopify?
Enter a real cost per item on each variant, pull the Profit by product variant report, then subtract per-variant shipping, ads, and return costs. Price minus true landed cost minus those costs equals variant profit.
Why do my product variants have different costs?
Different sizes use more material and labor, different fabrics cost differently, and heavier variants ship for more. One average COGS hides all of it.
Should I price variants differently on Shopify?
Yes, when the cost difference is material. XL and 2XL shirts with $19 and $23 costs cannot all sit at $50 without one of them quietly losing money. Inventory holding costs also differ per slow-moving variant.
How many variants should a Shopify product have?
Enough to serve real customer segments, not enough to create a buffet. Sarah's three fabrics served distinct buyers; her eight colors mostly did not. Test, then purge the bottom 72%.
What is the best way to find unprofitable Shopify variants?
Run the variant report with true per-variant costs, sort by net profit per unit, and flag every row where reported profit overstates true profit by more than a couple of dollars. Those are the variants funding your "best sellers."
Stop Pricing Every Variant Like It Costs the Same
Sarah did not lose customers when she cut 72% of her variants. She added over $200,000 a year to her bottom line.
Run each variant through MerchCalc's free Shopify profit calculator: true cost, shipping, ads, and fees per unit in, real net profit per variant out. Five minutes per variant will show you which sizes and colors are actually paying you, and which ones have been hiding inside a profitable-looking product all along.