Adding customers without the confirmation email

[Capn_Snazzy]

I am trying to figure out a way to add my old customers to my new oscommerce website.

 

I want to be able to email them all the newsletter but I am not sure of how I can add their contact info without them getting a confirmation email.

 

Is there not a way to just fill in customer details one by one without having to pretend that you are them?

 

A simple way to just place the names into the database?

 

Thanks much

Chris

[boxtel]

I am trying to figure out a way to add my old customers to my new oscommerce website.

 

I want to be able to email them all the newsletter but I am not sure of how I can add their contact info without them getting a confirmation email.

 

Is there not a way to just fill in customer details one by one without having to pretend that you are them?

 

A simple way to just place the names into the database?

 

Thanks much

Chris

<{POST_SNAPBACK}>

 

or set the email function to send it to you for the time being.

[bobg7]

Assuming you have some of the customer information, this might work, create a .csv with he following fields:

"customers_id";"customers_gender";"customers_firstname";"customers_lastname";"customers_dob";"customers_email_address";"customers_default_address_id";"customers_telephone";"customers_fax";"customers_password";"customers_newsletter"

 

Fill in the fields and with phpmyadmin insert the data into the customers field under the SQL tab.

 

"customers_id" = 1 thru 9999 (must be unique)

"customers_gender" = m or f

"customers_firstname" = first name

"customers_lastname" = last name

"customers_dob" = yyyy-mm-dd 00:00:00

"customers_email_address" = [email protected]

"customers_default_address_id" = 1 theu 999 (must be unique, copy customers_id)

"customers_telephone" = nnn-nnn-nnn

"customers_fax" = nnn-nnn-nnn or na

"customers_password" = see below

"customers_newsletter" = empty for yes - n for no

 

I created one with just the BOLD information and the tested an email and it worked.

 

For the password I created a dummy account and copied the encrepted field into each entry and was able to login.

 

If this works for you, remember to have the customer login and change there password and fill in the rest of the information: in the Account Information and Address Book sections.

 

Good luck.