Promotion formulas

Promotion formulas

9.7

Revision History
14.12.2010
Tab pages were transformed into panels. The Filter settings panel, which displays a data grid with a list of filter steps, was added. The Filter panel, by contrast, displays filter parameters. The Query panel was added to describe functions and parameters of queries. In the Information panel, you can now enter additional information about the discount calculation function.
07.10.2011
Query parameters were added from the removed Comment panel.
02.02.2012
The System column was added to the data grid. The Export and Summary functions menus were added to the context menu, and the Import command was removed from it. The multiple discount calculation functions entry window was added.
02.05.2012
The description of the Query panel now has reference information about parameters that can be used in discount calculation function queries.
20.09.2012
The Security level column was added to the data grid of the directory. The Add copy command was removed from the context menu of the data grid. The Security level panel was added to the Discount calculation function window
15.01.2013
Discount types were renamed Promotion types, and Discount calculation functions were renamed Promotion formulas.
24.03.2016
A description of the SQLite query panel was added.
07.07.2016
A description of the Guest tab panel was added.

Promotion formulas determine how to calculate discounts (or markups) or how to offer the bonuses that accompany a customer's promotion types. A standard promotion type includes Transact SQL and SQLite queries, which define how prices of menu items can be changed in an order or how items can be added to an order. Transact SQL queries are used in Tillypad XL Manager, while SQLite queries are used in Tillydroid App . This way, both applications can use the same promotion formula.

Standard promotion types are managed in the Promotion formulas directory.

The directory contains system promotion formulas, i.e. various methods of calculating commonly used discounts, markups and bonuses. The program enables you to apply the system promotion formulas as well as to create new formulas.