WooCommerce – How to Find Products Missing Price

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.

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.

woocommerce search products missing price

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.

woocommerce search products missing price

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.

woocommerce search products missing price

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.

woocommerce search products missing price

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.

woocommerce search products missing price

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.

woocommerce search products missing price

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.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.