WooCommerce – How to Hide Out of Stock Products from Catalog

Discover how to use WP Sheet Editor to hide out of stock products from your Woocommerce store’s catalog and keep your customers interested in the available products.

If you manage a WooCommerce store, you may have noticed that even out-of-stock products appear in your catalog.

This is not only inconvenient for your consumers, but it may also affect your store’s reputation and impact sales.

This issue, fortunately, has a solution. In this post, we’ll look at how to remove out-of-stock products from your WooCommerce catalog.

We’ll teach you how to filter your items without stock using various factors, for example, if you just want to hide out of stock products from the same category.

The best feature is that the WP Sheet Editor – WooCommerce Products plugin allows you to modify your products individually or in bulk.

If, on the other hand, you want to delete your out of stock products, please see our tutorial on finding and deleting out-of-stock items and check this one if you want to delete variations.

This plugin allows you to make advanced searches, and mass changes in a few minutes.

Install the WP Sheet Editor – WooCommerce Products plugin

Once you install the plugin to open it you must go to WP Sheet Editor > Edit Products

Woocommerce-WP-sheet-editor-spreasheet

1. Hide products out of stock individually

You can edit any field directly in the spreadsheet, as easily as you would in Excel or Google Sheets.

In this case, we will locate the Visibility column and change the current visibility type to “exclude-from-catalog”. The best part is that you can drag cells, copy and paste, or select the option from the drop-down.

Once you are done editing, save the changes.

hide-products-out-of-stock-in spreadsheet

This is the best option when your products do not share any filtering parameters, or you want to edit only some of them.

2. Find out of stock products and hide them

Now, to find the products that have no image and are out of stock, we will use the advanced search tool.

With this tool, you can also filter the products without descriptions, by date, price, etc.

Click on Search.

search-tool-to-filter-out-of-stock-products

Once you open the tool, you will see different fields that will help you perform different types of searches:

  • Keyword: Enter a specific keyword to search for all products that contain it.
  • Category, Tags: Enter categories or tags to filter products containing either a specific tag or category.
  • Search on variations: If you check this box, the plugin filters all product variations.
  • Enable advanced filters: This checkbox opens advanced filters to search for your products.

To find all out of stock products, you must select the following values:

  • Field key: Stock status
  • Operator: Equal symbol (=)
  • Value: Out of stock
  • Click on Run Search.

find-out-of-stock-products

Once the products without stock have been filtered in the sheet, to hide them from the catalog, we will use the Bulk Editor.

This tool allows you to apply thousands of changes in a few minutes.

Click on Bulk Edit to open it.

hide-out-of-stock-products

You must select these values to hide the products from the catalog:

  • Select the rows you want to update: Edit all results from my current search (including rows not visible)
  • What field do you want to edit: Visibility
  • Select the type of edit: Set value
  • We will replace the existing terms with these terms: exclude-from-catalog
  • Click Execute now.

hide-out-of-stock-products-in-bulk

Products with no stock are now hidden from the catalog.

hide-out-of-stock-products-result

3. Hide products without stock by keyword

We show you how to find products without stock by keyword.

Just use the Search tool.

search-tool-to-filter-out-of-stock-products

Now select the following values to filter the products by keyword:

Contains keyword: In this field, type a keyword of the product.

Check the Enable advanced filters checkbox and select the following fields:

  • Field: Stock status
  • Operator: “=”
  • Value: Out of stock
  • Click on “Run Search

search-out-of-stock-products-by-keyword

Now that the products have been filtered, to exclude them from the catalog, we must use the Bulk Edit tool.

open-bulk-edit-tool-to-hide-products

Now select these values to remove the products from the catalog:

  • Select the rows you want to update: Edit all results from my current search (including rows not visible)
  • What field do you want to edit: Visibility
  • Select the type of edit: Set value
  • We will replace the existing terms with these terms: exclude-from-catalog
  • Click Execute now.

hide-out-of-stock-products-in-bulk

All filtered products have been successfully excluded from the catalog.

hide-out-of-stock-products-by-keyword-result

4. Exclude out of stock products from the catalog by category, attribute, or tag

The plugin allows you to find all products that are out of stock by a specific category, attribute, or tag.

All you have to do is open the Search tool.

search-tool-to-filter-out-of-stock-products

Now you must type the category, attribute, or tag in the Enter Tags field. It is important to mention that this same field works to filter your products by categories, attributes, and tags.

Then check the Enable advanced filters checkbox and select the following values:

  • Field: Stock status
  • Operator: =
  • Value: Out of stock
  • Click Execute now.

search-out-of-stock-products-by-category

To exclude products from the catalog, we will use the Bulk Edit tool.

open-bulk-edit-tool-to-hide-products-from-catalog

Once you open the Bulk Edit tool, select these values to edit the products:

  • Select the rows you want to update: Edit all results from my current search (including rows not visible)
  • What field do you want to edit: Visibility
  • Select the type of edit: Set value
  • We will replace the existing terms with these terms: exclude-from-catalog
  • Click Execute now.

hide-out-of-stock-products-in-bulk

Products within the same category, and out of stock, have been excluded from the catalog.

hide-out-of-stock-products-by-category-result

Hiding out-of-stock products from your WooCommerce catalog is an influential step in ensuring your clients have a nice purchasing experience.

Thanks to WP Sheet Editor, you may hide out-of-stock products and avoid potential issues, and just have to spend some minutes by following the steps mentioned in this post.

Remember to keep an eye on your inventory and update your products on a regular basis to ensure that your catalog is up-to-date and correct. To do this, it can be useful to visit our tutorial on how to find and edit products with low stock.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.