↑↓ selectEnter openEsc close

    1. Elbuz

    How to match price list categories to your catalog categories

    25 min readUpdated

    Elbuz sorts supplier price list products into your catalog categories: link a supplier category to yours once, and every import assigns categories without you.

    When you need this:

    • The supplier splits a group by brand — one “Kettles” rule takes “Kettles Bosch”, “Kettles Tefal” and future brands.
    • You take part of the range — unwanted categories leave the price list and are skipped later.
    • A new supplier, no categories yet — the program copies their tree into your catalog.
    • New products arrive daily — they land in your categories; just click “Add new products to catalog”.

    Where to start: open “Price list category matching” and match your first category.

    What category matching does

    A match is a rule of the form “supplier category → my catalog category”. It belongs to a specific price list and is applied on every import: the program reads the category name of a row in the supplier's file, finds the matching rule and assigns your category to the row.

    What happens to a price list row during import
    YesNoYesNoYesNoYesNoPrice list row after importIs its categoryon the ignore list?The row is deleted from the price listDid a conditional rule from“Distribution rules” apply?The row gets abase catalog categoryIs there a match for thissupplier category?Did the AI model already picka category for this product?The row stays without a catalogcategoryThe product can be added to thecatalogwith “Add new products to catalog”The row is visible in “Trash” — or itdisappears if showing Trash is off
    • Action or result
    • Decision: the path depends on the answer

    A product without a base catalog category never gets into the catalog: the button for adding new products only takes rows that already have a category. So category matching is what makes it possible for a supplier's product to become your product at all.

    A rule works only within its own price list. If the same supplier sends a second file set up as a separate price list, you match its categories again.

    How the window works: catalog and price list side by side

    The window is split in two. On the left is “Catalog categories”, your tree. On the right is “Categories from the price list”, the supplier's tree with the root “List of categories from the price list”. You can drag the border between the panels, and the program remembers the width.

    Price list category matching window with the catalog tree on the left and the price list tree on the right
    1Catalog categories
    2Categories from the price list
    3Match button
    4Border between panels
    5Category name search
    1. Catalog categories — your own catalog.
    2. Categories from the price list — what the supplier sent.
    3. Match button — creates a category match.
    4. Border between the panels — drag it with the mouse.
    5. Enter category name — search works from two characters.

    Both panels control their trees the same way: the “Enter category name” field searches from two characters, and the additional operations button offers “Expand all categories”, “Collapse all categories”, “Refresh list” and “Clear filter”. Branches load as you expand them, and the first search expands the whole tree.

    The right panel's menu has two more items. The first is the “Only categories with products” filter: on a price list with hundreds of empty sections, it keeps only the ones that contain something. The last is “Category detection”, where you set where the price list's categories come from (how to extract categories from a price list).

    Additional operations menu of the right panel
    1Only categories with products
    2Refresh list
    3Category detection
    1. Only categories with products — leaves only categories that contain products.
    2. Refresh list — re-reads the tree after a match is created or deleted.
    3. Category detection — the neighbouring window where the source of price list categories is configured.

    In the right panel, the number in brackets next to a category name shows how many price list rows it contains. A category with no products has no brackets at all. This number tells you which categories to tackle first.

    Rows of the price list tree with product counts and row buttons on hover
    1Product count
    2Add to ignore list
    3Copy to clipboard
    1. The number in brackets — how many price list rows are in this category.
    2. Add to ignore list — removes the category from the price list together with its products.
    3. Copy to clipboard — copies the category name.

    A category that already has a match is marked with a checkmark — in both trees. Hover over a row to see its buttons:

    • in the left panel — “Match” or “Delete” (depending on whether a link already exists), “Add category” (if you have the right to create categories) and “Copy to clipboard”;
    • in the right panel — “Match” or the pair “Open” and “Delete”, plus “Add to ignore list” and the same copy button. “Open” highlights, in the left tree, your category that the selected supplier category is linked to.

    “Delete category” in the left panel removes the catalog category together with the products in it. It's the same action as in the “Categories” window, and the confirmation dialog warns you about it.

    If the price list is set up to import from separate Excel sheets, the top level of the right tree is the sheets — “Sheet: sheet name” nodes — with categories under them.

    How to match a category

    1. Select a category in the right panel — one that came from the price list.
    2. Select your own category in the left panel — where these products should go.
    3. Click “Match” — the button in the left panel's header or the same button in the tree row.
    4. In the dialog, trim the extra tail off the keyword and click “OK”.

    If one of the two isn't selected, the program tells you what's missing: “Select a category in the base catalog!” or “Select a category from the price list!”.

    The “Add category match” dialog opens: your category's name, the caption “Category from the price list”, and the two things that decide how many products the rule takes — the operator drop-down and the keyword field. The field already holds the full path to the selected supplier category, upper levels separated by “ / ”: “Home appliances / Kettles Bosch”.

    Add category match dialog
    1Catalog category name
    2Operator list
    3Keyword field
    1. The catalog category — products will go here.
    2. The operator list, «starts with» by default — the rule takes all categories whose name starts with the keyword.
    3. The keyword field — edit it by hand to remove an extra tail, most often a brand.
    OperatorWhen the rule applies
    “begins with” (listed first)the supplier category name begins with your word: “Kettles” picks up “Kettles Bosch”, “Kettles Tefal”, “Kettles, electric”
    “Equal”the name matches your word character for character
    “contains”your word appears anywhere in the name

    Suppliers often split one branch by brand: “Kettles Bosch”, “Kettles Tefal”, “Kettles Philips”. You leave just the beginning in the field — “Kettles” — and a single “begins with” rule picks up kettles of every brand, including ones that aren't in today's file yet.

    Trim the tail of the name by hand. The keyword field is filled in with the full name, brand included. “Kettles Bosch” → “Kettles”: the rule stops being about one brand and becomes about a product group.

    Trim the tail specifically. If the field says “Home appliances / Kettles Bosch” and you leave only “Kettles”, the “begins with” operator finds nothing — the name doesn't begin with that word.

    For the top level of the tree, use the “Equal” operator. With “begins with”, a category like “Appliances” would also take “Appliances for kitchen” and “Appliances for garden” — everything that begins with that word. Save “begins with” for the leaves of the tree.

    You'll see the “Added” message. If the rule couldn't be created, a red message with the reason appears instead. Both trees then reload on their own, and the checkmarks appear without any extra steps.

    Price list tree after refresh with the matched category and its buttons
    1Open button
    2Row without a match
    1. Open — highlights the linked catalog category in the left tree.
    2. A neighbouring row without a check mark — this category is not matched yet.

    Several supplier categories into one of yours

    This is a normal case. Match “Kettles Bosch” to your “Kettles” category, then “Kettles Tefal” to the same one, then “Thermopots” to it as well. The conditions add up: your category gets everything that meets at least one of them. There's no limit on how many.

    The program doesn't stop you from linking one supplier category to two of yours, but a row still gets only one category — the one whose rule is checked first (the “Order” field in the “Distribution rules” window). To spread one supplier category's products across different categories of yours, you need distribution rules based on words in the product name.

    When a match takes effect

    The rule takes full effect on the next price list import, during the “Distribute products across base catalog categories” operation. That's when the program runs all rows through your rules. You don't need to turn this operation on: it's in the operation list of almost every price list.

    The rule is applied to rows already imported right away, but narrowly: the program takes only rows that don't have a category yet, and only with an exact category name match — regardless of the operator you chose in the dialog.

    What happens after “OK” in the dialog. The right branch is the second and later supplier categories for the same category of yours: only there are rows redistributed before the next import
    NoYesNoYesYesNo“Match” buttonIs a category selectedin both trees?“Select a category in the basecatalog!”or “Select a category from the pricelist!”“Add category match” dialogoperator, keyword, “OK”Rows without a category withexactly thisname get your categoryDoes your category already havea rule in this price list?A new rule is createdother rows wait for the next importIs the saved rule conditionexactly the same?The rule doesn't changeThe condition is appended with “or”your category's rows areredistributed“Added”
    • Action or result
    • Decision: the path depends on the answer

    “I created a rule, but nothing changed.” That's what the first rule for a catalog category with the “begins with” or “contains” operator looks like: it won't move rows already imported, because their names don't exactly match your shortened word. The next price list import sorts everything; to skip the wait, open the “Distribution rules” window and click “Apply”.

    The second and later supplier categories matched to the same catalog category behave differently: after them, price list rows are redistributed right away.

    Matching isn't the only mechanism that assigns categories to rows, and not the first. A product already caught by a rule based on words in the name, or by the “All products in this category” checkbox, never reaches matching. The full order: the order in which rules apply.

    How to delete a match

    Select both categories — yours and the one from the price list — and click “Delete” in the left panel's header or in a row of either tree. The “Delete category matches?” dialog shows a single pair: your category, an arrow, the supplier category. After “OK” you'll see “Entry deleted”, and the checkmark disappears on its own.

    Only the selected pair is deleted. If you combined “Kettles Bosch”, “Kettles Tefal” and “Thermopots” into one “Kettles” and deleted “Thermopots”, both kettle categories still go to your category. A rule disappears completely only when nothing is left in it.

    You can't change the operator or keyword of an existing match in this window. If you need a different condition, delete the match and create it again.

    How to remove categories you don't sell from the price list

    You can leave unwanted categories unmatched — their products won't get into the catalog. But they stay in the price list: the supplier sends 10,000 items, you sell home appliances, and the rest is imported every time and clutters your lists. To get rid of them completely, use ignoring.

    One category at a time — from the tree

    Hover over a category in the right panel and click “Add to ignore list”. The program asks “Add to ignore list?”, shows the category name and the “Partial word match” checkbox (cleared by default). The buttons are “Add” and “No”.

    Add to ignore list confirmation dialog
    1Category name
    2Search by word occurrence checkbox
    1. The category that will leave the price list together with its products.
    2. The word-occurrence checkbox — removes every category whose name contains this string.

    With the checkbox cleared, the program removes the rows of this exact category and the tree node itself, along with its subcategories. The category disappears from the tree right away.

    The “Partial word match” checkbox widens the impact. With it, every category whose name contains this text gets removed. That's handy when the supplier has scattered “Clearance” across a dozen branches — but before you click, make sure the word doesn't appear where you don't expect it.

    Many categories at once — in a separate window

    When you need to throw out half the price list, the “Ignore supplier categories” window is more convenient.

    Where: “AI category matching” → “Actions” menu → “Ignore categories”.

    At the top of the window there's an explanation: “Select supplier categories that should not be imported. Their products will be removed from the price list, and rows with these categories will be skipped on the next import.” Below it is a list of all the price list's categories with these columns:

    • “Supplier category” — the name;
    • “Products” — how many price list rows are in this category;
    • “In catalog” — how many of them are already linked to products in your catalog. If it's not zero, you're about to throw out something you already sell;
    • “Status” — an “Active” or “Already ignored” badge.
    Ignore supplier categories window
    1Already ignored filter
    2In catalog column
    3Status column
    4Add to ignore list button
    1. Already ignored — shows what has already been thrown out.
    2. In catalog — if this is not zero, you are about to remove something you already sell.
    3. Status — a badge showing whether the category is active or already ignored.
    4. Add to ignore list — the number in brackets is how many categories are ticked.

    The header has the “Search by category name...” search, the “Select all in the current filter” toggle, three quick filters with counters (“All”, “Active”, “Already ignored”) and a “Shown: N of M” counter. The toggle selects every row in the current filtered set — keep that in mind when no filter is applied. Rows that are already ignored aren't selected.

    The “Add to ignore list (N)” button shows how many categories are selected. Then comes the confirmation “Add N categories to the ignore list and remove their products from the price list?” and the report “Added to ignore: N. Products removed: N”. In all-price-lists mode, a “Price lists / Suppliers” column appears, and the rule applies to all suppliers.

    For each selected category, the program writes an ignore rule (if there isn't one yet), deletes the category's rows from the price list and erases its “AI category matching” results. If the request breaks off midway, processed categories are already ignored and the rest stay as they were. Repeating is safe: no second rule is created for the same category.

    You can't undo ignoring from these two windows. The products are already deleted from the price list, and only the next import brings them back — after you remove the rule in the “Ignore rules” window (Directories → Processing price lists → Ignore rules).

    From then on, ignoring works by itself: on every import, the “Remove products that are on the ignore list” operation clears out the rows of these categories before category distribution starts. Catalog cards linked to the deleted rows stay where they are.

    How to copy the supplier's tree into your catalog

    The right panel's header has an “Add data from price list” button with two items:

    • “Add categories from the price list to the base catalog” — creates a copy of the supplier's tree in your catalog, with the same nesting;
    • “Add categories and products from the price list to the base catalog” — the same, plus it creates products with photos, videos and attributes.

    The program warns you with a “Warning” dialog, then shows “Please wait, adding data to the base catalog...”, and when it's done, “Updated”, and redraws the left tree. If the “Link to base catalog category” field is filled in on the price list card, the supplier's tree goes inside that category instead of the catalog root.

    This button doesn't create matches. Categories and products appear in your catalog, but there are no checkmarks in the trees. Each import starts distribution from a clean slate, so the next price list resets the categories of these rows.

    To make the result stick, match the categories manually, or on the price list card turn on distribution by “Product category name from the price list” — then the program looks for your category with the same name every time.

    Clicking again doesn't duplicate categories: for each supplier category, the program looks for an existing one of yours — created by this button from this price list, or with the same full name — and doesn't create a new one. The operation runs as a single request while the window waits for the response.

    Both menu items share the category creation step. After that they split: the second item also adds products — and that's where you can run into a refusal if a catalog update is already running
    YesNoCategories onlyCategories and productsYesNo“Add data from price list” menu item“Warning” confirmationDo you already have a categoryfor this supplier category?No new one is createdThe category is created in thecatalogWhich item was chosen?“Updated”Another catalog update startedless than 30 minutes ago?“The operation failed”categories created, products notaddedNew products with photos andvideosattributes from the price list arewritten
    • Action or result
    • Decision: the path depends on the answer

    After the categories, the second item runs a base catalog update for this price list with its own set of options:

    • new products are added together with photos and videos;
    • prices of existing products aren't updated;
    • attributes from the price list are written to all products linked to this price list — both new and existing;
    • catalog cleanup doesn't run: products aren't deactivated or deleted by relevance days, and fields marked “Clear catalog field before updating” aren't cleared.

    Two more things:

    • If a catalog update is already running — yours, a colleague's or a scheduled one — products won't be added. By then the categories are already created; the window shows a red “The operation failed”, and the operation log says “Batch processing is already running in another process — this run was rejected”. Try again later: the categories won't be created twice.
    • If the request breaks off after products have started being added, click the item again: rows already added won't get a second card. On the retry, these cards get their name, attributes and videos, but not photos: those come from a catalog update with “Update photo” turned on.

    What happens to products without a category

    Such rows stay in the price list without a catalog category. What happens to them next depends on the price list card setting “Show products in Trash that are not assigned to catalog categories”.

    • On (default) — unassigned rows are visible in the price list's product list: they're highlighted in the category column, with the hint “Product not categorized in base catalog”. You can sort them by hand or match more categories.
    • Off — such rows are hidden from the list and deleted on every import. This way an operator limits the work to what they've set up rules for: the supplier's TVs aren't matched, so they don't go anywhere.

    With the setting off, unassigned rows are deleted permanently on every import — along with photos, videos, attributes, reviews and store links. Keep it on while you're setting up matching.

    When a category or item disappears from the supplier's file

    Every price list import that reads at least one product from the file first erases all of the price list's old rows along with its category list, and then writes what came in the new file. This means:

    • If a category isn't in the new file, it won't be in the right panel either, and its rows won't be in the price list. An item that's gone from the file disappears from the price list the same way.
    • Your match stays: it disappears only when you delete it with the “Delete” button or delete the catalog category itself or the price list. If the category comes back to the file, the rule works again.
    • A price list import doesn't delete your catalog categories, whether created manually or with the “Add data from price list” button.
    • A catalog card created from such a row stays, but loses its supplier row. What happens to it next is decided by the base catalog update settings.
    • If not a single product was read from the new file, the old rows aren't erased.

    Scenarios

    The supplier split one product group by brand, but you have just one

    In the right panel, select one of these categories, for example “Kettles Bosch”, in the left panel select your “Kettles”, and click “Match”. In the dialog, keep the “begins with” operator and erase the brand name from the keyword so only the beginning is left: “Kettles”.

    On every price list import, the rule will pick up all supplier categories whose names begin with “Kettles” — including ones not in today's file yet. What won't happen: if this is your category's first rule in this price list, the “Kettles Tefal” and “Kettles Philips” already imported won't move until the next import.

    You only take part of the supplier's range

    Open “AI category matching” → “Actions” → “Ignore categories”. Select the categories you don't need, checking the “In catalog” column first, and click “Add to ignore list”.

    The rows of these categories disappear from the price list, and such rows will be skipped on later imports. What won't happen: your catalog cards linked to these rows aren't deleted. And you can't bring a category back from this window — the rule is removed in the “Ignore rules” window.

    A new supplier, and you have no categories for their range yet

    For a separate branch, first pick it in the “Link to base catalog category” card field. Then click “Add data from price list” → “Add categories from the price list to the base catalog” in the right panel. To keep the result on later imports, turn on distribution by “Product category name from the price list” on the card.

    A copy of the supplier's tree appears in your catalog, and price list rows without a category get matching categories from it. With the setting on, every import looks for your category whose name or full name matches the supplier category name. What won't happen: the button doesn't create match rules — there are no checkmarks in the trees.

    You've just started matching, and some categories aren't linked yet

    On the price list card, keep “Show products in Trash that are not assigned to catalog categories” turned on.

    Rows that don't have a category yet stay in the price list and are visible in its product list. Turning the setting off makes sense once you've matched everything you sell: then the remaining rows are deleted on every import, along with photos, videos and attributes.

    What to do

    What to do when the result is wrong

    Common problems
    What you seeWhyWhat to do
    The rule is created, but products already imported stayed where they were The first rule with “begins with” or “contains” doesn't apply to old rows: their names don't exactly match the shortened word Wait for the next price list import, or open “Distribution rules” and click “Apply” (when a match takes effect)
    A product is in a different category from the one you assigned in the tree A rule based on words in the name or the “All products in this category” checkbox applied before matching In the price list's product list, open “How the product was distributed”
    Products from the price list didn't get into the catalog A row without a base catalog category isn't added to the catalog Match its category or check the “Show products in Trash that are not assigned to catalog categories” setting (products without a category)
    I copied the tree with “Add data from price list”, and the next price list reset everything The button creates categories and products, but not matches Match the categories manually, or on the price list card turn on distribution by “Product category name from the price list” (about this button)

    FAQ

    How long does setup take on a large price list?

    It depends on the number of categories: a price list with 200 categories means 200 keywords entered once. After that, imports sort new products on their own; come back only when the supplier adds a new branch. Hundreds of categories are faster with AI category matching.

    How do I remove a category from the ignore list?

    In the “Ignore rules” window: Directories → Processing price lists → Ignore rules. Neither the tree nor the bulk ignore window has this action. The products come back to the price list on the next import.

    Does matching transfer prices, names or descriptions to the catalog?

    No. Matching answers one question — which of your categories a product goes into. Names, descriptions, attributes and prices come with the base catalog update.

    Where can I see all of a price list's matches in one list, and can I turn one off for a while?

    This window only shows checkmarks in the trees. All of the price list's rules in one list are in the “Distribution rules” window, where the “Active” checkbox turns off a catalog category's rule without deleting it (rule list).

    A supplier has two price lists. Will matches from the first carry over to the second?

    No. A match belongs to a price list: for a second file set up as a separate price list, you create it again. A word shared by all price lists is set with a global distribution rule.

    Where it is and who has access

    The window has no menu item of its own — you open it from other windows. The item has the same name everywhere: “Price list category matching”.

    From the “List of price lists”
    price list → header menu → “Categories” group → “Price list category matching”
    In the same window, with a button
    the arrow on the “Product Matching” button → the last item
    From the price list card
    “Additional” section → “Price list category matching”
    From neighboring windows
    “Distribution rules”; “AI category matching” → “Actions” menu
    Access right
    the “Price list category matching” window; creating and deleting categories requires rights to the “Categories” window
    Before you start
    an imported supplier price list — without it there's no category tree yet
    Extra-operations menu of the price list with the Categories group expanded
    1Price list category matching
    1. Price list category matching — opens the window this article is about.
    Additional section of the price list card with the category matching button
    1Price list category matching
    1. Price list category matching — the second way into the same window, from the price list card.

    The left panel's menu items “Add category” and “Delete category”, and the “Add category” button in a left-tree row, appear only for users the administrator has given the matching rights in the “Categories” window.

    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