Price List Hierarchy
Table Of Contents
When a customer is assigned to multiple price lists and Force Lowest Price is not enabled in [ System Values | Sales | Pricing ], Khaos Control follows a defined pricing hierarchy to determine which price should be used.
This article explains how the hierarchy works, how priorities are applied, and how promotional price lists are evaluated when more than one price is available.
Contents
- base-prices
- modifiers
- post-selection
- examples
- example-one
- example-two
How Price Selection Works
Khaos Control evaluates pricing in three stages:
- Base Prices are checked first to find the most applicable starting price.
- Modifiers are then applied, such as keycode discounts or customer discounts.
- Post Selection rules are applied last to validate or restrict the selected price.
For example, if Stop Structure Discounts is enabled, only the selected Stock Item base price may be used at that point in the pricing process.
In general, the higher the priority value, the more likely that pricing rule is to be applied.
NoteBy default, percentage discounts on Sales Orders are either combined or the higher-priority discount takes precedence.Alternatively, the Compound Discounts option in[ System Values | Sales | Pricing ]allows discounts to be multiplied together.For example:
- Keycode discount = 50%
- Price list discount = 20%
The 50% discount is applied first, leaving 50% of the price remaining.The additional 20% discount is then calculated from the remaining 50%.Calculation:50 + ((50 ÷ 100) × 20) = 60%The total effective discount is therefore 60%.
Base Prices
Base Prices provide the initial price before any discounts or restrictions are applied.
| Pricing Type | Price Source | Priority |
|---|---|---|
| Base Price | Special Offer | 10,000 |
| Base Price | Keycode | 9,500 |
| Base Price | Up/Cross Sell | 9,000 |
| Base Price | Catalogue Price | 7,000 |
| Base Price | Customer / Stock Item | 6,000 |
| Base Price | Price List / SCS Child Stock Item* | 5,002# |
| Base Price | Price List / SCS Parent Stock Item* | 5,001# |
| Base Price | Price List / Stock Item | 5,000 |
| Base Price | Customer / Stock Type | 4,000 |
| Base Price | Price List / Stock Type | 3,000 |
| Base Price | Stock Item | 1,000 |
Modifiers
Once a base price has been selected, modifier rules are applied.
| Pricing Type | Price Source | Priority |
|---|---|---|
| Modifier | Keycode Discount | 8,000 |
| Modifier | Bogof Discount | 7,000 |
| Modifier | Customer Discount | 5,000 |
| Modifier | Processing Charge | 1,000 |
Post Selection
Post Selection rules are applied after the price and discounts have been calculated.
| Pricing Type | Price Source | Priority |
|---|---|---|
| Post Selection | Stop Structured Disc | 7,000 |
| Post Selection | Guide Prices | 5,000 |
| Post Selection | Low Limit (Disabled) | 3,000 |
Promotion and Price List Priorities
When multiple qualifying price lists exist at the same level in the hierarchy, Khaos Control uses the promotion or price list code to determine which one takes priority.
The system compares codes using the following rules:
- The number 0 ranks higher than 9.
- Numbers rank higher than letters.
- Letters are evaluated alphabetically, regardless of capitalisation.
Example
If a customer is associated with the following price lists:
- bct1
- 8drt
The 8drt price list will take priority because numbers rank higher than letters.
This approach can be useful when designing promotional price lists that need to take precedence over others.
NoteProcessing Charges and Guide Prices are not available on all systems.
Base Price Notes
SCS Parent and Child Pricing
* SCS Parent and Child priorities only apply where stock items are part of an SCS relationship. If an item is not part of an SCS relationship, these priorities are ignored.
Force Lowest Price Behaviour
# Force Lowest Price can affect whether the parent or child item price is selected.
| Scenario | Result |
|---|---|
| Force Lowest ON, Parent Price lower than Child Price | Parent Price |
| Force Lowest ON, Parent Price higher than Child Price | Child Price |
| Force Lowest OFF, Parent Price lower than Child Price | Child Price |
| Force Lowest OFF, Parent Price higher than Child Price | Child Price |
| Force Lowest ON or OFF, Parent Price only | Parent Price |
| Force Lowest ON or OFF, Child Price only | Child Price |
Examples
Example One
This example demonstrates how Khaos Control selects between multiple price lists.
A customer has access to:
- A Price List / Stock Item linked directly to their customer account.
- A Price List / Stock Item applied through a Keycode.
- A Mini Price List within the Keycode.
NoteThe first two price lists occupy the same level within the pricing hierarchy.
Result
Khaos Control uses the price list with the highest alphanumeric priority.
Price lists associated with a Keycode are treated as additional price lists and not as Keycode prices.
If you need one price list to take precedence over another, consider using a code that begins with a number.
Example Two
A customer has two price lists assigned:
- A Price List / Stock Item with a 10% discount.
- A Price List / Stock Item with a 50% discount.
Result
- When Force Sales Order Lowest Price is enabled, Khaos Control uses the 50% discount price list.
- When Force Sales Order Lowest Price is disabled, Khaos Control uses the first qualifying price list in the hierarchy, which in this example is the 10% discount price list.
Additional Information
Understanding the pricing hierarchy can help when troubleshooting unexpected prices on Sales Orders. If a price appears different from what you expect, check:
- Which price lists are attached to the customer.
- Whether any Keycodes are being applied.
- Whether Force Lowest Price is enabled.
- Whether Compound Discounts are enabled.
- Whether any Post Selection rules, such as Stop Structured Discounts, are affecting the final result.
- The alphanumeric order of any competing promotional price lists.
Reviewing these areas will usually identify why a particular price has been selected.