- {p.ATTRIBUTE_CODE}
- All product attributes
- eg.: {p.price}, {p.cost}, {p.margin}
- {c.ATTRIBUTE_CODE}
- Customer KPI
- 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
- 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
- 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
- Conditional Pricing
- You can use IF in the formulas
{IF {p.price} > 100}
{p.price} * 0.9
{ELSE}
{p.price} * 0.8
{/IF}