WooCommerce – How to Find Products with Low Stock

posted in: Guides | 0

When your client asks you to give him a report of what products have low stock, you can face a serious problem if you have hundreds or thousands of products to check.

When that happens, you cannot filter your products with the normal WP editor because it doesn’t give you a proper search tool to filter all of them with just a few clicks. It could take you lots of hours or days to find all those out of stock products.

That’s why in this article we’ll show you how to easily and quickly find the out of stock products in your WooCommerce tool.

1- Install WP Sheet Editor

WP Sheet Editor makes it easier for you to manage your WooCommerce store because it has a powerful bulk updates tool that helps you filter and edit hundreds of products quickly.

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

You can download the plugin here:

- or - Read more about it

Once you open the plugin, you’ll see a spreadsheet containing all your products and their complete information.

If you don’t want to filter your WooCommerce store to find specific products with low stock, you may want to find them all. In that case, you need to use the “Search” tool to look for them. For example, you can look for the products with a stock of less than 10.

After opening the “Search” tool, you need to enable the advanced filters, which will help you find your products with low stock.

You need to set these values to look for the products with low stock:

  • Write “Stock” in “Field key”.
  • Choose the “less than” sign.
  • Write “10” in the “Value” field.
  • Hit the “Run search” button.

This is another way to find your products with low stock. For example, you can find all the products with the “Shirt” keyword.

For this, you need to open the “Search” tool and set the necessary values.

After opening the “Search” tool, you need to write the product keyword in the “Contains keyword” field.

Then you need to enable the advanced filters to open the necessary fields to find the products with low stock.

  • Write “Stock” in “Field key”.
  • Choose the “less than” sign.
  • Write “10” in the “Value” field.
  • Hit the “Run search” button.

Another important way to find your products with low stock is to filter them by category, attribute or tag.

With WP Sheet Editor it’s really easy to do it because it gives you the opportunity to find your products in those three ways by using one same field.

So after opening the “Search” tool, you need to write the product attribute, category or tag in the “Enter product category…” field.

After that, you need to enable the advanced filters to open the fields you’ll need to find the products with low stock.

  • Write “Stock” in “Field key”.
  • Choose the “less than” sign.
  • Write “10” in the “Value” field.
  • Hit the “Run search” button.

If you want to find all downloadable products with low stock, you need to take these simple steps:

Open the “Search tool” by clicking it on the toolbar above the spreadsheet.

Check the “Enable advanced filters” checkbox.

  • Write “_downloadable” in “Field key”.
  • Select the “equal” sign.
  • Check the “Value” checkbox.
  • Hit “Add new” to add another advanced filter.

Then, you need to look for the downloadable files:

  • Write “_stock” in “Field key”.
  • Choose the “less than” sign.
  • Write “10” in the “Value” field.
  • Hit the “Run search” button.

Done!

With WP Sheet Editor it’s really easy to find your products with low stock.

You can download the plugin here:

- or - Read more about it

Leave a Reply