Hi everyone,
I need to "delete" some anonymous customer records from the customers table (select * from customer where IsRegistered=0) to fix an issue with missing details, but am unsure on the proper way to approach things....
As the email column on these records is only blank, I am assuming that if I should only need to set the deleted column as true. Is there anything else that needs to be done?
Any help or advice would be much aprpeciated! My support from response is below
Thanks a million guys I really appreciated it!
Ok, the problem here is that you did have anonymous checkout enabled at one time in the past. You can verify that yourself by looking in the Customer table in the database - you have 369 records with an email address but IsRegistered=0. That means that the customer checkout out anonymously previously. Any time one of those customers returns to the site and tries to purchase again, they're going to run into this issue. The site already has a record of their email address and since you don't allow duplicates they can't register a new account, but the old record doesn't have any data on it since they went through anonymously.
To prevent this from happening again, you're going to want to either remove those old anonymous records from the DB so the customers can register without any issues next time, or convert them into a registered account. We cannot advise you on how to do either, but they're both pretty simple tasks. Just make sure that you have a full backup of the database first just in case.