jacven Posted June 25, 2009 Share Posted June 25, 2009 Hello I would like to know if it's possible to massive update current customers and change their newsletter susbscription status to ACTIVE thank you Link to comment Share on other sites More sharing options...
Guest Posted June 26, 2009 Share Posted June 26, 2009 Hello I would like to know if it's possible to massive update current customers and change their newsletter susbscription status to ACTIVE thank you Why would you want to do that? If I as a customer chose NOT to receive any newsletters or adds from an online store and you still sent them to me, I would be pretty mad. I would have remove my account and I would never come to your site again. That being said, yes you can. Do it through phpmyadmin. Run a query to update the customers table and set the newsletters field to 1. Link to comment Share on other sites More sharing options...
multimixer Posted June 26, 2009 Share Posted June 26, 2009 Maybe at the database directly, table customers? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
jacven Posted June 26, 2009 Author Share Posted June 26, 2009 Thank you all for the replies, can you please teach me this query? Regards. Link to comment Share on other sites More sharing options...
jacven Posted June 26, 2009 Author Share Posted June 26, 2009 Nevermind, I found it UPDATE `XXXXXXXX`.`customers` SET `customers_newsletter` = '1' Thank you Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.