When you manage a WooCommerce store you publish a lot of products, you can have 1000 products, but sometimes you need to know how much money you have in inventory.
Sometimes you 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.
This tutorial requires the WP Sheet Editor plugin, the first step is to install the plugin your site.
2- Setup the spreadsheet
This is a simple step, you just enable the “Products” spreadsheet and you can hide the unnecessary columns and sort them. Then click continue.
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, it displays all the products and all the product information.
It has a toolbar with cool features, including advanced search, bulk update tool, 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.
The inventory stats update according to the spreadsheet filters.
When you open the spreadsheet the inventory stats show all the products information, how many inventory units there are globally.
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”.
4- Get inventory stats for entire categories, attributes, keywords, etc.
Using the search tool, you can find products using advanced search criteria.
- Date range
- Product category
- Product tag
- Product attributes (Color, Sizes, etc.)
- Advanced filters
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.
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.