WooCommerce – How to Bulk Edit Product Prices in a Spreadsheet

Let’s see how to bulk edit WooCommerce product prices using an intuitive spreadsheet on WordPress.

You will agree that having to edit prices on lots of WooCommerce products is difficult.

To modify the price of many products, you normally have to:

1. Open a product
2. Edit the “Price” field
3. Update the product
4. Repeat that process with all the products you need to edit
5. Spend lots of hours, open many product pages, and make a lot of clicks

This is tedious!

You need a price bulk editing plugin that allows you to update WooCommerce product prices without having to spend a lot of time.

Best product price bulk editing plugin for WooCommerce

To edit bulk prices, we will use the WP Sheet Editor – WooCommerce Products plugin.

It will allow you to update WooCommerce product prices and save a lot of time by simplifying the process of managing bulk prices.

With WP Sheet Editor, you can completely streamline your WooCommerce product management.

• Easy product grid editor: Your products are displayed on a simple table view on wp-admin. You can edit prices in the spreadsheet.
• Advanced search: You can use any field as a search filter, so it’s easy to search for products based on price, category, tag, attribute, etc.
• Easy bulk editing: You can edit any field on hundreds of products; in this case, you can bulk update WooCommerce pricing with a few clicks.
• Easy product duplicator: You can duplicate products to create hundreds of products with a few clicks.
• Advanced variation manager: You can display and edit variations on the spreadsheet, create variations for hundreds of products, copy variations between products, etc.
• Easy export and import: We have the most simplified export and import process, and it is compatible with different CSV editors (Excel, Google Sheets, and others).

After installing and activating this product bulk editor for WooCommerce, go to WP Sheet Editor > Edit Products to open the products’ spreadsheet.

You’ll view all your products displayed on a table.

Bulk edit prices in all product types and variations

WooCommerce bulk actions are too limited and only allow you to edit prices on single products.

What if you want to bulk edit variable product prices?

How about if you want to bulk edit prices of variations?

Do you need to modify the prices of grouped products?

You can do all this with WP Sheet Editor, as it is the most advanced bulk editor for WooCommerce.

Edit prices for multiple products using the spreadsheet

If you want to manually bulk update prices in one place, without opening the products one at a time, you can use the Regular Price column to update WooCommerce prices in individual products.

Once you have changed prices in the spreadsheet, click on Save

This is a good way of bulk updating products because you can apply a new price to different products and save once.

But if you want to edit hundreds or thousands of WooCommerce prices, here’s how you can do it using the Bulk Edit tool:

Bulk edit WooCommerce prices

Editing prices using the spreadsheet is great, but you can also use the bulk editor for bulk update product pricing.

Here are the steps you need to follow to bulk update product prices:

Step 1 – Select the products you will bulk edit

You have three options to select the products whose products you’ll bulk change.

First, you can edit all your products (go to the next step if you want to update all WooCommerce prices in bulk).

Second, you can manually select the products by ticking each product’s checkbox in the spreadsheet’s first column.

Third, you can search for products by:

• price
• keyword
• category
• attribute
• tag
• regular price
• sale price
• status
• shipping class
• etc.

You just need to open the Search tool that is in the toolbar.

Once you open the Search tool, you can find your WooCommerce products by keyword, category, attribute, etc.

For example, if you want to bulk update prices for all the products containing the “shoes” keyword, you can insert that word in the Contains keyword field and then click Run search.

Once you run the search, all the products matching the search terms will be displayed on the spreadsheet.

After selecting the products you will update, you can proceed to bulk modify prices.

Step 2 – Bulk edit WooCommerce product prices

Once you have selected all the products whose prices you want to bulk edit, you can open the Bulk Edit tool, which allows you to edit hundreds or thousands of products with a few clicks.

After opening the Bulk Edit tool, you can follow any of the sections below to change the product prices:

a) Bulk set the same price for all selected products

To change product prices in bulk and set the same price for all the selected products at once, you can to enter the following values:

• Select the rows that you want to update: This will depend on how you selected the products to bulk update their prices (all products, all search results, manually selected products).
• What field do you want to edit: Regular Price
• Select type of edit: Set value
• Replace existing value with a new value: You need to enter the new price.
• Click on Execute now

After applying the new price to all the selected products, you’ll see that all the prices have been bulk updated.

b) Bulk increase specific amount to product prices

In case you want to bulk increase a specific amount to your current product prices, select these options:

• Select the rows that you want to update: This will depend on how you selected the products to bulk update their prices (all products, all search results, manually selected products).
• What field do you want to edit: Regular Price
• Select type of edit: Increase by number
• Replace existing value with a new value: You need to enter the amount you want to increase to the current prices without any sign.
• Click on Execute now

c) Bulk increase a specific percentage to prices

If what you need is to add a percentage to your current product prices, you can enter these values:

• Select the rows that you want to update: This will depend on how you selected the products to bulk update their prices (all products, all search results, manually selected products).
• What field do you want to edit: Regular Price
• Select type of edit: Increase by percentage
• Replace existing value with a new value: You need to enter the percentage you want to increase to the current prices without any sign.
• Click on Execute now

d) Bulk decrease product prices by number

On the contrary, if what you want is to decrease the product prices, you can easily do it by following these steps:

• Select the rows that you want to update: This will depend on how you selected the products to bulk update their prices (all products, all search results, manually selected products).
• What field do you want to edit: Regular Price
• Select type of edit: Decrease by number
• Replace existing value with a new value: You need to enter the amount you want to decrease to the current prices without any sign.
• Click on Execute now

e) Bulk decrease product price by percentage

Or you can enter these values to decrease a percentage from your product prices:

• Select the rows that you want to update: This will depend on how you selected the products to bulk update their prices (all products, all search results, manually selected products).
• What field do you want to edit: Regular Price
• Select type of edit: Decrease by percentage
• Replace existing value with a new value: You need to enter the percentage you want to decrease to the current prices without any sign.
• Click on Execute now

Tutorial: Bulk edit WooCommerce variation prices

Tutorial: Bulk edit sale prices and dates

Conclusion

With WP Sheet Editor, you can bulk edit hundreds of WooCommerce product prices in different ways with just a few clicks.

You just have to select the products you want to edit, and bulk update their prices using the Bulk Edit tool.

You can also bulk-change prices by editing the spreadsheet and saving changes.

Are you ready to start managing product prices more effectively and productively?