Username
Password
Remember Me
Log in

Product Price Formula for Magento (v1.6.1)

Product Price Formula for Magento
Compatibility:
  • Magento® Community 1.4.x, 1.5.x, 1.6.x, 1.7.x, 1.8.x, 1.9.x
  • Magento® Enterprise 1.7.x, 1.8.x, 1.9.x, 1.10.x, 1.11.x, 1.12.x, 1.13.x, 1.14.x
User Guide: Product Price Formula for Magento User Guide PDF
DEMOS
  1. Price based on object size DEMO
  2. Setup Fee DEMO
  3. Price Matrix DEMO
Product Price Formula
$199.00
Full version for Magento Community Edition
Pack includes:
  • Extension for Magento CE 1.4.x, 1.5.x, 1.6.x, 1.7.x, 1.8.x, 1.9.x
  • License key for 1 Magento Website
  • FREE Support
  • Documentation
Platform:
Community
License:
Full Regular$199.00
Quantity:
1$199.00
Need Installation?
No
Support:
4 months(included)
2CO Buy Now Add to Cart
  • Updates
    FREE
  • Support
    FREE
  • Money Back
    60 Days

A powerful extension for Magento to calculate the product price based on your custom math formula and product options. Allows creating complex logical conditions, multiple calculation rules, price matrix and more...

Features

  • Ability to create complex logical conditions like: if () {} elseif () {} elseif () etc.
  • Ability to create multiple rules and formulas within a single product
  • Full flexible control over the final price via a chain of conditions
  • Conditional branching
  • Ability to use product options within conditions and price formulas
  • Ability to use product attributes within conditions and price formulas
  • Ability to use configurable options. Full support of configurable products
  • Ability to use the quantity value in conditions and formulas, allows creating custom tier pricing
  • Ability to use math functions like sin(), cos(), sqrt(), pow(), etc.
  • Ability to create different formulas for different customer groups
  • Ability to limit formulas in time by setting the date range. You can create limited time offers.
  • Ability to apply formula either to the item price or the row total in cart (NEW)
  • Ability to calculate product's shipping weight based on your custom formula (NEW)
  • Ability to set custom validation criteria (formula or combination of options) (NEW)
  • Ability to copy price formulas from one product to multiple ones in bulk (NEW)

Screenshots:

previewpreview preview preview preview preview preview preview preview preview preview preview
Examples of Use

 

Calculation based on the object size

 

  • You need to apply a single setup fee to a bunch of products not depending on the quantity ordered. See the "Setup Fee" DEMO
Multiple products, single setup fee

 

Price matrix

 

Math operators and functions

Use the following condition and math operators:

Operator Explanation Example
() Sub condition ( {sku1} + {sku2} ) / PI
+ Addition {sku1} + 10
- Subtraction {sku1} - 10
* Multiplication 2 * PI * {sku_radius}
/ Division {sku1} / 1.5

 

Math functions:

Function Explanation
abs(x) Returns the absolute value of x
acos(x) Returns the arccosine of x, in radians
asin(x) Returns the arcsine of x, in radians
atan(x) Returns the arctangent of x as a numeric value between -PI/2 and PI/2 radians
atan2(y,x) Returns the arctangent of the quotient of its arguments
ceil(x) Returns x, rounded upwards to the nearest integer
cos(x) Returns the cosine of x (x is in radians)
exp(x) Returns the value of Ex
floor(x) Returns x, rounded downwards to the nearest integer
log(x) Returns the natural logarithm (base E) of x
max(x,y,z,...,n) Returns the number with the highest value
min(x,y,z,...,n) Returns the number with the lowest value
pow(x,y) Returns the value of x to the power of y
random() Returns a random number between 0 and 1
round(x) Rounds x to the nearest integer
sin(x) Returns the sine of x (x is in radians)
sqrt(x) Returns the square root of x
tan(x) Returns the tangent of an angle

 

Constants:

