About Services Tools Blog Contact us

Duplicate Listing Merge

Merges shop rows that are the same business at the same verified address, and merges duplicate lists for the same school, keeping the fullest record.

  • Data Merge & Cleaning
  • Footwear retail
  • Pipeline
  • Productised
  • Local/private
  • 2026

The problem

Imports create two or three entries for one shop, often from a head-office postcode or a second data file. Two entries for the same school split its reviews between them. Neither entry shows the whole picture.

What it does

Only entries that share a postcode confirmed against an official postcode lookup are candidates, and postcodes that a head office repeats across many towns are left out. Within a group, the most complete entry survives and takes any filled details from the others. The rest move to an archive with a note of which entry replaced them. The default run only reports, and for schools the oldest entry is kept.

Outcomes

  • Each confirmed address has one entry, with the phone and website from the thinner entries kept.
  • Head-office postcodes are not merged blindly.
  • The default run produces a plan to review and changes nothing.
  • Removed entries stay in an archive.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Shop duplicates Dry-run

Lantern Yard Shoes #4418 Keeper

18 Lantern Yard, York YO1 8AB

Phone 01632 960184 · Website none · Mon to Sat

Lantern Yard Shoes #4429 Duplicate

18 Lantern Yard, York YO1 8AB

Phone none · Website lanternyard.example · Hours none

Lantern Yard Shoes #5102 Excluded

1 Ledger Court, London EC1A 1HQ

Head office. This postcode is repeated in 14 towns, so it is not a merge candidate.

Sableford Primary

Autumn list Oldest

Opened 12 Sep 2023

42 reviews stay on this list

Spring list Newer

Opened 3 Mar 2025

6 reviews, split from the autumn list

Removed-row archive

Pointers to the survivor
RemovedSurvivorReason
North Quay Shoes #2201 #2194 Duplicate postcode, archived 2 Feb 2026

How it works

  1. Group shops that share a confirmed postcode.
  2. Exclude postcodes that a head office repeats across many towns.
  3. Keep the most complete entry and copy filled details from the others.
  4. Update the street line so it matches the full address.
  5. Archive the rest with a note of the entry that replaced them.
  6. For schools, keep the oldest entry and archive the duplicates.

Pipeline

flowchart LR
  A[Shops] --> B[Postcode]
  B --> C[Group]
  C --> D[Keeper]
  D --> E[Absorb]
  E --> F[Archive]
  G[Lists] --> H[Oldest]