How to move customer from one website to another in Magento?

Question

I have 2 websites set up in Magento, each has one store in it. Each website has its own customer accounts. Now, I need to shutdown one website, and migrate all customer accounts from website A to website B, so that customers from website A's store can login to website B's store. What do I need to do to accomplish this? What to do if a customer has account on both website A's store and Website B's store?

Answer 1

Wanna try a brutal idea?? It's inside my head and this is maybe a glitch of Magento.

1. Go to your customer that wanted the store to be changed.

2. Open your console on browser (firebug or something)

3. Find the html tag

<select id="_accountwebsite_id" name="account[website_id]" class=" required-entry required-entry select" disabled="disabled">
<option value="">-- Please Select --</option>
<option value="0">Admin</option>
<option value="1" selected="selected">Main Website</option>
</select>

4. remove the disabled="disabled" and add the value of option to id that your store want.

<select id="_accountwebsite_id" name="account[website_id]" class=" required-entry required-entry select">
<option value="">-- Please Select --</option>
<option value="0">Admin</option>
<option value="0" selected="selected">Main Website</option>
</select>

5. And Done. your customer store has been changed.

Remember this is the brutal and not recommended idea. LOL

Answer 2

Theres another, simpler way that just comes into my mind. Never tried this either. Go to System->Import/Export in your Admin and export your customers in a CSV file. Open this file with OpenOffice or LibreOffice, change the website and store code values and then try to import it again.