Forward Buying and Pantry Loading: Why Promo Sell-In Numbers Lie

Forward buying is the classic structural ROI distortion in trade promotions. Retailers order excess inventory during a promotional window, beyond what they expect to sell through to consumers during the deal period, and then sell the excess at full margin after the promotion ends. "Where did the discount go?" If the answer is "into retailer inventory and then out at full shelf price", the manufacturer paid for the discount and the retailer captured the margin.

Why retailers do it (rational behaviour)

Forward buying is rational behaviour for retailers, not a violation of trust. If a manufacturer offers a temporary cost reduction, it is the retailer's job to order as much as they can store and sell through at full margin once the deal ends. The retailer's commercial team is graded on gross margin per unit; forward buying improves that metric without violating any contract.

The fix has to be a structural one (mechanic and funding design), not a behavioural one (asking the buyer not to forward-buy).

How big is the problem

The magnitude can be substantial. In categories with long shelf life (canned goods, biscuits, frozen, household essentials), forward buying can represent 20 to 40 percent of sell-in volume during a deep TPR. In categories with short shelf life (fresh dairy, produce, fresh bakery), the same buying pattern is bounded by the spoilage risk and rarely exceeds 5 to 10 percent of sell-in.

Why the manufacturer pays

The volume that lives in retailer warehouses after the promotion ends never generates consumer incrementality. It simply transfers margin from the manufacturer (who funded the discount) to the retailer (who sells the inventory at the post-promo shelf price). On a 20 percent off TPR with 30 percent forward-buy rate, roughly 30 percent of the manufacturer's discount cost converted directly into retailer gross margin without producing any incremental shopper purchase.

The diagnostic signal

The classical detection rule: a visible spike in sell-in without a corresponding spike in sell-out during the promotional window. Plot weekly POS sell-out alongside weekly sell-in shipments; the gap during the promo window is the forward-buy estimate, modulo normal inventory replenishment patterns.

Three formulas turn the forward-buy diagnostic into a number on the page.

Forward-Buy Volume

The adjustment for normal inventory replenishment matters: a small sell-in / sell-out gap during a deal week is normal stocking. The flag is when the gap is materially larger than the trailing eight-week average for the same SKU and account.

Forward-Buy Rate

The thresholds that separate normal from problematic:

• Below 10 percent: normal inventory replenishment, no action
• 10 to 25 percent: moderate forward buying, watch for a pattern
• Above 25 percent: significant forward buying, requires action (mechanic redesign, funding-mechanism switch, or order quantity caps)

Margin Transfer to Retailer

The number is the dollars-and-cents view of how much trade investment leaked from the manufacturer's P&L straight into the retailer's gross margin without serving the manufacturer's commercial objective.

Adjusted ROI under forward-buy correction

Forward buying always pushes the adjusted ROI lower than the sell-in headline number. A promotion that reads +15 percent ROI on sell-in data may show -5 percent ROI once the forward-buy correction is applied. The gap is not a rounding error; it is the structural ROI distortion that makes deep-TPR scorecards routinely inflate the headline number.

A biscuit manufacturer analysed sell-in versus sell-out data for a 2-week 20 percent off TPR at a major retailer. The sell-in scorecard read as a comfortable winner. The sell-out reality was the opposite.

Scenario: a 2-week TPR at a single retailer

• Promo mechanic: 20 percent off TPR ($0.80 discount per unit on a $4.00 retail price)
• Window: 2 weeks
• Baseline sell-out: 18,000 units across the 2-week window
• Reported event ROI: +32 percent (on sell-in data)

The sell-in vs sell-out gap

• Sell-in during promotion: 42,000 units ordered by retailer
• Sell-out during promotion: 28,000 units scanned at registers
• Forward-buy gap: 42,000 - 28,000 = 14,000 units (33 percent of sell-in)
• Margin transfer to retailer: 14,000 units x $0.80 discount = $11,200

The $11,200 of manufacturer trade investment improved retailer gross margin without producing a single additional consumer purchase.

Sell-in-based ROI (the reported number)

• Sell-in incremental: 42,000 - 18,000 = 24,000 units
• Incremental GP: 24,000 x $1.85 contribution = $44,400
• Total promo cost: 42,000 x $0.80 = $33,600
• ROI = ($44,400 - $33,600) / $33,600 = +32 percent

Sell-out-corrected ROI (the actual number)

• Sell-out incremental: 28,000 - 18,000 = 10,000 units
• Incremental GP: 10,000 x $1.85 = $18,500
• Total promo cost: $33,600 (same as before; the discount applied to all 42,000 ordered units)
• ROI = ($18,500 - $33,600) / $33,600 = -45 percent

What changed

The manufacturer switched this retailer to scan-back funding for the next year of TPRs. Scan-back pays the retailer per unit scanned at the register, not per unit ordered. The forward-buy distortion disappeared by construction. Actual ROI improved by 25+ percentage points on the next 2-week TPR run at the same depth, because the forward-buy margin transfer was eliminated and the discount cost only applied to the units consumers actually purchased.

Closing the forward-buy gap is one of the highest-leverage waste-reduction moves in TPO, alongside reducing subsidised base. Five actions in roughly the order they should be tried.

Fund on sell-out, not sell-in

The single most effective countermeasure is to tie promotional payment to sell-out volume, not sell-in volume. If the retailer only gets paid for units that consumers actually purchase, forward buying becomes unprofitable for them. Scan-back mechanics (payment per unit scanned at the register) and bill-back mechanics (payment after sell-out is verified) both implement this principle. The retailer keeps the buying-decision freedom but loses the forward-buy arbitrage.

Cap promotional order quantities by sell-through rate

If the retailer typically sells 5,000 units in a 2-week promotion, cap the promotional order at roughly 6,000 (modest growth allowance). The cap removes the structural ability to forward-buy without changing the promotional experience for the consumer.

Switch from off-invoice to scan-back funding

Off-invoice discounts pay per unit ordered. Scan-back pays per unit scanned at the register. The change is mechanical: the manufacturer's accounts-payable team writes a different cheque on a different trigger. The result is a roughly 15 to 25 percent ROI improvement on the same all-in trade dollar across most deep-TPR events, because the forward-buy margin transfer is eliminated by construction.

Monitor sell-in vs sell-out divergence as a standard KPI

Add the divergence metric to the monthly governance dashboard. Flag any event where sell-in exceeds sell-out by more than 15 percent during the promo window for explicit investigation. The threshold catches the structural forward-buyers; the dashboard makes it routine to act on them rather than blame them after the post-event review.

Build forward-buy thresholds into trade terms

The cleanest long-term fix is contractual. Trade terms can specify maximum inventory build during promotional periods, with consequences ranging from rebate clawback to disqualification from the next promotional slot. The contractual approach removes the forward-buy decision from event-by-event negotiation and makes it part of the structural relationship.