What this page is for
Derive prices works out new prices for this list by reading another list as it stands now, converting to this list's currency, applying an adjustment, and rounding the result. Nothing is priced straight away: it generates a draft price change on this list, which someone still has to review and approve. A price already set by hand on this list is kept rather than overwritten by the derivation.
Only people whose role can set prices see this page.
Before you start
- Both price lists must exist (New price list): the one you are deriving from, and this one.
- The source list should already carry the prices you want to build from.
Fields
Read prices from
The other list this one's prices are worked out from. Required.
Example: Retail
Adjustment
How the source price is changed before it is written here.
- No adjustment: use the source price as it is, once converted to this list's currency.
- Percentage: raise or cut by a percentage.
- Fixed amount: add or subtract a fixed amount.
Example: Percentage
By
The size of the adjustment. A markup is a positive number; a discount is the same number with a minus sign in front.
Example: 15 for a 15% markup; -10 for a 10% discount.
Rounding
How the adjusted price is rounded.
- To the smallest coin: rounds to the currency's smallest unit.
- To the nearest step: rounds to the nearest multiple of the step.
- Up to the step: always rounds up.
- Down to the step: always rounds down.
- Just below the step, such as 499.99: rounds up to the step, then subtracts the smallest coin.
Example: Just below the step, such as 499.99
Round to a multiple of
The step the rounding works to. Not used with To the smallest coin.
Example: 50
Takes effect
When the generated price change should take effect, once approved.
Example: 1 November 2026, 06:00
How to…
How to derive a price list
- Open the list and press Derive prices.
- Choose Read prices from, the source list.
- Choose an Adjustment and, if you chose one, type By.
- Choose Rounding and, if it needs one, Round to a multiple of.
- Set Takes effect.
- Press Generate price change. It opens as a draft, source Derived, for you or someone else to check and submit for approval.
Worked examples
Supermarket
Tumaini Supermarket derives Wholesale from Retail: Read prices from Retail, Adjustment Percentage, By -12 (a 12% discount off retail), Rounding To the nearest step, Round to a multiple of 5, Takes effect now. The generated draft lands on Price changes with source Derived, ready to submit.
Restaurant and bar
The Acacia Grill & Bar derives a new Happy hour round from Bar: Read prices from Bar, Adjustment Percentage, By -20, Rounding Just below the step, such as 499.99, Round to a multiple of 50. A KES 650 (Kenyan shillings) cocktail becomes KES 520 after the discount, then KES 549.99 under the charm-pricing rule: up to the next KES 50 step, less the smallest coin.