| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Moving from username login to email login | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
Moving from username login to email login
I am moving to 4.4.1 . In order to switch the system to e-mail login, xcart needs me to remove all duplicate accounts that are using the same email address. Any ideas on how to do it in a bulk form rather than doing it manually for hundreds of accounts?
__________________
Regards, Sherif Nassar |
|||||||
#2
|
|||||||||
|
|||||||||
Re: Moving from username login to email login
Maybe something like this would help:
http://www.devcha.com/2008/03/how-to-remove-duplicate-records-with.html Or you could export to Excel and use that to remove duplicates, then import it back in. Just back it up first!
__________________
Paul Dodman e-business & m-commerce consultant w: www.luminointernet.com e: xcart@luminointernet.com Professional X-Cart help, advice, support and services, specialists in Mobile X-Cart. |
|||||||||
#3
|
|||||||
|
|||||||
Re: Moving from username login to email login
The thing is that the customers data is stored in more than one table. It is not a direct delete from one table. Anyone figured a way to do it? My objective is to remove the duplicate profiles while leaving the most recently logged in
__________________
Regards, Sherif Nassar |
|||||||
#4
|
|||||||
|
|||||||
Re: Moving from username login to email login
I'm thinking about the same thing too. I haven't done it myself, but here are a few of the tables that I think need to be updated if the userids change. I may have missed a couple. Here are my rough thoughts on the process.
Delete old accounts =================== Table: xcart_customers Delete any old duplicate accounts (or if you want to keep them around for archive purposes, put a counter on their e-mail address...i.e. fake@address.com_1,fake@address.com_2 so they're no longer duplicate) Relink records to newest account ================================ xcart_orders This action would move any previous orders into the new account, so that the full order history is maintained. Delete records pointing to any old accounts =========================================== xcart_newslist_subscription xcart_change_password xcart_old_passwords xcart_address_book xcart_stats_customers_products You don't want duplicate primary address records, for example, so just throw away the records in these tables that are linked to the old user ids.
__________________
|
|||||||
|
|||
X-Cart forums © 2001-2020
|