The bulk discount trap: when a price break is worth a bigger order

A 10% price break looks like found money. On a phone-stand SKU selling six units a day, taking the biggest tier means buying 417 days of cover — more than a year of one product, in one PO, in one payment. Whether that trade is brilliant or a trap is not a matter of opinion: it's a three-line calculation, and the discount's edge usually lives or dies inside one assumption you probably haven't checked. Here's the calculation, a worked tier comparison, and the five gates a price break has to clear before it gets your cash.

A 40-comment thread in r/shopify in July 2026 asked exactly this — how to decide when and how much to reorder when bulk discounts are in play — and the replies split into two camps: buyers who computed the break-even and buyers who took the discount and regretted the shelf space (r/shopify, July 2026). The computation takes twenty minutes. This piece is that computation.

The three costs that decide it

A price break changes three numbers at once, and you only feel the first:

• Purchase cost — units × new unit cost. This is the line the supplier quotes, and it always improves.
• Ordering cost — bigger orders mean fewer POs per year, so admin and per-order freight drop slightly. This improves too, but it's small.
• Carrying cost — average inventory doubles every time order quantity doubles, and every stored unit costs you money per year: capital, storage, shrinkage, damage, obsolescence. This line always gets worse, and it's the one merchants skip.

Total annual cost is the sum of all three. The right tier is the one with the lowest total, not the lowest unit price — and the gap between those two answers is the entire trap.

Worked example: three tiers, one SKU

Phone stands, selling 6 units a day (2,200/year). The supplier's tiers: 500+ units at $4.20, 1,000+ at $3.60, 2,500+ at $3.25. Carrying rate 25% per year of unit cost — a planning convention; your own rate comes out of your carrying-cost build-up. Ordering cost $25 per PO covering this SKU's share of admin and freight. Every dollar figure below is illustrative.

Reading the middle row: 2,200 units at $3.60 = $7,920; 2,200 ÷ 1,000 = 2.2 POs at $25 = $55; average stock is half an order, 500 units × $3.60 = $1,800 of capital, and 25% of that is $450. Total: $8,425.

So the biggest tier "wins" — by $237.37 a year over the 1,000 tier. Before you wire the money, look at what that win costs:

• Cash upfront: 2,500 × $3.25 = $8,125 versus $3,600 for the 1,000 tier. The extra $4,525 you pay today returns $237.37 a year in savings — a 5.2% annual return on the marginal cash. Most operators can beat that leaving the money untouched.
• Cover: 2,500 units at 6 a day is 417 days of stock. Your assortment decision, pricing power, and cash are all committed 14 months out on one SKU.
• Assumption fragility: the entire $237 edge depends on the 25% carrying rate. Rerun the same table at 35% — a tight stockroom and slower turns make this realistic — and the totals land at $8,605 versus about $8,594. The tiers are an $11 wash, except one of them owns 14 months of your shelf.

That's the trap in one sentence: the biggest price break frequently "wins" by an amount smaller than your uncertainty in the carrying rate. For contrast, the jump from 500 to 1,000 units saves $1,187.50 a year on roughly $1,500 of extra cash — a 79% marginal return that no reasonable assumption reverses. The first break is usually obvious money; the second break is where the trap lives.

The five gates a price break must clear

Run the marginal analysis first (savings per year ÷ extra cash required), then send the surviving tier through these gates. All five pass, or the discount doesn't.

The verdict for our example: take the 1,000 tier, decline the 2,500. Same supplier relationship, most of the savings, a quarter of the commitment.

Two refinements worth knowing. First, your order-quantity math has a baseline: the EOQ formula computes the order size that balances ordering against carrying, and with these inputs it lands near 320 units (illustrative) — below every tier, which is typical when suppliers price breaks aggressively. The EOQ article owns that formula; here it just explains why every tier feels like overbuying, and why the question is which tier's total cost is least bad. Second, price breaks sometimes sit next to freight breaks — order enough and LCL becomes a shared container, or the freight minimum finally makes sense. If the discount only pays off combined with a freight threshold, run the combined numbers; the same gates apply to the total.

When the discount is time-limited

Suppliers attach deadlines — quarter-end targets, "price goes up next month," a closeout lot. The math doesn't change; the psychology does. A deadline is only information if it's real, and the same five gates still decide. What a deadline does change is the cost of waiting to decide: run the calculation now, because a week of indecision converts a possibly-good discount into a missed one, while a rushed yes converts a possibly-good discount into 14 months of the wrong SKU. If the tier fails the gates, the discount was never the price — the cover was. And if you take a deadline deal and it sours, the over-order triage sequence is the recovery path, not a bigger discount next year.

The part merchants forget: the discount also reprices your mistakes

A price break scales everything, including errors. Order 2,500 units on a velocity that turns out to be 3 a day instead of 6, and the discount bought you 833 days of cover and a slow-motion write-down. This is why the velocity-confidence gate matters more than the marginal-return gate: the return math assumes the demand is real. Ads-driven SKUs deserve extra skepticism — a spend change can halve velocity overnight, and the discount you took at the old velocity becomes the anchor weight at the new one. Compute the same tier table at half your current velocity as a stress test; if the biggest tier still clears the gates at the pessimistic number, it's genuinely safe. If it only works at the optimistic one, it isn't.

Common questions

Should I order more to get a bulk discount? Run the total annual cost per tier — purchase plus ordering plus carrying — then check the marginal return: extra savings divided by extra cash. The first price break usually clears every hurdle easily. Later breaks typically win by less than your carrying-rate uncertainty, so they need all five gates, not just a calculator.

How do you calculate if a bulk discount is worth it? For each tier: annual purchase cost, plus POs per year times cost per PO, plus average stock (half the order) times unit cost times your carrying rate. Compare totals across tiers. Then compute weeks of cover at your real velocity — a tier that wins on total cost while buying 60 weeks of one SKU is rarely the right answer.

What carrying cost rate should I use in the comparison? Use the rate from your own carrying-cost math, not a borrowed number — the four components (capital, storage, risk, obsolescence) vary hugely by product and stockroom. The worked example used 25%, a common planning convention, and showed the result flipping near 35%. Recompute at your rate and at a pessimistic rate before trusting the ranking.

Does a bulk discount change my reorder point? No. The reorder trigger comes from lead time and sales velocity and stays put no matter how much you order per cycle. A discount changes order quantity and cash timing. If you also stretch lead time to hit the tier, your trigger moves — and that new lead time is what bites you later.

What if the supplier says the price break expires this week? The deadline changes urgency, not the math. Run the tier table and the five gates immediately rather than letting the deadline decide for you. A real closeout at a real discount can justify bending the cover cap for a proven stable SKU; a manufactured deadline on an ad-driven SKU is how over-order triage gets a new customer.

Next step

Next step: take the last price break a supplier offered you and run it through the table and gates in this order — total annual cost per tier, marginal return on the extra cash, weeks of cover, velocity stress test at half demand. If it passes, take the lowest tier that clears the cover cap, not the biggest discount on the sheet. For the quantity side of the decision independent of discounts, the worked order-quantity method is the companion piece.