Adjusting variation prices in WooCommerce can take a considerable amount of time, particularly when there are many options to consider. This article explains how to use our Product Import Export plugin to bulk edit variation prices to update multiple prices in one go.
If your store has products with various options, you likely know that adjusting variation pricing can quickly become a tedious and time-consuming chore. For instance, if you’re selling clothing with multiple sizes and color options for each item, you must manage dozens or hundreds of product variations. Each item will have its price, so you’ll need to update several prices whenever you want to make changes.
Without the right tools, this process can be painfully slow. When you have hundreds of products, this can take days, not to mention the chance of overlooking variations or entering the wrong prices. That’s where bulk editing comes in. Bulk editing allows you to adjust pricing for several product variations at once, saving time and keeping pricing consistent across your store.
Although WooCommerce has some built-in bulk editing features, they can be quite limiting if you have many variations to manage. This is where third-party plugins like Product Import Export for WooCommerce by WebToffee can simplify the process.
In this guide, we’ll show you how to bulk edit variation prices using the default WooCommerce feature and the Import Export plugin, making it easier to manage your pricing strategy and keep your store in order.
Key Takeaways:
- Managing variation pricing manually can be tedious and error-prone, and this is where bulk editing comes in.
- While WooCommerce offers basic bulk editing features, these may not be sufficient for larger stores with extensive product variations, making the need for advanced tools apparent.
- The Product Import Export Plugin by WebToffee simplifies bulk editing by allowing easy updates to variation prices for multiple products all at once.
In WooCommerce, there’s a product edit section where you can manage variation prices. If your product has multiple variations, you can select the ones you want to edit and update their prices simultaneously.
You can do this directly from the product’s variation settings by selecting multiple variations and editing them all at once.
- From your WordPress admin, go to Products > All Products.
- Select all the products you want to edit.
In the Bulk actions drop-down, choose Edit and click Apply.
- Under Product Data, click the Price dropdown.
- Enter the price in any of the options: Change to, Increase existing price by, Decrease existing price by.
- Likewise, in the Sales dropdown, select from any of the options: Change to, Increase existing sale price by, Decrease existing sale price by, Set to regular price decreased by.
- Click Update to save your changes.
This will quickly update the prices for all selected products. However, keep in mind that the default bulk editing feature in WooCommerce is limited to only simple products. It does not support bulk price changes for variable products or other categories.
This is where plugins come to the rescue. Our Product Import Export for WooCommerce offers enhanced flexibility for bulk editing variation prices, allowing for quick price adjustments across multiple variations with just a few clicks.
Let’s see how.
Follow the below steps to bulk edit variation prices using the Product Import Export plugin.
To bulk edit variation prices, follow these steps: First, export your product data to a CSV file. Then, import the CSV file and apply the pricing changes during the import process.
We won’t cover the details of exporting here. Instead, you can refer to the related article for guidance.
Also Read: How to Export Products from WooCommerce?
Step 1: Install WebToffee Product Import Export Plugin
From your WordPress dashboard.
- Go to Plugins > Add New.
- Search for ‘Product Import Export’ plugin by WebToffee.
- Install and Activate the plugin.
Step 2: Select Product as Post Type
Once the plugin is installed,
- Go to WebToffee Import Export (Basic) > Import.
- Choose Product as post type.
Step 3: Select Advanced Import Method
- Select Advanced Import as the method for importing to allow for filtering, column mapping, and various other advanced customization options.
- Next, upload the CSV file of the exported products and click on Map Import Columns to continue.
Step 4: Map & Update Product Field Values
In this step, we’ll map the columns for import and use the transform option to modify or edit any columns as needed.
This is where we will be applying the bulk edit to product prices so that it consistently updates prices for multiple products at once.
When mapping columns during import, clicking the pencil icon brings up a pop-up that allows you to set or update values for product fields.
In this pop-up, you can adjust the values for existing product fields as necessary throughout the import process. It matches a column from your input file to a product field, carries out the specified calculation, and updates the field with the new value.
Here is the list of supported operators:
Expression: Use operators like +, -, *, /, (), &, @, or string constants to modify field values. For example, [regular_price+10] adds 10 to the current price.
Input File Columns: Choose the column you want to modify from the dropdown menu.
Output/Preview: The plugin shows a sample value based on the first record in your file. For instance, if the regular price is 30 and you add 10, the preview will display 40.
Now, we will examine the common scenarios where bulk editing of prices is carried out.
Increase Regular Price
The regular price of a product is its standard or original price before any discounts, promotions, or sales are applied. It represents the amount a customer usually pays in normal situations without special offers.
To raise the regular price of products, say by 10 dollars.
- Click the pencil icon corresponding to Price: regular price row.
- In the Set value for column pop-up, enter ‘[{regular_price}+10]’ or any of your preferred values.
- Once done, click Apply.
If the starting price is 20, the regular price will be adjusted to 30 after the calculation, which will be reflected in the pricing of all products.
Note: Columns with empty or null values in the input file can cause errors when used in expressions. To prevent issues during the import process, make sure all columns contain valid values.
Decrease Sale Price
The sale price is the reduced or discounted price of a product offered during a promotion or special event. It is the price customers pay after a discount is applied to the regular price.
In this case, if you take 10 dollars off the sale price,
- Enter ‘[{sales_price}-10]’ in the Set value for column window for the product field ‘Price: Sale Price.’
- Click Apply.
The updated sale price, which was originally $45, will be modified during the import process as follows:
Step 5: Configure Advanced Import Options
This marks the final step in the import process. You can use the advanced options below to customize updates for existing products and set the batch import count.
There’s also the option to save the template file for future imports.
The WooCommerce Product Import Export plugin we covered in this article has a premium version with advanced features. It allows you to manage bulk tasks with ease, including bulk editing of variation prices and the transfer of product images, reviews, categories, tags, and other important information.
With features like advanced filtering and automatic column mapping, the process becomes more efficient, helping you save both time and effort.
Handling variation pricing doesn’t need to be complicated when you have the right tools. The Product Import Export plugin by WebToffee is specifically designed to make bulk editing quick and easy, especially for stores with complex product variations.
With its robust features, you can quickly update prices for multiple variations at the same time, saving you valuable time and ensuring uniformity across your store. No more hassle of manual updates, and let this plugin do the heavy lifting, allowing you to focus on managing your store smoothly.
Hope you’ve enjoyed this article. Feel free to comment below should you have any questions or feedback.
Also Read: How to Bulk Update WooCommerce Products