Constant Explanation
E Returns Euler's number (approx. 2.718)
LN2 Returns the natural logarithm of 2 (approx. 0.693)
LN10 Returns the natural logarithm of 10 (approx. 2.302)
LOG2E Returns the base-2 logarithm of E (approx. 1.442)
LOG10E Returns the base-10 logarithm of E (approx. 0.434)
PI Returns PI (approx. 3.14)
SQRT1_2 Returns the square root of 1/2 (approx. 0.707)
SQRT2 Returns the square root of 2 (approx. 1.414)

 

Variables:

Variable Explanation
{configured_price} Price after product options selected
{initial_price} Price before options selected
{price} Price after all calculations applied
{special_price} Special price configured in the product
{attrbute_code} Any product attribute code enclosed into {}
{option_sku} Call any product option by its SKU enclosed into {}
{option_sku.qty} The quantity of sub-option if Dynamic Product Options installed
{option_sku.price} Get the price of option by sku
{option_sku.length} Get the length of entered text
{configurable_pid} Returns the ID of currently selected product within the configurable product
{qty} Product quantity selected

 

Reviews

Customer Reviews

Fantastic Support

Rating:

Got a 7 day trial to find out if the product was suitable. All worked fine, asked about 2 features that were not included, they said it was a good idea (weight formula and the validation for the formulas) and would forward it to the developer. Wham! 20 hours later I received an email telling me they had added both and to give it a try! I hadn't even purchased the module and already they improved it. The help and emails I received before, and even after purchase were very quick (6-18 hours depending on timezones etc) and gave help with the formulas themselves with suggestions on how to make them more streamlined. I cannot stress how helpful they were and the module itself is excellent, I have some very complex formulas for pricing, and my old way required about 187 separate products. I now have that streamlined into 1! I cannot fault this developer and will be keeping a keen eye on all their modules in the future!

Review by TheModBlog - Oct 29, 2015

Essential extension and A+ support

Rating:

This extension works well when you have complex options and specs for pricing. It allows you to get essential variables for your price calculations and build conditions for every conceivable combination. We made some basic function syntax mistakes and support was extremely responsive and quick to solve our issues. It's great not to be restricted by Magento pricing rules.

Review by andresouroujon - Sep 15, 2015

Write Review
Your Rating: *
Nickname: *
Summary: *
Review: *

Questions & Answers

Questions & Answers

Marcis - 3 weeks ago

Question: Is there available backend demo for this plugin?
https://www.itoris.com/magento-product-price-formula.html

If not - is it possible to automatically calculate selling price by getting cost from a product attribute and then adding different marge depending on sum, cagegory etc.

Thanks in advace for your answer!
Marcis

ITORIS Team - 3 weeks ago

Answer: Hello Marcis,
There is no backend demo for this extension, unfortunately.
But, you can use product attributes in your formula. For example to add 20% to cost, Price = {cost} * 1.2
Or, make it conditional, for example make a 5% discount if price is greater than $200: IF ( {price} > 200 ) Price = {price} * 0.95

anup - 1 year ago

Question: I would like to use to calculate the following costs:

( {length} * ( {Width} + {Height} ) ) * 170.5 + 20 = Cost not including tax

and

