How to Track Distributor Secondary Sales in Real Time (Without Chasing WhatsApp Screenshots)

By Sufyan · 2026-08-05 · 5 min read

Last Tuesday I got on a call with a sales head at a mid-sized snacks brand in Karachi. He had 14 WhatsApp groups open. Fourteen. Each one was a distributor sending him screenshots of Excel sheets showing yesterday's secondary sales.

He told me he spends the first 90 minutes of every morning copy-pasting numbers into a master sheet. His RSM in Lahore does the same. So does the guy in Multan. That's roughly 22 hours a week across the team just moving data from screenshots into spreadsheets.

And here's the kicker — by the time the numbers land in his dashboard, they're already 18 hours old. Sometimes older. He's making Monday decisions on Friday data.

If you're reading this, you probably know exactly what I'm talking about.

Why Secondary Sales Data Is So Hard to Get

Primary sales are easy. You invoice the distributor, the number lands in your ERP, done. The problem starts the moment stock leaves the distributor's warehouse.

Secondary sales — what the distributor actually sells to retailers — is where visibility falls off a cliff. Most brands rely on one of three things:

  1. Distributor claims (submitted monthly, usually inflated to hit schemes)
  2. WhatsApp screenshots from the distributor's back-office guy
  3. A shared Google Sheet nobody updates on time

None of these give you real-time secondary sales tracking. And honestly, I used to think this was a technology problem. I was wrong. It's mostly a workflow problem — the tech is the easy part.

Distributors don't hide data because they're evil. They hide data because giving it to you creates work for them, and sometimes it exposes stock movement they'd rather keep fuzzy (dead SKUs, scheme abuse, that kind of thing). So any system you put in has to make their life easier, not harder. Otherwise it dies in month two.

What Real-Time Actually Looks Like on the Ground

Let me describe what a working setup looks like. This is roughly what we've built into Zivni, but the principles apply whether you use us, FieldAssist, BeatRoute, or something you cobble together yourself.

The field rep visits an outlet. Not the distributor — the actual kiryana store, supermarket, or pharmacy. He opens the app, picks the outlet from his beat, and books the order right there. Voice entry if he's in a hurry (this alone saves us reps about 40 seconds per order). The order syncs to the distributor's DMS in near real-time.

At the distributor end, their billing software picks up the order, generates the invoice, and the moment stock gets dispatched, that number becomes secondary sales data. Live. No screenshots.

But here's where most implementations fail: the distributor's DMS and your field app have to actually talk to each other. In Pakistan and the GCC, distributors run on maybe 30 different DMS platforms — SAP Business One, Candela, Focus, custom stuff built in 2011 by someone's cousin. If your field sales tool can't integrate with whatever they're running, you're stuck back at screenshots.

So the checklist I'd actually give you:

That last one is underrated. We spent about six months on our distributor portal before I realized the distributors we onboarded fastest were the ones who saw it as their tool — for stock aging, scheme reconciliation, rep productivity — not just a spy cam for the brand.

The Trust Problem Nobody Talks About

Here's the thing. When you tell a distributor "we want real-time secondary sales data," what they hear is "we want to check if you're lying to us."

And sometimes you are checking. That's fair. But if that's the only value they get from the system, they'll sabotage it. Reps will "forget" to sync. Orders will get entered in bulk at 11pm. Outlets will mysteriously all be within 5 meters of the distributor's office.

What's worked for the brands we work with in Dubai, Riyadh, and Lahore is flipping the pitch. Instead of "give us your data," it's "here's a tool that shows you which of your reps is actually productive, which outlets haven't been visited in 21 days, and which SKUs are sitting dead in your warehouse." The secondary sales visibility becomes a byproduct, not the pitch.

One distributor in Sharjah told me the outlet-not-visited report alone was worth the whole system to him. He'd been paying two reps for eight months who were basically ghosts. He found out in week three.

A Few Practical Things I'd Do This Month

If you're stuck in WhatsApp-screenshot hell right now, you don't need to boil the ocean. Start here:

Pick your top 5 distributors by revenue. Not all 40. The top 5. Get them on a proper field sales app with DMS integration. Give it 60 days. Measure how much time your regional managers save on data consolidation, and how much faster you catch stockouts.

Then expand. The distributors ranked 6-20 will follow when they see the top 5 getting better service, faster replenishment, and fewer arguments about claims.

And stop accepting Excel sheets over WhatsApp. I know it feels rude to say no. But every screenshot you accept is a vote for the old system to keep existing.

What's the actual cost of not knowing what sold yesterday? For most brands I talk to, it's somewhere between 3% and 7% of revenue lost to stockouts, expired stock, and misaligned trade spend. On a $20M business that's real money — enough to pay for the software 40 times over and still have change left for the sales team's Eid bonuses.

Anyway. If you're still copying numbers from screenshots into a master sheet on Monday morning, ask yourself how many more Mondays you want to spend that way.

© 2026 Zivni. All rights reserved.