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.
- Link a supplier category to yours — with the mouse, in two trees side by side; a single “begins with” rule picks up every brand in a group.
- Sort products automatically — on every price list import, new products included.
- Remove unwanted categories from the price list — one at a time from the tree, or hundreds at once in a separate window.
- Copy the supplier's tree into your catalog — with or without products.
- Decide what to do with unassigned products — show them for manual sorting or delete them.
- 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.
1
Catalog categories2
Categories from the price list3
Match button4
Border between panels5
Category name search- Catalog categories — your own catalog.
- Categories from the price list — what the supplier sent.
- Match button — creates a category match.
- Border between the panels — drag it with the mouse.
- 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).
1
Only categories with products2
Refresh list3
Category detection- Only categories with products — leaves only categories that contain products.
- Refresh list — re-reads the tree after a match is created or deleted.
- 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.
1
Product count2
Add to ignore list3
Copy to clipboard- The number in brackets — how many price list rows are in this category.
- Add to ignore list — removes the category from the price list together with its products.
- 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
- Select a category in the right panel — one that came from the price list.
- Select your own category in the left panel — where these products should go.
- Click “Match” — the button in the left panel's header or the same button in the tree row.
- 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”.
1
Catalog category name2
Operator list3
Keyword field- The catalog category — products will go here.
- The operator list, «starts with» by default — the rule takes all categories whose name starts with the keyword.
- The keyword field — edit it by hand to remove an extra tail, most often a brand.
| Operator | When 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.
1
Open button2
Row without a match- Open — highlights the linked catalog category in the left tree.
- 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.
- 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”.
1
Category name2
Search by word occurrence checkbox- The category that will leave the price list together with its products.
- 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.
1
Already ignored filter2
In catalog column3
Status column4
Add to ignore list button- Already ignored — shows what has already been thrown out.
- In catalog — if this is not zero, you are about to remove something you already sell.
- Status — a badge showing whether the category is active or already ignored.
- 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.
- 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
| What you see | Why | What 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
1
Price list category matching- Price list category matching — opens the window this article is about.
1
Price list category matching- 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
- How to extract supplier categories from a price list — if the right panel is empty: “No data!”.
- Product distribution rules by category — if products from one supplier category need to go into different categories of yours.
- AI category matching — if there are hundreds of categories and linking them one by one takes too long.
- Manually matching supplier products to the catalog — if price and stock should arrive in a specific product card.