( {length} * ( {Width} + ({Height} * pie / 2 ) ) * 170.50 + 20 = Cost not including tax


Will this work?

ITORIS Team - 1 year ago

Answer: Hello,
Yes, using the extension you can easily create price formulas like this. The variables are the custom option SKUs or product attributes in curly brackets, e.g. {optionSku} or {attribute_code}. For example, width and height are custom options entered by the customer, and length is the product attribute defined by admin, etc.

Ask Your Question
Nickname: *
Email: * (will not be shown to public)
Question: *

Change Log

Legend:
+ - new feature
* - bugfix
^ - improvement
- - excluded feature

1.6.1 (2018-01-10)
^ More speed improvements

1.6.0 (2018-01-08)
^ Speed improvements to calculations on frontend

1.5.9 (2017-07-03)
* Fixed final price calculation if the base price already includes tax

1.5.8 (2017-06-02)
^ Added support of multiple price boxes on the page
* Fixed issue with variables placed in brackets
* Fixed variable {optionSku.price} for options having a percentage price

1.5.7 (2017-04-07)
^ Added support of negative option prices
^ Added possibility to use sub-conditions within conditions

1.5.6 (2017-02-15)
^ Fixed issue on the customer edit page in backend

1.5.5 (2017-02-02)
^ Improved the calculation speed

1.5.4 (2017-01-25)
* Fixed issue with formula saving in backend when strict error reporting is enabled in php

1.5.3 (2016-08-12)
* Fixed issue with price calculation in cart
* Fixed display of product price with tax on the product view

1.5.2 (2016-07-05)
^ Added support of digital skus

1.5.1 (2016-06-17)
^ Allowing dash for SKU variables

1.5.0 (2016-05-24)
+ Added possibility to get the price of option using variable {option_sku.price}
+ Added possibility to get the quantity of option using variable {option_sku.qty} (if the Dynamic Product Options extension installed)
+ Added possibility to get the length of entered text using variable {option_sku.length}
* Fixed display of selected customer groups in formula
* Fixed JS error on frontend if call variable of option having native price
* Fixed JS error on frontend if variable used in the weight formula or in the validation formula only

1.4.1 (2016-04-01)
* Fixed issue with product's custom price if create order from backend

1.4.0 (2016-02-12)
+ Added full support of configurable products, added variable {configurable_pid} that returns the ID of currently selected product
* Fixed issue with price updating for products without options, i.e. if only attributes or {qty} used in formula

1.3.3 (2016-01-05)
* Fixed issue with 0 price in cart

1.3.2 (2015-11-25)
* Fixed issue with using product attributes in formulas

1.3.1 (2015-11-04)
^ Fixed the "Add to cart" conflict with the Dynamic Product Options extension

1.3.0 (2015-11-03)
^ Added compatibility with Magento CE 1.9.2.2, EE 1.14.2.2, and patch SUPEE-6788

1.2.1 (2015-10-27)
* Fixed issue with the order of multiple formulas within the same product

1.2.0 (2015-10-26)
+ Added possibility to copy price formulas from one product to multiple ones. Option "Copy price formulas 1 to many" added to the Actions dropdown on the product grid.

1.1.0 (2015-10-22)
+ Added possibility to override product's weight based on custom formula
+ Added possibility to disallow purchasing the product based on custom formula or combination of custom options
^ Copying formulas if admin duplicates product

1.0.7 (2015-10-09)
^ The formula editing area has been increased (for long formulas)

1.0.6 (2015-10-07)
* Fixed issue with total price rounding in the cart

1.0.5 (2015-10-02)
* Fixed issue prevented accumulative price with multiple formulas used in the same product

1.0.4 (2015-09-28)
^ Increasing the maximum length of formula

1.0.3 (2015-09-21)
* Fixed issue with empty payment methods when creating order from backend

1.0.2 (2015-09-17)
^ Added multi-currency support
+ Added possibility to select either apply formula to the item price or to the row total
+ Added possibility to enable display of the product price on frontend multiplied by the quantity selected

1.0.1 (2015-09-15)
* Fixed issue with variables of the dropdown type product options
* Fixed issue with tier prices calculation on frontend

10 REASONS TO CHOOSE ITORIS
risk free
Risk-Free Investment
No risk at all. 60-day money back guarantee.
simple licensing
Simple Licensing
One license per one Magento® installation. No store, website, or domain limitation. No monthly or hidden fees.
Try before purchasing
Free Lifetime Updates
Never pay for updates! Simply download the latest version of your favorite extension from our website when you need it.
Free Installation Service
Free Installation Service
Contact Us and we will help you install our extensions absolutely for FREE.
full open source
Full Open Source
No obfuscation, no encryption. Only Full Open Source extensions. Ideal for customizations.
Following Magento Standards
Following Magento® Standards
All our extensions are written following Magento® code standards.
Professionally Tested Modules
Professionally Tested Modules
We do our best to keep quality of our extensions: performance, functional, and cross-browser testing.
Comprehensive Documentation
Comprehensive Documentation
Detailed documentation for all extensions is available online and in PDF. Forum and FAQs.
Outstanding Support
Outstanding Support
Free and friendly EST time support. Help, tips & tricks, and even small customizations will be provided.
Long Term Strategy
Long Term Strategy
8+ years in eCommerce. We grow to provide you even better services and extensions, and are always open to customers' suggestions.