[SOLVED] Help needed! - Adding existing customers to newsletter.

[Philip Anderton]

Hello,

 

Wondering if anyone out there can help?

 

After recently installing a newsletter module I have realised that none of my customers are signed up. I know I can use the BO to change the subcription status - manually adding each customer - but as I have over 15'000 this is far from ideal. Does anyone have any idea how I can add existing customers on mass, maybe via SQL?

 

Many thanks in advance,

 

Philip.

 

Prestashop version: 1.4.5.1

Edited January 28, 2014 by Philip Anderton (see edit history)

[Philip Anderton]

Okay, I managed to resolve this by running this simple query in MySQL:

 

UPDATE `ps_customer`
SET `newsletter`='1';

 

This adds newsletter registration  on all customers in the table 'ps_customer'. A more detailed explanation of the operation can be found here.