You can bulk edit WooCommerce product prices using WP Sheet Editor plugin a spreadsheet WooCommerce management plugin that allows you to update regular prices, sale prices, variation prices, and wholesale prices across hundreds or thousands of products at once. Instead of opening individual product pages one by one, you can edit prices directly in a spreadsheet, apply bulk pricing rules, or export pricing data to a CSV file for offline editing.
WooCommerce includes basic product editing capabilities, but managing prices becomes increasingly difficult as your catalog grows. Tasks such as increasing prices across an entire category, adjusting variation prices, updating sale prices, or applying store-wide pricing changes often require significant manual work when using the default WooCommerce tools. In this guide, you’ll learn three practical methods for bulk editing WooCommerce product prices using WP Sheet Editor, including direct spreadsheet editing, automated bulk updates, and CSV import/export workflows.
Table of Contents
Quick Summary: How to Bulk Edit WooCommerce Prices
| Method | Best For | Time Required |
|---|---|---|
| Edit Prices Directly in the Spreadsheet | Individual price updates | Few minutes |
| Bulk Edit Prices with the Bulk Edit Tool | Large-scale price changes | Few minutes |
| Bulk Export and Import Prices via CSV | Advanced workflows and offline editing | Varies |
These methods work with simple products, variable products, product variations, sale prices, and many custom pricing fields added by WooCommerce extensions. Whether you’re responding to supplier cost increases, running a seasonal promotion, updating wholesale pricing, or restructuring your pricing strategy, WP Sheet Editor provides a much faster workflow than the default WooCommerce product editor.
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. All WooCommerce products are displayed in a spreadsheet view where each row represents a product and each column represents a product field. This allows you to manage product prices, categories, stock levels, attributes, sale dates, and other WooCommerce data from a single screen.
Because the spreadsheet loads product information in bulk, store managers can perform pricing updates much faster than they could using the standard WooCommerce editor. Changes can be applied individually, in bulk, or through CSV imports depending on the workflow that best fits the task.
WooCommerce Price Types
Before editing WooCommerce prices in bulk, it’s important to understand how pricing works within WooCommerce and how those price fields appear in the WP Sheet Editor spreadsheet. Knowing which fields control product pricing will help you choose the correct editing method and avoid unintended changes.
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, you can edit this field using the Regular price column.
- Sale Price: An optional discounted price that temporarily overrides the regular price. WooCommerce allows sale prices to be scheduled using start and end dates, making them useful for promotions, seasonal campaigns, flash sales, and limited-time discounts. You can edit these values using the Sale price, Sale start date, and Sale end date columns.
The way WooCommerce stores pricing information also depends on the product type being used:
- Simple Products: These products contain a single regular price and an optional sale price. They are the easiest product type to manage because all pricing information exists in one record.
- Variable Products: Each variation can have its own regular price and sale price. For example, different sizes, colors, materials, or configurations can all be priced independently. This flexibility is useful but often makes pricing updates more time-consuming when using the default WooCommerce editor.
- Grouped Products: Grouped products do not maintain their own prices. Instead, pricing is determined by the individual products included within the group.
- External/Affiliate Products: These products typically use custom pricing fields while directing customers to an external website for purchase.
If your store uses WooCommerce extensions such as Composite Products, WooCommerce Wholesale Prices, or WooCommerce Wholesale Pro, additional pricing fields may also be available. WP Sheet Editor automatically displays these custom price fields in the spreadsheet, allowing you to apply the same bulk editing methods described throughout this guide.
Why Use WP Sheet Editor to Bulk Update Pricing
Unlike WooCommerce’s built-in bulk editing tools, WP Sheet Editor provides spreadsheet-based product management, advanced filtering, bulk update operations, variation management, and CSV import/export functionality.
| 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 more efficient:
- Spreadsheet product editor: View and edit all WooCommerce products in a spreadsheet interface similar to Excel or Google Sheets. You can update prices directly inside cells without opening product edit screens.
- Advanced search: Filter products using categories, tags, attributes, stock status, shipping classes, keywords, custom fields, and price ranges before applying pricing changes.
- Bulk editing: Apply price updates to hundreds or thousands of products simultaneously. Set fixed prices, increase prices, decrease prices, or adjust prices by percentage.
- Product duplicator: Quickly duplicate products and create large product catalogs with less manual work.
- Advanced variation manager: Display product variations directly in the spreadsheet, update 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.
These capabilities make WP Sheet Editor useful for WooCommerce stores that regularly update pricing, manage supplier price changes, run promotions, maintain wholesale catalogs, or work with large product inventories.
Bulk Edit Prices in All Product Types and Variations
WooCommerce’s default bulk editing features are limited to basic operations and do not provide advanced controls for variable products or individual product variations. This becomes a significant limitation for stores with complex catalogs, multiple product options, or frequent pricing changes.
With WP Sheet Editor, you can bulk edit prices across simple products, variable products, individual variations, wholesale pricing fields, and many custom pricing fields added by third-party WooCommerce plugins. The methods covered below work regardless of whether you’re updating a handful of products or thousands of records at once.
This flexibility is particularly valuable when supplier costs change, seasonal promotions need to be launched, or product margins must be adjusted across an entire catalog. Instead of manually opening each product, you can update pricing data from a centralized spreadsheet interface.
If your primary goal is updating variable product pricing, see: How to bulk edit variation prices in WooCommerce.
Method 1: Edit Prices Directly in the Spreadsheet
If each product requires a unique price, editing prices directly in the spreadsheet is often the simplest approach. Rather than applying the same change across multiple products, this method allows you to review products individually and enter specific values where needed.
This workflow is ideal when updating selected products, correcting pricing errors, implementing supplier-specific pricing adjustments, or reviewing prices before a promotion. Because all products are visible on a single screen, you can move through your catalog much faster than using WooCommerce’s standard editor.
Click any cell in the Regular price column, enter the new value, and continue editing additional products as needed. Once you’ve completed all price updates, click Save in the toolbar to apply every modification simultaneously.
You can also update the Sale price, Sale start date, and Sale end date columns using the same spreadsheet workflow. This makes it easy to configure promotional pricing, schedule discounts, and manage sales campaigns without opening individual product settings.
Because all edits are saved together, this method significantly reduces the time required to update product pricing while maintaining complete control over individual product values. If you need to apply the same pricing rule across large groups of products, continue with 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 pricing rule needs to be applied across multiple products. Instead of editing products individually, you can perform a single bulk operation that updates hundreds or thousands of products at once.
WP Sheet Editor allows you to set fixed prices, increase prices by a specific amount, decrease prices by a specific amount, increase prices by a percentage, or decrease prices by a percentage. These operations can be applied to all products, specific products, filtered products, product variations, or products matching advanced search criteria.
This approach is particularly useful when responding to supplier price increases, adjusting profit margins, launching seasonal promotions, updating category pricing, or applying company-wide pricing strategies. By combining advanced filtering with bulk editing, you can target exactly the products you need to update without affecting the rest of your catalog.
Step 1: Select the Products to Update
Before applying any price change, determine which products should be included in the update. WP Sheet Editor offers several ways to select products depending on the size and complexity of your catalog.
Option 1: Edit all products. If you want to update your entire WooCommerce catalog, you can skip any filtering and proceed directly to the Bulk Edit tool. Simply choose Edit all the rows from my current search when configuring the bulk operation (even if you haven’t performed a search).
This option is useful when implementing store-wide price increases, adjusting prices due to inflation, updating margins across all products, or applying a universal discount.
Option 2: Manually select specific products. Tick the checkbox beside each product you want to update. This method works well when only a small number of products need pricing changes and those products do not share common categories, tags, attributes, or other filtering criteria.
Option 3: Filter products using the Search tool. This is often the most efficient approach when managing large WooCommerce stores. The Search tool allows you to narrow down products based on specific conditions before applying a pricing update.
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 flexibility allows you to create highly targeted pricing updates. For example, you can increase prices only for products within a specific category, products below a certain margin threshold, products supplied by a particular vendor, or products currently on sale.
For example, if you want to update all products related to shoes, enter the keyword shoes in the Contains keyword field and click Run search.
The spreadsheet will refresh and display only the products matching your search criteria. Once you’ve loaded the products you want to update, click Bulk Edit on the toolbar.
Step 2: Configure the Price Update
After opening the Bulk Edit tool, choose the type of pricing adjustment you want to perform. The examples below use the Regular Price field, but the same workflow can be applied to Sale Price and many custom WooCommerce pricing fields.
Each option serves a different pricing strategy, allowing you to choose the most appropriate method for your business needs.
a) Set the Same Price for All Selected Products
Use this option when every selected product should have exactly the same price. This replaces existing values with a single fixed amount regardless of their current prices.
Setting a fixed price is useful when standardizing pricing across a product line, launching a new collection at a common price point, creating fixed-price promotional bundles, or correcting 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 will refresh and display the updated prices for all affected WooCommerce products.
b) Increase Prices by a Fixed Amount
Use this option when you want to add the same monetary amount to every selected product. Instead of replacing prices, WP Sheet Editor increases each product’s current price by the amount you specify.
This method is useful when supplier costs rise by a predictable amount, shipping costs increase, operational expenses need to be passed on to customers, or a specific product category requires a consistent markup.
For example, adding $5 to every product in a category will increase 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 are ideal when you want pricing adjustments to scale proportionally across products with different price points. Instead of adding the same amount to every product, each product receives an increase based on its current value.
This approach is commonly used for inflation adjustments, supplier cost increases, profit margin improvements, and catalog-wide pricing strategies where maintaining proportional pricing relationships is important.
For example, a 10% increase will raise a $50 product by $5 and a $200 product by $20, ensuring that higher-priced products receive appropriately larger adjustments.
- 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, enter 10 for a 10% increase.
- Click Execute Now.
d) Decrease Prices by a Fixed Amount
Use this option when you want to reduce the price of every selected product by the same monetary value. Rather than replacing the existing price, WP Sheet Editor subtracts the specified amount from each product’s current regular price.
This pricing strategy is useful for running fixed-value promotions, liquidating excess inventory, responding to lower supplier costs, or making selected products more competitive without completely restructuring your pricing model.
For example, decreasing prices by $10 will reduce a $50 product to $40 and a $150 product to $140. Every product receives 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 using a currency symbol.
- Click Execute Now.
After the operation is complete, WP Sheet Editor will automatically update all selected products and display the new values directly in the spreadsheet.
e) Decrease Prices by a Percentage
Percentage-based price reductions are one of the most common pricing strategies used in WooCommerce stores. Instead of reducing every product by the same amount, each product receives a discount proportional to its current price.
This method is particularly useful for seasonal promotions, category-wide sales, clearance events, holiday discounts, and temporary marketing campaigns. Percentage discounts preserve relative pricing relationships while ensuring that higher-priced products receive larger absolute discounts.
For example, applying a 15% discount will reduce a $100 product by $15 and a $500 product by $75. This creates a consistent discount structure across your entire product selection.
- 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, enter 15 to reduce prices by 15%.
- Click Execute Now.
Once the operation finishes, the updated prices will be reflected throughout your WooCommerce store. Depending on your caching setup, you may need to clear your site cache so customers immediately see the updated pricing.
Method 3: Bulk Export and Import Prices via CSV
Some WooCommerce store owners prefer to review and update pricing outside WordPress. In these situations, exporting products to a CSV file can provide additional flexibility for collaboration, auditing, supplier reviews, or offline editing.
The CSV workflow allows you to export WooCommerce products, modify pricing data using Excel, Google Sheets, LibreOffice Calc, or another spreadsheet application, and then import the updated information back into your store. This method is especially useful when pricing changes originate from supplier spreadsheets or when multiple team members participate in pricing decisions.
To begin, click Export on the WP Sheet Editor toolbar.
The Export tool allows you to customize exactly which WooCommerce products and fields will be included in the CSV file.
Configure the export using the following settings:
- What columns do you want to export: Select the product name and Regular price columns. You may also include the product ID, category, sale price, SKU, stock status, or any other fields needed 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 best matches your workflow, such as Microsoft Excel 365, Google Sheets, or another CSV editor.
- Name of this export (optional): Save the export configuration for future use if you regularly perform similar exports.
- Click Start new export.
After downloading the file, open it in your preferred spreadsheet application and update the values in the Regular price column. You can modify prices manually, use spreadsheet formulas, calculate percentage increases, apply supplier pricing rules, or review pricing with other team members.
Once you’ve finished updating product prices, save the CSV file and return to the WooCommerce products spreadsheet in WP Sheet Editor.
Click Import on the toolbar to begin importing the updated file.
Configure the import settings 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 product pricing, you can select only the relevant pricing columns and ignore the rest.
This selective import process reduces the risk of unintentionally overwriting unrelated product information.
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 can identify 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 this preview carefully to verify that the correct products, columns, and prices are being updated. Confirming the mapping at this stage helps prevent accidental pricing errors.
If everything looks correct, click The preview is fine, start import.
The plugin will process the CSV file, locate the matching WooCommerce products, and update their pricing information automatically.
Once the import is complete, reload the spreadsheet and review the Regular price column to confirm that all pricing updates were successfully applied.
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.