Spado Posted March 28, 2018 Share Posted March 28, 2018 Hi all, I'm configuring the newsletter module, but i see i can't remove a user registered to the newsletter. I can see every customer registered to it on the costumer section, but it doesn't allow me to do any action on them... anyone had my same problem? Thanks Link to comment Share on other sites More sharing options...
Rhobur Posted March 31, 2018 Share Posted March 31, 2018 Just click the green checkbox in the Subscribed column for the user you want out., Link to comment Share on other sites More sharing options...
tantan199 Posted April 3, 2018 Share Posted April 3, 2018 Click the green image link, see attached screenshot. Link to comment Share on other sites More sharing options...
Spado Posted April 6, 2018 Author Share Posted April 6, 2018 On 4/3/2018 at 12:06 PM, tantan199 said: Click the green image link, see attached screenshot. On 3/31/2018 at 11:28 AM, Rho_Bur said: Just click the green checkbox in the Subscribed column for the user you want out., Thanks for the answer guys, but when i delete that specific user through the green checkbox, prestashop wont allow me to add the same user another time with the same email to the newsletter. In fact it says that "The email address is already registered". I think it's something to do with the phisical database, because the prestashop customer db is empty and it says "No customers registered to the newsletter". Link to comment Share on other sites More sharing options...
tantan199 Posted April 9, 2018 Share Posted April 9, 2018 You can delete the email from ps_emailsubscription table via phpmyadmin. Link to comment Share on other sites More sharing options...
Spado Posted April 10, 2018 Author Share Posted April 10, 2018 On 4/9/2018 at 10:48 AM, tantan199 said: You can delete the email from ps_emailsubscription table via phpmyadmin. Okay thanks, yet it's pretty unhandy Link to comment Share on other sites More sharing options...
Maryjan Posted March 3, 2020 Share Posted March 3, 2020 (edited) I have got the same problem. Ok I can delete newsletter user via phpmyadmin but Can I manage them in BO? When I delete e-mail signed to newsletter in BO he disappears but still stay in data base. Is it normal? Ps 1.7.6 Edited March 3, 2020 by Maryjan (see edit history) Link to comment Share on other sites More sharing options...
AndyNZ Posted June 5, 2020 Share Posted June 5, 2020 Experienced the same behaviour - seems to be "normal" for this kind of basic subscription module. Only way is run from time to time a simple SQL command in phpMyAdmin: DELETE FROM ps_emailsubscription WHERE ACTIVE = 0 If you have rights to do so you can also create an event to run this once a day at night. Just bear in mind that all not confirmed subscriptions will be removed as well. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now