As per this thread I have just made the fix for all my customers being subscribed even though the newsletter is disabled at registration lol
I now have over 200 customers all showing as subscribed and I would like to unsubscribe them in one easy step...can anyone help me out with the SQL I need for that please?
TIA
Lissa
Results 1 to 3 of 3
-
28 Jun 2010, 10:29 AM #1
Totally Zenned
- Join Date
- Oct 2007
- Location
- Australia
- Posts
- 843
- Plugin Contributions
- 0
SQL to unsubscribe all customers?
HunnyBee Design
"A man's manners are a mirror in which he shows his portrait." ~ Johann Wolfgang von Goethe
-
28 Jun 2010, 05:07 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,450
- Plugin Contributions
- 81
Re: SQL to unsubscribe all customers?
Assuming you're using only Zen Cart original code, and no addons related to newsletters, this will unsubscribe EVERYONE from your Zen Cart-managed newsletters.
Code:UPDATE customers set customers_newsletter = 0;
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
28 Jun 2010, 08:52 PM #3
Totally Zenned
- Join Date
- Oct 2007
- Location
- Australia
- Posts
- 843
- Plugin Contributions
- 0
Re: SQL to unsubscribe all customers?
Thanx DrByte, that was just what I needed
HunnyBee Design
"A man's manners are a mirror in which he shows his portrait." ~ Johann Wolfgang von Goethe
Similar Threads
-
why all the sql use $db->bindVars , can not put vars directly in sql string?
By linjuming in forum General QuestionsReplies: 3Last Post: 17 Oct 2012, 02:13 AM -
v139h Auto-unsubscribe banned customers ?
By frank18 in forum Managing Customers and OrdersReplies: 1Last Post: 19 Sep 2012, 03:09 PM -
Where do my customers unsubscribe?
By brandon in forum General QuestionsReplies: 1Last Post: 26 Mar 2011, 01:34 PM -
Remove unsubscribe button from unsubscribe page
By IA7X ShadowsI in forum Templates, Stylesheets, Page LayoutReplies: 3Last Post: 23 Oct 2010, 08:30 PM -
Is there a way for customers to do a one click unsubscribe?
By linnx in forum Templates, Stylesheets, Page LayoutReplies: 6Last Post: 25 Oct 2009, 07:20 AM
