Posted on Leave a comment

How to Bulk Edit WooCommerce Products

Bulk Edit WooCommerce Products

WooCommerce is a great tool for building any kind of eCommerce store. However, one of the functionalities that it dearly lacks is the ability to bulk edit products, by default. In this article, we will look at various solutions that you can use to bulk edit WooCommerce products.

There is a bulk edit feature built into WooCommerce, however, it is limited in functionality and limited to the number of products you can edit using it. With the built-in bulk editor, you cannot edit several product properties. If you have a large store with many products it can be very tiresome to edit each individual product. The only solution then is plugins.

Here are 2 plugins that we will review in this article:

  1. Elex WooCommerce Advanced Bulk Edit
  2. Bulk Price Converter for WooCommerce

1. Elex WooCommerce Advanced Bulk Edit

ELEX WooCommerce Advanced Bulk Edit Products, Prices & Attributes

You will need to download and install the plugin. If you are unsure about installing a plugin you can refer to our tutorial.

Step 1: Filter products

Once the plugin has been activated you will be redirected to the filter products screen as shown below.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Filter products

Here there are several product properties that you can use to filter products that you want to edit. For example, you can filter by title, product type, categories, price, and attributes. You can also add exclusions, by product ID and categories to remove unnecessary products from the filtered list.

For variable products, you will have the option to filter by global or custom attributes.

Once you choose the relevant filters click on Preview Filtered Products.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Filter products - Preview Filtered Products

Step 2: Previewing filtered products

When you get the preview of the products you had filtered, you can now make necessary changes to the filters. You can go back to the filters screen if you find unnecessary products that you don’t need to edit by clicking on the back button.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Back button

If you would like to exclude certain products, you can simply uncheck them.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Checkboxes

Once you are satisfied with the list of products that you want to edit, click on Continue.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Continue button

Step 3: Start a bulk edit

On the edit products tab, there are several product attributes that you can edit. A full list is shown below.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Edit products

There are several different options in each attribute as well. For example, in the title, you can set a new one, append text, prepend text, and replace.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Edit products - Title

Similarly, you can easily change the shipping class and all other product attributes that you can see.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Edit products - Shipping class

You can manage the price, stock, weight and dimensions, tax, attributes, categories, and several other product options easily from this tab.

For illustration purposes, we will prepend the words “White and” to the titles of the product.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Edit products - Prepend title

Once you are done making your changes, click on Update Products at the bottom of the page.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Update products

You will be prompted to confirm the changes. Click on Yes, Update.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Update products - Confirmation

Once the changes are complete you will get a notification as shown below.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Products updated

Click on Continue.

If we now check the products in WooCommerce you will see that the product titles have been updated. An example is shown below.

How to Bulk Edit WooCommerce Products - Elex WooCommerce Advanced Bulk Edit - Product titles updated

Although we updated only 2 products in the example above you can use the plugin to update thousands of products at one go. We used the free version of the plugin, however, there is a premium version that is available. The premium version has several additional features that make it a complete all in one solution for anyone looking to bulk update WooCommerce products. Some of the premium features include:

  • Support for variable product updates
  • Support for bulk editing individual variations
  • Support for bulk editing of WooCommerce External products
  • Scheduling of bulk updates
  • Revert back options
  • Scheduling of revert back option
  • Premium support and updates

The premium version of the plugin costs $79 for a single site, $119 for up to 5 sites, and $199 for up to 25 sites.

2. Bulk Price Converter for WooCommerce

Bulk Price Converter for WooCommerce

As the name suggests this plugin allows you to bulk update WooCommerce product prices. The plugin is a simple and easy to use solution for anyone looking to change product prices to a fixed price, add & subtract a fixed amount, or multiply & divide product prices.

Step 1: Access the plugin settings

Once you activate the plugin you will find a new menu item in your WordPress dashboard under the WooCommerce menu called Bulk Price Converter. Click on it to open the plugin’s settings.

How to Bulk Edit WooCommerce Products - Bulk Price Converter for WooCommerce - Menu

Step 2: Configuring a price update

On the next screen, you will find all the options that you can configure related to pricing of your WooCommerce products.

Under the general options, there are 4 fields.

  1. Direct price – this will change all the product prices to the amount you set here. For example, if you set it at $20 all products will be priced at $20.
  2. Multiply all products by – this will change the product prices by the multiple you set here. For example, if you set it as 2 it will double all the product prices.
  3. Add to all products – this will add the amount you set here to all products. For example, if you set it at $5 the prices for all the products will be raised by $5.
  4. Price type to modify – Allows you to select if you want to modify the sale prices or regular prices of products.

Under the product options, you can narrow down the products that you want to update the prices for by category and by tags. This is a feature of the premium version of the plugin.

Under the final price correction section, you can set the rounding off of prices.

How to Bulk Edit WooCommerce Products - Bulk Price Converter for WooCommerce - Options

Once you configure the prices that you want to change, you can either proceed with changing the prices or preview the prices. It is recommended to review the prices first. Click on Preview prices.

How to Bulk Edit WooCommerce Products - Bulk Price Converter for WooCommerce - Preview prices

You will then be able to see the prices that you are changing.

How to Bulk Edit WooCommerce Products - Bulk Price Converter for WooCommerce - Prices previewed

If you are satisfied with the prices you can then proceed and change the prices. Click on Change prices.

How to Bulk Edit WooCommerce Products - Bulk Price Converter for WooCommerce - Change prices

Once completed you should get a notification as shown below.

How to Bulk Edit WooCommerce Products - Bulk Price Converter for WooCommerce - Prices updated

The premium version of the plugin costs $19.99 for a 1-year, single site license. A lifetime license costs $39.99 for 1 site and $59.99 for unlimited sites.

Conclusion

Well, we have gone through 2 plugins that allow you to bulk edit WooCommerce products. There are many similar plugins available. Some focus on a single attribute as we have seen above, for example, the price. Others have more advanced features and can edit several product attributes.

You will need to choose a plugin that fits your purpose and budget.

Leave a Reply

Your email address will not be published. Required fields are marked *