Jump to content
Rhapsody

[solved] Need to Merge Two Customer Accounts

Recommended Posts

I have a customer who registered and ordered with one email address. Subsequent to that order, he registered with his new email address and ordered with his new email address. Is there a way I can merge his old account / orders with his new account so everything shows up with his new email login?

 

Edit: I used brute force approach with phpmyadmin access to database. I located and changed the id_customer filed in the various database tables associated with the old email address to that associated with the new email address. I located the following tables that have the id_customer field (ps_customer has the master id_customer filed):

(all prefaced with ps_): address, cart, customer_group, customer_thread, message, orders, order_return, order_slip

Share this post


Link to post
Share on other sites

hi there, how have you been.

 

it would take some manipulation in the database to associate the old orders with the new account, but it is certainly do-able. PM me if you would like to explore it further.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More