If you run a WooCommerce store with thousands of products, you’ve probably asked yourself: “How much inventory do I actually have? And what’s it all worth?” Whether you have 1,000 or 10,000 products, knowing your total stock units and retail value is essential for making smart business decisions.
You might need this information to:
- Estimate your invested capital: For example, understanding that you have $1M worth of pants sitting in inventory.
- Identify your most stocked categories: For instance, discovering you have 100,000 units of pants but only 20,000 watches.
- Find your most valuable categories by retail price: Knowing you have $50,000 in pants and $10,000 in shirts helps you prioritize marketing efforts.
The problem? WooCommerce doesn’t show you these numbers at a glance. You’d have to export data, crunch it in Excel, or manually estimate, which is slow and inaccurate.
In this tutorial, you’ll learn how to see your total inventory units and combined retail price for your entire store, and break those numbers down by category, attribute, tag, or keyword, directly inside your WordPress dashboard. No exports, no formulas, no guesswork.
1. Install WP Sheet Editor
WP Sheet Editor is a plugin that displays all your products in a spreadsheet interface. It lets you view your entire catalog at once, edit products quickly, run advanced searches, and — most importantly for this guide — provides real-time inventory stats and retail price totals.
Skip this step if you already have the plugin installed.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
2. Set Up the Products Spreadsheet
After installing the plugin, you’ll go through a quick setup. Simply enable the “Products” spreadsheet, hide any unnecessary columns, and arrange the fields you need.
Click Save when done.
Follow this tutorial if you need help customizing the spreadsheet layout.
3. Open the Products Spreadsheet
Once the setup is complete, go to WP Sheet Editor > Edit Products. You’ll see all your products displayed in a clean spreadsheet with all their data organized in rows and columns.
Notice the status bar above the spreadsheet. This is where the magic happens. It shows:
- Total products found (Rows): matching your current view or filters.
- Total inventory units (Inventory): combined stock quantity units across all displayed products.
- Total retail price: combined value of all displayed inventory.
4. Get Inventory Stats for Specific Categories, Attributes, or Keywords
The real power of this feature is that the inventory stats update dynamically based on your search filters. When you open the spreadsheet with no filters, you see global numbers for your entire store. But when you search for a specific category, the stats instantly recalculate to show only that segment.
For example, if you search for all products in the “Pants” category using the Search tool, the inventory stats will update to show the total stock units and retail price for pants only.
You can break down your inventory using any of these search parameters:
- Keyword — find inventory stats for products containing specific words in their titles
- Type — compare inventory across simple, variable, grouped, or external products
- Visibility — check stock value for hidden, catalog-only, or search-only products
- Product category — see which categories hold the most stock and value
- Product tag — analyze inventory by specific tags
- Product attribute — break down stats by size, color, brand, material, or any custom attribute
- Shipping class — understand inventory distribution across shipping groups
- Status — check inventory value for published, draft, or trashed products
- Stock status — compare in-stock vs. out-of-stock inventory value
- Regular price / Sale price — segment inventory by price ranges
- Date / Date range — see how inventory value has changed over time
- Author / Vendor — analyze inventory by product creator or vendor (for multi-vendor stores)
- Total sales — find inventory value of best-selling vs. slow-moving products
- Featured image — identify missing images and their associated inventory value
- And any other custom field or advanced criteria
The advanced filters let you build custom search queries with any field, operator, and value. For example:
- Products with stock < 100
- Products with download limit > 2
- Products with an empty featured image
For every search you run, the inventory stats update instantly. You’ll see the active filters displayed above the spreadsheet.
And the inventory and retail price totals will reflect only the filtered results.
Why This Is So Useful
With WP Sheet Editor, you can instantly answer questions like:
- How many inventory units do I have in trashed products?
- What is the retail value of all products missing images?
- How much stock do I have in a specific category or brand?
- What is my total inventory value for products with a specific attribute?
The stats work across all product types (simple, variable, grouped, and external) and include product variations in the calculations. It’s efficient, works on any server, and gives you the numbers you need.
Stop guessing your inventory value. Start managing your WooCommerce store with real data.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features