WooCommerce – How to Promote your Discounts in the Store

posted in: Guides | 0

When you apply discounts to your products, you need to promote them so that your customers know about it and buy more.

However, if you have hundreds of products at a discount it’s possible that you’ll have trouble promoting them, especially because the normal WP editor doesn’t allow you to do that on hundreds of products.

So in this article, we’ll show you some easy ways to promote all your discounts with just a few clicks.

1- Install WP Sheet Editor

WP Sheet Editor provides a Products Spreadsheet where you can see all the product information and 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- Open the spreadsheet

This spreadsheet shows you the products and their detailed information.

One of the ways in which you can promote your discounts with the WP Sheet Editor plugin is by appending the phrase “On Sale” to your discounted products.

This will help your clients know about your products on sale and you’ll have more opportunities to sell them.

To do that you need to take these simple steps.

a) Open the Apply changes in bulk tool.

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

b) Hit the “Select rows” button.

This button opens a search tool that will help you filter your products to select the ones you need to edit. In this case it will help you filter the products on sale.

c) Look for the products on sale.

As you can see, there are several fields in the search tool that you can use to filter the information. However, in this example you need to enable the advanced filters to look for the products on sale.

You enable them by checking the “Enable advanced filters” checkbox.

Once you open it, you need to set these values to filter the search:

  • Write “_sale_price” in “Field key”
  • Choose the > symbol in “Operator”
  • Write 0 in the Value field
  • Hit the “Run search” button

d) Append “On Sale” to the product titles

After you’ve searched for the products, you need to append the phrase to their titles. For that you need to take these steps:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Title” as the column you want to edit.
  • Select “Append” as the type of edit.
  • Write “ – On Sale” in the “Enter the value to append in the existing value”.
  • Hit the “Execute now” button.

After doing that, you’ll see that all your products on sale will be modified to include “On Sale” on their title.

If you want your clients to know about your products on sale, you can append a short message such as “This product is on sale” to their description.

For this you need to take these steps:

a) Open the “Apply changes in bulk” tool.

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

b) Hit the “Select rows” button.

This button opens a search tool that will help you filter your products to select the ones you need to edit. In this case it will help you filter the products on sale.

c) Look for the products on sale.

As you can see, there are several fields in the search tool that you can use to filter the information. However, in this example you need to enable the advanced filters to look for the products on sale.

You enable them by checking the “Enable advanced filters” checkbox.

Once you open it, you need to set these values to filter the search:

  • Write “_sale_price” in “Field key”
  • Choose the > symbol in “Operator”
  • Write 0 in the Value field
  • Hit the “Run search” button

d) Append “On Sale” to the product excerpts

After you’ve searched for the products, you need to append the phrase to their excerpts. For that you need to take these steps:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Excerpt” as the column you want to edit.
  • Select “Append” as the type of edit.
  • Write “ This product is ON SALE” in the “Enter the value to append in the existing value”.
  • Hit the “Execute now” button.
  • Done!

Another way to promote your discounted products is to feature your products on the product catalog. This will help your customers know which products are discounted.

a) Open the Apply changes in bulk tool.

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

b) Hit the “Select rows” button.

This button opens a search tool that will help you filter your products to select the ones you need to edit. In this case it will help you filter the products on sale.

c) Look for the products on sale.

As you can see, there are several fields in the search tool that you can use to filter the information. However, in this example you need to enable the advanced filters to look for the products on sale.

You enable them by checking the “Enable advanced filters” checkbox.

Once you open it, you need to set these values to filter the search:

  • Write “_sale_price” in “Field key”
  • Choose the > symbol in “Operator”
  • Write 0 in the Value field
  • Hit the “Run search” button

d) Feature your discounted products on the catalog

After you’ve searched for the products on sale, you need to feature them on the catalog. So you need to take these steps:

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

Leave a Reply