↑↓ selectEnter openEsc close

    1. Elbuz

    How to set a markup and discount for one price list

    6 min readUpdated

    Elbuz prices every product in a price list by the rules on the source’s “Pricing” tab: a percentage, coefficient or amount — per list, category or manufacturer.

    When you need this:

    • A 7% supplier discount on the whole list — one rule with −7 lowers all prices.
    • A brand sold strictly at RRP — a priority rule sets the RRP and exempts the brand from other markups.
    • One category without markup — a priority rule with no numbers keeps the supplier’s price.
    • A new supplier like an old one — copy rules from another price list.

    Where to start: create your first rule on the “Pricing” tab.

    What price list rules can do

    How to find the rules of a category

    Start here even if you eventually need one policy for all sources. Rules of a single price list are visible, and they are the easiest to check.

    Open the list of price lists, select a source and go to the “Pricing” tab. The window is split in two: the category tree of your catalog on the left, the rules grid on the right.

    Price list card, Pricing tab: category tree on the left, markup rules grid on the right
    1Pricing tab
    2Category tree
    3Selected category chip
    1. Pricing tab — holds the markup rules of this price list.
    2. Category tree — pick a category to see its own rules.
    3. Chip with the selected category at the top of the rules pane.

    Category tree on the left

    The category panel is collapsed by default to give the grid more room. Expand it with the arrow button at the left edge of the window. The state is remembered, so next time the panel opens expanded.

    The panel is called “Categories”. At the top is a search field with the hint “Enter category name”, next to it the “Additional operations” menu with four items: “Expand all categories”, “Collapse all categories”, “Update”, “Clear filter”. You can collapse the panel again with the same arrow or resize it by dragging its edge.

    The category selected in the tree is both the grid filter and the binding for new rules. Select “Laptops”, add a rule — the rule will work for products in the “Laptops” category and for no one else.

    By default the chip at the top right shows “All categories”. That is not “all rules” but rules without a category, a separate set for the whole price list. Rules for “Laptops” are hidden here, and vice versa. The chip’s cross (“All categories (reset selection)”) returns to this mode, not to everything at once.

    The window remembers the last selected category and opens on it next time. If you are sure you created a rule but the grid is empty, check the category chip first.

    What each rule column means

    The “Add” button with the hint “Add markup/discount rule” puts a new empty row at the top of the grid. Then you type values straight into the cells: a click on a cell opens it for editing, a click outside saves it. There is no separate “Save” button — every change goes to the database right away.

    A deleted rule cannot be restored: the window has no “Undo” button.

    Markup rules grid for the Gaming Chair category with the toolbar
    1Add
    2Apply markup to child categories
    3Apply markup to products
    4Copy markup rules from another price list
    5Rule order
    6Priority (discard others)
    1. Add — creates a new rule.
    2. Apply markup to child categories.
    3. Apply markup to products.
    4. Copy rules from another price list.
    5. Rule order column.
    6. Priority (discard others) column.

    Grid columns, in display order:

    ColumnWhat it holds
    ActiveCheckbox. Clearing it turns the rule off without deleting it. A new rule is created switched on.
    %Percentage added to the price. A negative value is a discount.
    *Coefficient the price is multiplied by. In a rule without thresholds, a negative coefficient means division.
    +/-Amount added to the price. A negative amount is subtracted.
    Price fromLower bound of the price range. If filled in, the rule becomes a threshold rule.
    Price toUpper bound. Empty or zero means “and above, with no limit”.
    ManufacturerLimits the rule to one manufacturer. You don’t type it — you pick it from the manufacturer list with the button next to the cell.
    Category from the price listLimits the rule to a category as the supplier named it in their file. Also picked from a list.
    Source fieldWhere to take the starting price from. Empty means “Price”.
    Destination fieldWhere to write the result. Empty means “Price”.
    Rule orderA number that sets which rule runs earlier within its markup type (order for the ladder).
    Priority (discard others)Checkbox. Products covered by this rule are taken out from under all other rules.
    Including subcategoriesCheckbox. The rule extends to nested categories at any depth.
    NoteText for yourself. Does not affect the calculation.
    Rule number. You need it when looking for a specific row in a product’s markup history.

    The grid shows 250 rows per page and has a filter row and sorting by clicking a header.

    The order of rows on screen is not the order of application. The grid sorts the way you find it convenient to read; the program applies rules in its own order, controlled by the “Rule order” column, not by row position. Dragging changes nothing in this window — drag and drop exists elsewhere, in markup types.

    Source fields and destination fields

    The buttons next to the “Source field” and “Destination field” columns open the same list of price fields of a price list row. There are ten of them:

    “Price”, “Price from the price list”, “Sale price”, “Old price”, “Min price”, “Max price”, “Average price”, “RRP”, “Cost price”, “Delivery cost”.

    The list is the same no matter which columns are mapped in this file: you can even pick a field the price list doesn’t have. A regular rule skips products with an empty source, and their price stays as it was.

    If you leave both columns empty, the rule reads “Price” and writes to “Price” — the usual case.

    There is an important detail about stacking. When the source and destination are the same, several rules in a row stack on top of each other: the second rule reads the already recalculated price. When they differ, the last rule simply overwrites the previous result. That’s why “add 10%, then another 5%” gives 15.5%, not 15%.

    How to create your first rule

    1. Open the “Pricing” tab of the source you need.
    2. Expand the category panel with the arrow at the left edge of the window.
    3. Select in the tree the category whose products you are pricing. If the rule should apply to the whole price list, leave the “All categories” chip.
    4. Click “Add”.
    5. Enter a value in one of the columns: “%”, “*” or “+/-”.
    6. If the rule should only work within a price range, fill in “Price from” and, if needed, “Price to”.
    7. Click “Apply markup to products” to see the result right away instead of waiting for the next price list upload.

    How to take products out from under rules, extend a rule to subcategories or narrow it with a filter

    Priority (discard others)

    A checkbox in the rules grid. Products under such a rule are exempt from all other rules: no ladder, no price list percentages, no global rules. The priority rule runs last, when the price is already in the right currency and untouched by other actions. Exchange rate, delivery, rounding and rounding step still apply.

    It always works, in any source mode — both a priority rule from the global rules and one from the price list itself.

    A typical use is a “price = RRP” rule for a brand whose supplier requires you to keep the recommended price (scenario). Without a number in “*”, “%” or “+/-”, a priority rule doesn’t rewrite the price — it only takes the products out from under other rules.

    One more detail: such a rule skips products whose source field is empty. If the supplier didn’t send an RRP, the price won’t drop to zero — the product keeps what it had. But it also stays locked, so regular markups won’t be calculated for it either.

    Including subcategories

    The checkbox changes what the rule is bound to: instead of “this category only” it becomes “this category and everything nested in it, at any depth”. Handy when the catalog structure is deep but the policy for the whole branch is the same.

    You can turn this on for all rules at once with the “Markup for subcategories” option in system settings (Account → System settings). Its description: “A markup set for a category applies to all its nested categories.”

    A subcategory’s own markup doesn’t cancel the parent one: the product gets both in turn. If “Apply markup once” is on, the first rule in order fires — not necessarily the subcategory rule. For a subcategory to follow only its own rule, turn on “Priority (discard others)” in it.

    Additional filter

    Below the grid there is a collapsible “Additional filter” block. It appears as soon as the grid has at least one rule. When you select a row, that rule’s condition loads into the block, and if there is one, the block expands by itself.

    Inside is a condition builder over the fields of the price list product grid: for example, “name contains”, “SKU begins with”, “stock greater than”. The “Clear all” and “Save” buttons save only the condition; the other rule columns are not touched.

    This is how you make a rule that the grid columns can’t express: say, raise the price only for products with the word “Pro” in their name.

    How to move rules to another price list and to subcategories

    Copying from another price list

    The button with two sheets in the toolbar, hint “Copy markup rules from another price list”. It is there only when the window is opened from a source card. It opens the “Copy markup rules from another price list” window with the search “Search by supplier or price list name...”.

    Window for copying markup rules from another price list
    1Search by supplier or price list name
    2Delete current rules before inserting new ones
    1. Search field to find a source price list.
    2. Checkbox that deletes current rules before the new ones are inserted.

    The hint in the window spells out the rules word for word:

    • “If the main item is selected in the tree, all price list rules are copied regardless of category.”
    • “If a specific category is selected, only its rules are copied.”
    • “By default rules are appended to the existing ones. Enable the flag below to first delete the current rules (of the whole price or the selected category respectively) and replace them with the new ones.”
    • “Manufacturer / supplier category bindings are copied as-is.”

    The confirm button is “Copy”; before it the source name is shown: “Copy all markup rules from price list:”. The result is “Rules copied:” with a number, or “The selected price list has no markup rules”.

    By default rules are added to the existing ones, not replacing them. Copy twice and you get a duplicate of every rule, and the price is calculated twice. If you are copying settings “the same as that supplier”, turn on the “Delete current rules before inserting new ones” checkbox.

    Apply markup to child categories

    The button with a chart in the toolbar. It takes the rules of the category selected in the tree and copies them to all its descendants — at every level down.

    The descendants’ rules are erased first. For each subcategory the program deletes all its rules for this price list and only then inserts the copies. There is no undo: if a subcategory had its own fine-tuning, it will be lost.

    The copies carry the whole rule, including the “Priority (discard others)” and “Including subcategories” checkboxes: in a subcategory the rule works the same way as in the parent category.

    Select the category in the tree beforehand: there is something to copy only when you are on a specific category. If the chip still shows “All categories”, the button won’t work and says so with a red toast “Select a category in the tree on the left first — the markup is copied from it to its child categories”.

    Scenarios

    The supplier gives a discount on the whole price list

    Task: the supplier sends prices without their 7% discount, but you need to calculate from the discounted price.

    What to turn on: on this source’s “Pricing” tab, leave “All categories” in the chip, click “Add” and enter −7 in the “%” column. Then click “Apply markup to products”.

    Result: a rule without a category applies to all products in the price list, and each price drops by 7%. For a new source it is read by the “All types of markups (percentage, coefficient, value, threshold markup)” type, second in the chain after the exchange rate, so the discount applies before the global category ladder.

    What won’t happen: the rule skips products with an empty or zero price. Products under a rule with the “Priority (discard others)” checkbox won’t get the discount. If the source is in “Only global rules” mode, the rule stays in the grid but has no effect.

    A brand strictly at the recommended price

    Task: the supplier requires you to keep the RRP for one brand, and you mark up the rest of the products as usual.

    What to turn on: a rule row with the “All categories” chip: in “Manufacturer” pick the brand, “Source field” — “RRP”, “Destination field” — “Price”, 1 in the “*” column, and the “Priority (discard others)” checkbox. On the source tab the rule applies to this price list; in the global rules window — to all sources.

    Result: the brand’s products get a price equal to the RRP converted at the exchange rate. The ladder, price list percentages and global rules don’t touch them, in any source mode. Rounding and rounding step still apply to them.

    What won’t happen: brand products for which the supplier sent no RRP get neither the RRP nor a markup from the rules: they keep the supplier’s price, with exchange rate, delivery and rounding applied. Without a number in “*”, “%” or “+/-”, the rule won’t rewrite the price — it only takes the brand’s products out from under other rules.

    Remove the markup from one category and keep it on the rest

    Task: products of one category must go at the supplier’s price, the rest of the price list with a markup.

    What to turn on: select the category in the tree on the left, add a row and turn on “Priority (discard others)” in it, leaving the numbers empty. For the rule to cover subcategories too, turn on “Including subcategories”.

    Result: the category’s products get the supplier’s price: no markup, discount or ladder affects them, while exchange rate, delivery and rounding apply. The rest of the price list is calculated as before.

    What to do when a rule is in the wrong place or does the wrong thing

    Common problems
    What you seeWhyWhat to do
    The rule worked on the wrong products or didn’t work at all The rule is bound to the category selected in the tree when it was created. The “All categories” chip shows rules without a category, not rules “for all” Select the right category in the tree and check whether your rule is visible in this mode (category tree)
    “Source mode: “Only global rules”. Rules set in the source are not applied.” The source reads only global rules; its own rules sit in the grid but have no effect In the “Prices” section of the card, select “Only this source's rules” or one of the “Global and own” modes (source rule mode)
    After copying, the grid has twice as many rules By default, copying adds rules to the existing ones instead of replacing them Delete the extra rows and copy again with the “Delete current rules before inserting new ones” checkbox (copying)
    “The selected price list has no markup rules” The source you copy from has no rules — or you are on a category that has none Select the main item of the tree to copy all rules of the price list, or pick another source (copying)
    “Select a category in the tree on the left first — the markup is copied from it to its child categories” No category is selected: the chip shows “All categories”, but markup must be copied from a specific category Select the parent category in the tree and try again (child categories)

    FAQ

    The rule exists, but I don’t see it in the table. Where is it?

    The table shows only the rules of the category selected in the tree. Rules without a category are visible when the chip shows “All categories”. Don’t remember the category? Open “Product markup history”: it shows which rule was applied (category tree).

    What is the difference between the “%” column and the “*” column?

    They are two ways to write the same action: “%” = 30 and “*” = 1.3 give the same price. The difference is in negative values: in a rule without thresholds, −2 in “*” halves the price, while −2 in “%” is a 2% discount.

    I added two rules, +10% and +5% — why did the price go up by 15.5%?

    When the source field and destination field are the same, the second rule calculates from the already marked-up price (source fields and destination fields).

    A discount larger than the price gave a plus — why?

    In a rule without thresholds, the result is taken as an absolute value: minus one hundred on a product priced at fifty gives fifty. In a threshold rule, the price comes out negative.

    Can I change the order of rules by dragging rows?

    No. The order is set by the “Rule order” column; drag and drop exists only in markup types.

    Can I see who changed a rule and when?

    No. The product price has a history, but the rule does not: the window won’t show who changed the percentage.

    Where it is and who has access

    From the price list card
    Price lists → source → “Pricing” tab
    Access right
    the rights block for the “Pricing” tab of the source card
    Prepare
    an uploaded supplier price list

    To set the same rules for all price lists at once, use the global rules window — one pricing policy for all suppliers.

    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