Solved

Can you merge duplicate customer accounts on Shopify?

makers18
Excursionist
21 0 214

Has there been any updates or progress on the ability to MERGE CUSTOMER ACCOUNTS that are duplicates?  We have a ton and we basically began online sales in early March.  This is really needed to keep up with past orders and preferences.  We also offer rewards for our repeat customers and this system has really made tracking sales difficult.  

 

 

Accepted Solution (1)

ekeshen
Shopify Staff (Retired)
12 8 10

This is an accepted solution.

You can now merge customer profiles. Thanks to your advocacy and feedback - you can merge customer profiles to ensure you have the most accurate view of your customers.

Identify duplicated customer profiles with the same name, phone number, email address, or another overlapping attribute then merge customers to make sure you maintain quality customer data.

To merge customer profiles:

  1. Search for a duplicate customer in the Customers page of your Shopify admin
  2. Click on the customer’s name and review their customer profile data to identify what data needs to be kept or removed. 
  3. Click into one of the duplicate profiles 
  4. On the bottom right of the profile you will see a heading called, Customer Data
  5. Click the button in that section that says Merge customer
  6. Search for the customer profile you intend to merge. 
  7. Complete the merge steps. 

 

Keep in mind, not every customer profile can be merged. There are some limitations for merging profiles that you can review in the Shopify Help Center.

We know this has taken time, and we appreciate your patience. We are excited to be launching this improvement for you today and look forward to hearing your feedback so we can keep improving your experience maintaining customer data in Shopify.  

 

To learn more visit the Shopify Help Center or the Community Blog.

View solution in original post

Replies 415 (415)

edcorusa
Excursionist
21 0 26

Yes, it would be very helpful to merge customer data. I have been using Shopify for just over six months and it seems they are not willing to correct issues or add features their customers want or need.

BrandyFS
Tourist
4 0 3

I'm still trying to delete the duplicate customer file on mine. I changed all his orders to the correct account, but it still shows he has 8 past orders on the incorrect account even though I click on the file and it says the customer has no orders. Therefore, the incorrect file will not delete. It is super frustrating and I have to hope he doesn't use the wrong file to order again next month. 

flagsaflying
Tourist
3 0 3

We would also love to see this feature added to eliminate duplicate accounts. I know there are ways to move orders however you can't then delete the one account that you've moved the order off of so it stinks either way as you still have a duplicate and it's likely that the wrong account could be used again in the future. 

herhappyplace
Visitor
1 0 1

How many years is this issue going to go on? It seems it should be an easy fix. It is very common in other systems. There is no sure way to stop it from happening when you have online and in store complicated with new staff. It is super frustrating!!!

NorthArrow
Visitor
2 0 1

@Shopify C'mon guys, this should be a basic feature. 

JAYTAY
Tourist
9 0 12

@Shopify Please can you tell us when this is going to be fixed or implemented? We have thousands of customers that need to be merged. This doesn't make the customer experience very helpful for ecomm owners. 

jeffbryght
Visitor
1 0 2

Adding our voice to this too.  This is desperately needed as it significantly impacts our customer experience and is a huge burden on our customer support efforts.

tkshajanes
Visitor
1 0 2

This is still needed BADLY!!!  Please help get this fixed, it seems so simple.

FionaDillon
Excursionist
18 0 9

Are there any updates from Shopify on this?

This happens for us when a customer updates or changes their email address. They email us asking us to update their account email address but both emails (old and new) have orders placed on them so we can't merge the accounts. 

We can merge profiles/email addresses on Klaviyo, it would be so helpful and great for customers if we could do this on Shopify too - it's really frustrating for customers. 

Paul_vd_Dool
Shopify Partner
107 6 95

Shopify is busy on a solution.

A few weeks ago I got asked if I would like to join a beta program for the "Customer Profile Merge" feature. I still have to get more info though.

 

It's coming.

Doppelganger - Managing duplicate user accounts
CDRess
Shopify Partner
26 0 24
That sounds promising!
BrandyFS
Tourist
4 0 3

