Distributor scan data: how wholesalers put it to work

Distributors use scan data to answer the one question their own systems can't: what actually sold at retail. A distributor's records stop at the store's back door. Invoices capture sell-in, the cases shipped to each account. Scan data captures sell-through, the units shoppers bought at the register. Most of the value sits in the gap between the two.

Wholesalers and distributors in the independent channel run on long account lists and busy routes, which makes the question of where to spend attention a daily one. Sell-through data gives it a better answer than order history alone.

Sell-in vs. sell-through: the gap that matters

Shipping a case is not selling a case. When sell-in runs ahead of sell-through, product piles up in backrooms and on slow shelves, and it comes back later as returns, expired stock, or a customer who quietly stops ordering. When sell-in lags sell-through, stores run out, and shoppers meet empty racks the distributor never hears about.

A distributor watching both numbers manages inventory across the whole pipeline instead of just pushing cases into it.

Say an account orders ten cases of an item every month like clockwork. Sell-in looks healthy. Scan data shows sell-through of six cases a month, which means the backroom is quietly absorbing four cases every cycle. That pattern ends one of two ways: a large return, or an abrupt stop in orders that looks like lost business but is really overstock catching up. Both are visible months in advance to anyone watching the two numbers together.

Which accounts deserve a rep's time?

Order history ranks accounts by what they buy. Scan data ranks them by what they sell, and the two lists disagree in useful ways. A store with modest orders but a strong rate of sale is an under-ordering account, which is the easiest growth conversation a rep will have all week. A store ordering heavily against weak sell-through is building a problem that lands back on the distributor as returns or churn.

Route time is the scarcest resource a distributor has. Ranking calls by the gap between selling and ordering puts that time where it changes something.

Where else does the data earn its keep?

Distribution voids, first. A void is a store that sells a category well but doesn't carry a given item. Scan data across many stores turns void-finding from guesswork into a target list: the accounts where the category moves and the item is absent.

Catalog decisions, second. Every distributor book accumulates slow items that survive on inertia. Channel-level sell-through shows which of them still move somewhere and which move nowhere, and that makes the cut list defensible instead of a matter of opinion.

Turning numbers into a counter conversation

The strongest use is the least technical. A rep who can stand at a counter and offer a store owner a fact-based reason to stock an item, drawn from how the category moves across stores like theirs, is doing something different from pitching. Store owners hear pitches all day. Evidence about their own channel is rarer.

The same evidence works in reverse, too. When a store owner asks why an item isn't moving, a rep who can compare that store's rate of sale against the channel's has an answer instead of a shrug, and sometimes the honest answer is placement or price rather than the product itself.

NRS Insights publishes a monthly same-store sales report built from POS (point-of-sale) scan data collected across a network of independent retailers running the NRS point-of-sale system. For a distributor, that's a channel-wide view no single route can assemble.