Secondary Sales Data: How FMCG Brands Actually Collect It (Without Going Crazy)
Last month I sat with a distributor in Karachi who'd been running 14 salesmen across 2,300 outlets. His secondary sales data? A WhatsApp group. Photos of order books. A clerk typing them into Excel every night until midnight.
He wasn't doing anything wrong. He just didn't know there was another way that actually worked for his business size.
This is the problem with secondary sales data collection in FMCG. Everyone says they want it. Few brands actually get it clean. And the gap between primary sales (what you ship to distributors) and secondary sales (what distributors sell to retailers) is where most growth conversations die.
So here's what I've learned after four years of building Zivni and watching companies in Lahore, Dubai, Muscat, and Manchester try to solve this.
What secondary sales data actually means (and why people get it wrong)
Secondary sales is the movement of stock from your distributor's warehouse to retail outlets. That's it. Not retail offtake (that's tertiary). Not what you invoiced the distributor (that's primary).
Sounds simple. It's not.
The reason it's hard is because your distributor doesn't really care about reporting it accurately. Their incentive is to book primary orders from you and move stock. Whether they tell you that outlet 4471 in Al Quoz bought 12 units of your shampoo or 8 units — they genuinely don't have a strong reason to be precise about it. Unless you make it easy for them and tie something meaningful to the data.
I used to think the problem was technology. Then I realized it's mostly incentive design, and technology just makes the incentive design possible.
The four methods people actually use
There are really only four ways FMCG brands collect secondary sales data. I'll rank them from worst to best based on what I've seen.
1. Distributor self-reporting (Excel/email)
Distributor sends you a sheet at month-end. You import it. You discover later that 31% of the SKU codes don't match yours. You spend the first week of the next month cleaning data instead of acting on it.
This is what 60-ish percent of mid-sized FMCG brands in South Asia and the GCC still do. Honestly, it's better than nothing — but only just.
2. DMS integration
You push your distributors onto a Distributor Management System. Their billing flows into your dashboard. Cleaner data, but you've now made every distributor relationship more complicated, and small distributors hate it.
Works well in markets like UAE and KSA where distributor networks are professionalized. Painful in Tier 2 Pakistani cities. I've watched brands lose three distributors in a quarter trying to enforce DMS adoption.
3. Field rep data capture via SFA
Your rep visits the outlet, takes the order, and the order itself becomes the secondary sales record. This is where field sales apps come in — Zivni, FieldAssist, BeatRoute, all of us solve a version of this.
The magic here: you don't have to ask the distributor for anything. The order data is captured at the point of sale by your own person, with GPS, timestamp, and outlet ID attached. Clean. Verifiable.
4. Hybrid — SFA + DMS reconciliation
The gold standard. Your reps capture orders. Your distributor's billing system confirms what actually got delivered. You reconcile both. Anywhere the numbers don't match, you investigate.
This catches phantom orders, missed deliveries, and the occasional distributor who's selling your product to outlets that aren't on your route plan (yes, this happens more than you'd think).
Tools that matter, and the ones that don't
Here's the thing — most teams overbuy on tooling. You don't need 14 modules. You need three things working properly:
- Order capture at outlet level. Voice entry helps a lot here. We added it because reps in Lahore were skipping order entry on busy market days. Voice cut average order-taking time from 94 seconds to about 22.
- Outlet master data that's actually maintained. Half the secondary sales reporting problems I see come from messy outlet IDs. Same shop entered three times under three names. Fix this first or nothing else matters.
- A dashboard your sales head will actually open on Monday morning. If it takes more than two clicks to see SKU-wise secondary sales by territory, no one uses it.
Things you probably don't need yet: AI forecasting, fancy BI cubes, predictive churn models for retailers. Get the basic data right for six months first.
Best practices that took me too long to learn
A few things I wish someone had told me before we started selling to FMCG brands seriously:
Don't let reps edit submitted orders. The moment editing is allowed, your secondary sales data becomes negotiable. We made this mistake in our v1 and a customer in Sharjah caught a rep changing yesterday's orders to hit weekly targets.
Tie data quality to commission. If reps know that incomplete outlet visits or skipped SKU checks affect their incentive, the data gets clean fast. Faster than any training program.
Reconcile weekly, not monthly. Monthly reconciliation means problems compound for 30 days before anyone notices. Weekly catches the distributor who's been short-shipping or the rep who's been parking the van at one outlet and faking visits.
Accept that your data will never be 100%. Aim for 92-95% accuracy on secondary sales reporting and you're ahead of almost everyone in the FMCG space. The brands chasing 99.9% burn out their teams and still don't get there.
And look, if you're still running this on Excel and WhatsApp — you're not behind because you're lazy. You're behind because the tools that existed five years ago genuinely weren't built for how distribution works in Karachi or Riyadh or Birmingham corner shops. They are now.
The distributor I mentioned at the start? He's six weeks into using Zivni. His clerk goes home at 7pm now. And he found out two of his "top" outlets hadn't been visited in 11 days.
That's usually what happens once you actually see the data.