WooCommerce – How to Search for Out of Stock Products

Let’s see how to search for all out of stock products in WooCommerce.

Let’s say you manage a WooCommerce store for a client and they ask you to give them a report on how many WooCommerce products are out of stock.

In addition, they ask you to report how many products are out of stock for each category in the store. For example, how many products in the “Technology” category are out of stock. Or how many products with the “t-shirt” keyword in the title and the “red” color are out of stock.

This is something you cannot do with WooCommerce only. That’s why we will show you how to search for WooCommerce out of stock products using the WP Sheet Editor – WooCommerce Products plugin.

This plugin allows you to manage your WooCommerce products using a spreadsheet where you can see all the product information and edit freely.

You can skip this step if you already have the plugin installed and activated.

1- Open the products spreadsheet

To open the products spreadsheet, go to WP Sheet Editor > Edit products in wp-admin.

You’ll see a spreadsheet containing all your WooCommerce products’ data.

2- Open the “Search” tool

The Search tool allows you to filter your WooCommerce products using any field as a search filter. You can search for products by stock status, stock, price, featured image, category, attribute, keyword, date, title, etc.

In this case, it will allow you to search for out of stock products, so you need to open it by clicking on Search.

3- Search for out of stock WooCommerce products

Now that you’ve opened the Search tool, you can proceed to find all your WooCommerce out-of-stock products.

In the subsections below, you can learn how to filter all out of stock products, as well as filtering out of stock products by keyword, attribute, or category.

a) Search for all WooCommerce products that are out of stock

If you want to search for all your WooCommerce products that are out of stock, you need to select these values in the Search tool:

• Tick the Enable advanced filters checkbox.
• Field: Stock status
• Operator: =
• Value: Out of stock
• Click on Run search.

After running the search, you’ll see all your out of stock products displayed on the spreadsheet.

You can check that the search results are correct by paying attention to the “Stock status” column.

b) Search for out of stock products by keyword

If you want to search for out of stock products by keyword (example: all out of stock products containing the “hoodie” keyword on the title), you need to select these values in the Search tool:

• Contains keyword: Enter the keyword in this field.
• Tick the Enable advanced filters checkbox.
• Field: Stock status
• Operator: =
• Value: Out of stock
• Click on Run search.

After running the search, you’ll see all out of stock products containing the selected keyword displayed in the spreadsheet:

c) Search for out of stock products by category

If you want to search for out of stock products by category (example: all out of stock products within the “Clothing” category), you need to select these values in the Search tool:

• Product taxonomy: Enter the category in this field. It allows you to search for products by product type, visibility, category, tag, shipping class, attribute, etc.
• Tick the Enable advanced filters checkbox.
• Field: Stock status
• Operator: =
• Value: Out of stock
• Click on Run search.

After running the search, you’ll see all your products that below in a specific category and are out of stock displayed in the spreadsheet.

d) Search for out of stock products by attribute

Do you want to find all products that contain specific product attributes and are out of stock? For example, all yellow products that are out of stock. You can do this easily by selecting these values in the search tool:

• Product taxonomy: Enter the product attribute in this field. It allows you to search for products by product type, visibility, category, tag, shipping class, attribute, etc.
• Tick the Enable advanced filters checkbox.
• Field: Stock status
• Operator: =
• Value: Out of stock
• Click on Run search.

Now you’ll see all the out-of-stock products containing the attribute you selected displayed in the spreadsheet.