I am moving from an old system onto opencart 2.1.0.1
have managed to get product and category data ported without issue however I am kind of stumped when it comes to moving the user data...
We have thousands of users, I'd like to port their full acct info but not sure how to handle the passwords.
Best if we could actually move them, but that has its own set of problems as they are encrytped.
Another option would be to notify them at login that they have to create a new password... but I can't find an extension for that...
any ideas?
This is, how a Customer DB Line in OC v.2.2 looks like, it shoud be easy, to export your Customers, and re-import them into your new Shop, after you made sure, that you changed all VARIABLES/TAGS, possibly different to your Version, before reuploading the File to your new Version Shop. (like possibly SALT, SAFE, CODE, I just don't know 1.5.4!!))
I am unaware of, if the password encryption has changed, if so, you would have to exchange/add a DEFAULT password into all Password Lines, in the downloaded File, and tell it to your Customers, along with the urgend advise, to change it immediately again.
But this is some work, and takes some time, I assume, to get a clean DB-UPGRADE done by one of the Pro's around here, like Peku, Qphoria, OsWorx, Randem, e.t.c., would be cheaper, and even more secure, after all.
Good Luck!
Ernie
PS. Password-Code has been changed...
I am unaware of, if the password encryption has changed, if so, you would have to exchange/add a DEFAULT password into all Password Lines, in the downloaded File, and tell it to your Customers, along with the urgend advise, to change it immediately again.
Code: Select all
INSERT INTO `oc_customer` (`customer_id`, `customer_group_id`, `store_id`, `firstname`, `lastname`, `email`, `telephone`, `fax`, `password`, `salt`, `cart`, `wishlist`, `newsletter`, `address_id`, `custom_field`, `ip`, `status`, `approved`, `safe`, `token`, `code`, `date_added`) VALUES ('1', '1', '0', 'Benjamin', 'Jacob', 'beni@jacob.ch', '079 517 80 50', '', 'eb2244b70ddacdtg54456dds5654sa4565175306a624f92ae8', '41D5M2mTD', '', '', '0', '1', '', '92.107.135.248', '1', '1', '1', '', '', '2016-03-09 19:56:22');Good Luck!
Ernie
PS. Password-Code has been changed...
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
tx for the reply but I should have been clearer...
I wasn't coming from opencart, password were mysql passwords... anyway.. ended up importing them without passwords and then made changes to password errors and forgotten page to make it more user friendly, should be decent enough workaround.
basically password error now says,
"Warning: No match for E-Mail Address and/or Password.
*** If you have an account with us and this is your first time using the new website please CLICK HERE TO GENERATE A NEW PASSWORD"
changed success message to add info about updating after using temp password
then I also changed forgotten page to say generate new password.. instead of "forgot password?".
I wasn't coming from opencart, password were mysql passwords... anyway.. ended up importing them without passwords and then made changes to password errors and forgotten page to make it more user friendly, should be decent enough workaround.
basically password error now says,
"Warning: No match for E-Mail Address and/or Password.
*** If you have an account with us and this is your first time using the new website please CLICK HERE TO GENERATE A NEW PASSWORD"
changed success message to add info about updating after using temp password
then I also changed forgotten page to say generate new password.. instead of "forgot password?".
Who is online
Users browsing this forum: No registered users and 2 guests
