If you’re managing a WooCommerce store with hundreds of variable products, updating variation prices one by one is not a realistic option. The default WooCommerce interface requires you to open each variable product, navigate to the Variations tab, expand each variation accordion, update the price, and save. Then repeat the entire process for the next product. For stores with dozens of variable products and multiple variations each, this can take hours.
This guide covers the best ways to bulk edit WooCommerce variation prices using WP Sheet Editor – WooCommerce Products. You’ll learn how to view all your variations in a spreadsheet, filter by product type or attribute, and apply price changes to hundreds of variations at once.
Related tutorials:
What You Need to Bulk Edit WooCommerce Variation Prices
WooCommerce: You need variable products with variations already created in your store.
WP Sheet Editor – WooCommerce Products: This plugin gives you a spreadsheet interface inside your WordPress dashboard where you can view and manage all your products and variations in one place. It supports advanced searches, bulk editing, and CSV export and import for products and variations.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you have the plugin installed and activated, follow the steps below to bulk update WooCommerce variation prices.
Step 1. Open the Products Spreadsheet
Go to WP Sheet Editor > Edit Products in your WordPress dashboard to open the products spreadsheet. Every row represents a product and every column represents a product field.
Step 2. Display Product Variations in the Spreadsheet
By default, the spreadsheet shows parent products only. To view and edit variation prices, you need to load the variations into the spreadsheet alongside their parent products.
Click the Display variations button on the toolbar.
The spreadsheet will reload and show each variation as its own row, grouped directly below its parent variable product.
Some fields on variation rows are read-only because they are inherited from the parent product. However, pricing fields like Regular price and Sale price are fully editable on variation rows, which is what we’ll be working with in the methods below.
Note: When you click Display variations, the spreadsheet also shows other product types alongside the variable products, including simple, grouped, and external products. If you want to work with variable products and their variations only, use the Search tool to filter them as described in the next step.
Step 3. Filter Variable Products Using the Search Tool (Optional)
If your store contains a mix of product types and you want to focus only on variable products and their variations, use the Search tool to filter them before applying any price changes.
Click Search on the toolbar to open the Search tool.
Configure the following settings to display variable products and their variations only:
- Tick the Search on variations checkbox.
- Tick the Enable advanced filters checkbox.
- Field: Type (product_type)
- Operator: =
- Value: variable
- Click Run search.
The spreadsheet will reload and display only variable products alongside their variations. The active search filters will be visible above the spreadsheet so you can confirm the correct criteria are applied.
You can also combine this filter with other conditions. For example, you can filter by attribute value (such as only variations with the “Color: Black” attribute) to update pricing for a specific subset of variations across your catalog.
With your variations loaded and filtered, choose one of the three methods below to apply your price changes.
Method 1: Edit Variation Prices Directly in the Spreadsheet
If you need to set a specific price for each variation individually (for example, when different sizes or colors have different price points), you can type the values directly into the Regular price column in the spreadsheet.
Locate the Regular price column, click on a variation’s price cell, and enter the new value. Move through the variation rows and update each price as needed. When you have finished making changes, click Save on the toolbar to apply all updates at once.
This approach is useful when variations across your catalog need unique prices rather than a uniform change. You can review and adjust each value before saving, giving you full control over the final result. When you click Save, all your changes are applied in a single operation rather than saving each variation separately.
Method 2: Bulk Edit Variation Prices with the Bulk Edit Tool
When you need to apply the same price change to many variations at once (such as increasing all variation prices by 10%, or setting every variation in a category to a new base price) the Bulk Edit tool is the most efficient approach.
Click Bulk Edit on the toolbar to open the bulk editing panel.
Configure the following settings:
- Select the rows that you want to update: Choose from the following options depending on your selection:
- Edit all the rows from my current search — applies the change to all variations currently visible in the spreadsheet after your search filter.
- Edit all the rows — applies the change to every variation in your catalog.
- Edit the rows that I selected manually — applies the change only to the variation rows you ticked with the checkbox selector.
- What field do you want to edit: Select Regular price to update the standard price. Select Sale price if you want to update the discounted price instead.
- Select type of edit: Choose one of the following options based on the type of change you need:
- Set value: Replaces the existing price on all selected variations with a single fixed value.
- Clear value: Removes the price from all selected variations.
- Increase by number: Adds a specific amount to each variation’s current price.
- Increase by percentage: Increases each variation’s current price by a percentage.
- Decrease by number: Subtracts a specific amount from each variation’s current price.
- Decrease by percentage: Reduces each variation’s current price by a percentage.
In this example, we will increase all variation prices by $1. The configuration looks like this:
- Select type of edit: Increase by number
- Increase by: Enter the amount to add.
- Important: Select the Edit only variations option. This ensures the bulk edit targets variation rows only and does not affect the parent variable products.
- Click Execute Now.
Once the operation completes, the spreadsheet will reload and display the updated prices across all affected variation rows.
The same workflow applies for all six edit types. For example, to apply a 15% discount to all variation prices in a specific category, you would first filter by that category using the Search tool, then open the Bulk Edit tool and select Decrease by percentage with a value of 15.
Method 3: Bulk Import Variation Prices from a CSV File
If you prefer to manage variation price updates outside of WordPress (for example, to have a team member review or edit the prices in Excel or Google Sheets before importing) you can export your variation data to a CSV file, update the prices there, and import the file back.
This method is also useful when you receive a supplier’s updated pricing sheet and need to apply those values directly without manually retyping them into the spreadsheet.
First, export your variation data using the Export tool. Open the Export tool from the toolbar, select the variation rows from your current search, choose the columns you need (at minimum the ID and Regular price columns), and click Start new export to download the CSV.
Here is an example of what the exported CSV looks like with variation prices:
Edit the Regular price column values in the CSV file as needed. Save the file when done. Then return to the products spreadsheet and click Import on the toolbar to open the Import tool.
Configure the following settings to upload the file:
- Source: CSV file from my computer
- Click Choose File and locate the updated CSV file on your computer.
- Click Next.
On the next screen, click Import all the columns to include every field from the file, or click Select individual columns to import if you only want to update the price column and leave other fields unchanged.
On the configuration screen, set the import to Update existing items, ignore new items. Match the CSV Field to record_id and the WordPress Field to ID so the importer maps each row in the CSV to the correct existing variation by its WordPress post ID. Click Next.
Review the import preview to confirm the variation prices are mapped to the correct columns. If everything looks accurate, click Start import to apply the updated prices from the CSV file.
The plugin will process the file and update each matched variation with the new price values. Once finished, you can reload the spreadsheet to verify the updated Regular price column on the variation rows.
Summary
Bulk editing WooCommerce variation prices with WP Sheet Editor – WooCommerce Products removes the need to open each variable product and edit variations one at a time. The three methods above cover different scenarios: editing specific variation prices individually in the spreadsheet, applying a uniform price change to many variations at once using the Bulk Edit tool, and importing price updates from a CSV file. All three methods work with the same spreadsheet-based workflow and can be combined with the Search tool to target a filtered subset of variations before applying any changes.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
FAQs: Bulk Editing WooCommerce Variation Prices
Can I bulk edit sale prices for variations?
Yes. Follow the same steps in the Bulk Edit tool or spreadsheet, but select Sale price instead of Regular price as the field to edit. You can also update the Sale start date and Sale end date columns to schedule the discount.
How do I bulk edit variation prices based on attributes?
Use the Search tool to filter variations by a specific attribute value; for example, all variations where Color is Black, or all variations where Size is XL. Once the filtered results are loaded in the spreadsheet, open the Bulk Edit tool and apply your price change to all rows from the current search.
Will the Bulk Edit tool affect parent products when I update variation prices?
Not if you select the Edit only variations option inside the Bulk Edit tool. This option restricts the operation to variation rows only, leaving the parent variable products unchanged.