WooCommerce – How to Bulk Edit Product Prices in a Spreadsheet

Let’s see how to bulk edit product prices in WooCommerce. Instead of updating prices manually, you’ll use an intuitive spreadsheet bulk editor that allows you to manage thousands of items at once.

Managing product prices in WooCommerce is difficult, especially when dealing with a large inventory. If you do it the normal way, you know that updating prices involves editing each product individually. But this process is tedious and prone to errors.

This is where WP Sheet Editor can help you a lot. This WooCommerce bulk editor transforms your WooCommerce product management by allowing bulk edits through an intuitive spreadsheet interface.

Table of Contents

Best product price bulk editing plugin for WooCommerce

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

It allows 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 simplify your WooCommerce product management.

Easy product bulk editor: Your products are displayed on a simple spreadsheet 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 items; 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).

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Check the features

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 simple products.

What 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.

Option 1 – Bulk edit prices in 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, keep reading the following sections of this tutorial.

Option 2 – Bulk edit prices with the “Bulk Edit” tool

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.

search for woocommerce products by keyword

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

Option 3 – Bulk export and import prices

You can bulk update WooCommerce prices by exporting and importing products using a CSV file. In this example, we will show you how to export the products, edit the prices in a CSV file, and import the prices back to update the pricing of your products in bulk.

You need to start by opening the Export tool.