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
- A separate markup for each price range — as a percentage, a coefficient or an amount.
- Closes narrow gaps between tiers — a product on the boundary doesn’t end up without a markup.
- Smooths the jump at tier boundaries — up without losing markup, or down for lower prices; what it means in money.
- One tier per product — in the order you set.
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 from | Price to | Coefficient | What it means |
|---|---|---|---|
| 0 | 200 | 1.9 | small items go up by 90% |
| 200 | 500 | 1.5 | +50% |
| 500 | 1,000 | 1.4 | +40% |
| 1,000 | 1,500 | 1.3 | +30% |
| 1,500 | 2,000 | 1.2 | +20% |
| 2,000 | 3,000 | 1.17 | +17% |
| 3,000 | 5,000 | 1.15 | +15% |
| 5,000 | 7,000 | 1.1 | +10% |
| 7,000 | 10,000 | 1.09 | +9% |
| 10,000 | 25,000 | 1.08 | +8% |
| 25,000 | 50,000 | 1.07 | +7% |
| 50,000 | — | 1.05 | +5% and beyond, no upper limit |
Дані таблицею
| Показник | to 200 | 200–500 | 500–1,000 | 1,000–1,500 | 1,500–2,000 | 2,000–3,000 | 3,000–5,000 | 5,000–7,000 | 7,000–10,000 | 10,000–25,000 | 25,000–50,000 | over 50,000 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Markup | 90 | 50 | 40 | 30 | 20 | 17 | 15 | 10 | 9 | 8 | 7 | 5 |
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 price | Store price |
|---|---|
| 299 | 343.85 |
| 300 | 345.00 |
| 301 | 343.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.
1
Additional settings2
Markup at tier boundaries list3
Help icon linking to the guide- Additional settings — the card sits below the rules grid, so it is easy to miss.
- Markup at tier boundaries — a list of three modes; the setting is shared across the whole account.
- 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.
Дані таблицею
| Ряд | X | Y |
|---|---|---|
| Stepped calculation | 200 | 15 |
| Stepped calculation | 205 | 15 |
| Stepped calculation | 210 | 15 |
| Stepped calculation | 215 | 15 |
| Stepped calculation | 220 | 15 |
| Stepped calculation | 225 | 15 |
| Stepped calculation | 230 | 15 |
| Stepped calculation | 235 | 15 |
| Stepped calculation | 240 | 15 |
| Stepped calculation | 245 | 15 |
| Stepped calculation | 250 | 15 |
| Stepped calculation | 255 | 15 |
| Stepped calculation | 260 | 15 |
| Stepped calculation | 265 | 15 |
| Stepped calculation | 270 | 15 |
| Stepped calculation | 275 | 15 |
| Stepped calculation | 280 | 15 |
| Stepped calculation | 285 | 15 |
| Stepped calculation | 290 | 15 |
| Stepped calculation | 295 | 15 |
| Stepped calculation | 300 | 14 |
| Stepped calculation | 305 | 14 |
| Stepped calculation | 310 | 14 |
| Stepped calculation | 315 | 14 |
| Stepped calculation | 320 | 14 |
| Stepped calculation | 325 | 14 |
| Stepped calculation | 330 | 14 |
| Stepped calculation | 335 | 14 |
| Stepped calculation | 340 | 14 |
| Stepped calculation | 345 | 14 |
| Stepped calculation | 350 | 14 |
| Stepped calculation | 355 | 14 |
| Stepped calculation | 360 | 14 |
| Stepped calculation | 365 | 14 |
| Stepped calculation | 370 | 14 |
| Stepped calculation | 375 | 14 |
| Stepped calculation | 380 | 14 |
| Stepped calculation | 385 | 14 |
| Stepped calculation | 390 | 14 |
| Stepped calculation | 395 | 14 |
| Stepped calculation | 400 | 13 |
| Stepped calculation | 405 | 13 |
| Stepped calculation | 410 | 13 |
| Stepped calculation | 415 | 13 |
| Stepped calculation | 420 | 13 |
| Stepped calculation | 425 | 13 |
| Stepped calculation | 430 | 13 |
| Stepped calculation | 435 | 13 |
| Stepped calculation | 440 | 13 |
| Stepped calculation | 445 | 13 |
| Stepped calculation | 450 | 13 |
| Stepped calculation | 455 | 13 |
| Stepped calculation | 460 | 13 |
| Stepped calculation | 465 | 13 |
| Stepped calculation | 470 | 13 |
| Stepped calculation | 475 | 13 |
| Stepped calculation | 480 | 13 |
| Stepped calculation | 485 | 13 |
| Stepped calculation | 490 | 13 |
| Stepped calculation | 495 | 13 |
| Stepped calculation | 500 | 13 |
| Stepped calculation | 505 | 13 |
| Stepped calculation | 510 | 13 |
| Stepped calculation | 515 | 13 |
| Stepped calculation | 520 | 13 |
| Stepped calculation | 525 | 13 |
| Stepped calculation | 530 | 13 |
| Stepped calculation | 535 | 13 |
| Stepped calculation | 540 | 13 |
| Stepped calculation | 545 | 13 |
| Stepped calculation | 550 | 13 |
| Stepped calculation | 555 | 13 |
| Stepped calculation | 560 | 13 |
| Level up | 200 | 15 |
| Level up | 205 | 15 |
| Level up | 210 | 15 |
| Level up | 215 | 15 |
| Level up | 220 | 15 |
| Level up | 225 | 15 |
| Level up | 230 | 15 |
| Level up | 235 | 15 |
| Level up | 240 | 15 |
| Level up | 245 | 15 |
| Level up | 250 | 15 |
| Level up | 255 | 15 |
| Level up | 260 | 15 |
| Level up | 265 | 15 |
| Level up | 270 | 15 |
| Level up | 275 | 15 |
| Level up | 280 | 15 |
| Level up | 285 | 15 |
| Level up | 290 | 15 |
| Level up | 295 | 15 |
| Level up | 300 | 15 |
| Level up | 305 | 14,95 |
| Level up | 310 | 14,9 |
| Level up | 315 | 14,85 |
| Level up | 320 | 14,8 |
| Level up | 325 | 14,75 |
| Level up | 330 | 14,7 |
| Level up | 335 | 14,65 |
| Level up | 340 | 14,6 |
| Level up | 345 | 14,55 |
| Level up | 350 | 14,5 |
| Level up | 355 | 14,45 |
| Level up | 360 | 14,4 |
| Level up | 365 | 14,35 |
| Level up | 370 | 14,3 |
| Level up | 375 | 14,25 |
| Level up | 380 | 14,2 |
| Level up | 385 | 14,15 |
| Level up | 390 | 14,1 |
| Level up | 395 | 14,05 |
| Level up | 400 | 14 |
| Level up | 405 | 13,95 |
| Level up | 410 | 13,9 |
| Level up | 415 | 13,85 |
| Level up | 420 | 13,8 |
| Level up | 425 | 13,75 |
| Level up | 430 | 13,7 |
| Level up | 435 | 13,65 |
| Level up | 440 | 13,6 |
| Level up | 445 | 13,55 |
| Level up | 450 | 13,5 |
| Level up | 455 | 13,45 |
| Level up | 460 | 13,4 |
| Level up | 465 | 13,35 |
| Level up | 470 | 13,3 |
| Level up | 475 | 13,25 |
| Level up | 480 | 13,2 |
| Level up | 485 | 13,15 |
| Level up | 490 | 13,1 |
| Level up | 495 | 13,05 |
| Level up | 500 | 13 |
| Level up | 505 | 13 |
| Level up | 510 | 13 |
| Level up | 515 | 13 |
| Level up | 520 | 13 |
| Level up | 525 | 13 |
| Level up | 530 | 13 |
| Level up | 535 | 13 |
| Level up | 540 | 13 |
| Level up | 545 | 13 |
| Level up | 550 | 13 |
| Level up | 555 | 13 |
| Level up | 560 | 13 |
| Level down | 200 | 15 |
| Level down | 205 | 14,95 |
| Level down | 210 | 14,9 |
| Level down | 215 | 14,85 |
| Level down | 220 | 14,8 |
| Level down | 225 | 14,75 |
| Level down | 230 | 14,7 |
| Level down | 235 | 14,65 |
| Level down | 240 | 14,6 |
| Level down | 245 | 14,55 |
| Level down | 250 | 14,5 |
| Level down | 255 | 14,45 |
| Level down | 260 | 14,4 |
| Level down | 265 | 14,35 |
| Level down | 270 | 14,3 |
| Level down | 275 | 14,25 |
| Level down | 280 | 14,2 |
| Level down | 285 | 14,15 |
| Level down | 290 | 14,1 |
| Level down | 295 | 14,05 |
| Level down | 300 | 14 |
| Level down | 305 | 13,95 |
| Level down | 310 | 13,9 |
| Level down | 315 | 13,85 |
| Level down | 320 | 13,8 |
| Level down | 325 | 13,75 |
| Level down | 330 | 13,7 |
| Level down | 335 | 13,65 |
| Level down | 340 | 13,6 |
| Level down | 345 | 13,55 |
| Level down | 350 | 13,5 |
| Level down | 355 | 13,45 |
| Level down | 360 | 13,4 |
| Level down | 365 | 13,35 |
| Level down | 370 | 13,3 |
| Level down | 375 | 13,25 |
| Level down | 380 | 13,2 |
| Level down | 385 | 13,15 |
| Level down | 390 | 13,1 |
| Level down | 395 | 13,05 |
| Level down | 400 | 13 |
| Level down | 405 | 13 |
| Level down | 410 | 13 |
| Level down | 415 | 13 |
| Level down | 420 | 13 |
| Level down | 425 | 13 |
| Level down | 430 | 13 |
| Level down | 435 | 13 |
| Level down | 440 | 13 |
| Level down | 445 | 13 |
| Level down | 450 | 13 |
| Level down | 455 | 13 |
| Level down | 460 | 13 |
| Level down | 465 | 13 |
| Level down | 470 | 13 |
| Level down | 475 | 13 |
| Level down | 480 | 13 |
| Level down | 485 | 13 |
| Level down | 490 | 13 |
| Level down | 495 | 13 |
| Level down | 500 | 13 |
| Level down | 505 | 13 |
| Level down | 510 | 13 |
| Level down | 515 | 13 |
| Level down | 520 | 13 |
| Level down | 525 | 13 |
| Level down | 530 | 13 |
| Level down | 535 | 13 |
| Level down | 540 | 13 |
| Level down | 545 | 13 |
| Level down | 550 | 13 |
| Level down | 555 | 13 |
| Level down | 560 | 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 price | Stepped calculation | Level up | Level down |
|---|---|---|---|
| 210 | 241.50 | 241.50 | 241.29 |
| 270 | 310.50 | 310.50 | 308.61 |
| 299 | 343.85 | 343.85 | 340.89 |
| 305 | 347.70 | 350.60 | 347.55 |
| 350 | 399.00 | 400.75 | 397.25 |
| 395 | 450.30 | 450.50 | 446.55 |
| Your earnings from six sales | 263.85 | 268.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.
- 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.
- 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.
- 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
| What you see | Why | What 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
- If you need the big picture — how the price is calculated and when it is recalculated — Pricing rules.
- If you need to understand the rule columns — How to set a markup and discount for one price list.
- If all suppliers need one ladder — How to set one pricing policy for all suppliers.
- If thresholds of different types overlap — How to set up the chain of markup types.
- If you are deciding whether to hand price lists over to Elbuz — what it gives your store.
