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