One customer, two accounts..merge orders?

[LissaE]

I have one customer who has created two accounts, with an order under each...one of the accounts needs to be deleted but have the order associated merged with the other account because I don't want to delete the order...can I do this relatively easily?

[Ajeh]

If you backup your database ...

Pull up the two orders in phpMyAdmin from the orders table so they are listing together ...

SELECT * from orders where orders_id = XX or orders_id = YY

Now you need to edit the customers_id to match the good customers_id ...

Check the account, Master Password is a handy tool for this ... and see if you need to tidy up the rest of the fields that may be off on fields that start with customers_ ...

[LissaE]

Absolutely perfect Ajeh, you rock!

I changed all the other order details to match the other customer id as well, email etc....I have Encrypted Master Password, checked and yup all there on the new one lol

Thanx :)

[Ajeh]

Thanks for the update that you were able to merge the orders into one customer account ...

[RixStix]

Thank you.
This worked like a champ for me too. Amazing what a person can learn if they use the search function.

[Ajeh]

Glad you were helped by this ... I find I learn a lot more with a few good searches as well ... it is amazing the things one forgets or can learn with them ...