Have your say in Community Polls: What was/is your greatest motivation to start your own business?

Re: Merging Duplicate Customer Records

Merging Duplicate Customer Records

Makssou
Visitor
2 0 0

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!

Replies 3 (3)

PaulMartin
Shopify Partner
618 59 146

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.

contact@paulmartinlopez.com
Feel free to email me! 😄
I'm open to conversations or work ʕ •ᴥ•ʔ
Makssou
Visitor
2 0 0

Hi,
Thank you for your feedback.

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

Thank you

PaulMartin
Shopify Partner
618 59 146

Hi Makss,

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

contact@paulmartinlopez.com
Feel free to email me! 😄
I'm open to conversations or work ʕ •ᴥ•ʔ