Blog8 min read
Primary vs Secondary Sales Data: Why the “Last Mile” Is the Hardest to Capture in Distribution
By Huzefa Motiwala · Co-Founder & Chief Product Officer
If I only look at primary sales, I can mistake shipments for demand. That’s the core issue. Primary sales show what I sold into the channel. Secondary sales show what distributors sold out to retailers, pharmacies, dealers, or trade buyers.
Here’s the short version:
- Primary sales data = manufacturer to distributor
- Secondary sales data = distributor to retailer or trade customer
- Primary data is easier to track because it sits in my own ERP or billing system
- Secondary data is harder to track because it comes from distributor systems, spreadsheets, and manual reports
- The main risk is simple: strong sell-in can hide weak sell-through
- The result can be excess channel stock, weak forecasts, bad incentive payouts, returns, and expiries
In sectors like pharma, FMCG, agrochemicals, electronics, lubricants, and consumer durables, this gap can shape day-to-day planning. If secondary sales lag primary sales by 10% to 20%+ for weeks, that often points to stock piling up in the channel instead of moving to the market.
FMCG Sales Data Sources | ERP - Primary Sales | DMS - Secondary Sales | SFA - Order Booking Sales?
Quick comparison
Primary vs Secondary Sales Data: Key Differences at a Glance
| Criteria | Primary sales data | Secondary sales data |
|---|---|---|
| What it tracks | Manufacturer shipments to distributors | Distributor sales to retailers or trade buyers |
| Also called | Sell-in | Sell-through / sell-out |
| Where it sits | Brand ERP, invoicing, billing system | Distributor software, Excel, local billing tools |
| Speed | Often near real time | Often delayed |
| Data quality | More standardized | Often messy and uneven |
| Best use | Revenue, supply planning, credit control | Forecasting, inventory checks, incentive design |
| Main risk | Channel stuffing can look like growth | Gaps, delays, and patchy reporting |
So when I want to know what shipped, I look at primary sales. When I want to know what the market actually bought, I need secondary sales. That distributor-to-retailer gap is the last mile - and it’s usually where visibility breaks down first.
1. Primary sales data
Transaction point
Primary sales, also called sell-in, track the first movement of goods from a manufacturer to a distributor, C&F agent, or super-stockist. The sale is recorded when stock is dispatched against a purchase order and invoiced [2][6].
What it shows
The manufacturer creates the source documents, so this data lives inside the brand’s ERP. It feeds revenue reporting, trade margin calculations, and incentive calculations [2][5]. In plain English, this is the easiest sales layer for a brand to record because the paperwork starts on its side.
Decision impact
Primary data shapes production planning, credit limits, and incentives [2][6]. But there’s a catch: primary sales can look strong even when end-market demand isn’t. If a company pushes extra stock into the channel, the numbers go up on paper without matching actual offtake [6].
Visibility stops at the distributor’s warehouse [6][3]. If the gap between primary and secondary sales stays high, that can point to channel stuffing [3]. So while primary sales are useful, they measure outbound shipment, not consumer demand.
The next layer starts where primary data stops: at the distributor’s warehouse.
2. Secondary sales data
Primary sales tell you what shipped out from the manufacturer. Secondary sales tell you something more useful: whether the market actually took it.
Transaction point
Secondary sales - also called sell-out or sell-through - track the movement of goods from a distributor or wholesaler to a retailer or the final point of sale [2][1]. In plain terms, this is the second leg of the channel: stock moving out of distributor inventory and into the retail market.
A simple example helps. A pharma distributor bills a pharmacy. An FMCG wholesaler bills a grocery store. That transaction counts as a secondary sale.
The hard part comes next. That sale usually has to be tracked outside the manufacturer’s own systems.
Visibility value
Secondary sales is the only layer that shows what is actually moving through the channel. Without secondary data, brands can’t tell with confidence whether products are selling through or just sitting in inventory after being sold in [2][1].
That gap matters more than it may seem. On paper, inventory can look like demand. In the market, it may just be stock gathering dust.
That’s why secondary data matters so much - and why standardizing it is such a pain.
Capture complexity
In most cases, secondary sales data sits outside the manufacturer’s ERP. It gets scattered across distributor software, local tools, and spreadsheets [2][7]. That makes cleanup and standardization hard, especially in pharma, FMCG, agrochemicals, electronics, lubricants, and consumer durables.
These sectors often deal with unorganized retail outlets and weak digital point-of-sale coverage. So instead of a clean live feed, brands may get manual reports sent late, patched together, or both. By the time the numbers arrive, the market may already have shifted.
Decision impact
Secondary sales data sits at the center of demand forecasting, incentive design, and replenishment. Without it, brands end up pushing stock into the channel instead of reacting to what retailers are actually selling.
That’s where channel stuffing starts to creep in.
When secondary sell-through trails primary sales, inventory is building up in the channel. And when incentives are tied to distributor purchases instead of secondary offtake, the signal gets distorted. Tie schemes to secondary offtake, not just purchases, and they stay closer to real demand while helping cut returns.
Why Secondary Data Is Harder to Capture Than Primary
Primary data is easier to capture because it stays inside the manufacturer’s own systems. Secondary data is tougher because it has to come in from outside those systems. That’s the basic split between clean primary data and messy secondary data.
Secondary sales data is harder to work with because it sits outside the manufacturer’s ERP. Once goods move through the distributor network, invoicing and billing often happen in a patchwork of local tools like Tally, Marg, Busy, Excel, and other systems that don’t sync neatly with the manufacturer’s ERP [4][7]. So the job isn’t just logging transactions. First, you need a data integration layer. Then you have to reconcile broken-up channel data coming in from different places.
The table below shows the most common capture issues across both data types:
| Capture Challenge | Primary Sales Data | Secondary Sales Data |
|---|---|---|
| System fragmentation | Centralized, company-controlled ERP | Fragmented distributor billing systems such as Tally, Marg, Busy, and Excel |
| SKU & outlet master data | Standardized company master data | Inconsistent SKU names and duplicate or phantom outlet codes |
| Reporting speed | Real time or near real time | Reporting lag that can extend well beyond real time |
| Manual reconciliation | Not typically needed | Common when data is entered or reconciled manually by distributors or field teams |
| Coverage | Full visibility into direct shipments | Uneven visibility across the channel |
| Partner data-sharing barriers | None | High, due to distributor resistance tied to tax or competitive concerns |
This is why secondary data can be more useful for decision-making, while also being much harder to standardize. The next step is to look at where each data type helps most, and where each one has limits.
Pros and Cons of Each Data Type
Each data type has a clear job. And each one has limits. The table below shows where each is strongest and where it falls short.
| Primary Sales Data | Secondary Sales Data | |
|---|---|---|
| Demand visibility | Weak - reflects shipments, not sell-through | Strong - reflects actual sell-through and outlet-level demand |
| Manipulation risk | High - susceptible to channel stuffing | Lower, but not zero |
| Best used for | Revenue recognition, production planning, credit management | Demand forecasting, trade-scheme design, field-force incentives, inventory health |
The main difference isn’t just where the data sits. It’s whether the data reflects shipments or actual demand.
Primary data can make channel inventory buildup easy to miss. On paper, shipments may look healthy. But that doesn’t always mean products are moving off shelves. A steady gap between shipments and sell-through can point to channel stuffing. When distributors take on extra stock just to hit shipment targets, returns and expiries often come next.
That’s why sell-through is usually the better planning signal. Secondary data shows what sold, what outlets are buying, and how much inventory is sitting with distributors. So it gives teams a better base for forecasting, incentive design, and replenishment decisions [5][3].
There is a catch: integration is harder. Secondary data often sits across scattered distributor systems, which means it can show up too late to fix stock problems or incentive issues.
Conclusion
The comparison is simple: primary sales show what shipped. Secondary sales show what the market absorbed.
Primary sales are the cleanest internal signal. But they stop at the distributor. They help with financial reporting and supply planning, and not much past that point in the channel.
That’s why secondary sales matter more for forecasting, incentives, and inventory control. Secondary data is harder to get because it lives outside the manufacturer’s systems. Even so, it’s the best demand signal you have. It shows what’s moving, what’s sitting still, and where the channel is quietly building inventory risk.
The biggest blind spot usually sits in the distributor-to-retailer gap. That’s where visibility tends to fall apart, and where data is least standardized across a distribution network.
Use primary data as your starting point. Then lean on secondary data to judge actual demand. In distribution, the last mile is where demand becomes visible, and also where data capture tends to break first.
FAQs
How much of a gap between primary and secondary sales is a red flag?
A primary-to-secondary sales ratio above 1.3 is usually a red flag. It suggests inventory is being pushed into the channel faster than the market is buying it.
A small gap can happen due to timing or reporting differences. But if that gap stays in place or keeps getting bigger, it may point to distributor overstocking, weaker product pull, or inefficiencies at the territory level.
What data should I collect first to improve secondary sales visibility?
Start by auditing your current data landscape. Figure out which distributors already work with digital systems and which ones still depend on manual reports. The first goal is granular, outlet-level data so you can move away from delayed reporting and get more timely visibility.
A practical place to start is with your field team. Have them log retailer orders during outlet visits, then digitize distributor billing and inventory where you can. If full integration isn’t possible yet, track a few core numbers to build a baseline:
- Lines per call
- Active outlet percentage
- Volume moved by SKU
How often should secondary sales data be updated to be useful?
Ideally, secondary sales data should be updated in real time to support demand forecasting and inventory management.
Weekly or monthly reports bake in a lag. That means teams often make decisions based on market conditions that are already three to six weeks old. When sales are captured digitally at the point of transaction, that same data becomes a daily input for operations. As a result, teams can spot stockouts and underperforming outlets sooner.