↑↓ selectEnter openEsc close

    1. Elbuz

    How to manually match supplier price list products to your catalog

    19 min readUpdated

    Elbuz finds similar catalog products for each unlinked price list row; you just confirm the pair. The supplier's price and stock then reach the card — no comparing names in Excel.

    When you need this:

    • Rules didn't link everything on import — the “To match” counter shows the rest, with candidates for each row.
    • The supplier names it differently — SKU, name and manufacturer differences are highlighted.
    • The product isn't in your catalog yet — create the card from the price list row.
    • Several suppliers carry the product — identical rows in other price lists link automatically.

    Where to start: “List of price lists” → source → “Product Matching”.

    What manual matching does

    Elbuz links some pairs on its own while the price list is being imported, using matching rules. Only the rows the rules couldn't handle end up in the manual matching window.

    • Candidate search — for the selected price list row, Elbuz looks for similar products in your catalog and shows the percentage of matching words.
    • Pair confirmation — the confirmation dialog shows both products side by side and highlights the differences; you can work from the keyboard.
    • One row, several cards — candidate ticks are stored on the server and survive a filter change.
    • New and unwanted items — you create a card from the price list row, or send an item or a whole category to the ignore list.
    • Pair memory — a confirmed pair goes into the directory and comes back on later imports; identical rows in other price lists are linked automatically.
    • Competitor products collected by the parser are matched in the same window, the same way.

    How the window works: price list on the left, catalog on the right

    The window is split in two. You can drag the border between the panels with the mouse, and Elbuz remembers the width.

    On the left is “Price list products”. Only rows without a pair appear here: as soon as a product is linked, it disappears from the list. Next to the heading there's a counter with the tooltip “Not found”. The first row is selected automatically once the list loads.

    There's no cap on the number of rows in the left panel: the list isn't loaded all at once, and Elbuz fetches from the server only the part you've scrolled to. The catalog list on the right works the same way.

    On the right is “Catalog — candidates”. While nothing is selected on the left, the panel is empty: there's nothing to find candidates for. The card above the list says “First select a price list product on the left”, and the “Candidate” card next to it says “Pick a product from the catalog”.

    The panel heading also has a counter showing how many candidates were found; when there are none, an icon with the tooltip “No similar products found in base catalog” appears next to it.

    Product Matching window: price list products on the left, catalog candidates on the right
    1Price list products
    2Counter
    3Catalog — candidates
    4Panel divider
    5Help
    6Window settings
    1. Price list products — rows of the supplier price still to be matched.
    2. Counter — how many rows are in the left list.
    3. Catalog — candidates — products from your catalog that may match the selected row.
    4. Divider — drag it with the mouse to resize the panels.
    5. The question mark — help for the right panel.
    6. The sliders button — opens the window settings.

    Each panel has an additional operations button with three items: “Refresh”, “Clear filter” and “Set up grid”. The last one opens the column picker, separately for the left list and for the catalog.

    The “Name” column comes first and is always visible: you can't remove it, but you can move it. Besides the name, it shows the photo, SKU and manufacturer. A manufacturer that isn't in the manufacturers directory is highlighted in red.

    Right-clicking a catalog row gives a single item, “Delete product”. It deletes the card from your catalog, not the price list row, so be careful: it's not the same as the item with the same name in the left panel.

    The catalog panel header has a “?” icon with the tooltip “How this window works” — short help right in the window, without going anywhere.

    A stock price list (a file linked to a main price list) works differently: the right panel shows the main price list instead of the catalog, headed “List of new products from the linked price list” and “List of found products from the main price list”. Same steps, but you link a stock row to a main price list row.

    How to match a product

    1. Select a row on the left. Its data goes into the “Price list” card, and on the right Elbuz finds similar catalog products.
    2. Review the candidates and click the right row. The ↑ and ↓ arrow keys move the selection through the list.
    3. Click “Match”. The button is in the candidate row itself and in the “Candidate” card; pressing Enter in the catalog list does the same.
    4. In the “Product Matching” confirmation dialog, compare the two columns — “Price list item” and “Product in base catalog” — row by row: “Manufacturer SKU”, “Name”, “Manufacturer” and “Price”, with photos on top. Differences in SKU, name and manufacturer are highlighted in amber; the price is shown side by side without highlighting, so check it yourself. Click “Match”.
    5. The product disappears from the left list, and the selection moves to the next row. You can keep going without touching the mouse.
    Comparison cards: price list row and the candidate with match percentage
    1Price list card
    2Candidate card
    3Match percentage
    4Match button
    5Highlighted words
    1. Price list card — the selected price list row appears here.
    2. Candidate card — the catalog product chosen on the right.
    3. Match percentage — how close the two names are.
    4. Match — opens the confirmation and links the pair.
    5. Highlighted words — matching words in one color, differing ones in another.

    To turn off the confirmation dialog, use “Show confirmation dialog” in the “Setup” menu — the button with sliders in the catalog panel header. It's on by default. Only turn it off for a large, uniform price list you're confident about: without confirmation, the pair is created as soon as you click.

    Product matching confirmation dialog with the comparison table
    1Price list item column
    2Product in base catalog column
    3Manufacturer SKU row
    4Price row
    5Highlighted difference
    6Match button
    1. Price list item — what the supplier sent.
    2. Product in base catalog — the candidate from your catalog.
    3. Manufacturer SKU — compare the codes first.
    4. Price — the price from the price list.
    5. Highlighted difference — values that do not coincide.
    6. Match — confirms and creates the link (cancelled in this shot).

    If you click “Match” without selecting one of the two, Elbuz tells you what's missing: “To match products, select a product from the base catalog!” or “To match products, please select a product from the price list!”.

    What to do

    Why the product you need isn't among the candidates

    The list on the right isn't built by artificial intelligence but by a plain search on the words in the name. It helps to know how it works: then it's clear why the product you need is sometimes missing.

    • Punctuation is stripped from the name, and it's split into words.
    • Single-letter words are dropped.
    • Words longer than seven characters lose their last two letters, words longer than five lose one. This catches different word forms.
    • About twenty words are taken from the name.
    • If the price list row has a manufacturer, Elbuz also extracts the model from the name — the word right after the brand.

    What else to take into account is set by toggles in the “Setup” menu (the button with sliders in the catalog panel header). Elbuz remembers your choice in this browser.

    • “Consider manufacturer”, “Consider category”, “Consider manufacturer SKU” — all three are on. Suspiciously few candidates? Turn off category or manufacturer: they often filter out the right product because the price list has a different category or spells the brand its own way.
    • “Remove Cyrillic” — off; keeps only Latin characters in the name and helps with price lists where names are mixed.
    • A Cyrillic “Р” instead of a Latin “P” inside SKUs and names is more reliably fixed during import, with the “Clean up homoglyphs” operation.
    Window settings drop-down with the switches
    1Consider manufacturer
    2Consider category
    3Remove Cyrillic
    4Show confirmation dialog
    1. Consider manufacturer — limits candidates to the same manufacturer.
    2. Consider category — limits candidates to the same category; turn off first if there are too few candidates.
    3. Remove Cyrillic — strips Cyrillic letters before comparing.
    4. Show confirmation dialog — asks for confirmation before matching.

    Each candidate shows a match percentage: how many words of the name and SKU matched the price list row. From 85% it's one color, from 60% another, below that a third.

    The percentage shows how similar the names are, not whether the products are the same: you make the call. The order of candidates comes from the search itself; to sort them by percentage, use “Sort candidates by match %”.

    The “%” column isn't an AI score. The model's score is shown by a separate AI assistant — a chip with a robot icon in the candidate card.

    How many candidates you get depends on whether the catalog search index is working:

    • if “Catalog search index” and “Index in the catalog grid” are on in “System settings” and the index is connected on the server, the index finds the candidates, and you get no more than 110: up to 10 by the “brand + model” pair and up to 100 by name words and SKU parts;
    • if the index isn't working, Elbuz does a plain scan of names and SKUs in the database, and the number of candidates is unlimited — the list includes every card that contains at least one word of the name, the SKU or the manufacturer name — subject to the “Consider manufacturer” and “Consider category” toggles.

    In the “Price list” and “Candidate” cards, matching words are highlighted in one color and differing words in another, so you see the difference without reading closely.

    A manual filter turns off smart candidate search. Once you type in the catalog list's filter row, Elbuz stops finding candidates for the selected product and shows a regular search across the whole catalog, as if candidate search were broken. Remove the filter or click “Clear filter” in the panel's additional operations menu to get candidates back.

    Left branch: why candidate search “disappears” when a filter is entered. Right branch: what determines how many candidates you get, and why the right card may have been filtered out by manufacturer or category
    yesnoyesnoyesnoRow selected on the left in “Price listproducts”Anything typed in the catalog filterrowor in “Search the catalog…”?Search by name words is turned offthe list shows products by your filterThe name is split into wordssingle letters dropped, long wordslose endings“Catalog search index” and “Index inthe catalog grid”on, and the index connected?Index search: up to 10 cards bybrand and modeland up to 100 by name words andSKU partsDatabase scan: every card with atleast one name word,the SKU or the manufacturer name“Consider manufacturer”or “Consider category” on?Only cards with the row'smanufacturer and category remainif they are detected in the rowCandidates on the right in “Catalog— candidates”
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    At the bottom of the catalog panel there's a “Search the catalog…” field — it searches by name and works as a filter too. Next to it, “Show all products” resets candidate search and filters and shows the whole catalog. This helps when the product is definitely there, but the names differ too much for search to find it.

    When there are no candidates at all, “No matches found in the catalog” appears over the list, with the explanation “Looks like this product is not in the catalog yet.” and two buttons — “Create new product” and “Show all products”.

    How to link a price list row to several product cards

    Sometimes one price list row corresponds to several catalog products, not one — the supplier lists a single item where you have separate cards.

    The “Match” column has a checkbox next to each candidate. Tick the ones you need, and the bottom of the panel shows “Ticked in the catalog: N” and two buttons: “Match ticked” and “Clear ticks”.

    Bottom of the candidates panel with two ticked products and bulk buttons
    1Tick box
    2Ticked count
    3Match ticked
    4Clear ticks
    1. Tick box — mark the candidate to match.
    2. Ticked in the catalog: N — the server keeps the count.
    3. Match ticked — matches all ticked products at once (not pressed).
    4. Clear ticks — removes all ticks.

    Ticks are stored on the server, not in the browser window. So they survive scrolling, filtering and reloading the list: you can find the first product, tick it, filter the list differently, find the second one — and link both together.

    The counter is also calculated on the server, so it's correct even when some ticked rows have already scrolled out of view.

    This is a separate set of ticks. Products you selected in the “Products” window for bulk editing don't show up here.

    There's no limit on the number of ticked products. All ticked pairs go to the server in one request, and the server writes them one by one, each as separate records, with no shared rollback. Ticks are cleared at the very end of the same operation, after the last pair. So if server processing is interrupted halfway:

    • pairs that were already written stay linked and are visible in the “Matched products directory”; the rest aren't linked;
    • the price list row is already linked by the first written pair, so it has disappeared from the left list;
    • ticks in the catalog aren't cleared, and “Ticked in the catalog: N” shows all of them, including those already linked.

    If you link the same pair again, there's no second record in the “Matched products directory”: the pair's previous record is replaced with the new one.

    How to create a product that isn't in your catalog yet

    Unmatched items are mostly new products in the price list, and creating them in the catalog right from here is the normal workflow. Each row in the left list has three buttons:

    • “Create new product” — creates a catalog product from the price list row data;
    • “Add to ignore list” — takes the item out of the workflow if you're not going to sell it;
    • “Delete product” — deletes the row from the price list.
    Price list rows with three quick action buttons
    1Create new product
    2Add to ignore list
    3Delete product
    4SKU and manufacturer
    1. Create new product — adds the item to the catalog from here.
    2. Add to ignore list — hides this kind of row from matching.
    3. Delete product — removes the price list row.
    4. Second line — manufacturer SKU of the row.

    The same actions are in the “Price list” card and the row's context menu (right-click), where the first one is called “Add product to base catalog”. The context menu also has “Add to ignore list” → “Category”, which takes the whole price list category out of the workflow, not just one item.

    The “Create new product” button opens the “Adding a new product” dialog with the “Select a category to add a product to” field and the “Open product card after adding” checkbox.

    • If the price list row already has a category, it's filled in. To keep the product's current categories, clear the field — the hint “Leave the field empty to keep the current categories.” says so.
    • If there's no category and the field is empty, you get the error “Category must be selected!”, and the card isn't created.
    • After you click “Add”, you see “Product added”: the card is created in the selected category with the photo from the price list, and field formulas are applied to it. The price list row is marked as found, and both lists refresh.
    • The “Open product card after adding” checkbox is remembered and works the same way in the price list products window.
    Adding a new product dialog
    1Category field
    2Empty-field hint
    3Open product card checkbox
    1. Category field — the category of the row is already filled in.
    2. Hint — leave the field empty to keep the current categories.
    3. Checkbox — open the product card after adding.

    What happens when you click “Match”

    One click does several things at once:

    • the “price list row — catalog product” pair is written to the directory of confirmed matches; this is where the link is restored from later;
    • the price list row gets the catalog product and the “found” mark; the category is taken from the catalog product, but only if the price list row didn't have one — the row keeps its own category;
    • the catalog product card gets a link to the supplier's item;
    • matching counters of all affected price lists are recalculated — the same “To match” badge;
    • a line with the product name in the catalog and the name in the price list is written to the work log, so you can see later who linked what.

    If the pair no longer exists by the time it's written — the price list row or the catalog card has been deleted — Elbuz silently skips that pair and moves on to the next one.

    The two top checks happen in the window, before anything is written. After that, the server does everything — for each pair separately, while ticks and counters are updated once at the end
    noyesyesnonoyes“Match” clicked or Enter pressedPrice list row and catalog productselectedor products ticked?Message about what's missingnothing is written“Show confirmation dialog”on?“Product Matching” dialogcheck and “Match” buttonFor each pair: do the price list rowand catalog card still exist?The pair is silently skippedWritten to the “Matched productsdirectory”price list row and card marked aslinkedIdentical unlinked rows in other pricelistsare linked to the same cardA line in the work logCatalog ticks, if any, are cleared“To match” counters are recalculatedThe row disappears from the left listthe selection moves to the next one
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    One product, all suppliers at once. Elbuz recognizes the same product in other price lists by a fingerprint of the name and SKU. When you link an item in one supplier's price list, identical rows in other suppliers' price lists are linked automatically, as long as they aren't linked yet. No need to do the same work twice.

    All confirmed pairs are collected in the “Matched products directory”: that's where you review and unlink them.

    A wrong pair doesn't stay in the window. After the catalog update, the card receives another product's price and stock, and from there they go to your storefront and marketplaces. So it's better to keep the confirmation dialog on and check the price in it yourself: it's shown without highlighting. A wrong pair is unlinked in the directory.

    When the price list price shows up in the product card

    Matching itself doesn't move the price and stock into the card. It only writes the link and marks the card as found in the price list; the price, stock and other card fields stay as they were. They're carried over by the base catalog update, and only on its next run. It starts:

    • manually — with the “Update” button in the “Updating base catalog” window;
    • automatically — after all price lists are imported at once (on a schedule or manually), if “Update catalog after import” is on in “System settings”, “Catalog update” section (on by default);
    • as a step in an Elbuz Flows scenario.

    If “Matched products only” is on in “System settings”, the update touches only cards linked to price list rows and leaves unlinked ones as they were. In that case, matching is required for a card to be updated from price lists at all.

    The new price reaches your storefront and marketplaces in one more step — building exports. After all price lists are imported at once (on a schedule or manually), this is triggered by the “Build exports after update” setting; after a manual “Update”, exports aren't built automatically.

    While “Fixed Price” is on in a card, the catalog update doesn't change its price and supplier, no matter how many price list rows are linked to it.

    You can link rows from different suppliers' price lists to one card. The card gets one offer — the catalog update picks it based on the “Price selection type” setting: “minimum”, “average” or “maximum”, taking supplier priorities into account. Details: Choosing the supplier price and taking missing products off sale.

    Scenarios

    Several suppliers carry the same product — link it once

    What to do. Open the window from the “Directories” → “Processing price lists” → “Product Matching” menu to see rows from all price lists together, and match one supplier's item the usual way — with the “Match” button.

    What you get. Unlinked rows in other suppliers' price lists with the same name and SKU fingerprint get the same catalog card. “To match” counters are recalculated in all affected price lists. The catalog update decides which offer goes into the card — see When the price list price shows up in the product card.

    What won't happen. A row already linked to another card isn't overwritten. A row where the same product has a different name or SKU won't link on its own — you match it separately.

    The card is definitely in the catalog, but it isn't on the right

    What to do. First check the “Manufacturer: …” chip at the bottom of the catalog panel. The row's manufacturer is detected automatically and can be wrong — click × to drop the brand limit. Still missing? Turn off “Consider category” in the “Setup” menu. Last resort: “Show all products” and search by part of the name in “Search the catalog…”.

    What you get. The × on the chip turns off “Consider manufacturer”, and the candidate list reloads. Elbuz remembers your choice in the “Setup” menu in this browser. “Show all products” resets candidate search and filters and shows the whole catalog.

    What won't happen. The chip isn't shown when “Consider manufacturer” is off or the price list row has no detected manufacturer — then the brand doesn't limit the list anyway. While something is typed in the “Search the catalog…” field, candidate search doesn't work for the next price list row: clear the field when you move on.

    Items you don't sell clutter the list

    What to do. In the row, click “Add to ignore list” and confirm with “Add”. To remove a whole price list category, right-click the row → “Add to ignore list” → “Category”.

    What you get. A rule with the product or category name goes into this price list's ignore list. The row and same-named rows of this price list (or the whole category) are deleted, and counters are recalculated. On later imports of this price list, Elbuz discards rows with exactly the same product or category name, or fingerprint.

    What won't happen. The rule applies to one price list: the same items stay in other suppliers' price lists. The button in the row and in the “Price list” card ignores only the product — only the context menu item removes a category.

    FAQ

    Where does a product go after matching?

    The left list shows only rows without a pair, so a linked row disappears from it. You can see the new pair in the matched products directory.

    The right panel shows the whole catalog instead of similar products. Why?

    Something is typed in the catalog filter row: a manual filter turns off candidate search. Remove the filter or click “Clear filter” in the panel's additional operations menu (candidate search).

    Is the “%” column for candidates an AI score?

    No. The browser calculates “%”: the share of words in the candidate's name and SKU that match the price list row. The model's score is shown by a chip with a robot icon when the AI assistant is on.

    Will matching pull the product description from the price list?

    No. Matching only links the price list row to the card so that it receives price and stock. Description and attributes are filled by a different feature, matching doesn't link options, and price list categories are linked in their own window.

    When is a manual match lost?

    When the product is deleted from the catalog or the supplier changes the name or SKU the row was recognized by. If the row is temporarily missing from the price list, the pair stays in the directory as a lost link and comes back with the product.

    Can I match competitor products?

    Yes, in the same window, the same way. Products collected by the competitor site parser go into the same table as price list rows; without a pair in your catalog, there's nothing to compare their prices with.

    Can Elbuz link such products on its own?

    Yes. During import, pairs are set by matching rules, and AI matching handles the rest in one run. The more they link, the less is left for manual matching.

    Where to find it and who has access

    Menu
    Directories → Processing price lists → Product Matching (unmatched rows from all price lists)
    Other entry points
    “List of price lists” → source → “Product Matching” button (this supplier only)
    All sources
    the “Price list products” panel in “All sources” mode → “Product Matching”
    Access right
    the “Product Matching” window; actions on products are a separate right — without it, view only
    Left menu: Directories > Processing price lists with the Product matching item
    1Product matching
    1. Product matching — opens the window for matching supplier products with the catalog.

    In the source header, next to the button, there's a “To match” badge with a number — these are price list products that don't have a pair in the base catalog yet.

    Supplier price list header with the Product Matching button and the counters
    1Product Matching button
    2To match counter
    1. Product Matching — opens the matching window only for this supplier's products.
    2. To match — how many price list rows still have no pair in the catalog.
    Toolbar of the All products panel with the Product matching button
    1Product matching button
    1. Product matching — the same button in the panel of products from all price lists.

    Without the right to take actions, the window opens in view-only mode: there's no “Match” column, no row buttons and no ticked products bar.

    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