Simplenews: How to batch unsubscribe multiple subscribers
spade - December 2, 2008 - 14:38
Hello,
so far I have only figured out how to unsubscribe one email at a time by filtering that address, selecting delete from the list, checking the one address and hitting Update.
To do this with a hundred addresses takes a whole lot of time. Is there an easier way that I have overlooked?
I have tried to enter more than one address in the filter field, but that didn't work.
It would be really nice if I could supply a list of addresses for deletion like I can for importing.
Kind regards,
Frank

You can do this by creating a "dummy" newsletter
Hi Frank,
I had the same problem. I found a workaround, but you need to be able to easily copy and paste a comma separated list of addresses that you want to unsubscribe. This might be the case if you can export them from another email tool, or by some other method with Drupal.
This technique isn't perfect, but it is quicker than manually unsubscribing one by one.
You might be able to do this with SQL too - but this method avoids having to dig around in PHPMyAdmin or similar.
To unsubscribe multiple addresses:
1. create a comma separated file with a list of all addresses you want to unsubscribe (how you do this depends on your particular circumstances)
2. create a new "dummy" newsletter called "Unsubscribed addresses"
3. select subscriptions > import in the admin interface for Simplenews
4. paste the list of addresses into the import field
5. check "Unsubscribed addresses" as the newsletter you want to import these addresses to, uncheck all other newsletters
6. click "Import" to add these addresses to the "Unsubscribed addresses" dummy newsletter
7. now click "List subscriptions"
8. in the filter dropdown, select "Unsubscribed addresses" as the newsletter and click "Filter"
9. you should now be able to see all the addresses you want to unsubscribe that you imported in step 6 - click the "Select all" checkbox in the first column header to select them all
10. select "Inactivate" from the Update options dropdown
11. click "Update" to unsubscribe them from your list
12. if you have multiple pages of addresses to unsubscribe, repeat steps 8-11 for each page
I hope that helps...
S
Looks like a nifty trick
Hi Skuft,
thanks for you workaround. Sonds like it could work. I'll give it a try.
Kind regards,
Frank
It worked
Hi Skuft,
I finally had the time to try your trick and can report that it worked as promised.
Thanks a bunch.
Kind regards,
Frank