Not sure if there’s an app for this but your best route would be to hire a developer who can create changes on your store’s data via creating a private app. That way you can merge customer data based on phone numbers and as a plus, have a backup on all 50k customer data before the merging begins.
Topic summary
Main issue: A store has ~50k customer records but only ~22k unique due to a Cash on Delivery workflow creating new records for repeat customers. The owner wants an automated way to merge duplicates using phone numbers as the key.
Attempts: Manual merging was tried but is too slow. No off‑the‑shelf app was identified in the thread.
Proposed approach: Hire a developer to build a private app (a custom, store-specific app) to merge customer data by phone number. The suggestion includes backing up all 50k records before running merges.
Follow-up: The store owner asked the commenter to implement the solution. The commenter declined, noting they specialize in theme development rather than app development.
Status/outcome: No solution implemented; discussion remains open. Next step implied is to engage an app developer to create the private app for automated merging and safe data backup.
1 Like