Book a consult

Loading scheduler…

CPG glossary

Consumption vs shipment data in CPG, explained

What consumption and shipment data are

Shipment data is what you shipped to a retailer or distributor; consumption data is what shoppers actually bought at the register. They are two different events, often weeks apart, and confusing them is the fastest way to misread a quarter. I learned that the hard way pulling Walmart Retail Link against our own shipment ledger and watching the two numbers refuse to reconcile.

Shipment is also called sell-in. It is the brand's revenue event: a case leaves your dock, an invoice goes out. Consumption is sell-through, also called POS, the data SPINS and Circana sell you. It is the demand signal: a unit crosses a scanner at Sprouts or Kroger. When your VP asks "how are we doing," sell-in answers what you booked and sell-through answers what the market wanted. If you typed "pos vs shipment" because the two charts told different stories, that is the whole problem in one search.

Why the two numbers diverge

In a frictionless world, every case you ship eventually gets scanned and the two lines track. They never do, because inventory sits in the middle. Every unit you shipped that has not yet sold is parked in a retailer DC, a distributor warehouse, or a store back room. Shipment runs ahead of consumption when retailers build stock, and behind it when they draw stock down.

The gap has a name when it spikes on purpose: forward buy. A retailer that knows a price increase or a deal deadline is coming will load up, so your shipment data balloons for a few weeks while consumption sits flat. The pull-forward feels like growth and is actually borrowed volume. The payback comes later as a shipment trough while the retailer sells down what it stockpiled. Watch sell-in alone through that window and you will forecast a boom into a bust.

PeriodShipped (sell-in)Sold (consumption)Pipeline change
Wk 110,00010,0000
Wk 222,00010,500+11,500
Wk 34,00010,200-6,200
Wk 43,5009,800-6,300
Total39,50040,500-1,000

The brand shipped 39,500 and shoppers bought 40,500, so the pipeline drew down 1,000 units net across the month. But week 2 looks like a 120% surge and weeks 3 and 4 look like a collapse. None of that is demand. It is a forward buy filling and emptying the pipeline. Demand was flat near 10,000 a week the whole time, and only consumption shows it.

Which number to trust, and when

Use the one that matches the question. For revenue, margin, and what finance booked, shipment is the truth because that is the invoiced event. For demand, market share, velocity, and whether a promotion actually moved units, consumption is the truth because it is the only signal that strips out pipeline noise.

The reconciliation rule I lived by: over a long enough window, cumulative shipment minus cumulative consumption equals the change in pipeline inventory. If that identity drifts and your inventory did not actually move, something is wrong, usually a returns adjustment, a data lag, or a SKU mapping break between your shipment system and the syndicated feed. SPINS and Circana both report consumption, and the difference between syndicated and panel sources is yet another reason two "consumption" numbers can disagree before you have even opened the shipment ledger.

The trap that bites demand planners hardest is forecasting on shipment because it arrives first and is your own data. It is also the most distorted, since every retailer inventory decision is baked into it. Forecast on consumption, then layer in known pipeline moves (a forward buy, a new distribution gain, a discontinuation) to translate demand back into the shipments you will actually book.

Where Scout fits

The reconciliation lives in two systems that almost never talk: your shipment ledger and a SPINS or Circana POS export. Scout connects them, so you can lay sell-in next to sell-through and see the pipeline move instead of guessing at it. Scout measures and analyzes that gap. It is not your ERP, it does not generate the shipment invoice, and it does not run your S&OP cycle.

The short version

  • Shipment (sell-in) is what you shipped and invoiced; consumption (sell-through, POS) is what shoppers actually bought. They are different events weeks apart.
  • The gap between them is pipeline inventory, and it spikes on a forward buy, so shipment alone will read borrowed volume as real growth.
  • Trust shipment for revenue and margin, consumption for demand and velocity, and reconcile them with one rule: cumulative shipment minus consumption equals the change in inventory.
See your CPG data answer questions in plain English — book a Scout demo

Want the rest of the CPG analyst's glossary?

Drop your email and we'll send the full set of CPG and retail-data definitions as one reference sheet.