Jump to content

Import customers data


Recommended Posts

we are loving CC6 so far!


we are upgrading and migrating to CC6 from years old CC3.


in customers data ,we noticed new CC6 database table has additional "salt" column for each customer


is it possible if we map tables of new CC exactly using old CC3 table, our old customer can login using old passwords they have?


or any other method to migrate CC3 to CC6 customers?


any help/hint will really help

Link to comment
Share on other sites

Hi! Thanks for your enthusiasm.


CubeCart v3 used an old fashioned basic way of storing passwords. The password column is literally just an MD5 hash of the password. 


e.g. pasword = 5f4dcc3b5aa765d61d8327deb882cf99


Try it here:



CubeCart v6 uses a much more sophisticated way to store a password where not only is the password encrypted but it is hashed which means adding text to the password the user doesn't know about to make it stronger. 


More info here: http://en.wikipedia.org/wiki/Salt_%28cryptography%29


If you copy the password from you v3 store into the v6 database table, leaving the salt with an empty value and "new_password" set to "0". On next login CubeCart will automatically convert the existing password into a more secure salted password.


You can't use a v3 database table in v6. The only way you can do what you want is how I just described. 

Link to comment
Share on other sites

Thanks it helped a lot ,now all cc3 customers can login in cc6 but with a problem

system force them to update address book but thrown a MYSQL error


[02-Apr-2015 10:37:07 UTC] PHP Notice:  `hash` is not allowed as a key in 'CubeCart_addressbook' table! in /home/myweb/public_html/shop15/classes/db/database.class.php on line 849
[02-Apr-2015 10:37:07 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_geo_country' table! in /home/myweb/public_html/shop15/classes/db/database.class.php on line 849

I realized as we migrated customers table from CC3 to CC6 , there is no entry make to CubeCart_addressbook and CubeCart_geo_country tables?

do CC6 enter a record of customer in CubeCart_addressbook when they first signup?


any work around or help in this will really help us speed up migration!




Link to comment
Share on other sites

  • 4 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...