Advanced Pricing

Brand Portal

Advanced Pricing allows more complex pricing options.  Much like a simple Excel formula, you can enter an equation to compute the trade order pricing.  Here you can do basic math; multiplication, division, addition, and subtraction, with parentheses for precedence.  

There are 4 reserved words;  mfgCost, ROUND, FLOOR, and CEILING.  Case sensitive.  The ROUND, FLOOR, and CEILING are identical to their Excel function in syntax.  'mfgCost' is the variable name for the manufacturing cost of the set. 

Here is an example of a 75% markup rounded to the nearest whole dollar:

    =ROUND(mfgCost * 1.75, 0)

Here is an example to make all your prices end with a three:

    =ROUND(mfgCost * 1.75, 1)  + .03

If present, an Advanced option will always override the basic percentage.