Oracle Config - Availability & Pricing Rules
- Marrara, Jean
Analytics
In Oracle Simphony we use prices to determine if an item is available or not available. The availability is managed at menu item level which includes Ala carte, Condiments and Combos.
What determines if an item is available or not is the existence of a price. If price is not defined the item is not available, if price is defined then item is available.
In Oracle Simphony we use Definition Sequence and Price Sequence to define the availability and the price of a Menu Item for a specific product, in a specific ordering mode and channel.
Availability Rules
Availability is managed at menu item level.
Menu Item level includes Ala carte, Condiments and Combos.
What determines if an item is available or not available is the existence a of price.
If price is not defined the item is not available, if price is defined item is available.
Prices can have effectivity dates, when a price is set but out of range of effectivity date then the item is also not available.
Prices are set for specific Definition Sequences and Price Sequences hence item is available only in the Level or Channel related to the definition and price sequence.
Price set as zero means item is available and price (or charge) is zero.
Availability and Prices
As stated above the items are available if they have prices and are not available if they do not have prices.
As described in the Item Pricing section, prices are set per Menu Item. Definition Sequence and Price Sequence, and a Menu Item may have zero or more prices.
In the EMC, the price is set using the Configuration / Menu Item Maintenance / Price Record. See the Item Pricing section for more details.
Definitions and Price Sequences
Menu Items may have one or more Definitions, and zero or more Price sequences, the pair Definition/Price sequence defines where and when the item can be used.
For Ala Carte and Combos the rule is:
Definition Sequence | Price Sequence | Channel |
|---|---|---|
1 | 1 | In Restaurant (Eat in and Take out) |
1 | 2 | 1st party Delivery |
1 | 3 | 3rd party Delivery |
1 | 4 | 3rd party Delivery - Non Integrated/Manual |
For Condiments the rule is:
Definition Sequence | Price Sequence | Modifier |
|---|---|---|
1 | 1 |
|
1 | 2 | Add (In Restaurant) |
1 | 3 | No (In Restaurant) |
1 | 4 | Sub (In Restaurant) |
1 | 5 |
|
1 | 6 | Add (Delivery) |
1 | 7 | No (Delivery) |
1 | 8 | Sub (Delivery) |
Optionally, in case more flexibility is required meaning different behavior for the Menu Item sold in different modes then different Definition Sequences can be used.
For Ala Carte and Combos the rule is:
Definition Sequence | Price Sequence | Channel |
|---|---|---|
1 | 1 | In Restaurant (Eat in and Take out) |
1 | 2 | 1st party Delivery |
2 | 1 | 3rd party Delivery |
2 | 2 | 3rd party Delivery - Non Integrated/Manual |
For condiments the rule is:
Definition Sequence | Price Sequence | Modifier |
|---|---|---|
1 | 1 |
|
1 | 2 | Add (In Restaurant) |
1 | 3 | No (In Restaurant) |
1 | 4 | Sub (In Restaurant) |
1 | 5 |
|
1 | 6 | Add (1p Delivery) |
1 | 7 | No (1p Delivery) |
1 | 8 | Sub (1p Delivery) |
2 | 1 |
|
2 | 2 | Add (3p Delivery) |
2 | 3 | No (3p Delivery) |
2 | 4 | Sub (3p Delivery) |
2 | 5 |
|
2 | 6 | Add (3p manual Delivery) |
2 | 7 | No (3p manual Delivery) |
2 | 8 | Sub (3p manual Delivery) |
Effectivity Groups
Effectivity Groups can be used to set temporary availability for items. The feature can be used for LTOs, coupons and any other kind of items requiring temporary availability.
In the Effectivity Group we set the Start and End dates as demonstrated in the picture below.
Then, when setting prices, we associate the effectivity group to the price, hence the price will be active only during the Effectivity Group date rage and, by consequence, the item will be only available within the same date range.
Permanently Disabling Items - Simphony 19.5.x
A Special Effectivity Group 99999 called “Disable” will be created and used to disable items at any level.
The End Date of the “Disable” Effectivity Group is set to a date in the past hence any item associated to the Group will be unavailable.
The Effectivity Group 99999 “Disable” is intended to be used to set Effectivity Group of the prices of the Menu Items that should be not available in certain locations.
The configuration can be done at property level by overriding the price at the location and set the Effectivity Group of the price to 99999 “Disable” .
Permanently Disabling Items - Simphony 19.6.2 and greater
NOTE: This procedure only works on Simphony versions 19.6.2 and newer.
A Special Effectivity Group 99999 called “Disable” will be created and used to disable items at any level.
The End Date of the “Disable” Effectivity Group is set to a date that is in the past hence any item associated to the Group will be unavailable.
The Effectivity Group 99999 “Disable” is intended to be used to set Effectivity Group of the Menu Item Master, making the Item unavailable even if price is set and active.
The configuration can be done at any level (Enterprise, Country, FZ or property) and will not override the Menu Item Master definition of the item, it will only override the Effectivity Group.
In the example below we are overriding the Effectivity Group of the 1001077 Stacker King Menu Item Master to 99999 “Disable” at the property “UAT-Lab-Brazil.