Skip to content

Instantly share code, notes, and snippets.

@jrick1229

jrick1229/catalog_visibility.sql

Created November 3, 2022 18:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jrick1229/ee64101597c7d3c60e6c1cef3a5ff6ff to your computer and use it in GitHub Desktop.
Save jrick1229/ee64101597c7d3c60e6c1cef3a5ff6ff to your computer and use it in GitHub Desktop.
Download ZIP
WooCommerce – Output a list of post_ids in the wp_postmeta table that are hidden from the catalog.
Raw
catalog_visibility.sql
SELECT * FROM `wp_postmeta` WHERE `meta_key` LIKE '_visibility' AND `meta_value` LIKE 'hidden'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment