Start here.
Combine customer entries when you can verify they describe the same person or business and your tool can retain the details your team needs. Keep separate people, addresses or jobs clear. Try uncertain cases with sample data before changing live records.
- Check what each entry represents before deciding whether it is a duplicate.
- Keep the contact details and work history people use in the next job.
- Review where a second entry is created so the same problem does not return.
Find out what the duplicate is costing your team
Imagine an appliance repair business. A returning customer fills out the website form with a new email address. The office creates another record, and the technician opens it without seeing the notes from the last visit. Meanwhile, two other people on the list use the same property manager’s number. Combining those two would make the list shorter and the work harder.
Take a pair of records staff have had to sort out recently. Ask what went wrong in the job itself. Did someone miss an appointment note, send a message twice, or look up the wrong address? That tells you what needs to be right when the next person opens the record.
Check what each record represents
An entry might describe a person, a company, a service address or a particular job. Check the difference before combining anything. One customer can have two service addresses. Two customers can use the same receptionist or have the same name.
Give staff enough information to review a possible match without guessing. Compare the known details and the work history. For an uncertain case, leave both records in place and say who will confirm the answer. A match suggested by a tool is a reason to look.
Decide which details must survive
For a confirmed duplicate, look at the open jobs and the notes your staff need before choosing which details to keep. In the repair business, the current contact may be correct in the new entry and the warranty visit recorded in the old one. The latest entry alone cannot answer both questions.
Ask how the tool handles linked jobs, notes and files. If the contact is also used by a mailing list or an invoice system, check what changes there. Ask whether a merge can be undone and what a recovery would restore. Use sample records before trying a group of live merges.
Give staff three cases to try
Run these cases with the person who makes appointments and the person who carries out the work. Have them look for an open job, choose the correct contact and find the relevant notes. If they cannot finish those tasks after the change, write down what is missing and ask the supplier to show how it would be handled.
| What staff see | Decision to try | Check afterwards |
|---|---|---|
| A returning customer confirms a new email address | Combine the duplicate person entries if your tool can retain the history. | A technician can find the old visit and the office can use the current email. |
| Two customers share a property manager’s phone number | Keep the customer entries separate and record the shared contact role. | Staff can reach the manager without mixing either customer’s jobs. |
| One customer has appliances at two addresses | Keep the addresses distinct under the customer where the tool supports it. | The work order still points the technician to the right location. |
Fix the step that keeps making copies
Look at where the second entry came from. If the website starts a new enquiry, staff may need an easy way to attach it to an existing customer. If people type the same details into two tools, agree which tool supplies them and what happens when the details change.
Start with one route that creates repeat work. Try a search before staff add a new contact, or have the form flag likely matches for someone to review. Ask staff whether they can find the right record without interrupting the customer. Check both the duplicates they caught and the distinct people they kept separate.
Bring a few sample pairs to your supplier
Use examples that show what your team needs to decide.
- A confirmed match
- Which details and linked jobs must stay visible after combining the entries?
- A lookalike
- Which clue tells staff these are different customers even though some details match?
- A repeat enquiry
- How should staff link it to the right customer without losing the new request?
Planning something with a similar workflow?
Discuss your project with usA couple of common questions.
Should we merge contacts just because they share a phone number?
Check who uses the number and what each entry describes. A shared office or property manager can be associated with more than one customer. Keep the entries separate if they describe different people or businesses.
Which record should we keep when we combine two entries?
Choose based on the verified information and the work attached to each entry. Check what your tool carries across, including open jobs, notes and files, before choosing.
How do we stop the duplicates coming back?
Find where the second entry is created. Give staff an easy way to find a returning customer or review a suggested match before opening a new record.