Customer records: 8 checks before you merge with Raja Jeevan Kumar Maduri

Customer records: 8 checks before you merge

Retail Technology Consultant

1 rating and 7 bookings across all services

profile
Digital Product

About this product

The same shopper exists three times: POS, online store, loyalty. This sheet is the eight-check habit for merging duplicates without losing points, credit or history.

Fix 1 - Define what same person means: phones can be shared or recycled, so confirm with a second signal.

Fix 2 - Set golden-record rules per field: verified beats typed; recency is a signal, not authority.

Fix 3 - Export everything first; a merge you cannot roll back is a bet.

Fix 4 - Dry-run on a few hundred records and read proposed merges by hand.

Fix 5 - Trace what follows the survivor: points, credit, open orders, warranties, history.

Fix 6 - Keep a merge audit trail for at least a full returns cycle.

Fix 7 - Block new duplicates at entry: required phone, search before create, no raw-signup incentives.

Fix 8 - Set a standing dedupe cadence: monthly duplicate report, weekly created-count.

Red flags: merges on name matching alone; no export before the job; points or credit changing after a cleanup with no report; signup incentives that reward duplicates; a one-time cleanup with no monthly report.

Planning material, not legal or data-protection advice. Thresholds are proposed starting points.

Want a second pair of eyes on your customer data? Book an advisory conversation through this profile. Bring only synthetic or anonymised examples, never identifiable customer data.

FREE