How To Bulk Change Product Prices in WooCommerce?

We know modifying WooCommerce product prices individually could be time-consuming and monotonous. This could also give rise to the possibility of errors.

Not only could it lead to confusion, but those errors could also damage your reputation among your customers.

So here we list an easy way to opt for WooCommerce mass price changes. Be it for countless products (any WooCommerce product type), based on product categories, attributes or other search filters, you can bulk edit prices at once quickly.

From sale promotions to tackling inflation, the product price needs a mass update.

Let’s see the default way to update product prices (the hard way) and then a smarter, faster and easier way.

How to change product prices in WooCommerce? (Default)

The default settings in WooCommerce can sufficiently help if your store only has very limited products and the prices for only a few items need to be changed.

Edit product price for single product

• Go to your WordPress admin > Products > All Products.
• Then, select the product you want to change the prices for.
• Under Product data, go to the General tab. You get two pricing options:
  1. Regular price: The product’s standard price.
  2. Sale price: The discounted product price. It should be lower than the original product cost.
• Click on Update to save your changes.

Another option is to click on the Quick Edit that appears when you hover over each product name option. Enter the regular price and sale price and update them.

Edit product prices in bulk

You can also apply bulk price changes to the products, but only for simple products.

• Go to WordPress admin > Products > All Products.
• Tick all the products you want to edit the price for, directly or using filters.
• Click on Bulk Actions > Edit > Apply.
• Under Product data > Price, select either of these options:
  • No change.
  • Change to: Enter the required price.
  • Increase existing price by: Raise the price by % or a fixed amount.
  • Decrease existing price by: Lower the price by % or a fixed amount.
• Under Product data > Sale, select either of these options:
  • No change.
  • Change to: Enter the required price.
  • Increase existing sale price by: Raise the price by % or a fixed amount.
  • Decrease existing sale price by: Lower the price by % or a fixed amount.
  • Set to regular price decrease by: The sale price will be calculated based on the reduced regular price by % or a fixed amount.
• Click on Update.

Cons of the default WooCommerce bulk edits

A key point to remember is that you can’t update the prices for variable products, product variations, bundles, subscriptions, groups, or any other product type.

Now here’s an interesting part though. You can select variable products to update prices. But it won’t happen. Strange!

Therefore, if you sell many variable products where each product comes in different sizes, colors, styles, etc. then the above method won’t work for you.

And, if you are doing it for each product one by one, that’s even worse.

Thankfully, there are plugins to ease this work. As usual, we’ve selected the one that is popular, reliable, robust and has quality support. And most importantly, one that makes your life easier.

That WooCommerce extension is Smart Manager.

Smart Manager – The best WooCommerce bulk edit plugin?

Smart Manager helps you save time by applying edits to multiple fields at the same time without accessing each product or post type singularly.

Smart Manager shows all your Products in an Excel-like spreadsheet, so managing them and making bulk edits is simple and quick from a single place.

Be it regular price, sale price, stock, description, featured images, quantity, categories, attributes and other custom product fields, you can edit them directly or in bulk using the spreadsheet.

And, the best part, it works for all WooCommerce product types and even custom ones. So you can bulk edit prices of bookable products, membership products and any custom fields provided by these plugins.

We’ll concentrate more on price fields here.

For example, you can increase or decrease the price of several products with just one click. Be it simple, variable, bundles, etc.

• Go to Smart Manager > Products dashboard. Click on the top header checkbox to select all items available in your store. Or select the ones you want to set or edit prices for.
• Click on Bulk Edit. It will open up a slide-over panel.
• Select Regular price from the drop-down list of select fields.
• In the drop-down of the next option set, you get options to determine the exact product price you want to set:
  • set to sale price
  • set to
  • increase by %
  • decrease by %
  • increase by number
  • decrease by number
  • copy from
  • Copy from field
• In the last drop-down, you can fill in the values.
• Like Regular price, you get the options for Sale price as well.
  • set to regular price
  • set to
  • increase by %
  • decrease by %
  • increase by number
  • decrease by number
  • copy from
  • copy from field
