WooCommerce – Calculate aggregated Stock by Product Category or Attribute

posted in: Guides | 0

Sometimes your client may ask you to check the stock of all the small black jeans for example. But how do you do it? Or how do you check the stock of all the green T-Shirts? Do you go one by one or do you do it all at once? How do you check the stock for all the high-quality (attribute) technology (category) products?

Surely it will take you lots of hours without any help. But in this article we’ll show you how you can check the product stock in different ways such as by category or by attribute.

1- Install WP Sheet Editor

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

The setup is easy and it only takes 2 minutes.

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

Please follow this tutorial for the quick setup.

2- Open the Sheet Editor Plugin

Once you open WP Sheet Editor, you’ll see a spreadsheet containing all your products with their complete information.

If you want to check the stock of all the shoes, you need to use the “Search” tool. This tool will help you filter the product to look for a specific one.

a) Write the keyword you’ll look for.

After opening the “Search” tool, look for all the Shoes to check their stock.

  • Write Shoes in the “Contains keyword” field.
  • Check the “Enable advanced filters” checkbox in order to open the fields to check their stock.

You can execute the search, and you’ll see the total stock units in the status bar above the spreadsheet. It will sum the stock from all the products found.

b) Search by stock quantity

Let’s say you want to look for the shoes running out of stock and so you decide to look for the products that are  10. For that, you need to make sure you set the following values…

  • Look for _stock in the “Field key” field.
  • Select the <= symbol which stands for equal or less than.
  • Write the quantity you want to look for in the Value field.
  • Hit the Run search button.

After that, you’ll see that the filters have been applied and all the products with stock equal or less than 10 will be displayed in the spreadsheet.

You can edit the products and view the aggregated stock above the spreadsheet

If you want to check the stock of all the products within category, you need to use the “Seach” tool, which helps you filter the products by category. So in the spreadsheet just click the “Search” tool.

a) Write the product category you want to look for.

In this example, we’ll use the “Fashion” category, so write it in the “Enter Product categories” field.

Then, check the “Enable advanced filters” checkbox. This checkbox will let you set the values to check the product stock.

b) Look for a specific stock quantity

For example, if you want to look for the products that are greater than or equal to 10, you just need to set the values in this way:

  • Look for _stock in the “Field key” field.
  • Select the >= symbol (equal or greater than).
  • Write the quantity you want to look for in the “Value” field. In this case, we’ll write 10.
  • Hit the “Run search” button.

After hitting the “Run search button”, your products will be filtered. You’ll see the filters applied to your products and the specific products that have been filtered.

If you want to check the stock by attribute, you need to use the “Seach” tool, which helps you filter the products.

a) Write the product attribute you want to look for.

In this case, we’re going to look for the black products, so we’re just going to write “Black” in the “Enter Product color” field.

Then, just check the “Enable advanced filters” checkbox to look for the products stock.

b) Look for a specific stock quantity

For example, if you want to look for the products that are equal to 10, you just need to set the values in this way:

  • Look for “_stock” in the “Field key” field.
  • Select the = symbol in “Operator”.
  • Write the quantity you want to look for in the “Value” field. In this case, we’ll write 10.
  • Hit the “Run search” button.

After that, you’ll see that all the black products that have exactly 10 items in stock will be shown in the spreadsheet.

Start checking your product’s stock now!

Install Sheet Editor and start saving time by checking your product’s stock with just some clicks.

You can download the plugin here:

- or - Read more about it

Leave a Reply