Merge Customers

Solved
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)

Accepted Solutions
ekeshen
Shopify Staff
Shopify Staff
12 8 7

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.  

 

Elan | Sr. PMM | Shopify

View solution in original post

Replies 415 (415)
Rae
Shopify Staff (Retired)
Shopify Staff (Retired)
1166 95 343

Hi, @makers18

This is Rae from Shopify. Welcome to the Community. 

I appreciate you reaching out about this, and sharing more details about the difficulties this has created for your business. 

At this time, there isn't a way to merge customers accounts in the Shopify admin, but there are some workarounds that may help ensure sales are attributed to the most relevant customer account, such as: 

  • Editing the customer's name, or email address, on the dormant account. This will ensure that new orders are placed under the active account only. 
  • Adding tags to active customer accounts to signify repeat purchases, or to highlight any order preferences related to the customer. 

I understand this is an important feature for your business, so I'd like to learn more about how these duplicates are created, so I can share your experience with our teams directly. With this in mind, is there a common factor that leads to duplicate accounts? For instance, do you sell both online and in person? If so, do some customers have multiple accounts from purchasing in person, and then also online? 

Once I have more details on this, I'll send your thoughts and feedback directly to our teams. 

In the meantime though, if we have any updates to share on this feature request, we'll post more information on our Announcements page, as well as our changelog, so please keep an eye out there. 

I look forward to your reply! 

Rae | 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

NateDakar
New Member
1 0 54

Any updates on this? Merging customers is VERY useful

wildfiberstudio
New Member
1 0 34

Yes, to merge customers would be great.  Our duplicate customers happened when we originally would swipe a card and it would capture the person's name.  We know put the person's name in first.  We would love to merge the old ones to the current customers as we work on a loyalty program on what they spend.  Hopefully it can be done.

 

makers18
Excursionist
21 0 214

No update unfortunately.  Basically, you can edit them all to look the same, but no merging.  It is a mess for looking up past orders as well for any type of loyalty program.  I can't believe it is not a feature being how many people use Shopify.  It is a one click solution in Square and they even suggest possible duplicates for you to review.  

SpencerCran
Excursionist
15 0 107

Agreed. We need this. 

Duplicates are created most commonly for us when:

1) Staff enter the wrong customer information

2) People purchase online with a phone number, then come into the store and purchase using an email address. Or purchase online with an email address one time and phone number another.

3) A significant other does not realize their household has a customer account already.

 

Tough_Traveler
Excursionist
17 0 72

We also really need this feature.  For us, this usually happens under these circumstances:

1) A customer places some orders using only a phone number, and some using an email address

2) A customer has more than one email address that they use

3) A customer buys something in our store and declines to provide an email, and then orders online and provides an email address

This can be particularly annoying when a customer places an order with their email address, then later places a second order and forgets to put in their email address, but then requests to be emailed updates on their new order.  It's impossible to add their email address to their second order, because it is rejected as belonging to another customer.  

Rae
Shopify Staff (Retired)
Shopify Staff (Retired)
1166 95 343

Hi, all! 

I appreciate you reaching out with these different use cases, and outlining how each of your businesses are impacted by duplicate customer accounts. I've shared your individual pieces of feedback with our team. 

If any other Community members would like to request this feature too, please reply in this thread with more information about how these duplicates occur, and I will pass your feedback along as well. 

While we don't have any updates on this request at this time, if we have news to share in the future we will post on our changelog and our Announcements page. Our changelog is a great resource to keep an eye on, as it outlines product updates and any recent changes made to our platform. Equally, our Announcements page is the best place to read more information on new and exciting updates. 

Thanks! 

Rae | 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

gospaorg
Tourist
4 0 29

This is very much needed.

ScotBell
Tourist
7 0 62

HOW IT HAPPENS

Customers forget a password, or that they have an account, and create a new acct. 

But they then either make a typo (yafoo.com instead of yahoo.com is one from this morning) or they skip an email address as they cannot create an acct (because it already exists).

 

IMPACT:

Customer frustration, as they cannot easily get into their account, and make typos or skip an email address.

Bad impression of us, as they don't get an email confirmation from the order.

Bad impression of us as they don't save the time they thought they would with the digital item. 

Extra effort on a busy customer's time, as they need to contact us

Extra  time by us spent on backward efforts instead of forward productive efforts, as we have to investigate / fix. We typically edit the earlier record by adding the prefix old- to their email.

Our "Yafoo" customer had a nice $75 download order which we fulfilled last night (after hours) but then this morning saw the bounce. 

-Scot

 

landerson
New Member
1 0 39

We have been asking for the ability to merge duplicate customers (usually for email typos) for over 5 years. It does not make any sense that the software folks could not have accomplished this by now. 

AndryeaNatkin
New Member
2 0 32

It's so frustrating to not be able to merge customer data into one account when they are in fact the same customer. Not only do customers use multiple email addresses but they go by various names, ie. mary vs margaret or sue vs susan.

Having the ability to merge these variations into one account would be so beneficial in so many ways.

It's the 21 century... PLEASE HELP.

CrosspoolAle
New Member
2 0 39

We also require this feature. It occurs most often when an order is made and the customer has used their email address online, then purchase again with their phone number. We run customers giveaways and competitions which rely on a certain number/certain of customer purchases to qualify. This makes it more difficult to manage. I'm new to Shopify, I surprised a simple function such as this is not available actually.

 

Mark

makers18
Excursionist
21 0 214
Agree. It has been a mess for the holidays with our reorders, and not realizing someone already has an account.
CrosspoolAle
New Member
2 0 39

I've also realised that many customers signed up to the mailing list without purchasing. When they came back and made a purchase, some don't re-enter the email address and they are created as another customer account.

 

It's an absolute pain.

makers18
Excursionist
21 0 214
YES! Same with us.
impactcloset
New Member
1 0 16

I am a brand new boutique and I have multiple customers that have different accounts.  Some of them because they have a different spelling of their name or used a different email address.  We sell online and in person in our mobile boutique using the POS.  I would like my orders from my customers to be clean and smooth and be able to pull up and see at a glance what a customer has purchased from us and how much they have spent with us.  Instead there are to many customers with orders under different names/email addresses.  What can I do - I would like to be able to merge these customers with their orders but I do not see that option . . . Why?  HELP!

makers18
Excursionist
21 0 214
We have had the same issues constantly, and it is only getting worse. It seems like a basic function of a system of that size with so many customers. Shopify continues to say they are not capable of doing this.
skoutshonor
New Member
1 0 13

I am in need of this as well. I have many customers that order without creating an account and use their phone number then make another purchase with their email and create an account. This is frustrating for our efforts as well as the customer. Adding points manually to their account for our rewards program is frustrating as well.

SpencerCran
Excursionist
15 0 107

It is kind of ridiculous that this has gone on for 5 years and is still not resolved. What is up, Shopify?