Thank goodness. I have yet another customer asking me to help them merge their logins. I hope it comes soon!

PaulNewton
Shopify Partner
6274 573 1319

If you look around at the recent releases notice there is now going to be B2B customer accounts and all that implies,  so yeah there is movement just no timelines or public details.

 

So merchants should still pursue solutions that are available now that fit their situation.

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


LeFoCo
Tourist
8 0 12

"So merchants should still pursue solutions that are available now that fit their situation."

 

Please, let us know what is now available to do this.

LEFoCo, a Squishmallow and plush only extension of learningexpress.com/foco.
LeFoCo
Tourist
8 0 12

Paul,  

That's awesome!  If you have a mailing list for when your Doppelganger upcoming features are released, please add me to it.

~Steve

LEFoCo, a Squishmallow and plush only extension of learningexpress.com/foco.

evanhill
Tourist
4 0 1

No brainer value add for all Shopify customers. I don't see any downside or complications from adding the feature. It's a pain point that needs fixing 

CandiGraves13
Visitor
2 0 3

Replying as this is a needed service for our company as well.  I'm unsure how it's happening.  It's possible customers forget their email login and simply create a new account, sometimes they forget to login to complete their purchases.  This feature is needed.

Candi Graves
Marketing Director | NormaLyte

Steven_Holowien
Excursionist
11 0 19

I vote for needing a merge function as well.  Desperately needed indeed.

 

denisezucco
Visitor
1 0 1

How has this still not happened?  This thread started in 2020.  That is 2 years ago and there have been over 25K views of this issue.

MudandHoneyCF
Excursionist
27 0 49

Exactly!! Two years of asking for a simple feature!!

PaulNewton
Shopify Partner
6274 573 1319

 This thread started in 2020.  That is 2 years ago and 


Yup, issues older than that this is just the biggest collection.

 there have been over 25K views of this issue.


For perspective about features remember shopify is hosts millions of stores.

25k "views" is not a petition , it's barely a blip .

Always make direct feature requests to shopify support, then loudly and clearly let other merchants know you have and that they should too.

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


JAYTAY
Tourist
9 0 12

Ok "genius"....as if it that hasn't been done already...by many of us.  

ilupo
Visitor
1 0 1

Yes this would be extremely useful! 

FlirtyPineapple
Tourist
4 0 6

Merging profiles is imperative for retaining customer loyalty. What's the point of showing how many orders someone has made when they may have different profiles? 

 

For us, it happens most when a customer enters their information incorrectly. Of course, I can revise it on that order, but now the customers profile is inaccurate for the number of orders they made. It may seem small, but when building customer loyalty, it is extremely imperative.

Cathyem
Tourist
7 0 3

Sometimes customers make a new account or checkout as a guest because they might have forgotten their login info etc. This is a huge pain when people are collecting points on our loyalty scheme.  Merging customers is a must!

aahlswede
Visitor
1 0 0

We also experience this problem. 

dreamglow
Visitor
1 0 2

This should be a HIGH priority for Shopify!!!

Tough_Traveler
Excursionist
17 0 72
It is now possible to remove customers from orders and replace them with
the correct customer. This mostly does what merging would do.
Biordi
Tourist
6 0 7

Can you show me how to remove a customer from an order?

Biordi
Tourist
6 0 7

Forget it! I just figured it out. Yay!

Katdrawdy
Tourist
6 0 5

So many duplicate customers!  For all the reasons already mentioned here but now that we are using Shopify payments, it seems like Shopify is automatically adding a new customer EACH TIME they use a credit card with a name attached!  For instance "Ms Smith" creates an account & becomes a customer. Then she shops in-store with a credit card that has her name on it and another "Ms Smith" is automatically created by Shopify.  Ms Smith comes in a week later and uses that same credit card and yet ANOTHER customer account is created....and on and on until poor Ms Smith has a zillion accounts, one for each time she shops.  ugh! 

