Auto-unsubscribe banned customers ?

[frank18]

My client runs a wholesale store. Customers are manually approved or banned by the store owner.

When my client sets a customer's status to 'banned' she keeps forgetting to check if this person is subscribed to her newsletter during the registration process.

The result is that 'banned' customers still receive a newsletter if they signed up to the n/l during the registration process - they are still being kept 'in the loop' which is not desirable.

Is there a way to automatically set the newsletter subscription to 'unsubscribed' as soon as a person is manually banned?

I guess it could be done via a script that periodically (invoked by cron job) checks something like

>> if customer banned then set newsletter to unsubscribed <<

Any input is appreciated.

Thanks / Frank

[frank18]

Ran this query in phpMyAdmin and fixed the problem manually:

UPDATE `zen_customers` SET `customers_newsletter`= 0 WHERE customers_authorization = 4

Next step is to create a php script and run it periodically via cron.

All good