MMDSolutions

Business admin for UK trades

How to Clean Duplicate Customer Records in a Trade CRM

By MMD Solutions Ltd · Published · 5 min read

Two similar customer names are a reason to review, not a reason to press merge. A trade business may work for an organisation, a property manager and several sites at once. This checklist helps you decide whether records are duplicates and check what happens to their linked work.

Confirm that two records represent the same customer before deciding how to reconcile their history.
Confirm that two records represent the same customer before deciding how to reconcile their history. MMD process illustration.

Choose a small set of possible duplicates

Start with a few records that are causing confusion in active work. Note their record IDs, why they were flagged and which jobs depend on them. Similar names, shared phone numbers or the same address can be useful clues, but each can also belong to different people or properties.

Do not launch a bulk merge based only on spelling similarity. For example, two contacts at the same letting agency can represent separate roles. One customer with two properties is also different from two copies of the same customer. Use the relationship structure your business actually needs.

Check identity and relationships first

  • Compare the contact name, organisation and role.
  • Check the appropriate email or phone against the source correspondence.
  • Distinguish billing details from site details.
  • Open associated enquiries, quotes, jobs and relevant notes.
  • Identify conflicting values and their sources.
  • Decide whether the records should stay separate, be linked or be reconciled.

If identity remains uncertain, leave the records separate and record what needs checking. Do not contact the wrong person or disclose one customer’s history to another merely to resolve a suspected duplicate.

Understand what the software will retain

Before merging, read the product’s current instructions for retained fields, activities, links and integration behaviour. Where available, use an appropriate export or backup and test with non-production examples. An exported customer CSV is useful evidence of field values, but is not necessarily a restorable backup of all documents and relationships.

HubSpot documents combining record history and associations while retaining most property values, with product-specific exceptions. It also states that merged records cannot be unmerged. Do not assume that another CRM follows the same rules or that deleting the duplicate reverses a merge.

An illustrative cleanup decision

“Records C104 and C209 appear to be the same returning customer. C104 contains the active job and old phone number; C209 contains a recently confirmed phone number. Reviewer checks the source message and linked records, then records which values must survive before using the software’s supported reconciliation process.”

By contrast, “Agency office” and “Property manager” may need to remain separate linked contacts. The correct result is an understandable customer history, not the smallest possible number of records.

Check the result and the cause

  1. Confirm the intended customer record opens correctly.
  2. Check linked active jobs, proposals, tasks and notes.
  3. Verify the intended contact and site details.
  4. Review connected systems for unexpected duplicates or missing links.
  5. Record what changed and who checked it.

Then ask how the duplicate was created: another CSV import, a form creating contacts, a different email address or manual entry without searching. Use an existing-customer selection or supported matching rule where appropriate. Avoid making a new record every time the same customer starts a different job.

Download the duplicate-review worksheet

Download the record-review log (CSV). It is a review aid, not an automatic matching or deletion tool. Restrict access to real customer information and use fictional examples when asking someone else to help.

If your system does not support safe merging, ask its support team about the supported alternative before changing live records. MMD can discuss the administrative handover around records; this article does not claim MMD Tracker offers a merge feature or that every duplicate needs custom software.

Sources and review

Reviewed 24 October 2026. HubSpot: merge behaviour and limitations.

Source material supports the specific examples referenced. The checklists, worksheets and illustrative scenarios are MMD's suggested business-admin processes, not customer results. Product workflows can change; check current documentation for the software you use.

Keep reading

Contact us

Tell us what you need help with. We’ll reply by email to discuss the next step.

We’ll use your details to reply. This won’t subscribe you to marketing.

How we handle your details

Your enquiry is stored securely and may be emailed to our support inbox. Only authorised staff and our hosting and email providers have access. We keep it only as long as needed to respond and meet record-keeping obligations. To ask about access, correction or deletion, email support@mmd-solutions.co.uk. This form does not subscribe you to marketing.

