Trigger for discount on orders
It is possible to add a trigger to manage the discount in the ordering process.
In this example we will give automatically discount based on the user groups the person ordering beloangs to.
-
People that are in the group 'Student' will get 50% off.
-
People that are in the group 'Internal' will get 100% off (they can order for free).
-
People in any other group (not in Student nor Internal) will get no discount and will have to pay the full price.
Note that the person should in any case also be part of the internet user group!
So to get the 50% discount, the person needs to be part of the Student group as well as the internet user group.
-
In the Order template, make sure that the option Reduction group is unchecked.
-
In the desktop, go to the backstage section - Database - Edit groups of current database
-
Check the ID of the groups to be included. In this example the Interal group is ID7 and the Student group is ID8
-
Check the following information:
-
World id: In the backstage section - Info - Current database information
-
in these example triggers we will use the Word id: 1234567
-
ID of the following 3 fields in the Order headers table:
-
'Total price'
-
'Total reduction price'
-
'Total VAT price'
-
ID of Order status field in the Order headers table
-
- Database, Trigger management (admin rights are required to be able to access the Trigger management). Two triggers are needed to make the reduction go smootly: