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

Forward buying is the classic structural ROI distortion in trade promotions. Retailers order more stock during a promotion than they expect to sell to shoppers while the deal is on. They then sell the extra 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 behavior)

Forward buying is rational behavior 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 is structural rather than behavioral. Change the mechanic and the way the promotion is funded, rather than 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, ambient snacks, 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 adds a genuinely new shopper purchase. 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 a 30 percent forward‑buy rate, roughly 30 percent of the manufacturer's discount cost turned straight into retailer gross margin. None of it bought a single extra shopper purchase.

The diagnostic signal

The classic detection rule is a visible spike in sell‑in without a matching spike in sell‑out during the promotion. Plot weekly sell‑out from the retailer's checkout data (what it sold to shoppers) alongside weekly sell‑in (what you shipped to it). The gap during the promotion is the forward‑buy estimate, once you allow for normal restocking.

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

Forward‑Buy Volume

The adjustment for normal restocking matters, because a small sell‑in to sell‑out gap during a deal week is ordinary stocking. What you look for is a gap much larger than the average of the previous eight weeks 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, and it needs action. Redesign the mechanic, change how the promotion is funded, or cap the order quantity

Margin Transfer to Retailer

It shows, in dollars, how much trade investment leaked from the manufacturer's P&L straight into the retailer's gross margin, and did nothing for the manufacturer's own goals.

Adjusted ROI under forward‑buy correction

Here Incremental GP and Promo Cost are both measured on sell‑out. That means the incremental gross profit on units consumers actually bought, and the discount funded on those units only. The Forward Buy Margin Transfer is the discount on the units the retailer stored away, and it is carried as its own line. So Promo Cost plus Forward Buy Margin Transfer equals the total discount funded across every unit the retailer ordered.

Forward buying always pushes the adjusted ROI below the headline number taken from sell‑in. A promotion that reads +15 percent ROI on sell‑in data may show -5 percent ROI once you correct for forward buying. That gap is why the scorecard on a deep TPR can report an ROI the event never earned.

A biscuit manufacturer compared sell‑in with sell‑out data for a 2‑week 20 percent off TPR at a major retailer. On sell‑in the event looked like a modest winner. On sell‑out it lost more than half of what it cost.

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, funded by the manufacturer on every unit the retailer orders)
• What a full‑price unit earns the manufacturer: $1.50. The retailer keeps about 25 percent of the $4.00 shelf price and pays $3.00, everyday trade terms take about $0.22, and that leaves $2.78 of Net Sales against a $1.28 cost. That is 54 percent of Net Sales, the top of the normal range for a branded food maker, so this is a strong brand.
• Window: 2 weeks
• Baseline sell‑out: 18,000 units across the 2‑week window
• Reported event ROI: +7 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 the checkout
• 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 the manufacturer's $1.50 regular gross profit per unit = $36,000
• Total promo cost: 42,000 x $0.80 = $33,600
• ROI = ($36,000 - $33,600) / $33,600 = +7 percent

Sell‑out‑corrected ROI (the actual number)

• Sell‑out incremental: 28,000 - 18,000 = 10,000 units
• Incremental GP: 10,000 x $1.50 = $15,000
• Total promo cost: $33,600 (same as before; the discount applied to all 42,000 ordered units)
• ROI = ($15,000 - $33,600) / $33,600 = -55 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 checkout rather than per unit ordered, so the 14,000 units bought ahead no longer earn the discount. Re‑cost this same event that way: the discount runs only on the 28,000 units shoppers bought, the cost falls to $22,400, and the return rises from -55 percent to -33 percent, about 22 points better. The margin transfer to the retailer is gone. The event still loses money, though, because a 20 percent cut on this brand buys only 10,000 extra units, and changing how it is funded leaves that number where it is. The depth is the next thing to fix.

Closing the forward‑buy gap is one of the highest‑return moves available for cutting waste in TPO, alongside reducing subsidized base. Five actions, in roughly the order to try them.

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. Two mechanics apply this principle. Scan‑back pays per unit scanned at the checkout. Bill‑back pays after sell‑out has been verified. 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 takes away the ability to forward‑buy, and it changes nothing about what the shopper sees.

Switch from off‑invoice to scan‑back funding

Off‑invoice discounts pay per unit ordered. Scan‑back pays per unit scanned at the checkout. The change is a small administrative one. The manufacturer's accounts‑payable team simply pays on a different trigger: units scanned instead of units ordered. The result is a higher ROI on the same total trade spend, because the forward‑buy margin transfer disappears by design. How much higher depends on how much the retailer was buying ahead. On this lesson's planning illustration (the How the Funding Method Changes ROI card later in this lesson, not a measured finding) it is about 15 percentage points.

Track the gap between sell‑in and sell‑out as a standard KPI

Add that gap to the monthly governance dashboard. Flag any event where sell‑in exceeds sell‑out by more than 15 percent during the promotion, and investigate it. The threshold catches the retailers who forward‑buy as a matter of course. Having it on the dashboard makes acting on them routine, rather than blaming them after the event review.

Build forward‑buy thresholds into trade terms

The cleanest long‑term fix is contractual. Trade terms can set a maximum stock build during promotional periods. The consequences range from taking a rebate back to losing the next promotional slot. Putting it in the contract takes the forward‑buy decision out of the negotiation on each event and makes it part of the standing relationship.