Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Change everyone to recieve newsletter


crosswinds

Recommended Posts

You can do it using phpmyadmin and change the database field. You can also have the tick box filled in on the create account page.

 

Check the legalities first as in most countries you have to allow customers to opt in to receiving newsletters, and not to opt out.

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

You can do it using phpmyadmin and change the database field. You can also have the tick box filled in on the create account page.

 

Check the legalities first as in most countries you have to allow customers to opt in to receiving newsletters, and not to opt out.

 

Hello again, i had a look in phpmyadmin, but im unfamilliar on how to do this.

 

I can edit one and one, but i dont know how to edit everyone in a batch?

Link to comment
Share on other sites

@@crosswinds

 

Maybe you missed Steve's warning. You can be held LIABLE if you send unsolicited newsletters to customers who HAVE NOT OPTED TO RECEIVE THEM.

 

Also, if you are unfamiliar with PHPMYDMIN, then I wouldn't suggest messing with the database.

 

 

 

Chris

Link to comment
Share on other sites

No one is going to do anything, ever, should someone complain to the authorities (and who would that be, 911?, the FBI? your webhost?) that they typed their email into your website and then they received an email from you. Especially if you have a 'unsubscribe' link in the email, and actually unsubscribed them.

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

@@npn2531

 

Actually, you can report spam to all of the major Anti-virus companies and they will add that person to the SPAM list which bans the users email address. I get spam all the time, and report every sender to Symantec. It works, the spam stops.

 

 

 

 

Chris

Link to comment
Share on other sites

Cool, I am going to report my competitor's email addresses to Symantec, that'll stop 'em! Heck, I'll add my last employers email address as well, I can't stand him.

 

Snark aside, if you type in your email address into a website, and subsequently get an email from that company, and then when you ask, or click an link to be taken off that list, and you are taken off, Symantec is not going to list that company as spam.

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

  • 4 weeks later...

Hello!

 

And sorry for my late reply.

 

Firstly, i do understand your concerns. But in Sweden, the rules for this is different.

Also. This is not for marketing reasons, but for general information to all my customers.

 

 

Thank you npn2531 for your more realistic input on this.

Link to comment
Share on other sites

To change every customer to receive the newsletter open up phpMyAdmin in your webhost control panel. Click your database open, then click on the SQL tab at the top. A dialog window will open. Paste in this:

UPDATE  `customers` SET  `customers_newsletter` =  '0'

 

and click go. This will change everybody to '0'. It may be you need to change everyone to 1 or 2, I just can't remember if 0, 1 or 2 is designation newsletter uses to tag for inclusion on the mailing list.

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

  • 3 weeks later...

To change every customer to receive the newsletter open up phpMyAdmin in your webhost control panel. Click your database open, then click on the SQL tab at the top. A dialog window will open. Paste in this:

UPDATE  `customers` SET  `customers_newsletter` =  '0'

 

and click go. This will change everybody to '0'. It may be you need to change everyone to 1 or 2, I just can't remember if 0, 1 or 2 is designation newsletter uses to tag for inclusion on the mailing list.

 

 

Thank you for your help!

Link to comment
Share on other sites

Please note in the above that in the cutting and pasting the ' may need retyping, as there seem to be several versions of ' .

It looks OK from here, although it is a good point that there are two different kinds of ticks used in the post: backticks ` around table and field names, and single quotes ' around field values. When cutting and pasting from a Word or Outlook document, you have to be careful about Microsoft "Smart Quotes" turning ' into other forms of "typographically pleasing" opening and closing curved single quotes that don't work in SQL.

Link to comment
Share on other sites

But in Sweden, the rules for this is different.

As Sweden is E.U., I would be surprised if they were operating under weaker privacy rules than in the U.S. Anyway, if know what your country's law is, and you feel that you're in compliance with it, you've taken responsibility for any problems.

 

Also. This is not for marketing reasons, but for general information to all my customers.

Depending on how the law is written, they may or may not make an exception for "general information" broadcasts (versus "marketing"). Certainly, informing customers of security problems such as a credit card processor breach would override any customer's failure to "opt in" to a newsletter.

 

However the government chooses to look at what you're doing, there's still the matter of individual customers reporting you as a spammer, and finding your emails blocked in a large number of places. If you can remember back to the heyday of "AOLusers", a large number of them would click "Report as Spam" in order to unsubscribe from various mailing lists. This solved their immediate problem (no more mail from that sender), but falsely labeled legitimate (non-spamming) businesses as spammers, creating an enormous headache for them.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...