How to Bulk Edit WooCommerce Product Prices?

For stores with variable products, it gets more complicated. One product can have multiple prices, sizes, colors, or materials, and each variation may need its own update.

Editing these prices one by one quickly becomes slow and error-prone.

This guide explains how to bulk edit WooCommerce product and variation prices, what WooCommerce can handle by default, and when a grid-based editor makes the job much faster for larger catalogs.

Why editing WooCommerce prices can get confusing

WooCommerce stores prices in two places:

Product price: used for simple products with one price.
Variation price: used when a product has attributes like size, color, or material.

If a product has variations, each variation has its own price.

That means updating the main product price won’t automatically update the variation prices.

Product type	What you need to edit
Simple products	Product price
Variable products (size, color, etc.)	Individual variation prices

Now let’s see how WooCommerce lets you edit these prices by default.

How to bulk edit WooCommerce product prices (default method)?

WooCommerce includes a built-in bulk editor.

It covers the basics, but has meaningful limitations for stores with variable products.

Editing the price of a single product

Go to WordPress admin > Products > All Products.
Open the product you want to edit.
Under Product data > General, you’ll see two fields:
- Regular price – the standard price.
- Sale price – the discounted price.
Click Update to save the changes.

Quick tip: You can also use Quick Edit from the product list to change the regular or sale price without opening the full product page.

Bulk editing prices for multiple products

WooCommerce also has a simple bulk editor for updating several products at once.

Go to WordPress admin > Products > All Products.
Select the products you want to update.
Click Bulk actions > Edit > Apply.
WooCommerce opens the Bulk Edit panel.
Here you can update pricing fields such as:
- Price
  - Change to
  - Increase existing price by (% or amount)
  - Decrease existing price by (% or amount)
- Sale
  - Change to
  - Increase existing sale price
  - Decrease existing sale price
  - Set to regular price decrease by
Click Update to apply the changes.

This method works well when you’re updating simple product prices across multiple products.

Where WooCommerce handles pricing well (and where it doesn’t)

The default bulk editor works fine when:

you manage simple products
you’re updating a small number of items
the change is the same across products

However, this bulk editor mainly updates simple product prices. It doesn’t directly update individual variation prices across multiple products.

That means you must open each product and edit its variations manually.

And that’s where price management starts getting slow.

Bulk edit WooCommerce product and variation prices using Smart Manager

WooCommerce’s bulk editor works, but only up to a point.

Once you start managing variable products, large catalogs, or pricing rules, things quickly become tedious.

This is where a bulk editing tool like Smart Manager becomes useful

Instead of opening products one by one, Smart Manager gives you an Excel-like product dashboard inside WordPress.

You can view and edit all product data, including product prices and variation prices, from one screen.

No jumping between product pages. No endless clicking.

Just search, filter, and edit directly in a grid.

What makes Smart Manager powerful for price management

Smart Manager turns price editing into a fast, controlled process.

With it, you can:

Bulk edit regular price and sale price across products
Bulk edit variation prices across multiple products
Increase or decrease prices by percentage or fixed value
Update prices for selected products only
Filter products by category, attribute, price range, or stock
Edit prices directly in the grid (inline editing)
Undo bulk edits if something goes wrong
Schedule pricing changes for later

This means you can manage hundreds or even thousands of product prices in minutes.

Instead of opening product pages one by one, you simply filter the products you want and update their prices in bulk.

Now let’s look at some real situations where store owners use Smart Manager to manage pricing faster.

Real store use cases for bulk editing prices

Once you have a grid-based editor like Smart Manager, updating prices becomes much easier.

Instead of editing products individually, you can filter the products you need and update them in bulk.

Here are some common scenarios store owners deal with.

How to set the sale price x% lower than regular price for multiple products at once?

Say you want to run a storewide sale — 20% off everything. Here’s how to set it up:

Go to Smart Manager > Products Price List dashboard.
Click on the header checkbox to select all the products and click on Bulk Edit.
You will have two options: New Action and Select from Presets. Now select New Action.
You will see a slide-over panel. In the Actions option, set the rules as Sale price > set to regular price and decrease by % > 20.
Now click on Apply Changes.

Smart Manager sets the regular price (if missing) and applies the % discount, all in one shot.

How to increase the price for all products containing a specific attribute?

Let’s say you sell T-shirts. Now suddenly, the “100% Organic Cotton” ones are getting all the attention.

Because who doesn’t want to save the planet and look good doing it?

It’s time to ride the green wave and give these premium pieces a price lift. Here’s how:

Head to Smart Manager > Products Price List dashboard.
Click on Advanced Search.
Now set the rules as: Attributes: Fabric > is > 100% Organic Cotton.
Click Search.
Select all the filtered products.
Use Bulk Edit to bump up the price, as shown before.

And you are done.

How to increase prices for high-value product variations

Sometimes you may want to adjust prices only for premium variations.

For example, increase prices for products where the highest variation price is above $100.

Here’s how:

Go to Smart Manager > Products Price List dashboard.
Click Advanced Search.
In the first dropdown, select Max Variation Regular Price.
Set the condition to greater than.
Enter 100 as the value.
Click Search.
Select the filtered products.
Click Bulk Edit.
Set the rules: Regular price > Increase by > 5%.
Now click on Apply Changes.

Now only products with higher-value variations will get the price increase.

Try the live demo

How to increase the price for all products containing a specific category?

Say you’re a skincare seller and “Ceramide-Infused” is the new buzzword — thanks to that one influencer who swears it fixed their entire life.

