Migrating passwords from ISC to Opencart
Posted: Fri Jul 26, 2013 12:48 pm
We're moving from the now dead Interspire Shopping Cart to Opencart, and I didn't want our customers to have to re-do their passwords. As OC and ISC use different encryption, I've done this vQmod to take care of using ISC passwords and salts in OC.
To use you need to import your customers into Opencart in whatever manner you choose (we are probably going to use Cart to Cart so that we get everything across without me having to scratch my head at too many SQL statements) - making sure that the 'salt' column from 'isc_customers' is transfered into your 'oc_customer' table in a column called 'isc_salt'.
An example of the SQL to migrate just the salt column if you have already moved all the other customer stuff (i.e. this is what I will run when Cart 2 Cart is done):
Then just add the XML file to your vQmod XML folder - changing the extension to xml from txt (can't post xml here).
To use you need to import your customers into Opencart in whatever manner you choose (we are probably going to use Cart to Cart so that we get everything across without me having to scratch my head at too many SQL statements) - making sure that the 'salt' column from 'isc_customers' is transfered into your 'oc_customer' table in a column called 'isc_salt'.
An example of the SQL to migrate just the salt column if you have already moved all the other customer stuff (i.e. this is what I will run when Cart 2 Cart is done):
Code: Select all
UPDATE oc_customer o
INNER JOIN isc_customers i ON i.custpassword = o.password
set o.isc_salt = i.salt