WooCommerce Clearance Sale – Feature Low Stock Products

posted in: Guides | 0

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.

1- 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:

- or - Read more about it

2- Setup the WooCommerce Products Spreadsheet

The setup is easy and it only takes 2 minutes.

Please follow this tutorial for the quick setup.

3- Open the Sheet Editor Plugin

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

4. Feature all running-out-of-stock products containing a keyword

If you want to feature all running-out-of-stock products containing a specific keyword, you need to take some steps.

a) Open the Apply Changes in bulk tool

This tool helps you apply changes to hundreds of products, so you need to open it by clicking it above the spreadsheet.

b) Click the “Select rows” button

The “Select rows” button opens a search tool that helps you filter your products. In this case you’ll filter the products by keyword.

c) Look for the product keyword

If you want to look for all the smartphones, just write the word in the “Contains keyword” field and your products will be filtered.

d) Enable the advanced filters

This is part of the Search tool and helps you search for the products in more detail.

In this case it will help you filter the products running out of stock.

e) Look for the products running out of stock

For example, if a product has less than 10 items in stock, you may want to feature them, so to look for them you need to set these values in the search:

  • Write _stock in “Field key”.
  • Select the <= symbol in “Operator”.
  • Write the quantity in “Value” (10 for example).
  • Hit the “Run search” button.

f) Feature the product

After you’ve filtered the products, you need to feature them, so you need to follow these steps.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Is featured?” as the field you want to edit.
  • Select “Set value” as the type of edit you’ll apply.
  • Write “yes” in the Replace the existing value with this value” field.
  • Hit the “Execute now” button.
  • Done!

Now all the products were updated, even if they were thousands.

If you want to feature all the running-out-of-stock products within a category, you need to follow these steps.

a) Open the Apply Changes in bulk tool

This tool helps you apply changes to hundreds of products, so you need to open it by clicking it above the spreadsheet.

b) Click the “Select rows” button

The “Select rows” button opens a search tool that helps you filter your products.

c) Look for the product category

If you want to look for all the products within the Technology category, just write the category in the “Enter product category” field and your products will be filtered.

d) Enable the advanced filters

These filters will help you filter the products running out of stock.

e) Look for the products running out of stock

For example, if a product has less than 10 items in stock, you may want to feature them, so to look for them you need to set these values in the search:

  • Write _stock in “Field key”.
  • Select the <= symbol in “Operator”.
  • Write the quantity in “Value” (10 for example).
  • Hit the “Run search” button.

f) Feature the product

After you’ve filtered the products, you need to feature them, so you need to follow these steps.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Is featured?” as the field you want to edit.
  • Select “Set value” as the type of edit you’ll apply.
  • Write “yes” in the Replace the existing value with this value” field.
  • Hit the “Execute now” button.
  • Done!

If you want to feature all the “blue” products running out of stock, you need to do this:

a) Open the Apply Changes in bulk tool

This tool helps you apply changes to hundreds of products, so you need to open it by clicking it above the spreadsheet.

b) Click the “Select rows” button

This button opens a search tool that helps you filter your products.

c) Look for the product attribute

If you want to look for all the blue products, just write the attribute in the “Enter product attribute” field and your products will be filtered.

d) Enable the advanced filters

This is part of the Search tool and helps you search for the products in more detail.

In this case it will help you filter the products running out of stock.

e) Look for the products running out of stock

For example, if a product has less than 10 items in stock, you may want to feature them, so to look for them you need to set these values in the search:

  • Write _stock in “Field key”.
  • Select the <= symbol in “Operator”.
  • Write the quantity in “Value” (10 for example).
  • Hit the “Run search” button.

f) Feature the product

After you’ve filtered the products, you need to feature them, so you need to follow these steps.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Is featured?” as the field you want to edit.
  • Select “Set value” as the type of edit you’ll apply.
  • Write “yes” in the Replace the existing value with this value” field.
  • Hit the “Execute now” button.
  • Done!

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:

- or - Read more about it

Leave a Reply