2 Ways to Bulk Edit Prices of Multiple WooCommerce Product Variants?

A user left a message in the comments section asking "How to batch edit prices of WooCommerce product variants"?

WooCommerce doesn't provide a tool to modify variant prices in bulk in the default editor. Therefore, if you want to solve this problem faster and easier and modify WooCommerce variant prices in bulk, you need to use a plugin, which is generally what I commonly use WooCommerce Variations Bulk Edit Plug-ins.

Installing this plugin provides full access to all the required tools and options for easy bulk editing of WooCommerce product variants and their prices. In the article, we will show how to edit WooCommerce variant prices in bulk using the plugin's features.

How to Bulk Edit Variation Prices in WooCommerce Variations Bulk Edit plugin?

If you want to put WooCommerce Variations Bulk Edit The plugin serves as a specialized tool to bulk modify multiple WooCommerce Variable Products, to download and install the plugin on WordPress first. Once installed and activated, you'll see in your WordPress dashboard the iT Bulk Editing Menu. Open this tab and click Woo Variations submenu, you can justifiably go to the main page of the plugin.

Go to the WooCommerce Bulk Edit menu

On this page, all WooCommerce products are listed in a table with a toolbar.

The most useful features in the toolbar

Here are the most important features of the toolbar that can helpBulk Edit WooCommerce Variant Pricing::

• Filter
• Manage variations
• Bulk Edit
• Bind Edit
• Column Manager
• Import/Export (Import/Export)

In the next steps, we will show you how to use these tools to efficiently batch edit WooCommerce variant prices.

Step 1: Filter WooCommerce Variable Products for Bulk Editing

Filter is the first icon in the toolbar that makes it easier to select variable products that need to be edited in bulk.

In this post, the variant prices will be modified in bulk, so you need to use the filter function to limit the product types and display only variable products. The specific operation is as follows:

• Enter the Filter Form's "Type" Tab.
• exist "Product Type" (Product Type) The drop-down box in front of the field opens a list of options.
• Select from the list "Variable product" (VP)The
• strike (on the keyboard) "Get Products" Button.

Once the filtering is complete, the system will display only variable products, and you can use Manage Variations tohit the nail on the headBulk Edit (Bulk Edit) tool to modify variant prices. Next, let's see how to do it.

Step 2: WooCommerce Bulk Modify Variant Prices

exist WooCommerce Variations Bulk Edit The plugin provides specialized tools to manage and edit variant prices in bulk. However, before using these tools, the product form needs to beSelected variable productsThe

Procedure for batch modification of variant prices

• in a tabletickVariable products that you want to batch edit.
• strike (on the keyboard) "Manage Variations" Tools.
• option "Variations Bulk Edit" option to open the variant bulk edit form.

Functionality of the variant bulk edit form

The form has an intuitive interface and offers a variety of handy tools that allow you to quickly find variants and adjust prices in bulk to improve operational efficiency.

Method 1: Edit prices for multiple variants directly in the table (Inline Edit)

Direct Edit (Inline Edit) It is the easiest way to modify the regular or promotional price of a variant and is especially suitable for modifying the price of a small number of variants.

Steps for using the Inline Edit method

Find the variant to be modified in the table by:

• Open the drop-down box to view the list of selected products and select a product.
• utilizationleft and right arrowsScroll through the products to find the desired variant.

Once you have found the target variant, clickRegular PricemaybeSale Priceof the cell.

Enter a new price value.

check or refer to Enter key Confirm the change and the price modification takes effect immediately.

If you need to modify the prices of a large number of variants, you can also use theBatch editing toolsThe more efficient method of batch modification will be introduced in the subsequent steps.

Method 2: Modify the price of WooCommerce variants in bulk using the Bulk Edit form

Batch edit forms are useful when you need to change the price of multiple WooCommerce variants of a product at once. Here are the steps to use this method:

Tick some variant products in the table.

Click on the top of the form Bulk Actions tool and select one of the options below:

• Selected variations: Modifies the price of the selected variant in a batch.
• All variations: Modify the price of all variants of the selected product in bulk.

When selected, the system displays Bulk Edit Form (Bulk Edit Form)The

Find in the form Regular Price, and then select one of the following actions in the related drop-down menu:

• Set new
• Clear value
• Increase by value
• Decrease by value
• Increase by %
• Decrease by %
• Increase by value from sale
• Increase by % from sale

• Decrease by value from regular price
• Decrease by % from regular price

After selecting the appropriate operation, enter the value in the text box and set the rounding options as needed.

Finally, click on the Performing Bulk Operations (Do Bulk) button to apply price changes to all variant products.

Below, we'll go through some examples to visualize more how different actions affect the prices of WooCommerce variant products.

Example 1: Clearing regular prices for all product variants

In this example, it is shown how a simple operation can be accomplished using the plugin's bulk editing tool. Assuming that what is wanted is to clear the regular price of all variants with a single click, this does not require any complex operations. Simply add the Bulk Actions tool, select the All variationsand then in the Regular Price Select from the list of operators for the field Clear valueThe

Clear regular prices for all product variants - example of batch operation

Finally, click on the Perform Bulk Edit (Do Bulk Edit) Button.

