Shop Forums WordPress Plugins Reporting who has opted-out

This topic contains 1 reply, has 2 voices, and was last updated by  Genevieve 2 years, 10 months ago.

  • Author
    Posts
  • #4878

    Genevieve
    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

You must be logged in to reply to this topic.