Hello everyone
i have been looking at ways of importing the companys current customer database data into a zen cart database the current database table headers are layed out as follows:
customerId | name | address | postcode | country | telephone | email | username | password | isWebMaster | isSalesAdmin | lastAccess | isAffiliate
Edit* the old database was created about 5 years ago without upgrading in mind and its HUGE
now i know most of this data is useless but the important information is there
unfortunatly not all the data is simply copy/paste
email (ok)
name (first and last names in one field, sometimes only a company name)
address (all in one line not always correct)
postcode (ok)
country (ok)
email (ok)
password (ok)
is there a way to have this data inserted into my current zen cart in any way? even if some fields are left with "PLEASE UPDATE THIS DATA" or words to that effect.
the goal here is to migrate the customers to the new database and cart software without them having to sign up again.
Many Thanks
Rich
Bookmarks