You can bulk edit WooCommerce product prices using WP Sheet Editor, a spreadsheet plugin built for WooCommerce store management. It handles regular prices, sale prices, variation prices, and wholesale prices across hundreds or thousands of products at once using three methods: editing cells directly in the spreadsheet interface, applying a bulk price rule (fixed value, increase or decrease by amount or percentage), or exporting your catalog to CSV for offline editing and reimporting it. This guide walks through all three methods plus several alternative approaches so you can pick the one that matches 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 Is For | Time Required | Requirements |
|---|---|---|---|
| Updates regular prices, sale prices, variation prices, and wholesale prices across your entire WooCommerce catalog in bulk, without opening each product page individually | Store owners and managers changing prices on more than a handful of products at once due to supplier cost changes, promotions, margin adjustments, or seasonal campaigns | 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 well enough for changing the price of one product at a time, but it does not scale beyond that. 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 if 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 (price, category, stock, attributes) appears as a column. Since the entire catalog loads into one screen, you can review and update pricing far faster than clicking through individual product pages, choosing between direct cell edits, a bulk rule, or a CSV import depending on how many products you are updating and how uniform the change is.
How WooCommerce Product Pricing Works
Before bulk editing prices, it helps to understand how WooCommerce stores pricing data and how those fields map to columns in the WP Sheet Editor spreadsheet. Knowing which field controls what helps you pick the right column or bulk rule and avoid changing the wrong value.
WooCommerce includes two primary pricing fields for most products:
- Regular Price: The standard selling price of a 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 lets you schedule sale prices with start and end dates, useful for promotions, seasonal campaigns, flash sales, and limited-time discounts. These map to the Sale price, Sale start date, and Sale end date columns.
How WooCommerce stores that pricing also depends on product type:
- Simple Products: A single regular price and an optional sale price. The easiest type to manage since all pricing data lives in one record.
- Variable Products: Each variation (a specific size, color, or material) can carry its own regular and sale price. On the storefront, WooCommerce displays this as a price range (for example, “$20.00 to $35.00”) until a specific variation is selected. This flexibility is useful, but it makes pricing updates slower in the default 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 or Affiliate Products: These typically use custom pricing fields and send customers to an external site 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 as spreadsheet columns, so the same bulk editing methods in this guide apply to them too.
Compare Your Options at a Glance
Before choosing a method, here is how the main approaches to bulk pricing compare on scope, effort, and where each one falls short.
| Method | Best For | Pros | Cons |
|---|---|---|---|
| Native WooCommerce Bulk Edit | Quick edits to a small number of simple products | No plugin required; already built in | No support for variations; no percentage-based rules; no advanced filtering; does not work for variable product pricing at all |
| WP Sheet Editor — Direct Spreadsheet Edit | A handful of products that each need a different, specific price | See and edit every product on one screen; full control per row; review pricing visually before saving | Not efficient for applying the exact same rule to hundreds of products |
| WP Sheet Editor — Bulk Edit Tool | Applying the same price rule (fixed value, or increase or decrease by amount or percentage) to many or all products at once | Updates thousands of products in one operation; supports advanced filters and variations; works on sale prices too | Requires an active plugin license |
| CSV Export and Import | Offline editing, supplier price lists, formula-based adjustments, or review by multiple team members before changes go live | Works in Excel or Google Sheets; good audit trail; supports complex spreadsheet formulas before import | Slower for frequent small updates; requires careful column mapping; higher risk of import errors if not reviewed |
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 a spreadsheet-based editing interface, advanced filtering, bulk update rules, a variation manager, CSV import and export, and scheduled automated updates.
| Feature | WooCommerce Default | WP Sheet Editor |
|---|---|---|
| Bulk edit simple product prices | Limited | Full control |
| Bulk edit variation prices | No | Yes |
| Increase or decrease by percentage or fixed amount | No | Yes |
| Spreadsheet-based editing | No | Yes |
| Advanced filtering (category, attribute, stock, custom fields) | No | Yes |
| CSV export and import for pricing | Yes (basic) | Yes, with column mapping and preview |
| Scheduled and recurring bulk price updates | No | Yes, via the Automations add-on |
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. Set a fixed price or adjust 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 WP Sheet Editor methods update the same underlying WooCommerce price fields. The right one depends on how many products you are 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 | A few minutes |
| Bulk Edit Prices with the Bulk Edit Tool | Applying the same price rule (fixed price, or an increase or decrease by amount or percentage) to many products at once | A 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. This 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 are 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 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 have 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, making it easy to configure promotional pricing and schedule discounts without opening individual product settings.
Because every edit saves together, this method cuts 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.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
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. This 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. Choose Edit all the rows from my current search when configuring the operation, even if you have not run a search. 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 do not 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. 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. 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. 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. 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. This 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 have 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. This 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. 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 guides 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
Frequently Asked Questions
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 variations alongside their parent products. Once variations are visible, filter for the specific ones you need and apply a price change with 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. See the full 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, the sale price and any scheduled sale dates stay untouched. 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 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.
Can I bulk edit prices only for products in a specific category?
Yes. Use the advanced Search tool to filter by category before opening the Bulk Edit tool, then choose Edit all the rows from my current search. This applies the price rule only to products in that category, leaving the rest of your catalog untouched.
Can I schedule bulk price changes to run automatically?
Yes, with the Automations add-on. It lets you set up recurring bulk price rules. For example, starting a seasonal sale on a set date and reverting prices afterward, without manually running the operation each time.
Does bulk editing WooCommerce prices affect SEO or cached pages?
Bulk editing itself does not change your product URLs, titles, or metadata, so it has no direct SEO impact. However, if your site uses a caching plugin or CDN, shoppers may briefly see the old price until the cache clears, so it is good practice to purge the cache after a large price update.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features