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

posted in: Guides | 0

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.

1- 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

2- Setup the WooCommerce Products Spreadsheet

The setup is easy and it only takes 2 minutes. Please follow this tutorial for the quick setup.

3- Open the Sheet Editor Plugin

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

The first step you need to take to find products is to open the “Search” tool, so in the spreadsheet click the “Search” button.

a) Look for the product keyword

Write the keyword you want in the “Contains keyword” field.

Then check the “Enable advanced filters” checkbox, which will allow you to look for the out of stock products.

b) Look for the out of stock products

Now you can use the advanced filters to search for the stock status, in this case, we’re searching for the out of stock products, so…

  • In “Field key” select “_stock_status”.
  • In “Operator”, make sure you set the equal sign (=).
  • In “Value”, write “outofstock” (no spaces and lowercase)
  • Hit the “Run search” button and that’s it.

c) View the spreadsheet

When you execute the search, the spreadsheet will reload and show you the products out of stock 🙂

Now you can edit those products or copy paste them to excel for the client.

To search for the out of stock products by categories, open the “Seach” tool in the spreadsheet.

a) Look for the product category and stock status

To look for the product category, just write the category in the Enter Product category field.

Then, check the Enable advanced filters checkbox, which will allow you to activate the fields you need to look for the out of stock products.

After that, you need to do the following:

  • In “Field key” write _stock_status”
  • In “Operator” make sure you set the equality sign (=).
  • In Value, you need to write “outofstock”. (It’s without spaces).
  • Finally, hit the “Run search” button.
  • Done!

To find the out of stock products that contain any attribute, you need to open the “Search” tool by clicking it in the spreadsheet.

After that just write the attribute in the “Enter Product attribute” field, which is the same for categories and tags. Then, check the “Enable advanced filters” checkbox, which will allow you to activate the fields you need to look for the out of stock products.

After that, you need to do this:

  • In “Field key”, write _stock_status.
  • In “Operator”, make sure you set the equal symbol (=).
  • Leave the “Value” checkbox unchecked. It means out of stock.
  • Then, just hit the “Run search” button.

For this, use the Search tool to filter your products. Open the tool by clicking it in the spreadsheet.

Write the tag in the Enter Product tag field, which is the same for categories and attributes.

Check the Enable advanced filters checkbox, which will allow you to activate the fields you need to look for the out of stock products.

Now, just set the values of your search:

  • In “Field key”, write _stock_status.
  • In “Operator”, make sure you set the equal symbol (=).
  • Leave the “Value” checkbox unchecked. This means out of stock.
  • Then, just hit the “Run search” button.

If you want to look for the out of stock products uploaded on a specific date, you need to use the “Date range” fields.

Let’s look for the 2018 December products. Remember that these are the dates in which you published the products.

  • Set the date range you’ll look for. In this case, it’s December 1 to December 31.
  • In “Field key”, write _stock_status.
  • In “Operator” make sure you have the equality to symbol (=).
  • Leave the “Value” checkbox unchecked. It means out of stock.
  • Hit the “Run search” button.

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

Leave a Reply