David321
Visitor
2 0 0

The only thing I can think of is that this exact scenario creates "tens of millions of customers" using Shopify businesses.  Sounds like a great marketing tool to increase their share price.

khard
Shopify Partner
22 1 8

Shopify just launched the new Merge Customer feature!

https://changelog.shopify.com/posts/merge-customer-profiles

 

AllStitch
Excursionist
17 0 34

so far it seems worthless. I can only merge 2 customers without any orders placed

see issues like

Customer has a credit card and can’t be merged.

Katdrawdy
Tourist
6 0 5

Wait. What?  So if the customer is an actual customer (has ever placed an order), they can't be merged?  But this is precisely HOW duplicates are created (when they shop and use overlapping attributes).  Also, how can we " identify duplicated customer profiles" when there is no way to sort by name, email, phone, etc.?

khard
Shopify Partner
22 1 8
Yes, I ran into a lot of these issues as well. And was unable to find
supporting docs that really elaborated on the feature.
chubbell
Excursionist
12 0 11
Yep ditto this is USELESS!!
Shay
Shopify Staff
2778 440 566

Hi everyone! As you have seen, there is now a customer merge feature (yay!). I have been reviewing your comments here about the functionality of the feature and wanted to clarify a few things and ensure I am accurately collecting your feedback on this. 

 

Some of you have mentioned an issue when trying to merge customer accounts with credit card details attached to them. Our developers are working on resolving that issue and it will not be a permanent blocker.

 

Officially, these are the hard blockers for merging customer profiles:

 

  • Profiles can't be merged in the following cases:
    • either of the customer profiles to be merged has an account (An account is when they fully register on your store, allowing them to sign in and see their order history, etc. Different from the default customer profile created)
    • either of the customer profiles has a subscription contract
    • either of the customer profiles is a B2B customer contact
    • either of the customer profiles has active gift cards
    • either of the customer profiles has discounts applied
    • either of the customer profiles has metafields applied
    • a customer profile merge is in progress
    • a customer data request is in progress
    • a customer data redaction request is in progress

@Katdrawdy you mentioned not being able to filter or sort your customer profiles by name, email address or phone number to find duplicate profiles. Customer accounts cannot have the same email address and if a customer checks out using a different phone number but the same email address then the phone number is added to the "Addresses" section, along with the address entered during that checkout. To find duplicates by sorting for phone numbers used across multiple addresses, etc, I would export the customer list to a CSV file and open it in a spreadsheet app to do more advanced sorting. You can also use your analytic reports to review customer account data and creation. The customer reports may be a good fit for what you want to do. 

Shay | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

JAYTAY
Tourist
9 0 12

This CAN'T List makes no sense. Basically if you have a customer that has never made a purchase is the only time you can merge the customers. It's still a useless functionality without the ability to merge accounts. 

Will_Cervarich
Excursionist
23 0 31

I don't think that's what @Shay is saying. @Shay , can you state for the record: if we have two customer profiles who've both made purchases and aren't otherwise blocked by any criterium on your list, should we be able to merge them?

JAYTAY
Tourist
9 0 12

Read the can't list. I cannot merge 100% of the duplicate customers in our database because at least one of those criteria exist. If you have loyalty programs good luck using this merge function. It's USELESS for us. 

Will_Cervarich
Excursionist
23 0 31

Thanks, @Shay . Regarding the first hard blocker, if we clicked "Disable Account" in both of the profiles, would that allow us to merge them? And then we can just send an account invite email after the merge for them to reactivate their account and choose a new password?

 

Are there any other workarounds for any of these blockers that we should know about?

 

Also, what do you mean by "either of the customer profiles has discounts applied" ? I'm sure you couldn't mean if either of the profiles has orders that include discounts, but I'm not aware of any other functionality you could be referring to (maybe it's a Plus+ feature?)

Shay
Shopify Staff
2778 440 566

Hi @Will_Cervarich, great questions!

 

