Doctor and Chemist List Cleanup: A 10-Step Checklist for Pharma Teams

A customer master is an approved directory of professional contacts and businesses relevant to field operations. It is not a prescription database.

Incorrect entries can create unnecessary travel, duplicate call plans, wrong-party orders, and disputes about territory coverage. A useful record should answer three questions: who is the customer, where can they be found, and who is responsible for the next action?

If those answers are uncertain, adding more fields will not fix the underlying problem.

Assign a company administrator or manager as master-data owner. Collect current territory sheets, approved customer lists, and legitimate correction requests.

Record each file's source and date; the newest spreadsheet is not automatically the most accurate. Keep a controlled backup and create a working review copy.

Define who may propose changes, who checks them, and who authorises territory transfers. If every MR independently edits the final master, the same inconsistencies will return.

Do not place every contact in one unlabelled list. Doctors, chemists, and stockists have different purposes in the field workflow.

Use a consistent customer-type field with permitted values such as Doctor, Chemist, and Stockist. Avoid switching between labels such as Retailer, Pharmacy, Chemist Shop, and Party for the same type.

If a business serves more than one role, document the relationship rather than silently treating it as interchangeable with a doctor's practice.

For doctors, consider verified name, speciality, qualification where relevant, area, practice address, and an appropriate business contact. For chemists, prioritise business name, locality, address, and authorised contact details.

Stockists may also require a business email. Use consistent spellings for areas and states.

Preserve the professional's preferred name. Mark uncertain values for review instead of guessing.

An empty phone field is better than an invented number. Do not collect patient identities, diagnoses, prescription details, or unrelated family information just because a spreadsheet has spare columns.

Begin with exact matches on customer type, normalised name, and area. Then manually review similar records. "Dr R K Sharma, Civil Lines" and "Dr Raj Kumar Sharma, Civil Lines" might be one person, but the name alone is not proof.

Two chemists can also share a trading name while operating at different addresses. Use a review log with suspected pair, evidence, decision, and reviewer.

Choose Same Customer, Different Customer, or Needs Verification. A shared clinic reception number does not prove two doctors are identical.

Microsoft's guidance on business-data platforms distinguishes duplicate detection from merging. Do not assume an import tool will safely consolidate histories or relationships.

Decide whether each approved record belongs to a particular MR or is shared across the company. Record the current owner, reassignment date, and approving manager.

Make these decisions before generating the next weekly call plan. For example, an MR moves from Prayagraj North to South.

If the transfer list is unclear, both representatives may plan the same clinic while other customers are missed. Verify how your software handles assignments and historical records; changing a login is not necessarily a complete data transfer.

Prioritise records with planned calls, active commercial activity, or known address changes. Ask the authorised team member to confirm clinic or shop name, locality, and operating location through appropriate business channels.

Record when and how details were checked. If the address remains uncertain, mark it Pending Verification rather than pretending it is confirmed.

Do not send unsolicited mass messages simply to discover which phone numbers work.

MRs should be able to suggest genuine new customers without automatically making every submission authoritative. Ask for enough information to identify the customer, check existing records, and determine territory ownership.

The released Doctors Detailing Customer List lets MRs submit doctor, chemist, and stockist records for company-admin review. Administrators can approve, reject, or edit pending requests.

Approval is a workflow decision, not independent proof that a qualification, phone number, or address is correct. A company may set a daily review target for pending requests.

That is a recommended management practice, not a guaranteed app response time.

Download the sample template and map columns before uploading hundreds of rows. Check the category, area, and ownership scope.

Begin with a small validated batch and inspect the results. Doctors Detailing supports Excel and CSV customer-list uploads, category selection, and a preview of import-ready rows.

The original spreadsheet is parsed in the browser; normalised fields are submitted. Company admins can use company-shared or MR-specific scope, while MR submissions require approval.

The import skips records conflicting with stored uniqueness constraints. It does not promise fuzzy matching or automatic merging of customer histories.

