WooCommerce – How to Bulk Edit Sale Prices and Dates

Let’s see how to bulk edit sale prices in WooCommerce. Unlike the normal way of editing sale prices for products and variations, we will use a product grid editor that allows you to bulk manage prices and sale prices using a spreadsheet on WordPress. This will allow you to save a lot of time by editing bulk sale prices for your WooCommerce products.

Related tutorials:

• Bulk edit product prices (regular price)
• Bulk edit variation prices

Adding sale prices or putting WooCommerce products is necessary for certain seasons like Black Friday, Christmas, Thanksgiving, Valentine’s Day, or any holiday.

For example, you may need to sell all your snow shoes during the winter. But how do you put them all on discount if you have hundreds or thousands of products to edit?

The normal process to add sale prices to your WooCommerce products is something like this:

1. Open one product
2. Add the sale price
3. Add the sale price dates
4. Save the changes
5. Open another product
6. Repeat the process on and on

Assuming it takes you 1 minute to edit each product non-stop, do you have 16 hours to edit the sale prices of your products one by one?

What if you can reduce these 16 hours to 5 minutes?

What if you can bulk update sale prices on thousands of products with a few clicks?

Best bulk editor for WooCommerce sale pricing

Bulk adding sale prices is the best option, and we will show you how to do it using the WP Sheet Editor plugin.

WP Sheet Editor provides many benefits to your productivity with its powerful tools:

• Product grid editor: View your products in a table format on wp-admin and easily modify sale prices using the spreadsheet.
• Search: Utilize any field as a search filter, making it effortless to find products based on criteria such as sale price, category, tag, attribute, and more.
• Bulk editing: Edit any field for numerous products at once, enabling you to update WooCommerce pricing in bulk with just a few clicks.
• Product duplication: Duplicate products and simplify the process of creating hundreds of products with minimal clicks.
• Advanced variation management: Display and edit variations within the spreadsheet, create variations for multiple products, and copy variations between products.
• User-friendly export and import: The most simplified export and import process that is compatible with various CSV editors, including Excel, Google Sheets, and others.

After installing and activating the plugin, follow the steps in the sections below to bulk update sale pricing in WooCommerce.

How to open the spreadsheet to bulk manage sale pricing

Go to WP Sheet Editor > Edit products.

You’ll see a spreadsheet with all your products and their detailed information.

Option 1 – Update sale prices using the spreadsheet

If you want to put individual products on sale using the spreadsheet, you need to use the following columns in the spreadsheet:

• Sale price – Add the sale price here.
• Sale start date – Select the date the sale starts here.
• Sale end date – Select the date the sale ends here.
• Note – Defining sale start and end dates is optional.

Once you have added the sale prices and dates, click on Save.

Editing sale prices in the spreadsheet is a great way to save a lot of time by bulk changing sale prices and dates. You can do it all in one place and don’t have to open products one at a time.

Option 2 – Bulk edit WooCommerce sale prices

If you don’t want to update sale prices using the spreadsheet, you can use the Bulk Edit tool, which allows you to edit thousands of products at once.

Here are some use cases for which using the Bulk Edit tool may be the best option:

• Updating sale pricing for an entire category
• Editing sale prices for products containing specific attributes
• Adding sale prices to low stock products so they sell faster
• Changing sale prices for all downloadable products
• Editing sale pricing for products containing a specific keyword or tag
• Modifying sale prices for all featured products
• And whatever else you want to do!

There are three simple steps for this process.

Step 1 – Select the products whose sale prices you want to bulk update

The first thing you need to do is select which products you will update, and you have three options.

First, you can edit all your products. If you choose this one, you can go to Step 2 below.

Second, you can manually select the products you will edit. Just tick the products using the checkbox selector in the spreadsheet. Once you do that, you can go to Step 2 below.

Third, you can search for the products and edit all the search results.

You can search for products by keyword, category, tag, shipping class, attribute, stock status, price, downloadable, sold individually, tax class, tax status, etc.

For this, you need to open the Search tool.

In this example, we will search for all products within the Dresses category in order to bulk edit sale prices for the entire category.

We need to enter the product category and click on Run search.

As you can see in the screenshot below, we have filtered all the products from the “Dresses” category, and they are displayed on the spreadsheet.

We can view the active search filters above the spreadsheet.

Step 2 – Bulk update WooCommerce sale prices

After selecting the products you want to update, you can proceed to add or modify sale prices in bulk.

Just open the Bulk Edit tool.

Now you need to select these values to bulk add or change sale prices to your products:

• Select the rows that you want to update: What you select here will depend on how you selected the products. You can edit all products, all the results from a specific search, or all manually selected products.
• What field do you want to edit: Sale price
• Select type of edit: You have several options here to bulk update sale prices:
  • Set value: This allows you to set the same sale price to all products.
  • Increase by percentage: This allows you to increase the current sale price by percentage. Example: Increase sale price by 5%.
  • Increase by number: This allows you to increase the current sale price by specific amount. Example: Increase sale price by 5 dollars.
  • Decrease by percentage: This allows you to decrease the current sale price by percentage. Example: Decrease sale price by 5%.
  • Decrease by number: This allows you to decrease the current sale price by specific amount. Example: Decrease sale price by 5%.
  • Copy regular price and decrease by number: It takes the regular price and subtracts the desired amount.
  • Copy regular price and decrease by percentage: It takes the regular price and decreases it by the desired percentage.
• Note – In this example we will copy the regular price and decrease 8 percent.
• Optional – You can edit parent products only or variations only.
• Click on Execute Now.

By selecting these values, you’ll have updated the sale pricing in bulk for all your selected products.

Step 3 – Edit the sale dates in bulk – Optional

After editing the sale price, you can edit the sale dates in bulk.

a) Bulk update the sale start date

You need to open the Bulk Edit again and select the following values to bulk update the sale start date:

• Select the rows that you want to update: What you select here will depend on how you selected the products. You can edit all products, all the results from a specific search, or all manually selected products.
• What field do you want to edit: Sale start date
• Select type of edit: Set value
• Replace existing value with this value: You need to select the date when the sale starts here.
• Optional – You can edit parent products only or variations only.
• Click on Execute Now.

b) Bulk update the sale end date

You need to open the Bulk Edit again and select the following values to bulk update the sale end date:

• Select the rows that you want to update: What you select here will depend on how you selected the products. You can edit all products, all the results from a specific search, or all manually selected products.
• What field do you want to edit: Sale end date
• Select type of edit: Set value
• Replace existing value with this value: You need to select the date when the sale ends here.
• Optional – You can edit parent products only or variations only.
• Click on Execute Now.

With WP Sheet Editor, you can bulk edit sale prices for hundreds of WooCommerce products with a few clicks. You can manage sale pricing using the spreadsheet, or you can bulk update sale price for ell your products, all the search results, or all manually selected products. Besides, you can set the sale dates in bulk.