[SOLVED] How to delete users newsletter subscriptions obtained from native module of PrestaShop

[ballashop]

Hi,

the module shows registered users or allows us to export, but how to delete some of them?
I also noticed that if a user who has already subscribed to the newsletter (from the native module), he again can still subscribe to the newsletter during the registration. 

The system does not recognize that the user mail is already subscribed to the list.
Any suggestions?

Thanks for any reply.

Balla

Edited April 5, 2022 by ballashop (see edit history)

[ballashop]

Hi,

i found this command line to delete some spam email from mysql:

DELETE FROM ps_emailsubscription WHERE email IN ('[email protected]','[email protected]', 'etc');

Just to know if this can create problems with the DB and possible relationships with others ones. 
Thanks for any reply.

Balla

[endriu107]

You can delete those emails with no worries.

[ballashop]

Hi @endriu107 thanks a lot.

Balla