i have added 700 new customers and I want to subscribe them en masse

[mikegraham]

I have just added 700 new customers and I now want to subscribe them all to the newsletter. Is there a quick way to do it?

[ThePatch]

I have not done this but I think this is how it'd play out.

1. Back up your database
2. Two fields need to be updated in your database ( customers_newsletter & customers_email_format )
3. customers_newsletter should be 1 for on, 0 for off
4. customers_email_format should either be TEXT or HTML

I used phpMyAdmin to edit the field and got the following as the SQL, I then asked it to create PHP code below. So write your SQL string and run it

Hope this helps!


Here's the SQL

UPDATE `DATABASENAME`.`customers` SET `customers_newsletter` = '1',
`customers_email_format` = 'HTML' WHERE `customers`.`customers_id` =3 LIMIT 1 ;


Here's the PHP

$sql = 'UPDATE `DATABASENAME`.`customers` SET `customers_newsletter` = \'1\', `customers_email_format` = \'HTML\' WHERE `customers`.`customers_id` = 3 LIMIT 1;';


You would obviously edit the ((WHERE `customers`.`customers_id` =3 LIMIT 1 ;)) so it updates all your customers as opposed to just a single record

[swguy]

Sending unsolicited bulk commercial email is a violation of the law in the US. You can lose your hosting account, get your email address blacklisted and even get sued. Don't do this.

The MailChimp boys wrote some tutorials for people who are new at email campaigns; this blog post has some links:

http://thecartblog.com/2008/07/13/wa...y-be-spamming/

Good luck,
That Software Guy