Or email support@mmd-solutions.co.uk

Help shape MMD

Start with a free 15-minute conversation about the admin taking up your evenings. If there is a fit, choose Callback alone or add enquiry, quote and payment follow-up.

Discuss a paid pilot

From £49 for 30 days + £49 standard setup (£98 first payment), before any applicable VAT. Starts on activation. Continuing after day 30 needs your explicit agreement. No obligation to buy or join a mailing list.

Read the pilot details and allowances

Optional analytics

Privacy and offer details

With your analytics permission, MMD also counts completed admin-estimator calculations by day and broad weekly time-saving range. The estimator does not send entered figures, contact details or a visitor identifier. These aggregate counts describe tool use and assumptions, not verified savings. Our hosting provider still processes ordinary request metadata; hashed network counters are used briefly for rate limiting. Google receives the named calculation event. Rejecting analytics keeps this optional measurement off; the calculator still works.

This website is provided by MMD Solutions Ltd, company 17265591, 15 Neptune Court, Vanguard Way, Cardiff CF24 5PJ. Guides are general information. The phone demo is a live, short-lived demonstration. CRM connections require separate setup and are not enabled by the public demo. Browsing or sending an enquiry creates no paid subscription. Prices, service scope and subscription terms must be agreed before purchase. Nothing here limits statutory consumer rights.

Analytics is optional and separate from the research conversation and paid pilot. Using this website or reading these terms does not subscribe you to email marketing. Contact support@mmd-solutions.co.uk with privacy questions.

If you accept, Google Analytics receives information about visits, device and browser types, traffic sources and interactions. We don’t send your name, email address, phone number or enquiry message to analytics. Advertising features are disabled.

GA4 user and event data is retained for up to 14 months; aggregated reports may be kept longer. We remember your choice on this device for six months. You can change it at any time using Pilot & cookies in the footer. Rejecting stops future analytics collection and removes our Google Analytics cookies; it does not erase data already collected.

MMD Solutions Ltd is responsible for this website’s analytics. Google may process data outside the UK. See how Google uses information from this site and Google’s privacy policy. To ask about your data or your privacy rights, email support@mmd-solutions.co.uk. You can also raise a concern with the Information Commissioner’s Office.

The paid pilot lasts 30 days from activation. Callback costs £49; Callback with either Enquiry & quote follow-up or Invoice & payment reminders costs £68; Callback with both additions costs £87. There is one £49 standard setup fee, making the first payment £98, £117 or £136 respectively. Prices are before any applicable VAT. Standard setup covers compatibility checks, standard configuration, message templates, testing and a handover, with up to one hour of setup time. We confirm availability, compatibility, scope and costs before you agree to start. Each addition includes 50 outgoing SMS segments per service month and normal customer replies. Long texts can use more than one segment. We notify you before the limit and pause additional automated messages at the cap. A £10 prepaid top-up for 100 outgoing segments needs your approval; no automatic overage charges. At day 30 you explicitly choose whether to continue at the same monthly price, held for your first three months. After that agreement, the service renews monthly; you can cancel the next renewal through the billing portal or by contacting us. If you do not continue, we agree how to return call handling to its previous setup. Existing customers pay £19/month per addition and one £49 setup fee to configure one or both additions. Custom integrations are scoped and quoted separately, with third-party fees and any maintenance agreed before work starts. Research participation, marketing and analytics are separate choices. Honest feedback is welcome; no positive review is required and the initial conversation carries no obligation to buy. Callback includes up to 20 voicemail messages or 20 processing minutes per service month, whichever is reached first, for one business number. Each message is counted separately and its duration is rounded up to a whole processing minute: a 20-second message uses 1 minute; a 61-second message uses 2. Messages are limited to 2 minutes. Unused allowance does not roll over. We confirm activation and reset dates, and how calls are handled at the limit, before activation. Extra callback usage must be agreed separately; there are no automatic paid top-ups.

 Chat on WhatsApp