AFemaleProdigy Posted October 31, 2014 Share Posted October 31, 2014 (edited) I have moved my primary shop into a new shared multishop group. Now none of my old customers can log in, the password reset says their accounts do not exist, but I still see them in BO, and I cannot move back to the default group. How can I fix this problem? Edited October 31, 2014 by AFemaleProdigy (see edit history) Link to comment Share on other sites More sharing options...
AFemaleProdigy Posted October 31, 2014 Author Share Posted October 31, 2014 (edited) Woooo! That was scary! Thought for sure I screwed it all up! I was able to fix it by going into phpMyAdmin and updating all of my customer shop ids to the new id! Not sure why PS doesn't change this automatically when you move people around. FYI in case anyone else does this... as it appears really easy to mess up... this was the query I used to fix it. With "1" being the original group id it searched for and "2" being the new group id it added. UPDATE ps_customer SET id_shop_group = replace(id_shop_group, "1", "2"); Edited October 31, 2014 by AFemaleProdigy (see edit history) 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now