WooCommerce bulk price update (programmatically and with a plugin)

Fast changes in WooCommerce are crucial to run your store. The bulk price update for WooCommerce products is one of them. Today, I will show you how to bulk change the product price using default WooCommerce options, programmatically, and with a WooCommerce plugin.

One-by-one product editing may not be the best choice 🙁! Especially if you have hundreds of products and you want to change their data. Is it possible in WooCommerce in a few minutes? Yes and no. It depends.

In this article, you’ll learn 3 methods to edit product prices in WooCommerce 🙂. First, I will tell you about editing products in general. Then, you will see a free plugin to import and update products in WooCommerce. What’s most important, I will give you 3 ways to bulk product price updates: the default WooCommerce editor, programmatically, and with a plugin. Let’s begin 🚀!

Table of contents

• How to edit products in WooCommerce?
• Import and update WooCommerce products faster with a plugin
• Update product price in WooCommerce
  1. Edit product prices in WooCommerce
  2. Change the product price programmatically
  3. Update prices & products with the plugin
• WooCommerce advanced bulk price edit options of the product importer
  • Update and synchronize product prices
  • Use price modifiers (PRO)
  • Advanced conditions for changing prices (PRO)
• Summary

How to edit products in WooCommerce?

First things first. When running your store, you will probably need to edit your products (titles, descriptions, attributes, and prices) sooner or later.

By clicking a specific product in the Products menu you will go to the WooCommerce product edit screen.

It’s the same product editor you can use to add a new product. Make some changes and update the product. That’s it.

Also, you can edit some of the product data faster using the Quick Edit option.

Finally, WooCommerce lets you edit more products at once as well.

For example, if you want to add or change the product category.

But, is there something faster to update product data for all WooCommerce products, including their price? Yes, there is 🙂.

Import and update WooCommerce products faster with a plugin

Dropshipping Import Products for WooCommerce is a plugin to let you import and update products in a few minutes. You may download the free plugin below.

After installing the extension, you can add a CSV or XML file with products to your server. Then, you can set up and run the import to update the products by adding or removing certain data.

How to import a file to update products?

1. Create a new import & choose the file

   First, you need to add a file to your server. Then, add a new import and enter the URL of the product feed (CSV or XML):

   

2. Select the product branch

   Next, choose the appropriate branch with your products.
   

3. Map product fields

   Then, use the plugin drag&drop UI to map data from the feed with the product fields. If you want to omit some fields or attributes, just do not map them. Please remember to map the product names or/ and SKUs.

   

4. Set import options

   Next, configure the last things before uploading the products.
   

   

   Also, choose the product name or SKU to recognize products.

   

   What's important, leave all fields to update or choose only some of the product data to update.

   

5. Start the import

   Finally, start the import to update your WooCommerce products.

   

   If something is missing, you can go always stop the import, go back, and edit the product mapper or import options.

   

Update product price in WooCommerce

The product price is one of the key elements of your products. You can set it in the Product data section when creating or editing the product.

You may set the regular and sale price (also with a schedule for any special offers).

The question is how to edit product prices in WooCommerce effectively! Let's see 3 methods to do that.

Edit product prices in WooCommerce

First, you can edit the price in the product editor:

You may also do it with the Quick Edit option for one product:

And more products (after selecting them and clicking the Edit button):

As you can see, in the Quick Editor you can modify the prices with available options. It may be useful if you want to update the product prices in WooCommerce quickly.

Change the product price programmatically

What about adjusting the product price with a line or two 🙂?

You can do that with WooCommerce hooks and the use of two functions:

update_post_meta() and wc_get_product()

First, you may change the price of a product with this function, for example, update_post_meta( $product_id, '_price', 10 );. You can add such a line to the theme's functions.php file and use it once or build advanced lines based on WooCommerce hooks (actions and filter) to run when you need.

The second function may be better due to WooCommerce's plans to implement HPOS.

For example, here it'd be better to change the product price with:
$product = wc_get_product( $product_id );
$product->set_price( 10 );
$product->save();

Update prices & products with a plugin

There is also the Dropshipping Import Products for the WooCommerce plugin, which I've already mentioned 🙂.

To bulk change the product prices in WooCommerce you need 3 things:

1. An XML or CSV file you use for the import

   Go back and read how to set the import and how to create the product feed.

2. Map the field for the product price and its name (or SKU)

   

3. Finally, make the price updatable in the import options

   

   💡 In the import options, remember to choose the name or SKUs to recognize products during the import.

And that's it! The plugin will run the import and update the product prices quickly 🚀!

WooCommerce advanced bulk price edit options of the product importer

Ok, let's see what options the plugin has to update your WooCommerce products.

Update and synchronize product prices

First, you may just map the field from the product field and run the import to change the price 1:1.

Use price modifiers (PRO)

Also, you can use advanced options when updating the product prices with the plugin.

You will need Dropshipping Import Products for WooCommerce PRO for two additional options.

With the price modifiers, you can adjust the prices by a value or percentage.

Advanced conditions for changing prices (PRO)

Last but not least, you may use conditional logic (advanced rules) for price modifications.

For example, you may want to raise the prices of imported or updated WooCommerce products by $10 for cheap products and 20% for more expensive ones.

But of course, it's possible to modify prices based on any fields from the feed (like categories or attributes) 💪!

As you can see, you may choose conditions to build the advanced system for product price updates 🚀!

Summary

Today, you've seen 3 methods to edit product prices in WooCommerce. Also, how to use a free plugin to import and update products in WooCommerce. Finally, you've learned 3 ways to bulk product price updates: the default WooCommerce editor, programmatically, and with a plugin.

I hope the article was helpful whichever option you use in your store.

Download the free version of the plugin.

You can also go PRO to get all advanced options of Dropshipping Import Products for WooCommerce, including price modifiers and conditional logic, of course 🙂!

If you have any questions let us know.