↑↓ selectEnter openEsc close

    1. Elbuz

    How to make a markup that depends on the product price

    6 min readUpdated

    Elbuz applies to each product the markup for the price range its price falls into: higher for cheap products, lower for expensive ones. You set up the tier ladder once.

    When you need this:

    • Small items +90%, expensive products +5% — each tier has its own coefficient.
    • A one-cent gap between tiers — Elbuz closes it itself.
    • A product that costs more to buy is cheaper in your store — “Markup at tier boundaries” smooths the transition.
    • A product got the wrong tier — “Rule order” sets which applies first.

    Where to start: set up the tiers — fill in “Price from” and “Price to” in the rules.

    What the threshold ladder can do

    How to set up a threshold ladder

    As soon as you fill in “Price from” or “Price to”, the rule becomes a threshold rule. Most rules are set up this way, and the reason is simple: a markup of dozens of percent on a cheap product scares no one, but on a product costing fifty thousand the same percentage means nobody buys it.

    Several threshold rules for one category make a ladder. Here is how it looks in a real setup for a home appliances category:

    Price fromPrice toCoefficientWhat it means
    02001.9small items go up by 90%
    2005001.5+50%
    5001,0001.4+40%
    1,0001,5001.3+30%
    1,5002,0001.2+20%
    2,0003,0001.17+17%
    3,0005,0001.15+15%
    5,0007,0001.1+10%
    7,00010,0001.09+9%
    10,00025,0001.08+8%
    25,00050,0001.07+7%
    50,000—1.05+5% and beyond, no upper limit
    Дані таблицею
    Показникto 200200–500500–1,0001,000–1,5001,500–2,0002,000–3,0003,000–5,0005,000–7,0007,000–10,00010,000–25,00025,000–50,000over 50,000
    Markup90504030201715109875
    Markup on each tier of the same ladder

    The ladder works mostly on cheap products. The first three tiers take almost the whole drop, from 90% to 40%; after that the steps shrink: from 5,000 up, neighboring tiers differ by one or two percent. Yet on expensive products even that matters: 5% of 50,000 is 2,500 on a single item.

    Use round numbers for boundaries and repeat them in neighboring tiers: “to 200” and right after it “from 200”. No need to count cents. A product priced at exactly two hundred takes the lower tier: of the two rules that match it, the first in rule order applies, and the product is then closed.

    Elbuz closes a small gap between tiers on its own. If you write “to 1,000” and “from 1,001”, a product priced at 1,000.50 would fall into neither and get no markup at all — so the lower tier is stretched up to where the next one starts.

    Any gap no wider than 1% of the upper boundary (and no less than 2 price units) is closed this way. Wide gaps stay as they are: “to 1,000” followed by a tier “from 5,000” is a deliberate band without markup, and products from 1,000 to 5,000 in it stay without a rule.

    How to remove the price dip where tiers meet

    A ladder has a flaw that isn’t obvious. The percentage is constant within a tier but jumps at the boundary, so every boundary produces a pair of products where the one that costs more to buy is cheaper in your store. Example: up to 300 it’s +15%, then +14%.

    Supplier priceStore price
    299343.85
    300345.00
    301343.14 — cheaper than the previous one

    A shopper comparing two models sees a mess, and you give away margin on one product while losing the price comparison on another.

    The bigger the step between tiers, the wider the dip zone: with a 15% → 14% step it covers prices from 300 to 302.6, and with a ladder of coefficients 1.9 → 1.5 it already spans 200 to 253 — a quarter of the tier.

    Two ways remove the dip, and they affect your earnings differently. Both are turned on in the “Markup at tier boundaries” list under the rules table.

    The Additional settings card under the pricing rules grid, with the Markup at tier boundaries list
    1Additional settings
    2Markup at tier boundaries list
    3Help icon linking to the guide
    1. Additional settings — the card sits below the rules grid, so it is easy to miss.
    2. Markup at tier boundaries — a list of three modes; the setting is shared across the whole account.
    3. Help icon — opens the guide section that explains what each mode does.

    Level up — keep the markup

    At the start of a tier, the markup equals the previous tier’s and smoothly goes down to its own by the end. A product at 301 gets the same 15% as one at 299 and comes out more expensive, not cheaper. The lower rate on pricier products stays — it just comes gradually, not in a jump.

    Level down — more competitive prices

    At the start of a tier, the markup is its own, and by the end it smoothly goes down to the next tier’s markup. A product at 299 already gets almost 14% and costs less than it would otherwise. The dip disappears because you give up part of the markup.

    Дані таблицею
    РядXY
    Stepped calculation20015
    Stepped calculation20515
    Stepped calculation21015
    Stepped calculation21515
    Stepped calculation22015
    Stepped calculation22515
    Stepped calculation23015
    Stepped calculation23515
    Stepped calculation24015
    Stepped calculation24515
    Stepped calculation25015
    Stepped calculation25515
    Stepped calculation26015
    Stepped calculation26515
    Stepped calculation27015
    Stepped calculation27515
    Stepped calculation28015
    Stepped calculation28515
    Stepped calculation29015
    Stepped calculation29515
    Stepped calculation30014
    Stepped calculation30514
    Stepped calculation31014
    Stepped calculation31514
    Stepped calculation32014
    Stepped calculation32514
    Stepped calculation33014
    Stepped calculation33514
    Stepped calculation34014
    Stepped calculation34514
    Stepped calculation35014
    Stepped calculation35514
    Stepped calculation36014
    Stepped calculation36514
    Stepped calculation37014
    Stepped calculation37514
    Stepped calculation38014
    Stepped calculation38514
    Stepped calculation39014
    Stepped calculation39514
    Stepped calculation40013
    Stepped calculation40513
    Stepped calculation41013
    Stepped calculation41513
    Stepped calculation42013
    Stepped calculation42513
    Stepped calculation43013
    Stepped calculation43513
    Stepped calculation44013
    Stepped calculation44513
    Stepped calculation45013
    Stepped calculation45513
    Stepped calculation46013
    Stepped calculation46513
    Stepped calculation47013
    Stepped calculation47513
    Stepped calculation48013
    Stepped calculation48513
    Stepped calculation49013
    Stepped calculation49513
    Stepped calculation50013
    Stepped calculation50513
    Stepped calculation51013
    Stepped calculation51513
    Stepped calculation52013
    Stepped calculation52513
    Stepped calculation53013
    Stepped calculation53513
    Stepped calculation54013
    Stepped calculation54513
    Stepped calculation55013
    Stepped calculation55513
    Stepped calculation56013
    Level up20015
    Level up20515
    Level up21015
    Level up21515
    Level up22015
    Level up22515
    Level up23015
    Level up23515
    Level up24015
    Level up24515
    Level up25015
    Level up25515
    Level up26015
    Level up26515
    Level up27015
    Level up27515
    Level up28015
    Level up28515
    Level up29015
    Level up29515
    Level up30015
    Level up30514,95
    Level up31014,9
    Level up31514,85
    Level up32014,8
    Level up32514,75
    Level up33014,7
    Level up33514,65
    Level up34014,6
    Level up34514,55
    Level up35014,5
    Level up35514,45
    Level up36014,4
    Level up36514,35
    Level up37014,3
    Level up37514,25
    Level up38014,2
    Level up38514,15
    Level up39014,1
    Level up39514,05
    Level up40014
    Level up40513,95
    Level up41013,9
    Level up41513,85
    Level up42013,8
    Level up42513,75
    Level up43013,7
    Level up43513,65
    Level up44013,6
    Level up44513,55
    Level up45013,5
    Level up45513,45
    Level up46013,4
    Level up46513,35
    Level up47013,3
    Level up47513,25
    Level up48013,2
    Level up48513,15
    Level up49013,1
    Level up49513,05
    Level up50013
    Level up50513
    Level up51013
    Level up51513
    Level up52013
    Level up52513
    Level up53013
    Level up53513
    Level up54013
    Level up54513
    Level up55013
    Level up55513
    Level up56013
    Level down20015
    Level down20514,95
    Level down21014,9
    Level down21514,85
    Level down22014,8
    Level down22514,75
    Level down23014,7
    Level down23514,65
    Level down24014,6
    Level down24514,55
    Level down25014,5
    Level down25514,45
    Level down26014,4
    Level down26514,35
    Level down27014,3
    Level down27514,25
    Level down28014,2
    Level down28514,15
    Level down29014,1
    Level down29514,05
    Level down30014
    Level down30513,95
    Level down31013,9
    Level down31513,85
    Level down32013,8
    Level down32513,75
    Level down33013,7
    Level down33513,65
    Level down34013,6
    Level down34513,55
    Level down35013,5
    Level down35513,45
    Level down36013,4
    Level down36513,35
    Level down37013,3
    Level down37513,25
    Level down38013,2
    Level down38513,15
    Level down39013,1
    Level down39513,05
    Level down40013
    Level down40513
    Level down41013
    Level down41513
    Level down42013
    Level down42513
    Level down43013
    Level down43513
    Level down44013
    Level down44513
    Level down45013
    Level down45513
    Level down46013
    Level down46513
    Level down47013
    Level down47513
    Level down48013
    Level down48513
    Level down49013
    Level down49513
    Level down50013
    Level down50513
    Level down51013
    Level down51513
    Level down52013
    Level down52513
    Level down53013
    Level down53513
    Level down54013
    Level down54513
    Level down55013
    Level down55513
    Level down56013
    Markup by supplier price: stepped calculation vs. the two leveling modes (ladder 15% → 14% → 13%)

    The stepped line drops vertically at the boundary: at 300 the markup instantly turns from 15% into 14% — hence the price dip.

    The other two lines get there gradually: “up” holds 15% right after the boundary and reaches 14% only at the end of the tier; “down” starts going down in advance and reaches the boundary already at 14%. The area between a mode’s line and the stepped line is the difference in your markup.

    What each leveling mode costs

    Six products around the 300 boundary, ladder 15% → 14% → 13%. The supplier price is the same in all three columns; the only difference is how the markup is calculated.

    Supplier priceStepped calculationLevel upLevel down
    210241.50241.50241.29
    270310.50310.50308.61
    299343.85343.85340.89
    305347.70350.60347.55
    350399.00400.75397.25
    395450.30450.50446.55
    Your earnings from six sales263.85268.69 (+1.8%)253.13 (−4.1%)

    How to read this. “Up” removes the dip and adds to your earnings: prices after each boundary are slightly higher. “Down” also removes the dip but takes part of the markup — on average half the step between tiers across the upper half of each tier. In return, your prices drop exactly where shoppers compare you with other stores.

    A step of 1–2 percent between tiers. The dip is narrow, and “down” just gives away a discount — turn on “up” or keep the stepped calculation.

    A large step (from 30% to 15%, from coefficient 1.9 to 1.5). The dip covers a quarter of the tier, and prices there really are illogical. “Up” levels them at no cost to you; “down” — if you deliberately want to be cheaper in the upper part of each tier.

    Gaps between tiers are intentional (a ladder “to 1,000”, then “from 5,000”, with no markup in between) — you don’t need the mode here: it leaves wide bands alone.

    Other details:

    • the first tier with “up” and the last tier with “down” keep a constant markup — there is nothing to stretch toward;
    • the coefficient and the “+/-” column behave the same way as the percentage, so you can run the ladder in any of the three columns;
    • the setting is shared across the whole account and can’t be turned on for a single source; new accounts have “up” by default;
    • prices change at the next price list import or right after “Apply markup to products”;
    • the selected mode shows up in “Product markup history”: it records the percentage actually applied to the product.

    How a threshold rule calculates and how it differs from a regular one

    A regular rule (both thresholds empty) runs as three separate steps in a fixed order: first the coefficient, then the percentage, then the amount. Each step works only if its column is not zero.

    A threshold rule is one combined formula: ((price + price × % ÷ 100) × coefficient) + amount. An empty coefficient counts as one.

    When the rule reads “Price” and writes to “Price”, both paths give the same result. Percentage 10, coefficient 2: without thresholds 100 → 200 (coefficient) → 220 (percentage), with thresholds 100 → 110 (percentage) → 220 (coefficient). Add an amount and the results still match: the order of multiplication doesn’t matter.

    They differ in three cases, and each is worth knowing.

    1. The source field differs from the destination field. In a regular rule, each step reads the source and writes to the destination, so steps don’t add up — the last filled one wins. Source “Price”, destination “Max price”, coefficient 2, percentage 10: without thresholds “Max price” gets 110 and the coefficient is lost. A threshold rule calculates everything together and writes 220.
    2. Negative values. A regular rule takes the absolute value of each step’s result; a threshold rule doesn’t. A discount larger than the price flips to a plus in a regular rule and gives a negative price in a threshold rule. A regular rule treats a negative coefficient as division; a threshold rule multiplies by it as is.
    3. Products without a price. Each step of a regular rule requires the source field to be greater than zero. A threshold rule has no such check — see the note below.

    Why a product gets only one tier

    Within its type, the first threshold rule whose range the price falls into closes the product to the other rules of that type. That is what makes a ladder a ladder: a product priced at 300 hryvnias gets coefficient 1.5 and no longer looks at the other tiers.

    The order is set by the “Rule order” column and, after it, by “Price from”. If the ranges of two tiers overlap, the one that comes first applies. The order of rows on the screen doesn’t matter here.

    The exception is turned on manually: the “All types of markups (percentage, coefficient, value, threshold markup)” and “Individual markup type (threshold markup)” types have the “Allow multiple markup thresholds” checkbox — with it, several thresholds apply to one product (details in the type filter).

    Different markup types work independently of each other — but only as long as the source is not in “Only global rules” mode and “Apply markup once” is not on. In normal mode, a product can get a threshold markup by category and then another threshold markup by category and manufacturer: the lock is released before each type.

    With either of these two conditions, the lock holds until the end of the run, and the product gets only one threshold markup for the whole chain. More: what applies first.

    Rule order

    The number in the column of the same name. It decides which rule is checked earlier within its type. For a ladder this matters: the first tier that matches closes the product to the rest.

    Rules with the same order are sorted further by other columns, and here types behave differently. Threshold types sort by “Price from” after the order, so a global ladder works correctly even if all tiers have order zero.

    But the “All types of markups (percentage, coefficient, value, threshold markup)” type, which handles the price list’s own rules, ignores “Price from” when sorting — there you must set the order explicitly, from the cheapest tier to the most expensive.

    Products without a price won’t get a markup — and that’s correct. An empty “Price from” means “from zero”, but rows where the source field is empty or zero are skipped by both regular and threshold rules.

    So feel free to start the first tier of the ladder at zero: a product the supplier sent no price for won’t get a price from the “+/-” column. If you don’t need such products in your store, remove them with an import rule.

    Scenarios

    Cheap goes up more, expensive less, in one price list

    Task: in one supplier’s price list, the markup should decrease as the product price grows.

    What to turn on: in the source’s “Pricing” tab — one row per tier with “Price from”, “Price to” and the coefficient in “*”. In the “Rule order” column, number the tiers from the cheapest to the most expensive.

    What you get: a product takes the first tier whose range its price falls into. Prices change at the next price list import or after “Apply markup to products”.

    What won’t happen: products without a price won’t get a markup. Products in a wide gap between tiers stay without a markup.

    Remove the price dip at tier boundaries without losing markup

    Task: at a tier boundary, a product that costs more to buy is cheaper in your store.

    What to turn on: in the “Markup at tier boundaries” list under the rules table — “Level up — keep the markup”.

    What you get: at the start of a tier, the markup equals the previous tier’s and smoothly goes down to its own. Prices after each boundary are slightly higher than before, and the dip disappears.

    What won’t happen: the mode leaves wide gaps between tiers alone. You can’t turn it on for a single source: there is one setting per account.

    A category ladder that is the same for all suppliers — see the scenario in the article about one pricing policy.

    What to do when the tier is wrong

    Common problems
    What you seeWhyWhat to do
    The wrong tier of the ladder applied The first threshold rule whose range the price falls into closes the product to the other rules of that type; the order is set by “Rule order” Set the order explicitly, from the cheapest tier to the most expensive, and check that the ranges don’t overlap (one match per product)
    Some products are left without a markup The price fell into a gap between tiers wider than 1% of the upper boundary: Elbuz doesn’t close such bands Join the boundaries: “to 1,000” and right after it “from 1,000” (threshold ladder)
    The product price came out negative The threshold rule has a negative coefficient or a discount larger than the price: a threshold rule doesn’t take the absolute value of the result Remove the negative coefficient from the threshold rule (two formulas)

    FAQ

    The rule has a percentage, a coefficient and an amount filled in. Which applies?

    All three. A threshold rule calculates with one formula: ((price + price × % ÷ 100) × coefficient) + amount. A regular rule works in steps: coefficient, percentage, amount (two formulas).

    A product costs exactly 200, and the tiers are “to 200” and “from 200”. Which one does it take?

    The lower one: of the two rules that match it, the first in rule order applies, and the product is then closed.

    Can several thresholds apply to one product at once?

    Not by default. The “Allow multiple markup thresholds” checkbox in the type filter allows it (type filter).

    Can I run the ladder with an amount instead of a percentage?

    Yes. The coefficient and the “+/-” column behave the same way as the percentage, including in the tier boundary mode.

    Can I turn on the smooth transition for just one price list?

    No: “Markup at tier boundaries” is one setting for the whole account. New accounts have “Level up” by default.

    Where can I see which percentage was actually applied to a product?

    In “Product markup history”: it records the percentage with the tier boundary mode taken into account (price check).

    Where to find it and who has access

    Ladder for one price list
    source card → “Pricing” tab
    Ladder for all price lists
    Directories → Processing price lists → Pricing rules
    Tier boundaries
    the “Markup at tier boundaries” list under the rules table
    Access right
    the “Pricing rules” window or the “Pricing” tab block

    How to add a rule row and what each column means — rules for one price list.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free