Your client asks you to give him a report on the out of stock products, but he wants only the products in the “Technology” category. How do you find those products? Even more, how do you find all the out of stock white T-shirts?
Of course, if you have no help, it will take you at least some hours or even days, depending on how big your WooCommerce store is.
In this article, we’ll show you how to find out of stock products using a simple spreadsheet.
Install the Sheet Editor Plugin
WP Sheet Editor provides a Products Spreadsheet where you can see all the product information, and you can edit freely.
You can skip this step if you already have the plugin installed and activated.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin – or – Check the features
Video Guide
Text Guide
Open the Sheet Editor Plugin
When you open the plugin, you’ll see a spreadsheet with all your products and their information.
1- Find out of stock products by keyword
To find all out of stock products containing a specific keyword, you need to follow these simple steps:
a) Open the Search tool
It’s located on the plugin’s toolbar, so click on it to open.
b) Enter the search values
- Contains keyword – Enter the product keyword.
- Enable advanced filters – Tick this checkbox and use these values:
- Field key: Stock status
- Operator: =
- Value: Leave it unchecked
- Click on Run search
c) See the spreadsheet
Your products will be displayed in the spreadsheet.
2- Find out of stock products by category, attribute, or tag
a) Open the Search tool
It’s located on the plugin’s toolbar, so click on it to open.
b) Enter the search values
- Enter tags – Enter product categories, attributes, or tags in this field. It works for the three of them.
- Enable advanced filters – Tick this checkbox and use these values:
- Field key: Stock status
- Operator: =
- Value: Leave it unchecked
- Click on Run search
c) See the spreadsheet
Your products will be displayed in the spreadsheet.
3- Find out of stock products by date range
a) Open the Search tool
It’s located on the plugin’s toolbar, so click on it to open.
b) Enter the search values
- Enable advanced filters – Tick this checkbox and use these values:
- Field key: Stock status
- Operator: =
- Value: Leave it unchecked
- Enter the dates in the Date range from and to fields
- Click on Run search
c) See the spreadsheet
Your products will be displayed in the spreadsheet.
Really easy, right?
Don’t lose time and start finding your out of stock products.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin – or – Check the features