Outlet Master Cleanup: The Dedup + Geo-Tagging Playbook for FMCG India

Every distribution metric you care about — coverage, productive calls, secondary sales by outlet — rests on one unglamorous foundation: the outlet master. And in most FMCG brands, that master is a mess. The same shop appears three times under slightly different names, closed outlets linger, new ones are added inconsistently, and half of them aren't geo-tagged. Build beats and dashboards on that, and every number is quietly wrong.

Cleaning the outlet master is the least exciting and most leveraged thing you can do before — or early in — any distribution-software rollout. Here's the playbook.

Why a dirty master corrupts everything

If "Sharma Stores," "Sharma Store," and "M/s Sharma" are three records for one shop, your outlet count is inflated, your coverage percentage is fiction, and your secondary sales are split across phantom outlets. If closed shops stay on the list, reps "cover" outlets that don't exist. If outlets aren't geo-tagged, you can't verify visits or optimise routes. The master is the spine of distribution data; a crooked spine bends everything attached to it.

Step 1 — Deduplicate

Consolidate duplicate records into one per real outlet. Match on name similarity, address, phone, and proximity, and merge — carefully preserving the transaction history. This alone usually shrinks an inflated outlet base by a meaningful percentage and instantly makes coverage numbers honest.

Step 2 — Purge and flag

Mark closed and inactive outlets so they drop out of coverage targets and beats. An outlet that hasn't ordered in months is either closed or a real coverage gap — either way, flagging it surfaces the truth.

Step 3 — Geo-tag every active outlet

Capture each outlet's GPS location, ideally during a rep visit. Geo-tagging is what makes GPS-verified visits and route optimisation possible — without it, you can't confirm a rep was actually at the shop or sequence a beat efficiently.

Step 4 — Enforce clean creation going forward

A one-time cleanup decays if new outlets are added sloppily. Enforce structured outlet creation — required fields, dedup checks at entry, mandatory geo-tag — so the master stays clean. This is part of why disciplined distributor and outlet onboarding matters.

What clean masters unlock

• Honest coverage — a real denominator, so coverage % means something
• Trustworthy secondary sales — sell-through attributed to real, unique outlets
• Verifiable visits — geo-tags make GPS verification and anti-spoofing work
• Efficient beats — route optimisation needs accurate locations
• Clean scheme tracking — outlet-level redemption requires unique outlets

The takeaway

You can buy the best distribution platform on the market and still get garbage analytics if it runs on a dirty outlet master. Dedup, purge, geo-tag, and enforce clean creation — it's tedious, it's foundational, and it's the difference between a dashboard you trust and one you don't.

For a free outlet-master audit or to see structured outlet creation in the field app, book a walkthrough.