↑↓ selectEnter openEsc close

    1. Elbuz

    How to sort price list products into catalog categories with rules

    17 min readUpdated

    Elbuz sorts price list products into your categories by rules set once: a word in the name, a condition on any row field, or “all products in one category”.

    When you need this:

    • A supplier category mixes what you keep in three — a keyword rule splits it.
    • “TV” appears in dozens of suppliers’ price lists — one rule covers them all, future ones too.
    • A supplier sells only tires — one checkbox puts the whole price list into one category.
    • See what will change first — “Check” calculates the distribution without saving.

    Where to start: price list → “Settings” → “Additional” → “Distribution rules”, then enter your first keyword.

    What distribution rules can do

    A rule is a condition plus a category in your catalog. You set the condition once, and it is then checked against every row of the price list on every import. A row that matches the condition gets your category; a row that no rule matches stays without one.

    A rule belongs to a specific price list. For a second price list from the same supplier, you set up rules again — except the ones you deliberately made shared across all price lists.

    The row’s category decides whether it becomes your product: a row without a base catalog category does not get into the catalog, and in the price list product list it is marked “Trash”. What happens to such rows next: products without a category.

    If you can link the supplier’s categories to yours by name, it is faster to do that in a separate window — “Price list category matching”.

    Condition-based rules are for cases where linking by name doesn’t work: the price list is a flat list with no categories, or one supplier category holds what you keep in three different ones. Elbuz stores both sets of rules together, so the price list’s rule list shows both kinds.

    How to sort products by keywords

    The “Basic settings” card is the quickest way. Its heading reads: “Assign products to the category if they”. Below it are four fields; enter keywords one per line:

    FieldWhat it means
    “contain text”the word appears anywhere: “Headphones” matches both “Sony Headphones” and “Wireless headphones”
    “do not contain text”an exception to the field above: rows with this word won’t go into the category
    “contain words”the whole word on its own: “Watch” matches “Apple Watch 9” but not “Watchband”
    “do not contain words”the same kind of exception, also by whole word

    These fields check two things from the supplier’s file: the product name and the name of the category it sits in within the price list. It’s enough for the word to appear in one of them. Manufacturer, SKU, or description aren’t available here — for those you need advanced settings.

    The Basic settings card for the Gadgets / Headphones rule with a keyword in the first field
    1contain text
    2contain words
    3do not contain text
    1. contain text — the word is searched in both the product name and the price list category name.
    2. contain words — the same search, but for a whole word; use it for short words.
    3. The "do not contain" fields — exclusions; on their own they do not work.

    This card has no “Save” button: the rule is saved automatically as soon as you click outside the field. Empty lines are removed, and longer words are moved to the top automatically, so the order of words in the field doesn’t matter.

    One word catches more than you might expect. In a 2,000-row price list, “Headphones” in “contain text” catches 387 items: headphones by name plus everything from supplier categories with “Headphones” in the name. “Watch” goes in “contain words”: as text, “watch” also appears in names of straps and cases, and “contain text” would catch them too.

    Exclusion words don’t work on their own. The “do not contain text” and “do not contain words” fields are exceptions to a condition, not a condition. If you fill in only those, the rule won’t work at all. First add the word that catches, then the word that excludes.

    How to set up a rule with conditions

    The “Advanced settings” card is a condition builder. All fields of the imported price list row are available here; “Category from the price list” and “Name” come first in the list, the rest are in alphabetical order. The Excel sheet name is also available as a field — that’s where you build a condition by sheet.

    Detailed settings card with the condition builder and the expanded list of fields
    1Category from price list
    2Name
    1. Category from price list — the field most conditions are built on.
    2. Name — the second most common field.

    A condition has three parts: field, operator, value. A rule can have several conditions, combined with “AND” or “OR”.

    • Text fields get the operators “contains”, “does not contain”, “equal to”, “not equal to”, “begins with”, “does not start with”, “ends with”, “does not end with”, “empty string”, and “non-empty string”.
    • Number fields — price, quantity — get “less than”, “greater than”, “between”, “equal to”, and their opposites.
    • Dates and checkboxes behave like text: enter their values as text.
    The Advanced settings card with a built condition for Computers / Tablet
    1Condition: field, operator, value
    2Condition summary
    3Save
    1. The built condition — a field (category from the price list), an operator (contains) and a value.
    2. The summary under the builder shows how the program read the condition.
    3. Save — unlike the basic card, changes here are saved manually.

    Below the builder, Elbuz shows the assembled condition in plain words — use it to check that the condition says what you meant. Next to it are “Clear all” and “Save”: unlike basic settings, here you have to save changes yourself.

    Almost all working conditions are about the price list category or the name, with the operators “contains” and “begins with”. In a 2,000-row price list, the condition “Category from the price list contains ‘Tablets’” catches 197 rows: everything the supplier filed under “Tablets Xiaomi”, “Tablets Samsung”, and similar branches.

    If the conditions aren’t saved

    If after “Save” you see a red message instead of “Success”, the conditions were not saved. Both messages come from this window’s condition builder — in the “Advanced settings” card and in the “Product distribution rules for all categories” block.

    MessageWhat to do
    “Conditions were not saved: make sure every condition has a field selected and a value filled in, then save again.”the builder has a row with no field or an empty value — fill it in or remove it, then click “Save” again
    “Conditions were not saved: the rule has a field or operator the builder does not offer. Reopen the rule and save it again.”an old condition uses a field or operator that no longer exists: close the rule, open it again, rebuild the condition from the current list of fields, and save

    Two numbers below the condition

    • “Assigned to category” — how many rows are in this category right now. This is the result of the previous distribution: the number won’t change until you click “Apply”.
    • “Matches the condition” — how many price list rows match the condition right now, regardless of which category they are in.

    If the rule finds nothing, a hint appears below the numbers: “The rule matches nothing in this price list - check the condition.” When rows are found but all of them are already distributed, the hint is different: “The condition matches N rows, but they are already in other categories: distribution takes only rows without a category.”

    When the whole price list is one category

    Sometimes the whole file is a single product group: only TVs, only tires, or only cat food. You don’t need to write rules: select a catalog category, tick “All products in this category” in the “Additional” card — and all products in the price list go into it.

    The Additional card for the Gadgets / Headphones rule
    1Apply to category
    2All products in this category
    3%, *, + fields
    4Additional text
    1. Apply to category — lets you switch a rule off without deleting it.
    2. All products in this category — for a price list where the whole file is one product group; while it is on, the price list's other rules do not work.
    3. The %, * and + fields — the rule's markup; it works only together with a separate markup type.
    4. Additional text — this text is appended to the chosen field for every product the rule caught.

    While this checkbox is ticked, the other rules of this price list don’t work: Elbuz doesn’t go through words and conditions, it simply puts all unassigned rows into one category. If you ticked it “so everything lands somewhere” and your other rules stopped working, this is why.

    • The checkbox only assigns rows that are still without a category, so categories set by detection from the price list category name are kept.
    • If the checkbox is accidentally ticked in two categories, Elbuz uses one of them — there’s no way to predict which.
    • The checkbox doesn’t work in global mode: a rule with it is saved but skipped during distribution.

    What else is in the “Additional” card

    • “Apply to category:” — the rule’s on/off checkbox: clear it to turn the rule off without deleting it.
    • “Additional text” and “Save to field” — the text from the first field is appended to the selected product field for every row the rule catches.
    • The “%”, “*”, and “+” fields — the rule’s markup. It only takes effect when the price list’s markup list includes the separate markup type based on import rules; without it, these numbers do nothing.

    How to set up one rule for all price lists

    Dozens of companies supply you with TVs, and all of them have “TV” in product names. Instead of a rule in every price list, open the window from the menu, select your “TVs” category, and enter the word there. The rule starts working at once on all price lists in your account, including ones you add tomorrow.

    Where: Directories → Processing price lists → Categorization.

    Distribution rules window opened from the main menu in global mode
    1Red notice: global mode
    2Apply button
    1. The red notice shows that rules are now created for all price lists at once.
    2. Apply recalculates the whole account in this mode and cannot be rolled back.

    Global rules run in a second pass — after the price list’s own rules and only on rows still without a category. In other words, a price list’s own rule always takes priority over a global one: the common word catches what’s left, and fine-tuning for a specific supplier stays with that supplier.

    How this mode differs:

    • the “All products in this category” checkbox doesn’t work — it only makes sense within a single file;
    • the builder shows only editable fields, in alphabetical order: “Category from the price list” isn’t moved to the top here;
    • there is no “Check” button and no rule list: you can’t see separately how many products a global rule took;
    • on the check panel only “Total rules” and “By rules” are meaningful — the other tiles are calculated per price list and show zeros; there is no “Copy report” button;
    • the three Excel reports use data from all price lists at once;
    • the import filter block saves a condition, but it won’t affect any file.

    Creating a global rule is safe — it takes effect on the next import of each price list. But the “Apply” button in this window recalculates all price lists in your account: click it only when you deliberately want to redistribute everything right now.

    In what order rules are applied

    Several rules can match one row, so the order in which Elbuz goes through them matters:

    1. Empty rules — no words, no condition, and no “All products in this category” checkbox — are deleted.
    2. The categories of price list rows are reset — distribution starts over from scratch.
    3. If category detection by price list category name is turned on in the price list card, it runs first. In most price lists it is off.
    4. If the price list has a rule with the “All products in this category” checkbox, all rows without a category go into it, and distribution for this price list ends there.
    5. Rules with the “contain text” field.
    6. Rules with the “contain words” field.
    7. Rules from “Advanced settings”.
    8. The same, but with global rules.

    Each next step works only on what is still without a category. A row caught by a keyword rule never reaches the advanced condition, even if that condition matches it too. Within one step, rules are checked by the “Order” column, and the first rule whose condition is true wins; by default, this column is left as is.

    If for one group of products you set up both a word in “Basic settings” and a condition in “Advanced settings”, the word wins. When products end up in the wrong place, look for a word that took the row earlier.

    How a price list row gets from import to a catalog category
    FoundNoYesNoCaughtNoCaughtNoCaughtNoYesNoYesNoCaughtNoYesNoPrice list row without a catalogcategoryCategory detection byprice list category name turned on?The row gets a catalog categoryDoes the price list have a rule with“All products in this category”ticked?All rows without a category go into it;other price list rules don’t runPrice list rule:“contain text”Price list rule:“contain words”Price list rule:“Advanced settings”Category from the matchedcatalog product(only with the “Apply” button)Has AI already matcheda category for this product?Global rules —the same three modesDo other rows with the sameprice list category already have acategory,or is this an option whose main rowhas one?“Trash” category:this product won’t get into thecatalog
    • Action or result
    • Decision: the path depends on the answer

    Besides rules, a few more steps can give a row a category. They also only take rows still without a category:

    • Category from the matched catalog product. If a row is linked to a product in your catalog (product matching) and category detection by SKU or name is turned on in the price list card, the row takes that product’s category. This only works with a manual “Apply” and only if there are distribution rules. It runs after the price list’s rules but before global ones: a price list rule takes priority, a global rule doesn’t.
    • AI category matching. The saved result of AI category matching is applied to the row right after the price list’s rules, and once more after the global ones.
    • Category of neighboring price list rows. With detection by price list category name turned on, a row without a category takes the category of other rows with the same price list category that are already matched to a catalog product.
    • Category of the main product. If at least one category detection option is turned on, an option row takes the category of its main row.

    Anything that none of these steps took goes to “Trash”.

    Each import writes the price list rows again, so a category set manually with “Change Category” only lasts until the next import. What happens to rows that are no longer in the file: when an item disappears from the supplier’s file.

    How to recalculate the distribution with “Apply”

    Rules run automatically on every price list import — as the “Distribute products across base catalog categories” operation, which almost every price list has (order of operations). The “Apply” button runs the distribution on the rows already imported, right now; the file is not read again.

    Window stateWhat is recalculated
    Price list open, no category selectedthe whole price list
    Price list open, category selectedthe rows currently in this category are reset, and only its rule runs; products in other categories aren’t touched, but the rule picks up unassigned rows from across the whole price list
    Window opened from the menuall active price lists of active suppliers

    A rule can’t move an already distributed product to another category on its own: each step works only on rows without a category. To move it, click “Apply” on the tree root — the categories of the whole price list are reset and distributed again.

    While Elbuz calculates, you see “Processing data, please wait”; when done — “Price rows distributed by rules: N”, where N is how many rows got a category in this run. A 5,000-row price list takes about a second; in global mode, multiply by the number of price lists.

    “Apply” in global mode can’t be undone. The button goes through every active price list in your account and, as its first step in each, clears the categories of all rows. The old values aren’t saved anywhere, and this operation has no log.

    Running it again restores only what the rules themselves can reproduce.

    What won’t come back: categories set manually with “Change Category”, and the categories of any price list without distribution rules — all of its products will go to “Trash”. A 1,990-row price list where 1,334 rows got their category from product matching and manual changes, and that has no rules, will lose all 1,334 after a global “Apply”.

    Right after the run, the window shows the “Last distribution” report: start time, scope, rows in the price list, and “Rows distributed”. Below is a “Before / After” table: the “No category” row always comes first, then the categories where something changed. The report is visible when the tree root is selected.

    The Last distribution report with Before and After columns
    1Rows distributed
    2No category row
    3Before and After columns
    1. Rows distributed — how many rows received a category in this run.
    2. The No category row is always first in the table.
    3. Before and After — row counts before and after the run, not product names.

    The report shows numbers, not products. The “Before / After” table contains row counts; Elbuz doesn’t keep the old values, so you can’t use it to roll back a distribution.

    If “Apply” for all price lists was interrupted

    A global “Apply” processes price lists one at a time and runs the full cycle for each: it resets the categories, distributes them with the price list’s rules, then with global rules — and only then moves on to the next one. Each step is written to the database immediately. So after an interruption:

    • price lists Elbuz managed to process are fully redistributed;
    • the price list where the interruption happened may be left with cleared categories or only partly distributed;
    • price lists it didn’t get to are not changed at all.

    Instead of the summary, a red message with the query error appears, and the “Apply” button becomes available again. To find out where it stopped, open “Distribution rules” from the price list card and click the tree root: if the time in the “Last distribution” report is not earlier than when you clicked “Apply”, that price list was processed.

    Running it again won’t duplicate anything: each price list is reset again and distributed from scratch by the same rules. To fix only the price list where the interruption happened, click “Apply” in the window opened from its card.

    How to check the distribution and find rows without a category

    The “Check” button: a forecast before you apply

    Next to “Apply” is the “Check” button. It calculates the same thing a run would do — with the same rules, in the same order — but saves nothing. You can click it as many times as you like.

    Above the buttons, the “What Apply will do” block appears with number tiles. The scope is the same as for a run: tree root — the whole price list; selected category — its rows plus rows without a category; subcategories aren’t included in the scope.

    The What Apply will do block shown after Check
    1With category tile
    2Show rows button
    3Check writes nothing
    1. The With category tile — rows that already have a catalog category.
    2. A button in a table row opens the list of rows behind that number.
    3. The hint — the check only calculates and writes nothing.
    NumberWhat it means
    In scoperows the run will process
    With categoryrows the rules will put into some category; the table below the numbers shows which categories and how many
    No categoryrows that will stay unassigned
    Not touchedrows outside the scope — they keep their categories; this number appears when a category is selected

    The number in the “Rows” column is a forecast from the rules alone; the final numbers can be higher, because automatic category detection also runs after distribution. The check shows warnings separately:

    • “all products from the price list” — all rows in scope will go into one category;
    • no rules in scope — the run will only clear the category of the rows in scope;
    • automatic category detection runs after distribution — by price list category or by catalog product;
    • confirmed AI matching will be applied after distribution — can appear together with the previous one.

    The forecast applies to the scope selected right now: switch the category and the block disappears until the next “Check”. The check doesn’t show which rule fired for a specific product — use the “How the product was distributed” window for that.

    “Check” calculates exactly what “Apply” would do but writes nothing — the forecast appears above the buttons

    The rule list and price list numbers

    Click the tree root, and the right panel shows “List of rules and distribution statistics”: all rules of the price list in one list. Columns: “Activity”, “Category”, “Assigned to category”, “Matches the condition”, “Order”, and “All products in this category”. Double-click to edit the checkboxes and the order.

    Each row starts with three icons: the pencil opens the rule’s category in the tree, the trash icon deletes the rule, and “Products of this category” opens the price list product list for the rule’s category.

    The rules list with the Assigned to category and Matches the condition columns filled in
    1Assigned to category
    2Matches the condition
    3Activity
    4Products of this category
    1. Assigned to category — how many price list rows ended up in this category.
    2. Matches the condition — how many rows fall under the rule's condition right now.
    3. Activity — a rule is switched off with this checkbox, not deleted.
    4. The third icon at the start of a row (after the pencil and the trash can) — Products of this category.

    “Assigned to category” is not “how many the rule caught”. It counts everything in the category, including products from product matching or AI matching. What the condition itself catches is in “Matches the condition”. Exception: a rule with “All products in this category” has no condition, so “Matches the condition” is empty and “Assigned to category” shows the true count.

    Above the list is a panel with six numbers — what is left to do:

    The check panel with six tiles and the table of price list categories without a catalog category
    1No category tile
    2Dead rules tile
    3No category — by price list categories
    4Copy report
    1. The No category tile — opens the list of rows without a category.
    2. The Dead rules tile — rules that match nothing.
    3. The table of price list categories whose rows still have no catalog category.
    4. Copy report — copies this report; I did not click it.
    NumberWhat it means
    Total ruleshow many rules this price list has
    By ruleshow many rows are assigned to the rules’ categories, including those brought in by matching
    No categoryprice list rows without a catalog category
    No productrows with no matching product found in the base catalog
    Dead rulesactive rules whose condition matches no rows: an error in the condition, or the word isn’t in this price list
    Not pinnedrules match rows, but those rows are already distributed by other rules

    Below the numbers is the “Rows without category, by price list category” table: unassigned rows grouped by the price list’s own categories, from largest to smallest. It tells you where to start.

    The “Copy report” button copies text to the clipboard: the date, the price list name, four numbers, “Dead rules” and “Not pinned” (if they are above zero), and the price list categories with the number of rows without a category. You can paste it into an email to support as is.

    The rows behind each number

    Next to each number is a list button: it opens a window with the products that make up that number. The button is on the “No category” and “No product” tiles, in every row of the price list category table, and in the check block — under the “With category” and “Not touched” numbers.

    The window shows the first 300 rows: name, supplier SKU, price list category, base catalog category, and price. The “Download all rows” button exports the full list to without the 300-row limit.

    The Price rows behind the number window listing rows without a catalog category
    1Row count
    2Price category column
    3Download all rows
    1. The row count — the window shows the first 300 of the 490 rows.
    2. The Price category column — the category name from the supplier's file.
    3. Download all rows — exports the rows to a file; I did not click it.

    On the panel, the “No category” list is the current state of the price list. In the check block, the tile with the same name and the “With category” list are a forecast of what happens when you click “Apply”.

    Three Excel reports

    In the additional operations menu above the list:

    • “List of unassigned categories” — supplier categories whose products are left without your category, with product counts and a sample item. This is where you start.
    • “List of assigned categories” — “catalog category ← price list category” pairs: check that nothing went to the wrong place.
    • “List of keywords from names” — a starting point for rules: the first word and the first two words of the names of unassigned products, with examples. Very short and purely numeric words are left out of the report.

    “Delete all rules” also removes category matching. The fourth, red item in the same menu removes all rules of the price list, and direct category matching is stored in the same records. Don’t click it “just to see what happens”.

    Why a product ended up in this category

    In the list of imported price list products, select a row, right-click to open the menu, and click “How the product was distributed”. The rules window opens with the tree expanded and the product’s category selected: you see the rule that fired — its words, its condition, and the number of products.

    The How the product was distributed window: the Headphones category highlighted in the tree and the rule that matched the product
    1Category the product was placed in
    2Rule that matched the product
    1. Highlighted category — where the product ended up.
    2. Rule on the right — the one that matched this product row.

    If the window shows a short message, that’s an answer too. “This product was not assigned by a rule” — the category came from category detection in the price list, AI matching, the matched product’s category, or the product isn’t distributed at all. The other possible message: the rule exists, but the catalog category it pointed to has been deleted.

    How to import only the products you need

    Below the rule list (tree root selected) is one more builder: “Product distribution rules for all categories”. It’s not part of distribution but a filter applied while parsing the file: rows that fail the condition aren’t saved, not even to “Trash”. Its hint: “Allows you to import only the products you need from the price list”.

    Product distribution rules for all categories block with an empty builder
    1Load filter hint
    2Condition builder
    3Save
    1. The hint explains that this is a load filter, not a distribution rule.
    2. A row that fails the condition is not saved at all when the file is parsed.
    3. The condition is saved manually here.

    Example: a supplier sends a full catalog of 40,000 items, but you only need products priced over UAH 1,000, or a single manufacturer. A condition in this block filters out the rest at the import stage, so the price list doesn’t fill up with rows you don’t need.

    • Save the condition with the “Save” button; an empty builder means there is no filter and everything is imported.
    • Conditions here are combined with “OR” by default, not “AND”. If you need both at once, switch the connector manually.

    In global mode, this block saves the condition to nowhere. The condition is saved without a link to a price list, while file parsing looks for the filter strictly by price list — so it won’t affect any file. The filter only makes sense in the window of a specific price list.

    Scenarios

    A supplier sends only tires

    The whole file is one product group, and all of it should go into one of your categories. In the window opened from this price list’s card, select your “Tires” category in the tree and tick “All products in this category” in the “Additional” card. You don’t need to fill in words or conditions.

    Result: on every import and after “Apply”, all price list rows without a category go to “Tires”. What won’t happen: while the checkbox is ticked, the other rules of this price list aren’t checked at all. Rows that already got a category from detection by price list category name stay in their categories.

    Headphones separate from headphone cases

    The supplier put both headphones and headphone cases into its “Headphones” section, but you keep them in two different categories. Select the “Headphones” category, and in the “Basic settings” card enter the word Headphones in “contain text” and Case in “do not contain text”.

    Result: “Headphones” gets the rows that have “Headphones” in the name or in the price list category, and don’t have “Case” in either. Rows with cases will be taken by the rule for your cases category, if you create one.

    What won’t happen: an exception in “do not contain text” only applies to words in “contain text”; for “contain words”, put the exception in “do not contain words”.

    The word “TV” in every supplier’s price list

    Open the window from the menu Directories → Processing price lists → Categorization — it shows the red text “Uses settings for all price lists”. Select the “TVs” category and enter the word in “contain text”.

    Result: on the next import of each price list, the rule runs after that price list’s own rules, on rows they left without a category. What won’t happen: the global rule doesn’t override a price list’s own rules. Don’t click “Apply” here: it would go through all active price lists and clear row categories in each first.

    You fixed a word in one category and want to recalculate only that category

    In the window opened from the price list card, select that category in the tree, click “Check”, review the forecast, then click “Apply”.

    Result: only the rows that were in this category are reset, and only its rule runs — first the price list’s own rule, then the global rule for the same category, if there is one. The rule can also pick up rows without a category from the whole price list.

    What won’t happen: products in other categories stay where they are — even those the new word now matches. To move them too, run “Apply” on the tree root.

    What to do

    FAQ

    I created a rule, but the products are still in “Trash”. What’s wrong?

    Distribution hasn’t run yet: it runs when the price list is imported. Click “Apply” — distribution runs on the imported rows right away. If that doesn’t help, check whether the price list has the “All products in this category” checkbox ticked (what it does).

    What’s the difference between “contain text” and “contain words”?

    “Contain text” looks for a sequence of characters anywhere, including inside a word. “Contain words” looks for the whole word: “Watch” matches “Apple Watch 9” but not “Watchband”. Use the second option when a short word appears as part of other product names.

    Why does the “Assigned to category” column show more rows than my rule catches?

    The column shows everything in the category, including products from product matching or AI matching. How many rows the condition itself catches is shown in the neighboring “Matches the condition” column (rule list).

    I click “Save”, but the rule isn’t saved: it says “Conditions were not saved”. What should I do?

    The builder has a row with no field or an empty value — fill it in or remove it, and save again. If the message mentions a field or operator the builder does not offer, reopen the rule (both messages).

    Can I set up two different sets of conditions for one category?

    No: there is exactly one rule per “price list + catalog category” pair. Add the second set of conditions to the same rule using “OR” (condition builder).

    A product is already in the wrong category. Will a new rule move it?

    No, rules only take rows without a category. Click “Apply” on the tree root — the price list categories are reset and distributed again. Manually set categories won’t come back (what “Apply” resets).

    Where to find it and who has access

    The open window’s title reads “Distribution rules”; in the main menu it has a different name — “Categorization”. Where you open it from determines which rules you are editing.

    From the price list card
    “Settings” tab → “Additional” section → “Distribution rules” — rules for this price list
    From the “List of price lists”
    price list → burger menu in the header → “Categories” group → “Distribution rules”
    Menu
    Directories → Processing price lists → Categorization — rules for all price lists
    From the price list product list
    context menu → “How the product was distributed” or “Add category to distribution rules”
    Access permission
    the “Distribution rules” window as a whole; there are no separate permissions for parts of the window
    Before you start
    an imported supplier price list
    Settings tab of the price list card with the row of buttons including “Distribution rules”
    1Distribution rules
    1. Distribution rules — opens the category distribution rules for this price list.

    When opened from the menu, the window works in global mode: no price list is selected. You can tell by the red text “Uses settings for all price lists” in place of the “Match” button.

    The “Distribution rules” item in the burger menu is always visible, but without permission for this window you will get an access denied message instead. The button on the “Settings” tab appears together with the “Additional” section — it requires the “Tab "Settings"” and “Tab "Import settings": settings” permissions of the “List of price lists” window.

    How the window is laid out

    The window is split in two. On the left is “Catalog categories”, your category tree. On the right is “Distribution rules”, the settings for the category you selected on the left. The header of the right panel shows the workflow: pick a category on the left, set the distribution rules, click “Apply”.

    The Distribution rules window opened from the price list card, with the category tree on the left and the rules list on the right
    1Catalog categories tree
    2Apply button
    3Hint on how to use the window
    4Category name search field
    1. Catalog categories tree — your own catalog; pick the category for a rule here.
    2. Apply button — recalculates the distribution over the rows already loaded.
    3. Hint — pick a category on the left, set the rules, then click Apply.
    4. Category name search field — filters the tree by name.

    The header of the left panel has the “Enter category name” field (searches from two characters), the “Add category” button, and a menu of additional operations: “Expand all categories”, “Collapse all categories”, “Refresh list”, “Clear filter”, and the red “Deleting a category”.

    “Deleting a category” deletes a base catalog category, not a rule — along with everything in it. To remove a rule, use the trash icon in the row of the rule list.

    The right panel has two states:

    Browsing the tree is safe: a rule is created only when you actually fill something in — a condition field, a markup, the order, or a checkbox. Rules with no conditions are deleted automatically at the start of the next distribution.

    The window always opens on the rule list and does not restore the category you selected last time. The exception is opening it from the “How the product was distributed” window: then it opens directly on that product’s category.

    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