• Click on the + sign, select Sale price field, enter the price change operation and the value. Click on Update.



• Now you’ll get two options – make changes Now or Schedule for later.
• Select the desired option. Enter a title for this task. This helps Undo the changes if required. Click on Ok.

You can immediately see the reflected changes. Quite flexible right?

Try the live demo

How to better control price fields with Smart Manager?

• Bulk edit sale price, regular price, bulk order, SKUs, stock status, product title, gallery images, tax status and more.
• Bulk edit variation prices or any other product type – bundle, affiliate, etc.
• Increase or decrease prices by a fixed amount or percentage in bulk.
• Set the sale price the same as the regular price in bulk.
• Inline edit stock price (direct edit) – no need to go through individual products.
• Bulk edit price of only selected products.
• Update prices based on product categories in bulk.
• Bulk update sign-up fees, recurring fees, etc.
• Add prices in bulk to the products.
• Apply search filters and edit prices of selected products.
• Use price filters to make a change. Say find all products above $200 and decrease their price by 10%.
• Update product price based on the condition – Say increase the price of products belonging to the category clothing and price above $100 by 15%.

That proves how flexible and powerful Smart Manager is.

Smart Manager: Additional features

• Bulk edit any post type – orders, coupons, posts, users, etc.
• Add new products, orders, coupons, blog posts, or other WordPress post types directly using the spreadsheet.
• Change product images for all products in a category.
• Set permissions based on user roles as to who can access particular dashboards and custom views.
• Rename Column headers; Sale Price becomes Discount Price.
• Stocklog allows you to see the history of each product and identify how fast it is moving.
• Undo inline and bulk edits.
• Add custom meta field values.
• Print PDF invoices in bulk or individually and add your brand logo to the invoices.
• Duplicate products, make edits and create variable products quickly with Smart Manager.
• Sort data columns for all post types.
• Export CSV data based on filters.

Get Smart Manager plugin

Bulk editing prices with Smart Manager: Use cases

Here are some use cases where you need to bulk edit product prices:

Seasonal discounts

Easily apply seasonal discounts across your entire product range. Simply select the products or categories you want to discount, set the discount percentage and apply the changes in one go.

Price spikes due to supplier cost

When supplier costs rise, updating prices for hundreds or thousands of products manually can be a nightmare. The Smart Manager plugin lets you adjust prices by a fixed amount or percentage across selected products or categories, ensuring your margins stay intact with minimal effort.

Limited-time offers

Run flash sales or limited-time offers by quickly reducing prices for selected items or entire categories and just as quickly revert them once the sale is over.

Inventory clearance

Clear out old inventory fast by marking down prices in bulk. Select the products you need to move, apply a significant discount and watch your inventory turn over quickly.

New product launch promotions

Promote new product launches with introductory pricing. Use Smart Manager to set special launch prices for new items and adjust them back to regular prices after the promotion period ends.

Pricing corrections

Quickly correct pricing errors across your catalog. If you’ve discovered a mistake in your pricing strategy, check out the Smart Manager plugin to make the necessary adjustments across multiple products or categories in one simple operation, minimizing downtime and customer confusion.

Winding up

Editing multiple products, their price and other post types was very exhausting earlier. But with Smart Manager, it’s a cakewalk.

If you haven’t used Smart Manager yet, it’s high time you begin. It will also help you reduce your workload and cut down on expenses.

Until then, happy growing!

Get Smart Manager plugin

FAQ

How do I update all products at once in WooCommerce?

• Open Smart Manager.
• Go to the Products dashboard.
• Select the header checkbox.
• Open Bulk Edit, select what you want to update – price, stock, description, etc. and click on Update.

What are the other factors that you must consider when changing the prices of your products in WooCommerce?
You must consider the following factors when changing the prices of your products in WooCommerce:

• Shipping
• Discounts
• Costs
• Taxes