Bulk Editing Pricing For Multiple Variations in WooCommerce
Selling products with multiple options, you may face a challenge of editing pricing for multiple variations in WooCommerce. Luckily, there are several methods to change variations’ prices in bulk. Below, we’ll describe how each method works.
WooCommerce provides a possibility to change prices of all variations of a product. To do so, open a variable product in the Edit mode:
At the top, expand the Product data dropdown and under Pricing, select a necessary option:
- Set regular prices
- Increase regular prices (fixed amount or percentage)
- Decrease regular prices (fixed amount or percentage)
Let’s, for example, try to increase prices of variations by 30%. For this, we need to select the option “Increase regular prices” (fixed amount or percentage) and press “Go”:
In the pop up that appears, enter a value (30% in our case). Note that you should add the % character too, otherwize, the prices will be increased by 30 currency units:
Let’s preview the new price and save the changes by pressing “Update”:
The advantage of this tool is that it’s available out-of-the-box. Though, it offers only basic functionality. For instance, you can only update prices of all product’s variations. If you, say, need to select specific variations of a product like red-coloured t-shirts, you would have to use some external solution.
Store Manager for WooCommerce offers more flexibility in changing prices of variations in WooCommerce.
Store Manager is an application that allows you manage your WooCommerce store online and enhances the default WooCommerce functionality.
How does price editing in Store Manager differ from the default WooCommerce tool? Firstly, changing the price by % and value come as separate options. This reduces the possibility of mistakes and spares you from entering the % character.
Thus, in Store Manager there will be five options (instead of three in the native WooCommerce admin):
- Set regular prices
- Increase regular prices by fixed amount
- Increase regular prices by percentage
- Decrease regular prices by fixed amount
- Decrease regular prices by percentage
Another advantage is that you can change prices of certain product variations. For instance, you can filter variations by an attribute like color or size. Then select filtered variations by holding the Shift button on the keyboard and then apply a desired action:
To update prices of all product’s variations, press Select All and pick an option from the drop-down list:
Then enter a value and press “Go:”
To preview new prices, press the pencil icon. If everything looks good, close the window and click Apply:
When you have hundreds or thousands of variable products, updating variations of every product one by one isn’t an option. To solve the task, you can use a flexible Import/Export Products Wizard with Store Manager for WooCommerce.
Using the Wizard, you can export just several fields related to a specific task. To update variations’ regular prices, it’s enough to add just these fields: SKU (for identification), Variations, and Regular Price (if you want to update a sale price, then you need to add the Sale Price field respectively):
After you’ve finished with the export, you can change the prices in two ways.
Open the file and modify values in the Regular Price column using the tools of the spreadsheet program you are using (Excel, Google spreadsheets).
Then save the changes and import the file back.
Read the complete guide on how to import variable products with variations.
In step 3, select the option Modify Only to overwrite existing prices with new ones:
Another approach is to make necessary changes during import using an SQL expression. In this case, you don’t even have to open the exported file.
Run the Import Wizard. In step 3, find the field Regular Price and press Edit to open SQL Editor.
Write an expression to make necessary updates. To increase prices by 15%, for example, you can use the following expression:
Press Execute Expression to check the result:
In the last step, select the Modify Only import method. Also, expand Advanced Options and configure the settings as shown in the screenshot below:
Preview the data and run the import.
If you are familiar with SQL, you can use more advanced expressions, for example, to update prices of variations with a specific attribute (color, size).
Also, you can order the development of advanced expressions with our tech engineers. To get a quote, describe your task and submit it to firstname.lastname@example.org
Try Store Manager for WooCommerce for free to massively update variation prices in WooCommerce!