Same customer place orders as "Guest" while she already have "Customer" account with same email address. Is it possible to merge the two?

[papagino]

Hello people,

I have a client with a registered "Customer" account but she placed some orders as a "Guest", is there a way to merge all transaction to her "Customer" account?

Also, I have the "Customer loyalty and rewards v3.1.0 - by thirty bees" module enable, but since she placed an order under Guest, her rewards are not shown for her "Customer" account. Is there a way to transfer rewards for her Guest account to her Customer account?

I tried using the "Cart Rules" to manually create a voucher for her customer account, but only her Guest account is listed when doing a search for her email or name in the Cart Rule/conditions selection.

How can I resolve this?

 

Cheers

Edited November 26 by papagino

[datakick]

There is a built in customer merge functionality exactly for this purpose 

[papagino]

17 minutes ago, datakick said:

There is a built in customer merge functionality exactly for this purpose 

how, where???

[datakick]

2 minutes ago, papagino said:

how, where???

[papagino]

If I do a search for the email address of this client under Customers > Manage your Customers, there are 2 listed, one is a Guest account and the other is a Customer account, how can I merge the two account???

[the.rampage.rado]

If you are in the guest profile you should merge into the customer profile. Just check which is which.

[papagino]

5 minutes ago, the.rampage.rado said:

If you are in the guest profile you should merge into the customer profile. Just check which is which.

Did what you said and it worked, now all transactions are under the "Customer" and Guest was deleted.

Problem solved...

You're a PRO...

Cheers

[30knees]

I also do this regularly. Customers could somehow be prevented from ordering as guests based on an email match.

[DRMasterChief]

14 hours ago, 30knees said:

I also do this regularly. Customers could somehow be prevented from ordering as guests based on an email match.

Yes, indeed. Is there a solution that looks for identical email addresses and shows them to me? I can then decide whether I want to merge them or not.

[the.rampage.rado]

There is no such feature.

But you can make a custom query in the SQL manager in BO and pull this list:
(adjust the table prefix to your needs)

In general - if you want certain list to be created and it's still not a part of thirty bees you can do so with ChatGPT and save it in the SQL manager to use from BO.

 

SELECT 
    email, 
    COUNT(id_customer) AS customer_count, 
    GROUP_CONCAT(id_customer ORDER BY id_customer) AS customer_ids
FROM 
    ps_customer
GROUP BY 
    email
HAVING 
    customer_count > 1;