- \n
- Create a child theme and save the code in the functions.php<\/strong> theme <\/strong>file located in the Appearance \u27a1 Theme File Editor<\/strong> path.<\/li>\n\n\n\n
- Use the Code Snippets p<\/span><\/a>lugin<\/span><\/a> to add your code to WordPress.<\/li>\n<\/ol>\n\n\n\n
- \n
- Before you add any codes to your site, be sure to back up the data so that you can restore the site to its previous state in case of any problems.<\/li>\n<\/ul>\n\n\n\n
Now you can get help from the following coding for bulk editing product price by formula for WooCommerce:<\/p>\n\n\n\n
function filtering_product_prices( $price, $product ) {\n$price = (float)$price;\n$new_price = $price * 1 ;<\/mark>\n\nreturn ceil($new_price);\n}\nadd_filter('WooCommerce_product_get_price', 'custom_price', 90, 2 );\nadd_filter('WooCommerce_product_get_regular_price', 'custom_price', 90, 2 );\nadd_filter('WooCommerce_product_variation_get_regular_price', 'custom_price', 99, 2 );\nadd_filter('WooCommerce_product_variation_get_price', 'custom_price' , 99, 2 );\nadd_filter('WooCommerce_variation_prices_price', 'custom_variation_price', 99, 3 );\nadd_filter('WooCommerce_variation_prices_regular_price', 'custom_variation_price', 99, 3 );\nfunction custom_price( $price, $product ) {\n wc_delete_product_transients($product->get_id());\nreturn filtering_product_prices( $price, $product );\n}\nfunction custom_variation_price( $price, $variation, $product ) { \n wc_delete_product_transients($variation->get_id());\nreturn filtering_product_prices( $price, $product );\n}<\/code><\/pre>\n\n\n\nIn order to be able to apply the desired changes to the product price using a formula, you must change the new price variable, which is highlighted in yellow, to your desired formula. Let’s give some examples to make it clear to you.<\/p>\n\n\n\n
Example 1: Cut the regular price by half<\/h3>\n\n\n\n
To cut all regular prices by half, simply replace the yellow highlighted line below: <\/p>\n\n\n\n
$new_price = $price * 0.5;<\/code><\/pre>\n\n\n\nExample 2: Increase the regular prices of the Accessories category by 25.<\/h3>\n\n\n\n
To make such a change, replace the following code:<\/p>\n\n\n\n
if (has_term( 'accessories', 'product_cat' )) { \nreturn ceil((float)$price + 25); \n}<\/code><\/pre>\n\n\n\nExample 3: Decrease all products in the Accessories category by 10% and increase the price of Hats by one-third.<\/h3>\n\n\n\n
To do this, you need to make the below changes:<\/p>\n\n\n\n
if (has_term( 'accessories', 'product_cat' )) {
return ceil((float)$price *1.1);
} elseif (has_term( 'hats', 'product_cat' )) {
return ceil((float)$price*4\/3);
}<\/code><\/pre>\n\n\n\nExample 4: Decrease the price of all products cheaper than $100 by 15.
Use the below code to make this change:<\/h3>\n\n\n\nif ( $price < 100 ) {
return ceil((float)$price-15);
} <\/code><\/pre>\n\n\n\nUse WooCommerce products bulk edit pro plugin to bulk edit product prices by formula<\/h2>\n\n\n\n
WooCommerce products bulk edit plugin<\/span><\/a> provides you with the most useful tools and options which is needed to bulk edit any product features. By getting help from this plugin, you can easily filter your products and then make any changes in their WooCommerce fields.<\/p>\n\n\n\n
One of the important uses of this plugin is to bulk edit product prices by formula for WooCommerce. Making these changes on your WooCommerce site is possible by following the 3 simple steps:<\/p>\n\n\n\n
Step 1: Install WooCommerce products bulk edit pro plugin<\/h3>\n\n\n\n
The first step to using the WooCommerce products bulk edit pro plugin is to download and install it on your WordPress website.<\/p>\n\n\n\n
After installing and activating t<\/span><\/a>h<\/span><\/a>e plugin<\/span>,<\/a> you will see its bulk editing option in the WordPress dashboard. Then, by pressing Woo Products<\/strong>, you can visit the main page of this bulk editing plugin..<\/p>\n\n\n\n
\n\n\nPBULKiT – Bulk Edit WooCommerce Products<\/p>\n\n\n\n
The easy way to bulk edit product prices by formula in WooCommerce<\/p>\n\n\n\n
\nBuy Plugin<\/a><\/div>\n\n\n\nFree Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n\n![\"PBULKiT](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nStep 2: Filter the desired products<\/h3>\n\n\n\n
On the main page of the WooCommerce product bulk edit pro plugin, a list of all products is observed with a comprehensive toolbar designed at the top of the table. The first icon in this toolbar is used for opening the Filter<\/strong> Form<\/strong>.<\/p>\n\n\n\n
![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-woo-products-menu-and-choose-filter-button.png\")
<\/a><\/figure>\n\n\n\nAs you may notice in the picture below, the Filter Form<\/strong> has been divided into eight sections, providing all the WooCommerce fields for filtering the products. <\/p>\n\n\n\n
You can use this form to filter your desired products based on any value, like stock quantity, price range, category, etc. In the following example, we will show you how to use these effective Filter Form<\/strong> before bulk editing product price by formula.<\/p>\n\n\n\n
![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-general-tab-in-filter-form-1.png\")
<\/a><\/figure>\n\n\n\nStep 3: Bulk edit product prices by formula<\/h3>\n\n\n\n
After filtering the products, you have to follow the below instructions to bulk edit product price by formula for WooCommerce: <\/p>\n\n\n\n
- \n
- Mark some of the products in the product table to select them for bulk editing their prices.<\/li>\n\n\n\n
- Open the Bulk Edit<\/strong> form by clicking on the icon illustrated below:<\/li>\n<\/ul>\n\n\n\n
![\"mark](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/mark-products-and-select-bulk-edit-button.png\")
<\/a><\/figure>\n\n\n\n- \n
- In the Bulk Edit<\/strong> form, go to the Pricing<\/strong> tab.<\/li>\n\n\n\n
- In front of the Regular Price<\/strong>, there are three boxes. <\/li>\n<\/ul>\n\n\n\n
The first box is a list of operators:<\/p>\n\n\n\n
- \n
- Set New:<\/strong> Set new value for product price.<\/li>\n\n\n\n
- Clear Value:<\/strong> clear or remove product price value.<\/li>\n\n\n\n
- Formula: <\/strong>Change product price value by formula.<\/li>\n\n\n\n
- Increase by Value:<\/strong> Increase product price by value.<\/li>\n\n\n\n
- Decrease by Value:<\/strong> Decrease product price by value.<\/li>\n\n\n\n
- Increase by %:<\/strong> Increase product price by percentage.<\/li>\n\n\n\n
- Decrease by %:<\/strong> Decrease product price by percentage.<\/li>\n\n\n\n
- Increase by Value (From sale):<\/strong> Increase product price by value based on product sale value.<\/li>\n\n\n\n
- Increase by %(From sale): <\/strong>Increase product price by percentage based on sale value.<\/li>\n<\/ul>\n\n\n\n
![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-regular-price-options.png\")
<\/a><\/figure>\n\n\n\nIf you choose Formula <\/strong>from the drop-down list in this box, you can write a formula in the next box.<\/p>\n\n\n\n
You can use all mathematical operators to write a customized formula, including:<\/p>\n\n\n\n
- \n
- Multiplication (*) <\/li>\n\n\n\n
- Division (\/) <\/li>\n\n\n\n
- Addition (+) <\/li>\n\n\n\n
- Subtraction (-)<\/li>\n<\/ul>\n\n\n\n
Note:<\/strong> By choosing Increase\/ Decrease by value\/%<\/strong>, you can add or subtract any fixed\/percent amount from the current value. It is also possible to bulk edit the regular price based on the sale price by selecting Increase by Value\/%<\/strong> (From sale). The same options are available for Sale Prices as well.<\/p>\n\n\n\n
The last box is used to round the price if needed. <\/p>\n\n\n\n
- \n
- After writing the formula, you need to press the Do Bulk Edit<\/strong> button to let the plugin update the regular prices of the selected products based on it.<\/li>\n<\/ul>\n\n\n\n
To help you write the formula correctly and exactly based on your needs, we are going to make some examples in the following.<\/p>\n\n\n\n
![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-formula-in-regular-price.png\")
<\/a><\/figure>\n\n\n\nBulk Edit WooCommerce simple product price by formula<\/h3>\n\n\n\n
Simple products are the most popular types in WooCommerce online stores and store managers usually need to update their prices. The steps for WooCommerce bulk pricing of simple products are exactly as we described before. However, we will review it briefly to make it clear.<\/p>\n\n\n\n
- \n
- Go to the Filter Form.<\/strong><\/li>\n\n\n\n
- Open the Type<\/strong> tab and locate the Product Type<\/strong> field.<\/li>\n\n\n\n
- Choose Simple Product<\/strong> from the list.<\/li>\n\n\n\n
- Press Get Product<\/strong> to see a list of Simple products in the table.<\/li>\n<\/ul>\n\n\n\n
![\"Filter](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/filter-simple-product.png\")
<\/a><\/figure>\n\n\n\n- \n
- Mark some products on the table.<\/li>\n\n\n\n
- Press the Bulk Edit<\/strong> button.<\/li>\n<\/ul>\n\n\n\n
![\"Mark](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/bulk-edit-products.png\")
<\/a><\/figure>\n\n\n\n- \n
- Go to the Pricing<\/strong> tab in the Bulk Edit<\/strong> form.<\/li>\n\n\n\n
- Choose Formula<\/strong> from the list of Operators<\/strong> and insert your formula in the Regular price<\/strong> or Sale Price<\/strong> fields.<\/li>\n<\/ul>\n\n\n\n
![\"Set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/set-sale-price-formula.png\")
<\/a><\/figure>\n\n\n\n- \n
- Press Do Bulk Edit<\/strong> to change product price.<\/li>\n<\/ul>\n\n\n\n
![\"Bulk](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/bulk-edit-sale-price-result.png\")
<\/a><\/figure>\n\n\n\nBulk edit variable product price by formula for WooCommerce<\/h3>\n\n\n\n
Variable products in WooCommerce allow store managers to offer multiple variations for a single product. The advantage of variable products is the option to set different prices for each variation. It helps customers to compare different features of a single product on the same page and then select their favorite one. However, when it comes to WooCommerce bulk update prices of variable products, store owners face many problems. Especially when there are a lot of variations in the store and they need to change their prices regularly.<\/p>\n\n\n\n
The good news is that the WooCommerce bulk products editing plugin solved this problem and you can use it to bulk price update WooCommerce product variations by following the below simple steps:<\/p>\n\n\n\n
- \n
- Filter variable products:<\/strong><\/li>\n<\/ul>\n\n\n\n
Filtering variable products is simply possible by selecting the right option from the list of Product Type<\/strong> options. However, the advanced Filter Form<\/strong> of our plugin allows you to go further and filter the exact variations you need.<\/p>\n\n\n\n
![\"Filter](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/filter-variable-product.png\")
<\/a><\/figure>\n\n\n\nFor example, if you just want to change the WooCommerce product price of Blue<\/strong> and Large<\/strong> variations, you can easily go to the Categories\/Tags\/Taxonomies<\/strong> tab, then set the right terms \u2013 Blue and Large- in front if each attribute like Color<\/strong> and Size<\/strong>. <\/p>\n\n\n\n
![\"Set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/set-variable-product-attribute.png\")
<\/a><\/figure>\n\n\n\nNow, you can press Get Products <\/strong>to see a list of all Blue-Large products in the table.<\/p>\n\n\n\n
![\"Set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/set-product-color-attribute.png\")
<\/a><\/figure>\n\n\n\n- \n
- Show and select variations in the table<\/strong><\/li>\n<\/ul>\n\n\n\n
In the next step, you have to click the Manage Variations<\/strong> tool on the toolbar and then select the Show Variations <\/strong>option. When you enable this option, all variable products with their variations will be displayed in the table in separate rows.<\/p>\n\n\n\n
![\"Select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/select-show-variations-option.png\")
<\/a><\/figure>\n\n\n\nNow, you need to mark the exact variations that you need to bulk update WooCommerce product price by formula.<\/p>\n\n\n\n
![\"Mark](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/select-show-variations-products.png\")
<\/a><\/figure>\n\n\n\n- \n
- Bulk change product price by formula for WooCommerce<\/strong><\/li>\n<\/ul>\n\n\n\n
The final step is to use the Bulk Edit<\/strong> form and set your formula in the Regular Price<\/strong> or Sale Price<\/strong> fields as we described before.<\/p>\n\n\n\n
![\"Set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/set-sale-price-formula-2.png\")
<\/a><\/figure>\n\n\n\nAs soon as pressing on the Do Bulk Edit<\/strong> button, the prices of all selected variations will be updated. <\/p>\n\n\n\n
![\"Bulk](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/06\/bulk-edit-sale-price-result-2.png\")
<\/a><\/figure>\n\n\n\nExample 1: Increase the regular price of products in the Accessories or Clothing categories by formula<\/h3>\n\n\n\n
To successfully fulfill the purpose of this example, the below steps are required: <\/p>\n\n\n\n
- \n
- Go to the Filter Form<\/strong> and open the Categories\/Tags\/Taxonomies<\/strong> tab. Choose OR<\/strong> from the first combo box of the product categories field, then select Accessories<\/strong> and Clothing<\/strong> from the list of categories in the next box.<\/li>\n<\/ul>\n\n\n\n
![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-accessories-and-clothing-categories.png\")
<\/a><\/figure>\n\n\n\n- \n
- Press the Get Products<\/strong> button to filter the products, then mark any of them in the table and open the Bulk Edit<\/strong> form.<\/li>\n<\/ul>\n\n\n\n
![\"result](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-regular-price-column.png\")
<\/a><\/figure>\n\n\n\nAs we mentioned above, you need to go to the Pricing<\/strong> tab, choose Formula<\/strong> from the first combo box, and write the below formula in the next box:<\/p>\n\n\n\n
(X * (0.40))+20)<\/strong><\/p>\n\n\n\n
Please note that in all formulas used in this plugin, X<\/strong> represents the current value of product prices.<\/p>\n\n\n\n
To round the prices, you can choose one of the default options of the third combo box. For example, we chose 99.<\/p>\n\n\n\n
![\"write](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/write-formula-in-bulk-edit-form.jpg\")
<\/a><\/figure>\n\n\n\nNow, by pressing the Do Bulk Edit<\/strong> button, all prices of selected products are increased by 10%, as we expected.<\/p>\n\n\n\n
![\"result](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-formula.png\")
<\/a><\/figure>\n\n\n\nExample 2: Decrease the regular prices of the products that their stock quantities range from 5 to 20 by one-third<\/h3>\n\n\n\n
The Steps to reach the purpose of this example are as follows:<\/p>\n\n\n\n
- \n
- Open the Filter Form<\/strong> and go to the Stock<\/strong> tab, find the Stock Quantity<\/strong> field, and set 5 and 20 for the first and second boxes, respectively.<\/li>\n<\/ul>\n\n\n\n
![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-stock-tab-in-filter-form.png\")
<\/a><\/figure>\n\n\n\n- \n
- Click on the Get Products<\/strong> button to see the filtered product in the table.<\/li>\n\n\n\n
- Mark the checkbox next to the ID<\/strong> to select all the products.<\/li>\n<\/ul>\n\n\n\n
![\"mark](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/mark-checkbox-id-in-all-products.png\")
<\/a><\/figure>\n\n\n\n- \n
- Open the Bulk Edit<\/strong> form and go to the Pricing<\/strong> tab. <\/li>\n\n\n\n
- After choosing the formula, write the below formula in the second box:<\/li>\n<\/ul>\n\n\n\n
X-(X\/3)<\/strong><\/p>\n\n\n\n
By clicking on the Do Bulk Edit<\/strong> button, you can see that all regular prices have been changed according to the written formula.<\/p>\n\n\n\n
- After choosing the formula, write the below formula in the second box:<\/li>\n<\/ul>\n\n\n\n
- Mark the checkbox next to the ID<\/strong> to select all the products.<\/li>\n<\/ul>\n\n\n\n
- Click on the Get Products<\/strong> button to see the filtered product in the table.<\/li>\n\n\n\n
- Open the Filter Form<\/strong> and go to the Stock<\/strong> tab, find the Stock Quantity<\/strong> field, and set 5 and 20 for the first and second boxes, respectively.<\/li>\n<\/ul>\n\n\n\n
- Press the Get Products<\/strong> button to filter the products, then mark any of them in the table and open the Bulk Edit<\/strong> form.<\/li>\n<\/ul>\n\n\n\n
- Go to the Filter Form<\/strong> and open the Categories\/Tags\/Taxonomies<\/strong> tab. Choose OR<\/strong> from the first combo box of the product categories field, then select Accessories<\/strong> and Clothing<\/strong> from the list of categories in the next box.<\/li>\n<\/ul>\n\n\n\n
- Bulk change product price by formula for WooCommerce<\/strong><\/li>\n<\/ul>\n\n\n\n
- Show and select variations in the table<\/strong><\/li>\n<\/ul>\n\n\n\n
- Filter variable products:<\/strong><\/li>\n<\/ul>\n\n\n\n
- Choose Formula<\/strong> from the list of Operators<\/strong> and insert your formula in the Regular price<\/strong> or Sale Price<\/strong> fields.<\/li>\n<\/ul>\n\n\n\n
- Go to the Pricing<\/strong> tab in the Bulk Edit<\/strong> form.<\/li>\n\n\n\n
- Open the Type<\/strong> tab and locate the Product Type<\/strong> field.<\/li>\n\n\n\n
- Go to the Filter Form.<\/strong><\/li>\n\n\n\n
- After writing the formula, you need to press the Do Bulk Edit<\/strong> button to let the plugin update the regular prices of the selected products based on it.<\/li>\n<\/ul>\n\n\n\n
- Clear Value:<\/strong> clear or remove product price value.<\/li>\n\n\n\n
- In front of the Regular Price<\/strong>, there are three boxes. <\/li>\n<\/ul>\n\n\n\n
- In the Bulk Edit<\/strong> form, go to the Pricing<\/strong> tab.<\/li>\n\n\n\n
- Use the Code Snippets p<\/span><\/a>lugin<\/span><\/a> to add your code to WordPress.<\/li>\n<\/ol>\n\n\n\n