You can bulk edit WooCommerce product prices using WP Sheet Editor, a spreadsheet plugin for WooCommerce store management. It lets you update regular prices, sale prices, variation prices, and wholesale prices across hundreds or thousands of products at the same time, either by editing cells directly in a spreadsheet, running a bulk price rule, or exporting your catalog to CSV for offline editing. This guide covers all three methods so you can pick the one that fits the scale and type of price change you need to make.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Quick Summary: Bulk Editing WooCommerce Product Prices
| What It Does | Who It’s For | Time Required | Requirements |
|---|---|---|---|
| Updates regular prices, sale prices, variation prices, and wholesale prices across your WooCommerce catalog in bulk, without editing each product page individually | Store owners and managers who need to change prices on more than a handful of products at once, due to supplier cost changes, promotions, or margin adjustments | A few minutes for direct spreadsheet edits or a bulk rule; longer for CSV workflows depending on catalog size | WP Sheet Editor – WooCommerce Products plugin installed and activated on a WordPress site running WooCommerce |
Table of Contents
WooCommerce’s built-in product editor works fine for changing the price of one product at a time, but it does not scale. Increasing prices across an entire category, adjusting every variation of a variable product, updating sale prices ahead of a promotion, or applying a store-wide price change all require opening and saving each product individually when you rely on the default WooCommerce screens. WP Sheet Editor removes that bottleneck by loading your full product catalog into a spreadsheet, where prices can be edited directly, updated in bulk with a rule, or exported to CSV and reimported.
After installing and activating the plugin, go to WP Sheet Editor > Edit Products to open the products spreadsheet. Every WooCommerce product appears as a row, and every product field, including price, category, stock, and attributes, appears as a column. Because the entire catalog loads into one screen, you can review and update pricing far faster than clicking through individual product pages, and you can choose between editing cells directly, applying a bulk rule, or importing a CSV file depending on how many products you’re updating and how uniform the change is.
WooCommerce Price Types
Before editing WooCommerce prices in bulk, it helps to know how pricing works within WooCommerce and how those fields appear in the WP Sheet Editor spreadsheet. Knowing which field controls what will help you choose the right column or bulk rule and avoid changing the wrong value.
By default, WooCommerce includes two primary pricing fields for most products:
- Regular Price: The standard selling price of a WooCommerce product. Customers see this value whenever no sale price is active. In the spreadsheet, this is the Regular price column.
- Sale Price: An optional discounted price that temporarily overrides the regular price. WooCommerce allows sale prices to be scheduled with start and end dates, which is useful for promotions, seasonal campaigns, flash sales, and limited-time discounts. These are the Sale price, Sale start date, and Sale end date columns.
How WooCommerce stores pricing also depends on the product type:
- Simple Products: A single regular price and an optional sale price. These are the easiest product type to manage because all pricing data lives in one record.
- Variable Products: Each variation, for example a specific size, color, or material, can carry its own regular price and sale price. This flexibility is useful for stores, but it makes pricing updates slower in the default WooCommerce editor since each variation has to be opened separately.
- Grouped Products: These do not hold their own price. Pricing is inherited from the individual products included in the group.
- External/Affiliate Products: These typically use custom pricing fields and send customers to an external website to complete the purchase.
If your store uses extensions such as Composite Products, WooCommerce Wholesale Prices, or WooCommerce Wholesale Pro, those plugins add their own custom price fields to each product. WP Sheet Editor automatically detects and displays these custom fields as spreadsheet columns, so the same bulk editing methods described in this guide apply to them as well.
Why Use WP Sheet Editor to Bulk Update Pricing
WooCommerce’s native bulk editing tools are limited to a handful of basic actions and do not support variation-level pricing or percentage-based adjustments. WP Sheet Editor replaces that with spreadsheet-based editing, advanced filtering, bulk update rules, a variation manager, and CSV import/export.
| 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 |
WP Sheet Editor includes several tools that make WooCommerce price management significantly faster:
- Spreadsheet product editor: View and edit all WooCommerce products in a spreadsheet interface similar to Excel or Google Sheets, updating prices directly inside cells without opening a single product edit screen.
- Advanced search: Filter products by category, tag, attribute, stock status, shipping class, keyword, custom fields, or price range before applying a pricing change.
- Bulk editing: Apply price updates to hundreds or thousands of products in one operation, setting a fixed price or adjusting by a fixed amount or percentage.
- Product duplicator: Duplicate products quickly to build out large catalogs with less manual data entry.
- Advanced variation manager: Show product variations directly in the spreadsheet, edit variation prices, create new variations, and manage variable products in bulk.
- Export and import: Export WooCommerce products to CSV, edit prices in Excel or Google Sheets, and import the updated file back into WordPress.
Which Method Should You Use?
All three methods update the same underlying WooCommerce price fields. The right one depends on how many products you’re changing and whether the change is uniform across them.
| Method | Best For | Time Required |
|---|---|---|
| Edit Prices Directly in the Spreadsheet | A small number of products that each need a different, specific price | Few minutes |
| Bulk Edit Prices with the Bulk Edit Tool | Applying the same price rule (fixed price, or an increase/decrease by amount or percentage) to many products at once | Few minutes |
| Bulk Export and Import Prices via CSV | Offline editing, supplier price lists, formula-based pricing, or review by multiple team members before applying changes | Varies with catalog size |
Bulk Edit Prices in All Product Types and Variations
WooCommerce’s default bulk editing does not provide controls for variable products or individual variations, which is a real limitation for stores with complex catalogs or frequent pricing changes. With WP Sheet Editor, you can bulk edit prices across simple products, variable products, individual variations, wholesale pricing fields, and custom pricing fields added by third-party WooCommerce plugins. The methods below work whether you’re updating a handful of products or an entire catalog.
This is especially useful when supplier costs change, a seasonal promotion needs to launch, or margins need adjusting across a category, since you can update pricing from one spreadsheet screen instead of opening each product.
If your main goal is updating variable product pricing specifically, see: How to bulk edit variation prices in WooCommerce.
Method 1: Edit Prices Directly in the Spreadsheet
If each product needs a unique price rather than a shared rule, editing directly in the spreadsheet is usually the simplest approach. This workflow works well for updating selected products, correcting pricing errors, applying supplier-specific adjustments, or reviewing prices before a promotion goes live. Because every product is visible on one screen, you can move through a catalog much faster than with WooCommerce’s standard editor.
Click any cell in the Regular price column, enter the new value, and continue through the rest of your products. Once you’ve made all the updates you need, click Save in the toolbar to apply every change at once.
You can update the Sale price, Sale start date, and Sale end date columns the same way, which makes it easy to configure promotional pricing and schedule discounts without opening individual product settings.
Because every edit saves together, this method cuts down the time needed to update pricing while keeping full control over each product’s individual value. If you need to apply the same rule across a large group of products instead, use Method 2 below.
Method 2: Bulk Edit Prices with the Bulk Edit Tool
The Bulk Edit tool is the fastest way to update WooCommerce prices when the same rule needs to apply across multiple products. Rather than editing products one by one, a single bulk operation can update hundreds or thousands of products at once.
WP Sheet Editor lets you set a fixed price, increase or decrease by a specific amount, or increase or decrease by a percentage. These rules can apply to all products, manually selected products, or products matching an advanced search. Combining filtering with bulk editing lets you target exactly the products you need without touching the rest of the catalog, which is useful for responding to supplier price increases, adjusting margins, launching a seasonal promotion, or updating pricing for a specific category.
Step 1: Select the Products to Update
Before applying any price change, decide which products should be included. WP Sheet Editor offers a few ways to select products depending on the size and complexity of your catalog.
Option 1: Edit all products. To update your entire WooCommerce catalog, skip any filtering and go straight to the Bulk Edit tool, then choose Edit all the rows from my current search when configuring the operation, even if you haven’t run a search. This is useful for store-wide price increases, inflation adjustments, margin updates across all products, or a universal discount.
Option 2: Manually select specific products. Tick the checkbox beside each product you want to update. This works well when only a small number of products need a price change and those products don’t share a category, tag, or attribute you could filter by.
Option 3: Filter products using the Search tool. This is usually the most efficient approach for large stores. Click Search in the toolbar to open the advanced search interface.
You can filter products using criteria such as:
- Keyword
- Category
- Attribute
- Tag
- Regular price
- Sale price
- Stock status
- Shipping class
- Product status
- Custom fields
- Any other available WooCommerce product field
This makes it possible to build a highly targeted update, for example increasing prices only within one category, only for products below a certain margin, only for products from a particular vendor, or only for products currently on sale.
For example, to update all products related to shoes, enter the keyword shoes in the Contains keyword field and click Run search.
The spreadsheet refreshes to show only the products matching your search. Once the products you want to update are loaded, click Bulk Edit in the toolbar.
Step 2: Configure the Price Update
After opening the Bulk Edit tool, choose the type of pricing adjustment you want. The examples below use the Regular Price field, but the same steps apply to Sale Price and most custom WooCommerce pricing fields.
a) Set the Same Price for All Selected Products
Use this option when every selected product should end up at exactly the same price, replacing existing values regardless of what they currently are. This is useful for standardizing pricing across a product line, launching a new collection at one price point, creating fixed-price bundles, or fixing inconsistent pricing across similar products.
- Select the rows that you want to update: Choose the products identified during 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 fixed price.
- Click Execute Now.
After the operation finishes, the spreadsheet refreshes and shows the updated prices for all affected products.
b) Increase Prices by a Fixed Amount
Use this option to add the same monetary amount to every selected product’s current price, rather than replacing it. This suits situations where a supplier cost rises by a predictable amount, shipping costs go up, or a category needs a consistent markup.
For example, adding $5 to every product in a category raises a $20 product to $25 and a $100 product to $105.
- Select the rows that you want to update: Choose the target products.
- 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 a currency symbol.
- Click Execute Now.
c) Increase Prices by a Percentage
Percentage-based increases scale proportionally across products at different price points, since each product’s increase is calculated from its own current value rather than a flat amount. This is commonly used for inflation adjustments, supplier cost increases, margin improvements, and catalog-wide strategies where relative pricing needs to stay consistent.
For example, a 10% increase raises a $50 product by $5 and a $200 product by $20, so higher-priced products receive a proportionally larger adjustment.
- Select the rows that you want to update: Choose the products identified 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 amount, for example 10 for a 10% increase.
- Click Execute Now.
d) Decrease Prices by a Fixed Amount
Use this option to subtract the same monetary value from every selected product’s current price. This suits fixed-value promotions, clearing excess inventory, passing along lower supplier costs, or making selected products more competitive without restructuring your whole pricing model.
For example, decreasing prices by $10 reduces a $50 product to $40 and a $150 product to $140, with every product receiving the same discount amount regardless of its original price.
- Select the rows that you want to update: Choose the products you want to modify.
- 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 a currency symbol.
- Click Execute Now.
Once the operation completes, WP Sheet Editor updates all selected products and shows the new values directly in the spreadsheet.
e) Decrease Prices by a Percentage
Percentage-based reductions are one of the most common pricing strategies for WooCommerce stores. Instead of reducing every product by the same amount, each product’s discount is calculated from its own current price, which preserves relative pricing across the catalog while giving higher-priced products a larger absolute discount.
For example, a 15% discount reduces a $100 product by $15 and a $500 product by $75.
- Select the rows that you want to update: Choose the products selected during 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 remove, for example 15 to reduce prices by 15%.
- Click Execute Now.
Once the operation finishes, the updated prices apply throughout your WooCommerce store. Depending on your caching setup, you may need to clear your site cache before customers see the new pricing.
Method 3: Bulk Export and Import Prices via CSV
Some store owners prefer to review and update pricing outside WordPress. Exporting products to CSV gives you that flexibility for collaboration, auditing, supplier reviews, or offline editing. You can export WooCommerce products, modify pricing in Excel, Google Sheets, LibreOffice Calc, or another spreadsheet application, then import the updated file back into your store. This is especially useful when pricing changes come from a supplier spreadsheet or when multiple team members are involved in setting prices.
To begin, click Export on the WP Sheet Editor toolbar.
The Export tool lets you customize exactly which products and fields will be included in the CSV file. Configure it as follows:
- What columns do you want to export: Select the product name and Regular price columns. You can also include product ID, category, sale price, SKU, or stock status for reference.
- Which rows do you want to export: Export all products, or apply a search filter first to export only a targeted group.
- What app will you use to edit this file: Choose the spreadsheet application that matches your workflow, such as Microsoft Excel 365 or Google Sheets.
- Name of this export (optional): Save the export configuration if you run similar exports regularly.
- Click Start new export.
After downloading the file, open it in your preferred spreadsheet application and update the Regular price column values. You can edit prices manually, use spreadsheet formulas, calculate percentage increases, apply supplier pricing rules, or review pricing with your team.
Once you’ve finished updating prices, save the CSV file and return to the WooCommerce products spreadsheet in WP Sheet Editor. Click Import in the toolbar to begin.
Configure the import as follows:
- Source: CSV file from my computer
- Click Choose File and select the updated CSV file.
- Click Next.
Next, choose which columns from the CSV file should be imported. If you only want to update pricing, select just the relevant price columns and leave the rest unselected, which reduces the risk of accidentally overwriting unrelated product data.
Choose how existing products should be matched and updated:
- Select Update existing items.
- Ignore new items if your goal is only to update current products.
- Use the product ID as the matching field so WP Sheet Editor identifies the correct WooCommerce products.
- Click Next.
Before importing, WP Sheet Editor generates a preview showing exactly how the incoming data will affect your WooCommerce products. Review it carefully to confirm the correct products, columns, and prices are being updated, since checking this preview is what prevents accidental pricing errors.
If everything looks correct, click The preview is fine, start import. The plugin processes the CSV file, locates the matching WooCommerce products, and updates their pricing automatically.
Once the import finishes, reload the spreadsheet and check the Regular price column to confirm the updates were applied correctly.
Bulk Edit Variation Prices
Bulk Edit Sale Prices and Dates
Bulk Edit Wholesale Prices
This method works with multiple WooCommerce wholesale pricing 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 bulk price changes to run automatically on a recurring basis instead of triggering them manually each time. See the full setup guide below:
- How to schedule automatic bulk price changes in WooCommerce
- How to bulk schedule price and stock changes
- Import WooCommerce prices and stock from FTP server
FAQ: Bulk Editing WooCommerce Prices
How do I bulk edit product prices in WooCommerce?
Install and activate the WP Sheet Editor – WooCommerce Products plugin, then go to WP Sheet Editor > Edit Products to open the spreadsheet view of your catalog. From there you can either edit the Regular price column directly for individual products, or select multiple products and click Bulk Edit to set a fixed price or increase or decrease prices by a fixed amount or percentage across all of them at once.
Can I increase WooCommerce prices by percentage?
Yes. In the WP Sheet Editor Bulk Edit tool, choose Increase by percentage as the type of edit, then enter the percentage amount, for example 10 for a 10% increase. The tool calculates the new price relative to each product’s current price, so a $50 product and a $200 product each receive a proportional increase rather than the same flat amount.
How do I bulk edit variation prices in WooCommerce?
In the WP Sheet Editor products spreadsheet, click the Display variations button to show product variations alongside their parent products. Once variations are visible, you can filter for the specific ones you need and apply a price change using the same Bulk Edit tool used for simple products (making sure to select Edit only variations), either setting a fixed price or adjusting by a fixed amount or percentage. For a full walkthrough, see the bulk edit variation prices guide.
Will bulk editing prices affect products currently on sale?
Bulk price edits only change the field you select. If you choose Regular Price as the field to edit, the sale price and any scheduled sale dates stay untouched. If you want to change sale pricing instead, select Sale Price as the field in the Bulk Edit tool, or use the Sale price, Sale start date, and Sale end date columns directly in the spreadsheet.
Do bulk price changes take effect immediately on my live store?
Yes, price updates made through WP Sheet Editor write directly to the WooCommerce product data, so the new prices apply on your store as soon as the operation finishes. If your site uses a caching plugin or a CDN, you may need to clear the cache for the updated prices to appear immediately for shoppers.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features