Available Variables
Filipe Sá
Last Update a day ago
- {p.ATTRIBUTE_CODE}
- {c.ATTRIBUTE_CODE}
- All customer Attributes
- eg.: {c.discount_rate}
- All customer Attributes
- Customer KPI
- All customer KPI fields
- eg.: {e.number_orders}
- All customer KPI fields
- Statistical sales
- sd
- {sd.qty_invoiced}
- Quantity invoice in that day for the product
- {sd.min_price}
- Min sale price in that day for the product
- {sd.max_price}
- Max sale price in that day for the product
- {sd.avg_price}
- Average sale price in that day for that product
- {sd.qty_invoiced}
- sm
- {sm.qty_invoiced}
- Quantity invoice in current month for the product
- {sm.min_price}
- Min sale price in current month for the product
- {sm.max_price}
- Max sale price in current month for the product
- {sm.avg_price}
- Average sale price in current month for that product
- {sm.qty_invoiced}
- sy
- {sy.qty_invoiced}
- Quantity invoice in current year for the product
- {sy.min_price}
- Min sale price in current year for the product
- {sy.max_price}
- Max sale price in current year for the product
- {sy.avg_price}
- Average sale price in current year for that product
- {sy.qty_invoiced}
- Conditional Pricing
- You can use IF in the formulas
- sd