Let’s learn how to search for WooCommerce products missing price.
Here are some important reasons to find all WooCommerce products without prices on your store:
- Customer experience: Customers may get frustrated if they find products without prices, leading to a poor shopping experience and potential loss of sales.
- Sales: Products without prices cannot be purchased, which directly impacts sales and revenue.
- SEO: Search engines may rank pages with incomplete product information lower, affecting organic search traffic.
In this and more cases, finding your products missing regular price can be the first step to solving many problems.
However, WooCommerce doesn’t allow you to quickly search for products that don’t have product prices.
That’s why in this tutorial we will use the WP Sheet Editor – WooCommerce Products spreadsheet plugin.
It allows you to view and manage thousands of WooCommerce products in a spreadsheet interface.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you install the plugin and activate your license, you need to follow the steps below to search for WooCommerce products missing price.
1- Open the spreadsheet
Go to WP Sheet Editor > Edit products, 1 and you’ll see all your WooCommerce products displayed on the spreadsheet.
If you pay attention to the Regular price column, you’ll be able to see some products missing price. However, this is not the best way to find out which of your WooCommerce products have no prices.
2- Search for WooCommerce products missing price
To filter out products that don’t have prices in WooCommerce, we are going to use the WP Sheet Editor Search tool. It allows you to view and manage your WooCommerce products using a spreadsheet interface.
Once you open the Search tool, you need to select these values in order to find all the products without price:
- Tick the Enable advanced filters checkbox.
- Field: In this example, we will select the Regular price field, but you could select the Sale price field, depending on what you need. You could even search for products that don’t have regular price nor sale price; just add another advanced filter.
- Operator: =
- Value: Leave this field empty.
- Click on Run search.
After running the search, you will see all the unpriced products displayed in the spreadsheet. This is the way you can search for all WooCommerce products missing prices.
Optional – Add product prices
After filtering out all the products that do not have a price, you can proceed to add the prices using the spreadsheet.
Just move to the “Regular price” column, add the prices in the cells, and save the changes.
If you want to learn how to bulk edit product prices in WooCommerce, you can follow this tutorial.
As you can see, WP Sheet Editor – WooCommerce Products allows you to easily search for all products missing prices.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features