view all ‘hidden’ products

Hi @lucytech,

By default, there is no option to sort products based on visibility. However, you can easily update the visibility for all products using the bulk edit tool.

I hope this clarifies your concern. If you have any other questions, feel free to ask.

I would need to check each product for that?

I have about 800 products.

Can I look in the database?

Do you know which table it would be in? What MySql query could I run?

Thanks

Hi @lucytech,

Can I look in the database? Do you know which table it would be in?

Yes, You can look for product_visibility in the wp_term_taxonomy table. More info:

• https://github.com/woocommerce/woocommerce/wiki/Database-Description
• https://stackoverflow.com/a/48487242/23495588

What MySql query could I run?

We haven’t any ready-made SQL query for you, but we hope these resources can guide you along the way:

• https://stackoverflow.com/questions/50633551/update-the-product-visibility-in-woocommerce-3
• https://stackoverflow.com/questions/53058584/handle-woocommerce-visibility-for-hidden-products-in-a-wp-query
• https://stackoverflow.com/questions/53716321/get-the-catalog-visibility-for-a-product-in-a-sql-query-on-woocommerce

I have about 800 products.

You can follow the resources I’ve shared above or take a slightly different approach.

Start by exporting the product to a CSV file. Then, edit the visibility column (maybe using Google Sheets) and import them back.

To do so, you can use the default export import tools, or for more advanced performance, try the Product CSV Import Suite plugin. Both methods are effective, so choose the one that suits you best!

• https://woo.com/document/product-csv-importer-exporter/
• https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema

I hope this helps! Please let us know how it goes or if you need further assistance.

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.