WooCommerce – Calculate Global Inventory Units and Retail Price

If you have a WooCommerce store, you can publish lots and losts of products. You can have 10 thousand products, and sometimes you need to konw how much money you have in inventory.

You may need to know the combined inventory units for all products, and how much all the inventory is worth.

You might need this to:

• Estimate how much money you have invested. For example, if you have $1M worth of pants.
• Which categories are the most stocked. For example, if you have 100k pants, but 20k watches.
• Which categories are the most valuable in terms of retail price. For example, if you have $50k in pants, and $10k in shirts.

In this tutorial, we’ll show you how to get those numbers easily, and we’ll show you how to get those number for every category, attribute, even keywords.

1- Install WP Sheet Editor

WP Sheet Editor is a plugin that provides a spreadsheet where you can view all the products at once, edit products quickly, make advanced searches, and it also provides some cool stats about your products inventory.

2- Setup the products spreadsheet

This is a simple step. You just enable the “Products” spreadsheet and you can hide the unnecessary columns and sort them.

Then click Save.

Follow this tutorial if you need help to customize the spreadsheet.

3- Open the products spreadsheet

After the quick setup, you’ll see the spreadsheet displaying all the products and all the products’ information.

It has a toolbar with cool features, including advanced search, bulk update tool, duplicate items, etc.

Notice that above the spreadsheet we have a status bar, where you can see how many products were found on your store, and it also provides the inventory stats that we need.

4- Get inventory stats for entire categories, attributes, keywords, etc.

The inventory stats update according to the spreadsheet filters.

This means that, when you open the spreadsheet, the inventory stats show all the products’ information: how many inventory units there are globally and how much money that is.

But if you search for products under the category “Pants” using the Search tool, the inventory stats will update and show the total inventory units and retail price for all the products under the category “Pants”.

Using the search tool, you can find products using advanced search criteria.

You can find products by:

• Keyword
• Type
• Visibility
• Product category
• Product tag
• Product attribute (size, color, brand, material, and any other custom attribute)
• Shipping class
• Status
• Stock status
• Regular price
• Sale price
• Date
• Date range
• Author
• Total sales
• Featured image
• Vendor
• And any other advanced search criteria

The advanced filters option lets you build custom search queries. You can select any field, a search operator, and a value.

For example, you can search products with stock < 100, or products with download limit > 2, or products with “Featured image” = (empty, products without image).

And for each of those searches, the inventory stats will get updated.

You’ll be able to see how many inventory units you have for individual product categories, how much all the inventory is worth for specific keywords, tags, product attributes, and advanced filters.

Once you filter your products using any search filters, you’ll see all the active filters above the spreadsheet:

You’ll also view the inventory and retail price data above the spreadsheet:

This is very helpful

You can see how many inventory units you had in the products moved to the trash, or in the products without images, and more.

This works with all product types, including simple, variable products, and more. It includes product variations inventory too.

And it is very efficient, it works with any server.