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
- Name rule
- SET the feed field you would like to adjust
- 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
/
- Subtraction
]]
Close the formula two closing brackets
-
- WHERE for all products or some products conditionally
- 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
]]
Comments
0 comments
Please sign in to leave a comment.