WooCommerce: Bulk Edit Product Prices in a Spreadsheet

Are you looking for the best way to bulk edit product prices in WooCommerce? In this guide, we will show you how to bulk manage WooCommerce pricing using an intuitive spreadsheet on WordPress. Instead of updating prices manually, we’ll show you how to view and manage your products in one place. You will be able to bulk change product price, increase prices by percentage or amount, decrease prices by percentage or amount, etc.

Managing prices in WooCommerce can be time-consuming. You need to open and edit each product individually. This takes a lot of time and effort. So in this guide, you’ll learn how to save a lot of time and manage prices with efficiency.

Table of Contents

WooCommerce price types

Before jumping into bulk editing WooCommerce prices, it’s important to understand the different types of prices WooCommerce allows you to manage.

By default, WooCommerce includes two main price fields for each product:

Regular Price: This is the standard price of a product. It’s what customers see by default unless a sale price is set. You can edit regular prices in the spreadsheet using the Regular price column.
Sale Price: This is an optional, discounted price. If set, it overrides the regular price during the sale period. WooCommerce also lets you schedule sale prices for specific date ranges, which is useful for running time-limited promotions. You can edit sale prices and dates in the spreadsheet. Just look for the Sale price, Sale start date and Sale end date columns.

The way these prices are managed can vary slightly depending on the product type:

Simple Products have a single set of regular and sale prices.
Variable Products allow each variation (like size or color) to have its own regular and sale prices.
Grouped Products don’t have a price of their own; they pull prices from the individual products in the group.
External/Affiliate Products use a custom price field linked to an external site.

If you’re using plugins like Composite Products, WooCommerce Wholesale Prices, WooCommerce Wholesale Pro, etc., you might also see additional price types. And you can bulk edit all these prices in a spreadsheet.

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

You can also use the Sale price column, as well as the Sale start date and Sale end date columns in order to bulk update sale prices.

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