Mass Price Update by Formula for Magento 2

Mass Price Update by Formula for Magento 2
Magento Edition
Pro installation
  • 11
  • 7

The extension would be useful for those who frequently change products' Price, Special Price, Customer Group Price, etc. Unlike the native Update Attributes mass action, the new Update Price action allows admins to update the prices by a specific formula that uses values of any price-typed attributes as variables. Be it a simple change like +10.50 or -5.5% or a sophisticated formula like ({price} + 1) * {coefficient_attr} / 3 * 4 + 1.5^2.


Once the extension has been installed, the Actions menu will include a new point Update Price. To make use of it, follow the simple steps:

• Filter and select the to-be-updated products and click on Update Price.

• In the modal window featuring all the attributes of the price type, fill out the fields using expressions and formulas.

Simple expressions:


Use variables based on product attribute values:
{price} + {attribute_code1} - 2
{price} * 4 / {attribute_code2}

Other examples including brackets, exponentiation (^), square root (sqrt) and others (abs, exp, sin, cos, tan, log):
(5.50 + 3) * 2
{price} * 4 + {attribute_code3}^3
abs{price} + exp(1.5)

Don't forget that multiplication and division operations have higher priority over addition and substraction.

• The same way, you can add the needed number of Customer Group Price rows and enter individual expressions. Please note, once you apply the change all the previous Customer Group Price records will be replaced with the new ones.

• Hit Apply to queue the update operation!


  • Mass price update with any formula
  • Update Price as well as any other product attribute of the price type
  • Ability to update Customer Group Price by formula too
  • Simple expressions: +10 | -3% | *1.5
  • Use attribute values as variables
  • Use regular math operators like brackets, power (^), square root (sqrt), abs, exp, sin, cos, tan, and log



Magento Open Source (CE) 2.2.x, 2.3.x, 2.4.x
Magento Commerce (EE) 2.2.x, 2.3.x, 2.4.x


We provide comprehensive product support for all the Magento extensions available on this site starting from the moment of your purchasing them. If you need help on the extensions installation or on any issues relating to our products, our dedicated team of proven technical experts is at your service, ready to assist you at any time.


new feature bugfix
v.2.1.4 (Jul 26, 2023)
Minor code refactoring.
v.2.1.3 (Jun 19, 2022)
Added support for Magento 2.4.4 and PHP 8.1.
v.2.1.2 (Sep 3, 2021)
Minor code refactoring.
v.2.1.1 (Aug 17, 2020)
Minor fixes and improvements.
v.2.1.0 (Aug 10, 2020)
Added Customer Group Price update by formula.
v.2.0.0 (Aug 6, 2020)
Initial release.


Write Your Own Review

Only registered users can write reviews. Please, log in or register