Example 2: Reducing the promotional price of the pink, green and blue variants by 10 percent

Follow the steps below to bulk edit the promotional prices for pink, green and blue variants with the plugin:

• Check the box in the form Pink, green and blue Variants.
• exist Bulk Actions tool, select the Selected Variations Options.
  (Select Selected Variants Option - Batch Manipulation Tool)

• exist Bulk Actions In the interface, find the Sale Price field and select it from the list of operators Decrease by valueThe(Select Promotional Price Field - Batch Operation Form)

• strike (on the keyboard) Perform Bulk Edit (Do Bulk Edit) button to apply the changes.

Method 3: Batch Modify Prices for All WooCommerce Variants Using Bind Edit

Bind Editing is another method provided in the plugin toolbar for WooCommerce to batch edit product variants and prices. To use this method, follow the steps below:

strike (on the keyboard) Manage Variations tool and select Show Variations Options.(Select the Show Variants option in the Manage Variants tool)

View all variants of the product in the table and check some of the variants (1).

strike (on the keyboard) Bind Edit Tools (2).

Click on the Regular Price cell (3) and then modify it using one of the following methods:

• Manual entry of price values

• Using the Calculator Icon and follow the steps below:
  • Select an operator:
    • +: Increase in price
    • –: Reduced prices
    • Sp+: Increase in price based on promotional price
  • exist Enter Value Fill in the fields with numbers.
  • option n maybe %, respectively, indicating the application of a fixed value or a percentage change.
  • Optional if desired Rounding optionsThe
  • strike (on the keyboard) Apply changes Button.(Selection of Operator Fields in Calculator)

take note of: The options available for Sale Price are the same as for Regular Price, the only difference being the last operator, which reduces the sale price based on the regular price.

The following example shows how to use the Binding Editor Tool next Bulk Edit WooCommerce Variant PricingThe

Example 3: Increasing the Regular Price of a WooCommerce Variant by 50%

In the example, demonstrate how to increase the regular price by 50%:

Tick some variants in the form.

strike (on the keyboard) Bind Edit Tools.

In the selected variant of the Regular Price cell, click Calculator iconThe

Select from the list of operators +The

In the next input box, type 50The

In the third box select %The

strike (on the keyboard) Apply Changes Button.

Increase the regular price of WooCommerce variants, the result was the same as expected.

How to modify WooCommerce variant prices in bulk using Import/Export method?

Batch editing multiple WooCommerce product variant prices in an Excel file also works well, especially in these cases below:

• The edited information needs to be imported into the new site.
• Need to share an Excel file with someone and ask them to edit the price for you.

Regardless of the reason, if you need to export the product fields and re-import them after editing the data in bulk in an Excel file, you can follow the steps provided below the article.

Step 1: Add the Variant Sales Price column to the table

Since the purpose of exporting CSV files in this article is to batch edit the changing selling prices of products. First, you need to open the "Column Configuration File" by opening theForms add columns to a table.

In the form, you can mark all the fields that you want to display in the table, including theSelling price.Then press "Apply to Forms"The

Step 2: Export WooCommerce Product Fields to CSV File

Next, you need to click on the toolbar Import/Export (Import/Export) tool to open the appropriate form:

(Select the Import and Export tool in the WooCommerce toolbar)

There are four ways to export data in this form:

1. All products in the form / All fields: All fields for all products will be exported regardless of the columns added to the table.
2. Selected Products Only / All Fields: Exports all fields for only the products marked in the form.
3. All Products in Form / Visible Fields Only: Exports only the columns that are visible in the table for all products.
4. Selected Products Only / Visible Fields Only: Exports only the columns where the labeled products are visible in the table.

Step 3: Bulk Edit Multiple WooCommerce Product Variant Prices

strike (on the keyboard) Export Now button, the system will download a CSV file, which can be opened in Excel, and the Sale Price column to modify the data.

Step 4: Import the CSV file to the website

After you have finished editing the batch of WooCommerce variant prices, open the Import/Export (Import/Export) form and click Import button. Then follow the steps below:

• strike (on the keyboard) Choose FileThe CSV file will be uploaded to the form after editing.
• tick Matching existing products (by ID or SKU) will be updated Options.
• strike (on the keyboard) Continue Button.

take note of: If you want to import data to a new site, you must first install and activate the WooCommerce Variant Bulk Edit plugin on that site.

strike (on the keyboard) Run the importer button without changing the other options.

Wait for the plug-in to finish importing the data.

WooCommerce Import InterfaceOnce the import is complete, you will see a success message indicating that the task has completed successfully.

It is also possible to export product data in the WordPress backend via the following path without using a plugin:

WooCommerce > Products > All Products (WooCommerce > Products > All Products)

Then click Export button to download the CSV file. When you are done with bulk editing of prices for WooCommerce variants, return to this page and click on the Import button to replace the data.

reach a verdict

Editing product variant prices in WooCommerce is a waste of time. In order to improve efficiency, we talk aboutWooCommerce Product Variant Bulk Edit PluginThe

With the help of the plugin, it is possible to use the Filter Form respond in singing Bulk Edit Form (Bulk Edit Form) Utilities such as the WooCommerce Variant Price Batch Edit can be completed in just a few seconds.