Hi all,
I have a situation going on, One of my customers used to be registered and has had orders in the past but now she called us and said she can't get into her account. We immediately though she forgot her password and has locked her account so we reset her password and when we were checking to see if the account is locked or not I noticed that it says (Customer Is Registered: No) I have seen this in the past but always it was for new accounts and the only thing we would need to do was to delete the account and create a new one. for her we can not do that since she has had orders in the past and want to keep that history. How can I fix this? anyone else has had this problem? can I somehow change this to a YES using SQL?
Thank you,
Hiva Javaher