WooCommerce Clearance Sale – Feature Low Stock Products

Sometimes clients ask you to feature products running out of stock on the store catalog, to sell them quickly. So they can ask you to feature all the smartphones or T-Shirts for example.

Also, they can ask you to feature all products within a category or products containing a specific attribute. But how do you feature all the smartphones if you have 100 of them? How do you feature all the products within the Technology category or all the blue products?

With the normal WordPress editor you need to take some steps to do that. Of course, it will take you lots of hours because you’ll have to open each product, see their stock and if they are running out of stock you’ll feature them. It sounds difficult, doesn’t it?

However, in this article we’ll show you how easy it is to feature products running out of stock. You’ll learn to do it in all products containing a keyword, products within a category, and products containing attributes.

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 - Read more

Open the Sheet Editor Plugin

Once you open the plugin, you’ll see a spreadsheet with all your products and their detailed information.

In this section, we’ll show you how easy it is to feature low stock products using these search parameters:

  • Keyword
  • Status
  • Category
  • Attribute
  • Tag
  • Shipping class

Just follow these simple steps:

a) Open the Bulk Edit tool

This tool will allow you to apply changes to thousands of products at once. You just need to filter them and then apply the changes you wish.

It’s located on the plugin’s toolbar, so just click on it to open.

b) Filter your products

You can easily filter your products by keyword, status, category, attribute, tag, etc.

For this, you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Now, you’ll find the following fields to filter your products:

Optional fields

  • Contains keyword – Enter a specific keyword to filter all the products containing it.
  • Status – Draft, Private, Published, Scheduled, etc.
  • Enter Tags – Enter categories, attributes, tags, shipping classes.

Low Stock search

  • Click on Enable advanced filters
  • Field Key: Stock
  • Operator: <=
  • Value: 5

After selecting the search method you’ll use and setting the low stock search, click on Run search to filter your products.

c) Feature on the catalog all the products filtered

Once you’ve filtered your products, use these values to feature them on the product catalog:

  • What field do you want to edit: Is featured?
  • Select the type of edit: Set value
  • Replace existing value with this value: Tick this checkbox
  • Click on Execute now.

You can filter all your downloadable products with low stock. Just follow these simple steps:

a) Open the Bulk Edit tool

With this tool you can apply changes to thousands of products at once. You just need to filter them and then apply the changes you wish.

It’s located on the plugin’s toolbar, so just click on it to open.

b) Filter your low stock downloadable products

For this, you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Now you need to do this in order to filter all the low stock downloadable products:

Tick the Enable advanced filters and use these values:

  • Field key: Stock
  • Operator: =
  • Value: 5, for example.

Now, please click on Add new to add a new advanced filter, and use these values:

  • Field key: Downloadable (_downloadable)
  • Operator: =
  • Value: Tick this checkbox.

c) Feature on the catalog all the products filtered

Once you’ve filtered your products, use these values to feature them on the product catalog:

  • What field do you want to edit: Is featured?
  • Select the type of edit: Set value
  • Replace existing value with this value: Tick this checkbox
  • Click on Execute now.

Save lots of time!

With WP Sheet Editor it’s really easy to feature hundreds of products at once and save lots of time to rest or work on something else and increase your productivity.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

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.

Close Menu