Retail Technology Consultant
1 rating and 7 bookings across all services

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.