For the accounts question, disabling the account does not unlock the merge feature. The account, while no longer connected to that profile still exists and the customer could reactivate the account at any time using the same email address. I believe this is the only permanent blocker at this time, whereas the other ones can be temporarily removed and re-added (metafields) or their gift cards, etc, can be used up. You could also cancel gift cards and reissue their remaining amount through the correct account if you wanted to clean that up sooner. 

 

The discounts on customer profiles is most likely referring to wholesale account discounts, which is a PLUS feature. 

 

In regards to: if we have two customer profiles who've both made purchases and aren't otherwise blocked by any criterium on your list, should we be able to merge them?

 

Yes, you should be able to merge those two accounts. The current issue with merging customer accounts with credit cards on file might cause this to not work at the moment, but that issue will be resolved ASAP. 

Shay | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

Paul_vd_Dool
Shopify Partner
107 6 95

Hi @Shay,

 

I just want to check if I understand this correctly.

If I have a customer that has a fully registered account with orders and they have also checked out as a guest once, creating another (non-fully registered) account. Because one of the two accounts is fully registered, they can't be merged?

If both accounts are fully registered I can understand, but in this situation, the customer made a mistake and we're trying to rectify that by merging the two accounts.

Doppelganger - Managing duplicate user accounts
Katdrawdy
Tourist
6 0 5

For me, the most common way customers are inadvertently being duplicated is when someone with an account decides to checkout as a guest.  So, I have a lot of customers with an active account plus one or more default customer profiles. If I'm reading this right, once the credit card issue is fixed, I'll be able to merge those?

Shay
Shopify Staff
2778 440 566

Hey @Paul_vd_Dool, I completely understand your logic when approaching this topic and that is feedback I will share with our developers for further consideration.

 

@Katdrawdy As it stands, if even one of the two profiles attempting to be merged has a fully registered account on your store, you will not be able to merge the profiles together. Profiles with a registered account cannot be merged at this time. 

Shay | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

PaulNewton
Shopify Partner
6274 573 1319

Gonna end up needing a flowchart to understand all this.

 

So currently profile-merging is more of a mitigation tool to catch a duplicate account before at least one registration happens in the any of duplicates. 

Basically first time customers / new-repeat customers .

Still better than nothing but that seems a very narrow window.

 

@Paul_vd_Dool Seems there's a need for tools that alert a merchant when that window is open.

 

The registration blocker is perhaps related tangentially to the upcoming new-customers feature.

Would the window even be wider if hypothetically there was a setting to require approving customer accounts 🤔?

 

 

note to self: the Flow app cannot operate on multiple accounts to try and send an alert email .

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


Dan_Knowlson
Excursionist
13 0 13

so basically the merge feature is useless for the use cases where it would actually be needed

Way to go Shopify, sterling effort!

edcorusa
Excursionist
21 0 26
I have to agree. This solution is not a step forward for to the side. The idea of merging accounts is to help us as the sell to keep track of account that are made by mistake and to help the customer who made an account by mistake and placed an order, but can not see his order history. In our case, we have had a company that has placed a number of orders from one purchaser, but then that purchaser leaves and a new purchaser creates an account or a customer forgot they had an account and creates a new one and places an order. The clauses for not being able to merge two accounts means that you have to catch the two accounts before they have placed an order is impossible unless you pay someone to sit and start at the customer list 24/7. This is not a step forward.
Rahamy13
Visitor
2 0 8

Essentially what they have done is created an initial frame work and then pushed it out as an "open beta" to make everyone work through all the issues... this should not have been released as a "solution" as it fixes nothing we have been pointing out for YEARS. Additionally, they made no effort to bring testers on and review things...I've contacted Shopify numerous times about this, I've work with Partners who were also attempting to work with them and communication was nill. On top of it, most of the threads pertaining to this have been marked as "Solved" but they haven't been. Absolutely pathetic performance Shopify... for a company your size with the resource you have at your disposal you can do much better, if you choose to.