Imagine this: You’re running a members-only store. You want to restrict some products from your catalog so that those products be seen by your registered customers only. Now, the problem comes when you discover that you have thousands of products to be hidden from the catalog. That’s going to take you many hours since WooCommerce doesn’t include any option with which you can apply that change to hundreds of products with just a few clicks.
That’s the reason in this entry, we’ll show you how to hide thousands of products from your catalog using the plugin WP Sheet Editor Products Spreadsheet plugin.
What’s the WP Sheet Editor Products Spreadsheet plugin?
It’s a powerful, easy-to-use plugin that helps you easily manage your WooCommerce store. It displays all your products and their complete information in a spreadsheet.
To hide your products from the catalog, you need to take these simple steps:
1- Open the Bulk Edit
This tool helps you manage apply changes to hundreds of products in just a few clicks. You can open it by clicking on it in the plugin’s toolbar.
2- Filter your products (Optional)
Once you’ve opened the Bulk Edit tool, you can filter your products in different ways. You can look for your products by keyword, status, category, attribute, date, ID, etc.
So you need to take these steps to filter your products:
In the Select the rows you want to update field, select the I want to search rows to update option.
The Search tool contains the following fields.
- Contains keyword: Use this field to filter all the products containing a specific keyword like shirt.
- Status: With this field you can look the published and the draft products.
- Enter Tags…: This is a special field because you can use it to filter your products by tag, category, shipping class, or attribute.
If you want to search all downloadable products, just tick the Enable advanced filters checkbox and set these values:
- Field key: _downloadable
- Operator: =
- Value: tick the checkbox
3- Hide products
After filtering your products, you need to use these values to hide them from your catalog:
- Field you want to edit: Visibility
- Select type of edit: Set value
- Value: exclude-from-catalog
- Click on Execute now
See how easy it is? Start managing your WooCommerce store with WP Sheet Editor and apply this and thousands of other changes to hundreds of products quickly.