Resolve ambiguous duplicates before upload.

Ask an experienced MR and a new MR to find the same doctor and chemist on a phone. Search with at least two letters, inspect the area, open the details, and confirm the assigned scope.

Test using ordinary field connectivity. A successful import is not enough if similarly named customers are difficult to distinguish.

Correct the source data instead of adding decorative labels. Check the Call Planner separately; an imported contact should not be assumed to become an automatically scheduled visit.

For chemist POB, verify the selected party and applicable rates within the relevant workflow. Do not assume customer lists, price lists, and POB product masters are fully synchronised.

A clean directory deteriorates when nobody owns corrections. Reserve fifteen minutes weekly to review new submissions, suspected duplicates, relocated clinics, closed shops, and changed assignments.

Keep a simple exception log: issue, owner, next action, and resolution date. Each month, sample records from different territories to check category, location, and ownership.

Correct or retire stale data according to company policy. Consistent small reviews are more sustainable than a single annual cleanup.

Imagine 300 rows: 180 doctors, 90 chemists, and 30 stockists. A manager flags 18 possible duplicates, 12 uncertain addresses, and nine unclear assignments.

These are illustrative figures, not measured results from any customer. Review finds eight confirmed duplicate pairs, six genuinely different customers, and four unresolved cases.

The manager corrects confirmed errors in the working master without destroying necessary history. Address checks and ownership decisions are assigned to responsible team members.

Only approved rows are uploaded first. Two MRs test search and customer selection, after which the remaining validated records are added.

This demonstrates a controlled process, not a promise of increased sales or prescriptions.

Track the share of records with a confirmed owner, unresolved duplicate candidates, age of pending approval requests, and share of priority addresses recently verified. Define the denominator for every percentage.

If 270 of 300 records have a confirmed owner, ownership completeness is 90%. That describes directory quality, not call coverage or sales performance.

Do not reward representatives simply for adding more names.

A doctor directory may contain personal data. Limit collection to legitimate business needs, restrict access by role, and maintain correction and retention procedures.

India's Digital Personal Data Protection Act, 2023 and the Rules notified in November 2025 have phased commencement arrangements. Check current government notifications and seek qualified advice for legal compliance.

The Department of Pharmaceuticals also maintains UCPMP 2024 and a September 2025 amendment on pharmaceutical marketing practices. Promotional compliance is separate from customer-master maintenance.

Neither a clean directory nor an app login authorises inappropriate promotion or patient-level data collection.

How often should a pharma doctor list be updated? Review new requests weekly and recheck high-priority accounts when changes arise.

Use monthly sampling and adjust the frequency to territory turnover. There is no universal schedule for every company.

Can Excel remove duplicate doctor names automatically? Excel can flag matches, but similar names do not prove identical people.

A human reviewer should decide ambiguous cases before consolidation or deletion. Does Doctors Detailing automatically merge customer records?

No general-purpose merge should be assumed. The released Customer List supports imports, search, role-based scope, and MR-submission approvals.

Import conflict handling is not the same as merging records. What happens if an MR adds the wrong clinic?

Ask the company admin to review and correct the entry using available customer-management controls. Check any affected plans or orders separately, and document the correction.

Should a doctor and chemist use one record? They serve different field purposes.

Follow the supported customer types and confirm any business relationship separately instead of assuming one record can represent both.

Choose one manager and a manageable batch. Standardise categories, review duplicates, verify important locations, assign ownership, and test the upload with two MRs.

Extend the process only after it works in everyday field conditions. Doctors Detailing provides Customer List import, search, company or MR scope, and an approval workflow for MR submissions.

Those tools support disciplined master-data management, but accuracy remains a company responsibility. Explore the customer-management, call-planning, and POB workflows before a wider rollout. typecheck of earlier writes (static/__dev/weekly-blog-draft-2026-10-26.md): clean