Now, everything with that ceramide tag needs a little price glow-up. Here’s how to do that:

Go to Smart Manager > Products Price List dashboard.
Select Advanced Search. A slide-up panel will open.
Here in the first option, select Category.
Keep the second option as is.
Next, in the third option, select Ceramides from the drop-down.
Click on Search.
Now all the products from the said category would show up.
Just select them and bulk edit their price as explained before.

And just like that, your trendy ceramide collection is now 20% more expensive — and still 100% sold out.

How to update variation prices for premium sizes?

Many stores price larger sizes slightly higher because they require more material.

For example, a clothing store may want to increase prices of XL and XXL variations by $3 across all products.

Here’s how to do it using Smart Manager:

Go to Smart Manager > Products Price List dashboard.
Click Advanced Search.
In the search filters, set the rule: Attributes: size > is > choose the values XL and XXL.
Click Search to filter the matching variations.
Select the filtered rows.
Click Bulk Edit.
Choose the action:
Regular price > Increase by > 3.
Now click on Apply Changes.

All XL and XXL variations across products will now have the updated price.

How to increase prices for products that come back in stock?

Sometimes products go out of stock because of high demand. When they are restocked, many stores slightly increase the price.

For example, if a product sells out quickly, you may decide to increase its price by 5% once it’s back in stock.

Here’s how to do it:

Go to Smart Manager > Products Price List dashboard.
Click Advanced Search.
Set the filter: Stock status > is > In stock.
Click Search.
Select the filtered products.
Click Bulk Edit.
Set the rule: Regular price > increase by % > 5.
Now click on Apply Changes.

Now all restocked products will have the updated price.

How to increase prices for products above a specific price?

Sometimes you only want to update prices for premium products.

For example, if supplier costs increase, you may decide to increase prices of products above $100 by 10%.

Here’s how to do it:

Go to Smart Manager > Products Price List dashboard.
Click Advanced Search.
Set the filters:
- Regular price > greater than > 100
- Click Search.
Select the filtered products.
Click Bulk Edit.
Set the rule:
- Regular price > increase by % > 10.
Click Update.

Now only products above $100 get the price increase.

How to correct pricing errors?

Let’s say you sell premium home decor, vases, lamps, statement mirrors, etc.

Everything is smooth until one little typo later, your $300 mirror is listed at $30. Guess who’s crying? (Hint: it’s not the customer.)

Here’s how to fix it faster than your heart rate after noticing the mistake:

Go to Smart Manager > Products Price List dashboard.
Now you will see a Search option at the top.
Type mirror and click on enter. You will see all of your mirror products.
Next, locate the product, click on the regular price cell and update it to $300.

That’s it. Now just sit and wish no one noticed this and order this yet.

How to set prices for the future?

Imagine you run an electronics store and a new version of your bestselling noise-cancelling headphone collection just dropped. Now, you want to run a product launch sale for an hour and give an exclusive 10% discount.

Here’s how to do this in minutes:

Go to Smart Manager > Product dashboard.
Search and select the new headphone models.
Now click on Bulk edit.
Under Actions, select Regular price from the drop-down.
In the next option, select decrease by %.
In the last option, add the value, i.e., 10.
Now click on Apply Changes and then click on Yes.
A new popup will open. Here you need to give your task a title so that you can easily undo the changes if it’s a mistake.
In the same, you have to enable the Schedule this bulk edit option.
Now you can set the exact date and time for the bulk edit.
And click Ok.

Voila! You’ve got your discount running exactly when you want it, without waking up to update prices at 2 AM.

Now, if you can revert the prices after the promotion ends by simply using the Undo feature. Here’s how to do that:

First click on reverse clock icon next to Export option.
Now, the list of all bulk edit and inline edits tasks will be listed.
Here select the task and click on the Undo button located on the top bar above the grid.
You will see two options: Selected tasks and All tasks.
Choose selected tasks.

And that’s it. The prices would go back to as it was before the sale.

Stop playing whack-a-mole with product prices

Updating WooCommerce product prices is easy when you have only a few products.

But once your catalog grows, especially with variable products, editing prices manually becomes repetitive and slow.

WooCommerce’s default tools handle basic price edits.

But when you need to update variation prices, categories, or hundreds of products at once, a grid-based editor becomes much more efficient.

Tools like Smart Manager let you filter products, edit prices in bulk, and manage both product and variation pricing from a single screen.

Get Smart Manager plugin

FAQs

Does editing the main product price update variation prices in WooCommerce?

No. In WooCommerce, variable products store prices at the variation level. Updating the main product price does not override individual variation prices.

Each variation needs to be updated separately, or in bulk using a grid-based editor.

Can WooCommerce’s default bulk editor update variation prices?

The default bulk editor in WooCommerce primarily handles simple product prices. It does not provide a direct way to update individual variation prices across multiple products.

For that, you need to edit each variable product individually or use a dedicated bulk editing tool.

Is it possible to increase prices by a percentage for one category only?

Not with WooCommerce’s default tools. The built-in bulk editor applies changes to all selected products without filtering by category.

A tool like Smart Manager lets you filter by category first, then apply percentage-based price changes only to those products.

Can I schedule a price change to go live at a specific time?

WooCommerce does not include native scheduling for price changes.

Smart Manager supports scheduled bulk edits, letting you set a future date and time for price changes to take effect — and undo them afterward if needed.

What happens if I make a bulk pricing mistake?

WooCommerce’s default editor does not include an undo function.

Smart Manager includes a task history that lets you reverse bulk edits by selecting the relevant task and clicking Undo, restoring prices to their pre-edit state.