Managing prices for WooCommerce variable products can quickly become complicated, especially when your store includes hundreds of product variations. Updating the price of each variation individually is time-consuming and inefficient for store managers.
Many WooCommerce store owners need a fast way to bulk edit WooCommerce variation prices, update multiple variable product prices, or change pricing rules across many variations at once.
Although WooCommerce allows you to create variable products and assign prices to each variation, it does not provide an efficient built-in tool for bulk editing variation prices. As a result, managing WooCommerce variation price changes manually can take a lot of time.In this guide, we will explain 4 practical methods to bulk edit WooCommerce variation prices, including using inline editing, bulk editing tools, and CSV import/export. By using these methods, you can quickly update the price of multiple variations and manage WooCommerce variable product pricing more efficiently.
How to bulk edit variation prices in the WooCommerce variations bulk edit plugin?
If you want to use the WooCommerce variations bulk edit plugin as a professional tool for making changes in multiple WooCommerce variable products, first, you need to download and install it on your WordPress. After installation and activation, you will see the iT Bulk Editing menu in your WordPress dashboard. By opening this tab and pressing the Woo Variations submenu, you will be led to the plugin’s main page.
On this page, all your WooCommerce products are listed in a table with a comprehensive toolbar.
The most useful tools designed in this toolbar and you may need to do WooCommerce bulk edit variation prices are:
- Filter
- Manage variations
- Bulk Edit
- Bind Edit
- Column Manager
- Import/Export
In the following steps, we will show you how to use these tools to do the bulk edit variation price WooCommerce efficiently.
VBulkit – Bulk Edit WooCommerce Variations plugin by ithemeland
The easy way to bulk edit multiple WooCommerce product variation prices
Step 1: Filter desired WooCommerce variable products
Filter is the first icon in the toolbar which is used to make the process of choosing the variable products for bulk editing more convenient.
As we will bulk change variation prices in this tutorial, we use the filter form to limit the products to variable products. To make this happen, you need to simply:
- Go to the Type tab in the Filter Form.
- Open the combo box in front of the Product Type field.
- Choose Variable product from the list.
- Press the Get Products button.
After filtering the variable products, you can bulk edit their variations using the bulk edit tool in the manage variations form. Let’s see how.
Step 2: WooCommerce bulk change variation prices
In the WooCommerce variations bulk edit plugin, we designed special tools for managing bulk editing variations. However, before using this tool, you must mark some variable products in the table.
After selecting your desired products, you can click the Manage Variations tool and choose the same option to open the Variations Bulk Edit Form.
The variations bulk edit form comes with many handy tools designed in an easy-to-use interface, allowing you to find variations and make required changes nice and smooth quickly.
To help you better understand how to use this plugin for WooCommerce bulk edit product variations & prices, we will review all available methods individually.
Method 1: Inline edit variation price of multiple WooCommerce variable products
The easiest method for changing regular and sale prices of variations is inline editing, which is a good solution when you need to change a few numbers of variations prices.
To use the inline edit method, try to:
- Find the variation you want to change its regular price or sale price in the table using one of the below ways:
- Open the combo box to see the list of selected products and choose one.
- Press the right or left arrows to scroll over the products.
- After finding the required variation, you can simply click on the regular or sale price cell of the table and type the number.
- Finally, press the Enter key on the keyboard to apply the changes to the variation.
Method 2: Use the bulk edit form to WooCommerce change prices for all variations
The Bulk Edit form is helpful when you need to bulk edit prices for multiple WooCommerce variable products. Here, you can find how to use this method in our plugin:
- Mark some variations in the table.
- Press the Bulk Actions tool on top of the table and choose one of the below options:
- Selected variations: To bulk edit the price of the selected variations.
- All variations: To WooCommerce change price for all variations of selected products.
- After choosing one of the options, the Bulk Edit form will be displayed.
- In this form, locate Regular Price, then choose one of the below operators in the related combo box:
- Set new
- Clear value
- Increase by value
- Decrease by value
- Increase by %
- Decrease by %
- Increase by value from sale
- Increase by % from sale
Note: The operators available for the sale price field are the same except for the last two options which are Decrease by value or Decrease by % from regular price instead.
- After choosing the right operator, you need to insert the number in the text box and then set a round option if you need to.
Finally, click on the Do Bulk button to apply the changes to the variation prices.
Now, let’s make some examples to get insight into working with different operators for WooCommerce bulk change variation prices.
Example 1: Clear the regular price of all product variations
In this example, we want to show you a simple usage of the bulk editing tool of our plugin. Let’s suppose that you want to clear the regular price of all variations with one click. There is no magic needed here, you can do this task simply by choosing All variations from the Bulk Actions tool and then choosing Clear value from the Operator list of the Regular Price field.
Finally, press the Do Bulk Edit button.
That’s it. You have removed the Regular price of all variations successfully in a few seconds.
Example 2: Decrease the varaition sale price of pink, green, and blue variations by 10
Follow the below steps to bulk edit the Sale Price of Pink, Green, and Blue variations in our plugin:
- Mark Pink, Green, and Blue variations in the table.
- Choose the Selected Variations option from the Bulk Actions tool.
- Select Decrease by value from the operator list of Sale Price Field in the Bulk Actions form.
- Press the Do Bulk Edit button to apply changes.
Method 3: Use bind edit to WooCommerce change price for all variations
Bind Editing is another tool available in the toolbar of our plugin for WooCommerce bulk edit product variations & prices. To use this method, follow the below instructions:
- Press the Manage Variations tool and choose the Show Variations option.
- Review the variations of products in the table and mark some of them (1)
- Press Bind Edit tool (2)
- Click on one of the Regular price cells of the selected variations in the table (3) then make the changes you need by using one of the following methods:
- Insert the number manually
- Press the Calculator icon and proceed with the following instructions:
- Select one of the operators:
- +: To increase the price.
- -: To decrease the price.
- Sp+: To increase based on the sale price.
- Insert the number in the Enter Value field.
- Choose n or % to apply changes as a fixed amount or percentage.
- Select the rounding option if you need.
- Press the Apply changes button.
Note: The options available for the Sale price are just like the regular price in the Calculator except the last operator, which lets you decrease the sale price based on the regular price.
The following example shows how the bind editing tool can help you to WooCommerce bulk edit variation prices.
Example 3: Increase WooCommerce variation regular price by 50%
In this example, we will describe how to increase the regular price by 50%:
- Mark some variations in the table.
- Press the Bind Edit tool.
- Click on the Calculator icon in the regular price cell of a selected variation.
- Choose + from the operator list.
- Insert 50 in the next box.
- Choose % in the third box.
Press the Apply Changes button.
The result is exactly as we expected.
VBulkit – Bulk Edit WooCommerce Variations plugin by ithemeland
The easy way to bulk edit multiple WooCommerce product variation prices
How to use the import/export method for WooCommerce bulk change variation prices?
Bulk edit multiple WooCommerce product variation prices in an Excel file is useful when you aim to import the edited information into a new website, or you need to share the Excel file with others and ask them to do this task for you.
For any reason, you may need to export the product fields and import them again after bulk editing the data in the Excel file, you can follow the instructions we are going to share with you in this guide:
Step 1: Add the variation sale price column to the table
As the purpose of exporting a CSV file in this tutorial is bulk editing the variation sale price of products. First we need to add the column to the table by opening the Column Profiles form.
In this form, you can easily mark all fields you want displayed in the table, including Sale Price, and then press the Apply to Table.
Step 2: Export WooCommerce product fields to a CSV file
In the next step, you have to click on the Import/Export tool in the Toolbar to see the form:
In this form, you have four ways to export the data, which are:
- All products in table/All fields: All fields related to all products will be exported regardless of the columns you have added to the table
- Only selected products/All fields: All fields related to some products that you have marked in the table will be exported.
- All products in table/Only Visible fields: The table’s columns related to all products will be exported.
- Only selected products/ Only Visible fields: The table columns related to the marked products will be exported.
Step 3: Bulk edit multiple WooCommerce product variation prices
By pressing Export Now, a CSV file will be downloaded to your system, and you can open it in Excel and then change the data in the Sale Price column.
Step 4: Import the CSV file to the website
After finishing the WooCommerce bulk edit variation prices task, open the Import/Export form again and click the Import button. Then follow the below instructions:
- Press Choose File and add the edited CSV file to the form.
- Mark existing products that match by ID or SKU will be updated.
- Press the Continue button.
Note: If you want to import data to a new website by using the Import/Export form of the WooCommerce variations bulk edit plugin, it is essential to install and activate it on that website.
- Press Run the importer without changing the other options.
- Wait for the plugin to import the data.
- When replacing the bulk edited prices is done, you will see a message like this, and your task is done successfully.
It is also possible to export product data by navigating to the below address in the WordPress dashboard without using our plugin:
WooCommerce > Products > All Products
Then press the Export button and download the CSV file. After WooCommerce bulk edit price variations, visit this page again and press the Import button to replace the data.
Conclusion
Updating variation prices is a common task for WooCommerce store managers, especially when working with variable products that contain multiple options such as size, color, or material. Without the right tools, changing prices for each variation individually can become extremely time-consuming.
Fortunately, there are several ways to bulk edit WooCommerce variation prices. You can use inline editing for quick updates, apply bulk actions to change prices across multiple variations, or export variation data to a CSV file for large-scale price updates.
However, using a dedicated WooCommerce bulk editing plugin like VBULKIT is often the most efficient approach. These tools allow you to filter variable products, select multiple variations, and update prices in bulk using powerful editing features.
With the right workflow, you can manage WooCommerce variation pricing much faster and keep your store pricing accurate and consistent.
FAQ
How do I bulk edit WooCommerce variation prices?
You can bulk edit WooCommerce variation prices by selecting variable products and applying bulk editing actions that update the regular price or sale price of multiple variations at the same time. Many store owners use bulk editing plugin like VBULKiT to make this process faster and more flexible.
Can WooCommerce change prices for all variations at once?
Yes. It is possible to change the price of all variations by using the VBULKiT plugin that allows you to increase, decrease, or set new prices for multiple variations simultaneously. This approach is commonly used when adjusting prices across large product catalogs.
How do I change the price of a variable product in WooCommerce?
To change the price of a variable product, open the product edit page in WooCommerce, navigate to the Variations tab, and edit the price for each variation. For faster updates, bulk editing tools like VBULKiT can modify variation prices across multiple products at once.
Why is bulk editing variation prices important in WooCommerce?
Bulk editing variation prices helps store managers save time when updating large numbers of products. Instead of editing each variation individually, bulk editing allows you to apply price changes across many products quickly and consistently.
Can I update WooCommerce variation prices using a CSV file?
Yes. WooCommerce allows you to export product and variation data to a CSV file, edit the price values in spreadsheet software such as Excel, and import the updated file back into your store to apply the new prices.
What is the easiest way to manage WooCommerce variation prices?
The easiest way to manage WooCommerce variation prices is by using VBULKiT plugin that allows you to filter products, select variations, and apply pricing changes in bulk. This method is especially useful for large WooCommerce stores with many product variations.
