I recently turned on email address confirmation for visitors signing up for the newsletter. I'd now like to delete all the newsletter subscriptions made prior to this.
Whilst the database table newsletter_subscriber
does have a date column change_status_at
, this column is not displayed in the admin, so I can't filter and delete just the old subscriptions.
Ideally I'd like to just run a simple query against the database, which will delete just what I want. However, I'm really cautious about running any queries directly against the Magento database as I'm worried about unexpected interactions.
I have searched the database schema for forign key references to columns in the newsletter_subscriber
table, and can't find any.
Is there anyway to be sure that this is a standalone table and safe to delete from?