How to Bulk Edit WooCommerce Variation Prices

In this tutorial you will learn how to bulk edit WooCommerce variation prices. Updating prices one at a time in WooCommerce can take a while, especially when a product has many sizes, colors, or other options. This guide shows how to change variation prices in WP Sheet Editor – WooCommerce Products. You can change individual prices in the spreadsheet, apply bulk changes with a few clicks, or update prices with a CSV file.

Related tutorials:

• How to bulk edit WooCommerce product variations
• Bulk edit product prices for simple products
• Bulk edit sale prices and dates

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 displays your products and variations in a spreadsheet on your WordPress dashboard for searching, editing, and importing or exporting products and variations.

Once you have the plugin installed and activated, follow the steps below to bulk update WooCommerce variation prices.

Important. Always backup your site before applying changes.

Step 1. Open the Products Spreadsheet

Go to WP Sheet Editor > Edit Products in your WordPress dashboard to open the products spreadsheet.

Step 2. Display Product Variations in the Spreadsheet

To view and edit variations, you need to load the variations into the spreadsheet alongside their parent products.

Click the Display variations button.

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 the Search tool.

Set 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 search 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.

Method 2: Bulk Edit Variation Prices

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.

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 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:

• 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 process is complete, the spreadsheet will reload and display the updated prices across all affected variation rows.

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:

1. Display variations in the spreadsheet.
2. Click on Export.
3. Set the export settings.
4. Download a CSV containing your product variations.

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 and save the file when done.

Then return to the products spreadsheet and click Import.

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.

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.

Optionally, you can use the product SKU as an identifier.

Click Next.

Review the import preview to confirm the variation prices are mapped to the correct rows and columns. If everything looks accurate, click The preview is fine, start import to apply the updated prices from the CSV file.

That’s how you can use WP Sheet Editor to bulk edit WooCommerce variation prices.