Importing Member

[shahed]

I like to import member from old shopping cart, I have their info on a cvs file. They only have email,name, phone and address .

What would be the best way to import them to member table. I think I will not import address. So If I use phpmyadmin to import all member(ofcourse matching fields) what should I put on other fields like DOB or password? Would they be able to retrive the password from the system.

I have about 2000 members so just need to make sure with you guys.

 

Shahed

[shahed]

anyone can just tell me how do I start, I do not want to mess up my whole site...

[shahed]

there are so many expert here.. no one knows how cutomer table work?

Help guys

[Ajeh]

The customer gets 1 entry in customers table and 1 entry to start with in the address_book with the primary address being address_book_id=1

 

You need to have the minimum of the following info in these two tables:

 

table: customers

customer_id ... must equal same as below

email_address ... must be unique

customers_default_address_id ... default is 1

 

table: address_book

customer_id ... must equal same as above

address_book_id ... default is 1

 

Now when the customer comes to the site with just an email address they can say forgotten password and they will recieve a new password.

 

Then, they can login with the new password and complete the remaining information after they login.

 

You will have to decide what effect it has on your store if the data is left blank.

 

I suggest you test a manual entry as described above and see what works/breaks on your site. :shock: