Home » WooCommerce: How to Edit Product Prices in Bulk?

WooCommerce: How to Edit Product Prices in Bulk?

by adminkys

I’m pretty sure that during one of those Black Friday sales all you wanted to do was to apply a bulk discount to your WooCommerce products without having to generate a coupon code.

Let’s not forget that despite coupons are trackable and you can assess your marketing efforts with their usage statistics, requiring the user to take one additional step at checkout (entering the correct coupon code) reduces your sales conversion rate (the same applies with useless checkout fields by the way – less work to do, higher conversion rate).

In today’s post, we’ll see what are the 3 options I recommend in order to apply bulk store discounts. It pretty much depends on your product types (simple vs variable for example) and whether you want to do this via the settings or with a little bit of PHP.

1. Product Price Bulk Editing (WordPress Dashboard)

This is the easiest solution. You can just do this from the “Products” admin page of your WordPress dashboard.


  1. Go to the “Products” admin page
  2. Tick all the products you want to edit the sale price for
  3. Click on Bulk Actions > Edit
  4. Select Sale > “Change to:”
  5. Choose “Set to regular price decreased by fixed amount or %”
  6. Enter e.g. 30%
  7. Update

The problem is that this method only works for simple products, and it won’t change the pricing of variable, grouped or any product with price ranges (min – max).

2. Product Price Bulk Editing (Premium Plugins)

In case your store has many variable products (for example, a fashion WooCommerce store – where each product comes in different sizes, colors, styles…), then the above method won’t work for you.

Thankfully, there are plugins for that. As usual, I’ve chosen WooCommerce plugin vendors based on marketplace reputation, dedicated support quality, code cleanliness, long-term reliability and – probably almost as importantly – where the “people behind” the plugin are active supporters of the WordPress ecosystem.

a. Bulk Table Editor for WooCommerce

Sold on the official WooCommerce marketplace, Bulk Table Editor turns your product admin in an Excel-like product table. You have bulk functions for stock, price, sale price, sale start and end dates – as well as advanced search, filtering and paging functions.

You can also bulk delete products and variations by simply deleting rows in the plugin spreadsheet. It just makes it easy to move items to trash.

Besides, you can bulk clear sale prices and easily set up a bulk store offer in seconds.

Bulk edit WooCommerce products like nobody’s watching!

b. YITH WooCommerce Bulk Product Editing

With a single click, you can automatically apply the same bulk discount to variable and simple products. Or, you can filter by category or do an advanced search so you can find the correct products to edit:

The advanced product filter provided by YITH plugin

3. Programmatically Apply a Coupon (PHP Snippet)

This method is my favorite.

It requires a little PHP that must be placed in your child theme’s functions.php (here’s a free video lesson in case you don’t know how to override WooCommerce the right way).

In this case, the coupon will be automatically applied to the cart once a user goes to the WooCommerce Cart page.

First, you need to create the coupon from WordPress Dashboard > WooCommerce > Coupons. Make sure to set the coupon code with an overall % cart discount (and not a fixed amount), then write down the coupon code as you will need it for the PHP snippet.

After this is done, simply use this snippet: https://businessbloomer.com/woocommerce-apply-coupon-programmatically-product-cart/ (and exactly the “Apply a Coupon Programmatically for ALL Products” version – it’s the second snippet).

Enjoy 🙂

You may also like