WooCommerce – Apply Discounts on Thousands of Products Quickly

posted in: Guides | 0

Sometimes your client wants you to put hundreds of products on sale. It could be christmas season, black friday season, or any holiday.

For example he can ask you to put all the smartphones or all the shoes on sale for a season. But how do you do it if you have 200 smartphones or 1500 T-Shirts? How do you put all the small green shirts on sale? Do you do it one by one?

We’re sure it will take you lots of hours to put all those products on sale, but don’t worry.

In this article we’ll show you how you can quickly put hundreds of products on sale.

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.

Put individual products on sale quickly

Once you have opened the plugin, you can put individual products on sale by using the spreadsheet.

For this you just need to locate the “Sale price” column and add the sale prices. You can also define the time range the products will be on sale by writing it on the “Sales price date from” and the “Sales price date to” columns.

a) Write a sale price

To add a new sale price, you have to go to the “Sale Price” column and add the new prices to individual products by writing the price on the “Sale rice” column. You can edit quickly using your keyboard.

b) Define the date range you want your products to be on sale (optional)

For example you may want to put products 1, 3, and 5 on sale for a week, so you need to define those dates on the “Sales price date from” and “Sales price date to” columns.

Of course, you can put products on sale and not define a specific time, leaving your products to be on sale for an undefined time. But most of the time that’s not the case, so we’ve added the date range columns.

After you’ve defined the time range, just hit the “Save” button above the spreadsheet and that’s it.

If you want to put hundreds of products on sale with just some clicks, then you need to use the “Apply changes in bulk” tool.

This tool helps you apply changes to all your products or to groups of products, depending on how you filter the information.

To open this tool you just need to click it.

For example you may want to put all the smartphones on sale, you need to open the “Apply changes in bulk” tool and hit the “Select rows” button.

Once you’re in Select rows, you need to look for the product keyword.

  • Write the keyword (Smartphone) in the “Contains keyword” field.
  • Hit the “Run search” button.

After you’ve filtered your products by keyword, you need to go on and set the following values.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select the “Sale Price” column in the field you want to edit.
  • Add the new sale price ($9.99 for example)
  • Hit the “Execute now” button, and ready.

If you want to filter your products to apply changes only to the products within the Clothes category, then you need to open the “Apply changes in bulk” tool and hit the “Select rows” button.

Once there, it’s a piece of cake to find the category.

  • Write the product category in the “Enter product category” field. For example you can look for the “Clothes” category.
  • Hit the “Run search” button.

After you’ve filtered your products by keyword, you need to go on and set the following values.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select the “Sale Price” column in the field you want to edit.
  • Add the new sale price ($9.99, for example)
  • Hit the “Execute now” button, and ready.

If your client has asked you to put the red products on sale, then you need to filter the products by attribute.

For this, open the “Apply changes in bulk” tool and then hit the “Select rows” button.

Then follow these two simple steps.

  • Write the product attribute in the Enter product attribute field. For example you can look for the red products.
  • Hit the Run search button.

After you’ve searched for the red products, you need to go on and set the following values.

  • Confirm that you understand your products will be updated.
  • Select the Sale Price column in the field you want to edit.
  • Add the new sale price ($9.99, for example)
  • Hit the “Execute now” button, and that’s all. Easy, right?

If you sell downloadable products like software, plugins, music, etc., then you may want to put those products on sale. With Sheet Editor you can do that as well.

For that, just open the Apply changes in bulk tool and then hit the Select rows button.

To search for the downloadable products, check the Enable advanced filters checkbox.

Once you enable the advanced filters, you need to do this to search for the downloadable products:

  • Write _downloadable in “Field key”.
  • Make sure you have the equality sign in Operator.
  • Write “yes” in Value.
  • Hit the “Run search” button.

After searching for the downloadable products, you need to go on and set the following values.

  • Confirm that you understand your products will be updated.
  • Select the Sale Price column in the field you want to edit.
  • Add the new sale price ($99.99, for example)
  • Hit the “Execute now” button, and that’s all.

It’s a snap, isn’t it?

With Sheet Editor you can put hundreds or thousands of products on sale with just some clicks.

You can download the plugin here:

- or - Read more about it

Leave a Reply