Merging Duplicate Customer Records

[Makssou]

Hey Shopify community! I'm stuck with a tricky situation and could use some expert advice.

Problem: I've got 50k customer records, but only 22k are unique. This is due to my Cash on Delivery system creating new records for repeat customers.

Goal: Merge these duplicates to have only the 22k unique customers.

What I've tried: Manual merging (way too slow!)

What I need: An automated way to merge records based on phone numbers.

Has anyone dealt with this before? Any tips or tools you'd recommend? I'm even willing to hire an expert if needed.

Thanks in advance for any help!

[PaulMartin]

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.

[Makssou]

Hi,
Thank you for your feedback.

I saw that you're a shopify partner, are you able to create this solution ?

Thank you

[PaulMartin]

Hi Makss,

Unfortunately, no, sorry man. I specialize in Theme development and not app development - I'm still learning it.