Bulk editing WooCommerce product prices is difficult with the default tools. WooCommerce does not include advanced pricing controls, so tasks like increasing prices across a category, updating variation prices, or adjusting sale prices for multiple products at once can take a significant amount of time. In this guide, you’ll learn how to bulk edit WooCommerce product prices using WP Sheet Editor.
Managing prices in WooCommerce can be time-consuming. The default product editor requires you to open and edit each product individually, which takes a lot of time and effort when you’re dealing with a large catalog. This guide covers three methods for updating prices in bulk, so you can manage pricing changes with much less manual work.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
After installing and activating the plugin, go to WP Sheet Editor > Edit Products to open the products spreadsheet. You’ll see all your products displayed in a grid with their complete information, where every row is a product and every column is a field.
WooCommerce Price Types
Before getting into the editing methods, it helps to understand the price fields available in WooCommerce and how they appear in the spreadsheet.
By default, WooCommerce includes two main price fields for each product:
- Regular Price: The standard price of a product. This is what customers see unless a sale price is active. You can edit this in the spreadsheet using the Regular price column.
- Sale Price: An optional discounted price that 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 their scheduling in the spreadsheet using the Sale price, Sale start date, and Sale end date columns.
How prices are structured also depends on the product type:
- Simple Products have a single set of regular and sale prices.
- Variable Products allow each variation to have its own regular and sale prices. For example, a t-shirt with sizes S, M, and L can have a different price for each size.
- Grouped Products do not 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, or WooCommerce Wholesale Pro, additional price fields will also appear in the spreadsheet and can be bulk edited using the same methods described in this guide.
Best Plugin to Bulk Edit WooCommerce Product Prices
To bulk edit prices in WooCommerce, we will use the WP Sheet Editor – WooCommerce Products plugin. Here’s how it compares to the default WooCommerce bulk editing tools:
| Feature | WooCommerce Default | WP Sheet Editor |
|---|---|---|
| Bulk edit simple product prices | Limited | Full control |
| Bulk edit variation prices | No | Yes |
| Increase or decrease by % or fixed amount | No | Yes |
| Spreadsheet-based editing | No | Yes |
With WP Sheet Editor, you get a complete set of tools for managing WooCommerce product pricing:
- Spreadsheet product editor: All your products are displayed in a simple spreadsheet view inside wp-admin. You can edit prices directly in the cells the same way you would in Excel or Google Sheets.
- Advanced search: Use any field as a search filter to find products based on price range, category, tag, attribute, shipping class, stock status, and more before applying a price change.
- Bulk editing: Apply price changes to hundreds or thousands of products at once using the Bulk Edit tool. You can set a fixed price, increase or decrease by a number, or apply a percentage adjustment.
- Product duplicator: Duplicate products to create large numbers of similar items quickly.
- Advanced variation manager: Display and edit variations in the spreadsheet, create variations for multiple products, copy variations between products, and update variation prices in bulk.
- Export and import: Export product data to CSV, edit prices in Excel or Google Sheets, and import the file back to update your catalog.
Bulk Edit Prices in All Product Types and Variations
WooCommerce’s default bulk actions are limited and only allow basic price edits on simple products. They don’t support updating variation prices, and they don’t give you the ability to increase or decrease prices by a percentage.
With WP Sheet Editor, you can bulk edit prices across all product types, including variable products and their individual variations. The methods below work for simple products, variable products, and product variations.
If you specifically need to update variation prices, see: How to bulk edit variation prices in WooCommerce.
Method 1: Edit Prices Directly in the Spreadsheet
If you want to manually review and update prices for individual products without applying the same change to all of them, you can edit the Regular price column directly in the spreadsheet. This is useful when each product needs a different specific price rather than a uniform change across a group.
Click on any cell in the Regular price column, type the new value, and move on to the next row. When you have finished making changes, click Save on the toolbar to apply all updates at once.
You can also edit the Sale price, Sale start date, and Sale end date columns the same way to update sale pricing for specific products. This approach lets you apply different prices to different products and save all changes in a single click, rather than saving each product separately.
If you need to apply the same price change to hundreds or thousands of products at once, use Method 2 below.
Method 2: Bulk Edit Prices with the Bulk Edit Tool
The Bulk Edit tool lets you apply a price change to any number of products in a single operation. You can set a fixed price for all selected products, increase or decrease prices by a specific amount, or apply a percentage adjustment. This is the fastest way to update prices across a large portion of your catalog.
Step 1: Select the Products to Update
You have three options for selecting which products to include in the bulk edit.
Option 1: Edit all products. If you want to apply the price change to your entire catalog, you can skip the selection step and proceed to Step 2. In the Bulk Edit tool, select Edit all the rows to target every product in the spreadsheet.
Option 2: Manually select specific products. Tick the checkbox on the left side of each product row you want to include in the bulk edit. This works well when you have a small number of products scattered across different categories or attributes that don’t share a common filter.
Option 3: Filter products using the Search tool. Click Search on the toolbar to open the Search tool and filter products before running the bulk edit. You can filter by:
- Keyword
- Category
- Attribute
- Tag
- Regular price
- Sale price
- Stock status
- Shipping class
- Product status
- And any other product field using the advanced filters
For example, if you want to bulk increase prices for all products containing the keyword “shoes”, enter that word in the Contains keyword field and click Run search.
The spreadsheet will reload showing only the products that match your search criteria. Once you have your target products loaded, open the Bulk Edit tool from the toolbar.
Step 2: Configure the Price Update
Inside the Bulk Edit tool, choose one of the following edit types depending on the type of price change you need to apply. All five options use the Regular Price field. You can apply the same logic to the Sale price field by selecting it instead.
a) Set the Same Price for All Selected Products
Use this option to replace the existing price on all selected products with a single fixed value. This is useful when you want to standardize pricing across a product group, set a launch price for a new line, or reset prices after a sale.
- Select the rows that you want to update: Choose based on how you selected your products in Step 1.
- What field do you want to edit: Regular Price
- Select type of edit: Set value
- Replace existing value with a new value: Enter the new price.
- Click Execute Now.
After the operation completes, the spreadsheet will reload and you’ll see the updated price applied to all affected products.
b) Increase Prices by a Fixed Amount
Use this option to add a specific dollar amount to the current price of every selected product. For example, if you want to increase the price of all products in a category by $5, this is the option to use. The plugin adds the amount to each product’s existing price rather than setting a uniform value.
- Select the rows that you want to update: Choose based on how you selected your products in Step 1.
- What field do you want to edit: Regular Price
- Select type of edit: Increase by number
- Replace existing value with a new value: Enter the amount to add, without any currency sign.
- Click Execute Now.
c) Increase Prices by a Percentage
Use this option to apply a proportional increase to all selected product prices. This is useful when adjusting for supplier cost increases, inflation, or margin adjustments where a flat amount would not scale appropriately across products at different price points. A 10% increase on a $20 product and a $200 product will each produce different results, keeping the relative margins consistent.
- Select the rows that you want to update: Choose based on how you selected your products in Step 1.
- What field do you want to edit: Regular Price
- Select type of edit: Increase by percentage
- Replace existing value with a new value: Enter the percentage to add, without any sign. For example, enter 10 to increase prices by 10%.
- Click Execute Now.
d) Decrease Prices by a Fixed Amount
Use this option to subtract a specific amount from the current price of every selected product. This is useful for applying a fixed discount, passing on a supplier reduction, or clearing older stock by reducing prices by a set amount per product.
- Select the rows that you want to update: Choose based on how you selected your products in Step 1.
- What field do you want to edit: Regular Price
- Select type of edit: Decrease by number
- Replace existing value with a new value: Enter the amount to subtract, without any sign.
- Click Execute Now.
e) Decrease Prices by a Percentage
Use this option to reduce all selected product prices by a percentage. This works well for running a sitewide discount on a category, applying an end-of-season markdown, or reducing prices proportionally across products with different base prices.
- Select the rows that you want to update: Choose based on how you selected your products in Step 1.
- What field do you want to edit: Regular Price
- Select type of edit: Decrease by percentage
- Replace existing value with a new value: Enter the percentage to subtract, without any sign. For example, enter 15 to reduce prices by 15%.
- Click Execute Now.
Method 3: Bulk Export and Import Prices via CSV
If you prefer to edit prices in a spreadsheet application outside of WordPress, you can export your products to a CSV file, update the prices there, and import the file back. For example, to review changes with a team member, work with a supplier’s pricing sheet, or make edits offline.
Start by clicking Export on the toolbar to open the Export tool.
Configure the following settings to export your product prices:
- What columns do you want to export: Select the product name and Regular price columns. You can also include the ID, category, sale price, or any other fields you need for reference.
- Which rows do you want to export: Select all products, or apply a search filter first to export only a targeted subset.
- What app will you use to edit this file: Choose Microsoft Excel 365, Google Sheets, an older version of Excel, or another CSV editor.
- Name of this export (optional): Enter a name to save this export configuration for reuse.
- Click Start new export.
Open the downloaded CSV file in your spreadsheet application and update the values in the Regular price column for the products you want to change. Save the file when done.
Once your prices are updated in the file, return to the products spreadsheet and click Import on the toolbar to open the Import tool.
Configure the following settings in the Import tool:
- Source: CSV file from my computer
- Click Choose File and locate the updated CSV file on your computer.
- Click Next.
On the next screen, choose which columns to import. You can import all columns from the file, or select only the price column if you want to limit the update to pricing data only.
Select whether you want to update existing products, create new ones, or both. In this case, select Update existing items and ignore new items. Set the matching field to product ID so the importer knows which existing product to update for each row in the CSV. Click Next.
The plugin will display a preview of the data about to be imported. Review it to confirm the prices look correct and are mapped to the right columns. If everything looks accurate, click The preview is fine, start import.
The plugin will process the file and update each matched product with the new price values from the CSV. Once finished, you can reload the spreadsheet to verify the updated Regular price column.
Bulk Edit Variation Prices
Bulk Edit Sale Prices and Dates
Bulk Edit Wholesale Prices
This method works for multiple WooCommerce wholesale price plugins.
Add or Remove Decimals from Prices
- How to bulk remove decimals from product prices
- How to add 99-cent pricing to product prices in bulk
Schedule Price Changes in Bulk
With the Automations add-on, you can schedule thousands of bulk price changes to run automatically on a recurring basis. See the guide below for the full setup:
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
FAQ: Bulk Editing WooCommerce Prices
How do I bulk edit product prices in WooCommerce?
You can bulk edit WooCommerce product prices using the WP Sheet Editor – WooCommerce Products plugin. It allows you to increase, decrease, or set a fixed price for thousands of products at once using the Bulk Edit tool, or by editing the Regular price column directly in the spreadsheet.
Can I increase WooCommerce prices by percentage?
Yes. The Bulk Edit tool includes options to increase or decrease prices by a fixed amount or by a percentage. Both options calculate the change relative to each product’s current price, so the result is different for each product rather than applying a single uniform value.
How do I bulk edit variation prices in WooCommerce?
The spreadsheet can display product variations alongside their parent products using the Display variations button. Once variations are visible, you can filter specific ones and apply price changes using the Bulk Edit tool, the same way you would for simple products. See the bulk edit variation prices guide for a full walkthrough.