WooCommerce – Find All Out of Stock Products by Category, Attribute, Keyword

Your client asks you to give him a report on the out of stock products, but he wants only the products in the “Technology” category. How do you find those products? Even more, how do you find all the out of stock white T-shirts?

Of course, if you have no help, it will take you at least some hours or even days depending on how big your WooCommerce store is.

In this article, we’ll show you how to find out of stock products using a simple spreadsheet.

Install the Sheet Editor Plugin

WP Sheet Editor provides a Products Spreadsheet where you can see all the product information and you can edit freely.

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

You can download the plugin here:

- or - Read more about it

Open the Sheet Editor Plugin

When you open the plugin, you’ll see a spreadsheet with all your products and their information.

To find all out of stock products containing a specific keyword, you need to follow these simple steps:

a) Open the Search tool

It’s located on the plugin’s toolbar, so click on it to open.

b) Enter the search values

  • Contains keyword – Enter the product keyword.
  • Enable advanced filters – Tick this checkbox and use these values:
    • Field key: Stock status
    • Operator: =
    • Value: Leave it unchecked
  • Click on Run search

c) See the spreadsheet

Your products will be displayed in the spreadsheet.

To find all out of stock products by category, attribute or tag, you need to follow these simple steps:

a) Open the Search tool

It’s located on the plugin’s toolbar, so click on it to open.

b) Enter the search values

  • Enter tags – Enter product categories, attributes, or tags in this field. It works for the three of them.
  • Enable advanced filters – Tick this checkbox and use these values:
    • Field key: Stock status
    • Operator: =
    • Value: Leave it unchecked
  • Click on Run search

c) See the spreadsheet

Your products will be displayed in the spreadsheet.

To find out of stock products by date range, you need to follow these really simple steps.

a) Open the Search tool

It’s located on the plugin’s toolbar, so click on it to open.

b) Enter the search values

  • Enable advanced filters – Tick this checkbox and use these values:
    • Field key: Stock status
    • Operator: =
    • Value: Leave it unchecked
  • Enter the dates in the Date range from and to fields
  • Click on Run search

c) See the spreadsheet

Your products will be displayed in the spreadsheet.

To find out of stock downloadable products, you need to follow these really simple steps.

a) Open the Search tool

It’s located on the plugin’s toolbar, so click on it to open.

b) Enter the search values

  • Enable advanced filters – Tick this checkbox and use these values:
    • Field key: Stock status
    • Operator: =
    • Value: Leave it unchecked
  • Click on Add new to add a new filter, and use these values:
    • Field key: Downloadable
    • Operator: =
    • Value: Check this
  • Click on Run search

c) See the spreadsheet

Your products will be displayed in the spreadsheet.

Really easy, right?

Don’t lose time and start finding your out of stock products.

You can download the plugin here:

- or - Read more about it

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.

Close Menu