Number Function rules allow you to modify numeric fields in your feed data with a custom rule.

Note: Number Function rules can only be applied to numeric fields. Learn more about Data Types.

Create a calculator function

1. Name rule
2. SET the feed field you would like to adjust
3. TO create a calculation
   •  [[  Start the formula with two opening brackets
   • Select your number field from your product catalog - fields starting with [P]
   • Use any common operator in your formula, such as,
     • Subtraction -
     • Addition +
     • Multiplication *
     • Division /
   • ]] Close the formula two closing brackets
4. WHERE for all products or some products conditionally
5. Save rule

Examples

Static Text: Orange, Fields: Blue

1. Add 20% to Price for a markup

For example, follow the formula below to add 20% to your prices

[[ [P].[price] + ( [P].[price] * .2 ) ]]

2. Multiply Price by .7 to discount Price by 30%

For example, follow the formula below to discount price by 30%

[[ [P].[price] * .7 ]]

3. Subtract 2 from Quantity to create a buffer

For example, follow the formula below to add 50% to your quantity

[[ [P].[quantity] - 2 ]]