List all password protected posts

  • Resolved stoelwinder

    (@stoelwinder)


    5 years, 1 month ago

    So I’ve found a nice features in either Firefox or Bitwarden (still figuring that out) that automatically populates a field with the title “Password” with my WordPress Admin password.

    The problem with that feature is that I noticed that some of my products which I had updated via the “Quick Edit” option in Woocommerce now have a password auto-filled out.

    Is there a way to see all products/posts/comments in WordPress that have a Password configured so I can remove the password?

    Not sure if this should be classified as a wordpress or woocommerce problem, but thought WordPress makes the most sense as it looks like a WordPress feature.

Viewing 3 replies - 1 through 3 (of 3 total)

  • You can use a plugin like Admin Columns to show various parts of the post in the admin list, and choose whether it is sortable or not. So if you add the password column to the list and sort the list, all the ones with passwords would be on one end.
    (I haven’t tried this…)

    Thread Starter stoelwinder

    (@stoelwinder)

    There doesnt appear to be an option to sort by visibility or password protection. As the password protection option falls under Visibility and it is not showing up in the list of options to show in the Admin Columns

    Thread Starter stoelwinder

    (@stoelwinder)

    Ended up doing it the not-wordpress way (SQL):

    SELECT * FROM wp_posts WHERE post_status = ‘publish’ AND post_password != ”

    • This reply was modified 5 years, 1 month ago by stoelwinder.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘List all password protected posts’ is closed to new replies.