Home Forums WordPress Plugins Reporting who has opted-out

Viewing 1 reply thread
  • Author
    Posts
    • #4878
      Gigi
      Participant

      Is there any way for a WP admin to see which users have chosen to opt-out of email notifications?

    • #4880
      vinny
      Keymaster

      Hi Genevieve,

      Not at this time. I want to add it to version 2.0 which is coming, hopefully the first quarter of 2017. You can find out by running a DB query in phpMyAdmin or any other MySQL client. There’s even a plugin which is really handy: SQL Executioner.

      This is the query:

      select user_id, user_login
      from $wpdb->usermeta um
      join $wpdb->users u on (user_id = id)
      where meta_key = 'bbpnns_opted_out'
      and meta_value = 1
      

      Just replace $wpdb->usermeta and $wpdb->users with the prefixed table names.

      Cheers,
      Vinny

Viewing 1 reply thread
  • You must be logged in to reply to this topic.