WooCommerce – Apply Discounts on Thousands of Products Quickly

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.

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.

If you want to put individual products on sale in the spreadsheet, you need to go to the Sale Price and write the new sale price in the cells of the products you wish.

OPTIONAL. Define a date range for the sale prices.

WP Sheet Editor allows you to define a time range in which your products will be on sale. For example, you can put them on sale from May the 1st to May 31st of 2019.

For that, just go to the Sale price from column and the Sale price to column, and define the dates.

You can easily put all products containing a keyword on sale, or all products containing a category, etc. You just need to follow these simple steps:

a) Open the Bulk Edit tool

The Bulk Edit tool helps you apply changes to hundreds of products at once. It’s located on the plugin’s toolbar, so just click on it.

b) Filter your products

You can filter your products by keyword, category, attribute, or tag. For that, just select the I want to search rows to update option in the Select the rows that you want to update dropdown.

In the Search tool, you’ll find the following fields to filter your products:

  • Contains keyword – Find all products containing a specific keyword.
  • Status – Draft, Pending review, Private, Published, Trash, Scheduled.
  • Enter Tags – Enter categories, attributes, tags, shipping classes.
  • Click on Run search to filter your products.

c) Set the new sale prices

In the Bulk Edit fields, you need to set these values to add new sales prices to the products filtered:

  • What field do you want to update – Sale Price
  • Select type of edit – Set value
  • Replace existing value with this value – Enter the new sale price
  • Click on Execute now.

You can easily put all downloadable products on sale. Just follow these simple steps:

a) Open the Bulk Edit tool

The Bulk Edit tool helps you apply changes to hundreds of products at once. It’s located on the plugin’s toolbar, so just click on it.

b) Filter all your downloadable products

To filter all the downloadable products, just select the I want to search rows to update option in the Select the rows that you want to update dropdown.

In the Search tool, you need to do this:

  • Tick the Enable advanced filters checkbox and use these values:
    • Field key: Downloadable
    • Operator: =
    • Value: Tick this checkbox.

c) Set the new sale prices

In the Bulk Edit fields, you need to set these values to add new sales prices to the products filtered.

  • What field do you want to update – Sale Price
  • Select type of edit – Set value
  • Replace existing value with this value – Enter the new sale price
  • Click on Execute now.

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:

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