How to Bulk Edit WooCommerce Sale Prices in a Spreadsheet

In this tutorial, you will learn how to bulk edit WooCommerce sale prices. You can do this with WooCommerce’s built-in product editor or use WP Sheet Editor.

Before choosing a method, consider what you need to update. The built-in bulk editor in WooCommerce works for sale-price changes to selected products. WP Sheet Editor is useful when you need to filter products, work with variations across your catalog, or update sale dates in bulk. This guide shows how to set a fixed sale price, calculate a discount from the regular price into the sale price, schedule a promotion, and clear sale prices with WP Sheet Editor for WooCommerce Products.

The plugin allows you to edit products from a spreadsheet in your WordPress dashboard:

• Apply a sale price to selected products.
• Calculate discounts from regular prices.
• Edit product variations.
• Set sale start and end dates.
• And clear sale prices when a promotion ends.

To edit regular prices instead, see our guide to bulk editing WooCommerce regular prices.

Editing sale prices with native WooCommerce

WooCommerce includes a bulk editor for changing sale prices on selected products:

1. Go to Products > All Products.
2. Select the products you want to edit.
3. Choose Edit from the Bulk actions menu.
4. Click Apply.
5. In the bulk-edit panel, use the Sale price options to set a value or change the price by a fixed amount or percentage.

You can also schedule sale dates when editing an individual product. For more information about the built-in bulk editor, see WooCommerce’s bulk editing documentation.

The built-in product-list editor is useful for straightforward changes to selected products. But if you need to find products by any search criteria, edit variations across your catalog, or update sale prices and sale dates in a spreadsheet, WP Sheet Editor provides the best workflow without leaving the WordPress dashboard.

Bulk manage sale prices in WP Sheet Editor

Go to WP Sheet Editor > Edit products. to open the spreadsheet. You can click Display variations to load the variations next to their parent products.

Edit sale prices in the spreadsheet

Once you’re in the spreadsheet, you can use these columns to manage sale pricing:

• Sale price: Enter the discounted price.
• Sale start date: Double-click to select the date the sale price begins.
• Sale end date: Double-click to select the date the sale price expires.

Sale start and end dates are optional. If you leave them blank, the sale price remains active until you remove it.

To edit sale prices on product variations across your catalog in WP Sheet Editor:

1. Click Display variations to view variations next to their parent products.
2. Locate the Sale price column.
3. Change the sale prices in the spreadsheet cells. You can also edit the Sale start date and Sale end date columns.
4. Click Save to apply the changes.

Bulk update sale prices in products or variations

Step 1. Select the products you want to edit

You have at least three options to bulk edit your sale prices:

Option 1. Edit sale prices in all the products

If you want to update your entire catalog, you don’t need to filter or select products first. Open the Bulk Edit tool and go to Step 2.

Option 2. Edit specific products selected manually

WP Sheet Editor allows you to manually check the products you want to edit.

After selecting the products, open the Bulk Edit tool and go to Step 2.

Option 3. Edit all the products from a search

The Search tool allows you to filter your products when you want to update products that share a specific value. For example, to find products with a regular price of 45 dollars, filter for Regular price = 45. Or you can edit sale pricing in all products from a specific category, attribute, stock status, etc.

Start by opening the Search tool.

In this example, we will find all products whose regular price is $45, so we will select these values in the Search tool:

• Tick the Enable advanced filters checkbox.
• Field: Regular price
• Operator: =
• Value: 45
• Click Run search.

Optional: If you want to apply the search filters to variations only, tick the Search on variations checkbox. This is useful when you want to edit variations containing a specific attribute, for example.

The spreadsheet will load only the products containing the specific filters you have enabled. Now you can open the Bulk Edit tool and go to Step 2.

Step 2. Bulk update sale prices

In the Bulk Edit tool, set these values to add or update sale prices:

• Select the rows that you want to update: Choose the rows based on how you selected the products: all products, search results, or manual selection.
• What field do you want to edit: Sale price.
• Select type of edit: Choose how to calculate the new sale price:
  • Set value: Apply the same sale price to all selected products, such as $10.00.
  • Increase by percentage / number: Increase the existing sale price by a percentage or fixed amount.
  • Decrease by percentage / number: Decrease the existing sale price by a percentage or fixed amount.
  • Copy regular price and decrease by number: Set the sale price to the regular price minus a fixed amount, such as $2. For example, if a product’s regular price is 20 dollars and you enter 2, the new sale price will be $18.
  • Copy regular price and decrease by percentage: Calculate the sale price by reducing the regular price by a percentage. For example, for a product with a regular price of $50, choose Copy regular price and decrease by percentage, enter 20, and the sale price will be $40.
• Value: Enter the amount or percentage for the selected calculation.
• Select what you want to edit:
  • Edit only parent products
  • Edit only variations
• Click Execute Now.

Optional: Clear WooCommerce sale prices in bulk

If a promotion has no expiration date and you want to end it, it’s useful to clear the Sale price field in bulk. Just select these values in the Bulk Edit tool after selecting the products or variations you want to update:

1. Select the rows that you want to update: Choose the rows based on how you selected the products: all products, search results, or manual selection.
2. What field do you want to edit: Sale price
3. Select type of edit: Clear value
4. Select what you will edit:
   • Edit only parent products
   • Edit only variations
5. Click Execute Now.

Optional: Bulk update sale dates

a) Bulk update the start date

• Select the rows that you want to update: Choose the rows based on how you selected the products: all products, search results, or manual selection.
• What field do you want to edit: Sale start date
• Select type of edit: Set value
• Replace existing value with this value: Select the sale start date.
• Select what you will edit:
  • Edit only parent products
  • Edit only variations
• Click Execute Now.

b) Bulk change sale end date

• Select the rows that you want to update: Choose the rows based on how you selected the products: all products, search results, or manual selection.
• What field do you want to edit: Sale end date
• Select type of edit: Set value
• Replace existing value with this value: Select the sale end date.
• Select what you will edit:
  • Edit only parent products
  • Edit only variations
• Click Execute Now.

That’s how you can bulk update sale prices in WooCommerce products and variations.