Post by tonybarnes » Fri Jul 26, 2013 7:47 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):

Code: Select all

UPDATE oc_customer o
INNER JOIN isc_customers i ON i.custpassword = o.password
set o.isc_salt = i.salt
Then just add the XML file to your vQmod XML folder.

Attachments


New member

Posts

Joined
Thu Dec 06, 2012 1:09 am

Post by olstar » Fri Jul 26, 2013 7:58 pm

We did something similar going from Xcart to Opencart O0

Thanks for the contribution :)

Professional UK Based eCommerce - Our Free Opencart Mods - Our Premium Opencart Mods
Kashflow Integration


User avatar
New member

Posts

Joined
Tue Jul 05, 2011 3:53 pm


Post by tonybarnes » Fri Jul 26, 2013 9:41 pm

No probs - hopefuly take some strain out of shifting from a dead product for someone

New member

Posts

Joined
Thu Dec 06, 2012 1:09 am

Post by Walkeralan » Fri Sep 23, 2016 10:42 am

I know about your issue. However, I choose interspire to opencart of third party that supports to move customer with paswords from interspire to opencart. It passes over barriers of defference about structure. Other solution for x-cart to opencart, you can search OpenCart migration extension of LitExtension provider.

Newbie

Posts

Joined
Thu Jul 14, 2016 4:17 pm
Who is online

Users browsing this forum: No registered users and 6 guests