↑↓ selectEnter openEsc close

    1. Elbuz

    How Elbuz detects the product manufacturer from a price list

    10 min readUpdated

    Elbuz fills in the “Manufacturer” field of price list products itself: it takes the brand from a file column or the product name and links it to your manufacturer directory.

    When you need this:

    • The brand is in a separate column — matched against the directory even without the operation.
    • The brand is only in the product name — “Search for a product manufacturer” checks its words against the directory.
    • The supplier writes “A-DATA” or “Bosch,” — punctuation is stripped on both sides.
    • Two brands in the name — one is kept, in a fixed order.

    Where to start: check the file for a brand column.

    What manufacturer search can do

    How Elbuz searches for the manufacturer

    “Search for a product manufacturer” fills in the “Manufacturer” field and links it to the directory. It goes through three sources in turn.

    Left branch: a price list without the operation, where only the ready “Manufacturer” field is matched. Right branch: a full run. Words from the product name never get into the directory: only “Manufacturer” field values are added
    NoYesYesNoYesNoPrice list import reached theoperationsIs “Search for a productmanufacturer”in the list of operations?At the end of the import: the“Manufacturer” fieldis matched against directory namesand synonymsAn empty “Manufacturer” field takesthe valueof an attribute with a “brand” nameExact match of the “Manufacturer”fieldwith a name, then with a synonymUnlinked rows: words of the productname,price list categories, Excel sheetnameSeveral brands found?One is kept: first from the productname,then more products in the samecategory,then in the whole catalogIs “Add newmanufacturers” on?Unknown names from the“Manufacturer” fieldare added to the directory and linkedLog: “Manufacturer search: matched/not found in the directory” and twonumbers
    • Action or result
    • Decision: the path depends on the answer

    A ready value. If the “Manufacturer” field is already filled in from a file column, the operation looks for an exact name match in the directory and substitutes the directory spelling. Then it does the same with synonyms.

    These two steps run even when the operation is not in the list: at the end of the import, Elbuz matches the whole field value of products without a manufacturer against the directory.

    An attribute with a “brand” name. If the “Manufacturer” field is empty, Elbuz takes the value of an attribute named one of nine variants: Бренд, Производитель, Виробник, Brand, Manufacturer, Vendor, Марка, Торговая марка, Торгова марка. The list is hard-coded; case and edge spaces don't matter. How to use it — see below.

    Words from the text. The main and trickiest method for a regular price list. The product name is split into words; each word is cleaned and compared with directory names. The price list category is split the same way, while Excel sheet names are checked whole for the brand name inside.

    OrderWhere the words come fromHow they're compared
    1product nameword for word with the directory name
    2price list categoryword for word; this step always runs
    3Excel sheet namethe brand name is searched for inside the sheet name

    Both sides are cleaned before comparison. Each price list word keeps only digits, Latin and Cyrillic letters, ä ö ü ß and spaces; all-digit words and words shorter than the threshold are dropped.

    Directory names and synonyms go through the same cleaning, so punctuation inside a name doesn't matter: “A-DATA” in both the price list and the directory becomes “ADATA”.

    Spelling in the price list or directoryWhat cleaning turns it into
    SamsungSamsung
    Bosch,Bosch
    (Bosch)Bosch
    A-DATAADATA
    Black&DeckerBlackDecker
    BLACK & DECKERBLACK DECKER — already two words
    Xiaomi/RedmiXiaomiRedmi
    NestléNestl
    KrügerKrüger

    Results on live data. The directory contained Samsung, A-DATA, Bosch, Nestlé, Nestle, Under Armour, LG, BLACK & DECKER, Black&Decker, De’Longhi.

    Name in the price listWhat was found
    Smartphone SAMSUNG Galaxy S24Samsung — case doesn't matter
    Washing machine Bosch, 8 kgBosch — cleaning removed the comma
    TV LG 55LG
    SSD A-DATA 512GBA-DATA — the hyphen was removed on both sides
    Coffee Nestlé Classic 200 gNestlé, not Nestle: “é” disappeared in the price list and in the directory too
    Coffee machine De’Longhi MagnificaDe’Longhi
    Drill Black&Decker 500WBlack&Decker
    Drill BLACK & DECKER 500Wnothing — after cleaning it's two words
    T-shirt Under Armour size Lnothing — the name has two words

    A space around punctuation. Cleaning removes the mark on both sides, so A-DATA, Black&Decker and De’Longhi are found by the words of the product name. But BLACK & DECKER becomes two words, and such a name is never found that way: the comparison goes one word at a time.

    Add the spelling without spaces — Black&Decker.

    A doesn't help either: it's cleaned the same way, so “BLACK & DECKER” stays two words.

    A spelling with spaces can only be detected by an exact match of the “Manufacturer” field or through the Excel sheet name.

    What decides which brand is found

    The “Min. characters” field

    The operation's only parameter, in the panel on the right. The default is 3: shorter words aren't checked, so that words like “of”, “for” and “kg” don't match something in the directory. Zero and any non-numeric text are treated as 3 anyway.

    The threshold counts letters, the same way for Latin and Cyrillic: both LG and ЛГ are two letters, and with a threshold of 3 neither would get into the search.

    The code makes an exception for two brands: LG and HP are checked at any threshold. The Cyrillic ЛГ isn't in the exception. If you raise the threshold to 6, both Bosch (five letters) and Бош (three) drop out of the search.

    If several brands are found in a product

    Only one is kept. The selection order is: first, the one found in the product name rather than in the price list category; next, the one with more products in the same category of your catalog; next, the one with more products in the catalog overall; finally, the longer word.

    Both product-count criteria are calculated during the run itself, by queries against your catalog, rather than read from a stored counter in the manufacturer card.

    What happens if a run stops halfway

    The operation writes results to price list rows step by step: “brand” attributes, exact name matches, synonyms, then search by words. Only after that — and only if “Add new manufacturers” is on — are unknown names added to the directory; last comes the “Manufacturer search” log line with two numbers.

    • If the run stopped before the operation finished, some price list rows already have a manufacturer and the rest don't. The directory hasn't changed: the only thing the operation does to it at the start is remove synonyms with an empty name. There will be no log line with two numbers; its absence is exactly how you can tell the operation didn't finish.
    • If it stopped while adding new manufacturers, the directory may keep entries that were already added, while price list rows aren't linked to them yet. The next run will link them: the linking-by-name step runs every time, even when no new manufacturers were added.
    • Repeating is safe. Each step takes only rows that aren't linked to the directory yet, so a repeat doesn't overwrite manufacturers that are already detected. The service dictionary table that may be left over from an interrupted run is deleted and recreated by the operation at the start.

    The operation has no cap on the number of price list rows: each step is a single query over the whole price list, without splitting into batches.

    How to take the brand from a separate column

    This is the most common case after “brand in the name”: the file has a separate brand column, and you need its value to become the product manufacturer.

    The working recipe is simple: map this column to the “Manufacturer” field. The field is then filled in while the file is read, and the operation links it to the directory by an exact name match — even when it isn't in the list of operations. No checkboxes or reordering are needed.

    Now about the link between two operations, which is why people often reorder them. The first step of manufacturer search reads attributes: for products with an empty “Manufacturer” field, it takes the value of the attribute whose name is in the list of nine “brand” variants (see above).

    Attributes are created by the other operation. So the order of the two operations in the pipeline matters: while the attributes operation is last, there are no attributes yet when manufacturer search runs.

    Reordering helps only when the attribute really has one of the nine “brand” names. The operation takes the name from the field label in the catalog language, and of the standard fields only one fits the list: the “Manufacturer” field, which in a Ukrainian-language catalog creates an attribute named “Виробник”.

    But a column mapped to the “Manufacturer” field fills the very field the first step reads, even without any attributes — and the step no longer touches it, since it works only with empty ones.

    So in a regular price list with a brand column, moving the attributes operation up changes nothing.

    Where this step really works is when attributes come from the supplier's feed with their own names. In an XML feed the supplier sets the attribute name, so a brand attribute arrives named, for example, “Бренд”. Such attributes are read while the file is parsed, before any operations, so there's nothing to reorder here either.

    Bottom line: the link between the operations is real, but reordering helps less than it seems. First check what the brand attribute is called, and only then change the order.

    Scenarios

    The supplier gives the brand in a separate file column

    What to turn on. In the price list column addresses, map the brand column to the “Manufacturer” field. You don't have to add the “Search for a product manufacturer” operation for this.

    What you get. The column value goes into the “Manufacturer” field while the file is read. Elbuz then looks for an exact match with a directory name, then a synonym, and substitutes the directory spelling. Without the operation this runs at the end of the import; with it, inside the operation.

    What you won't get. A spelling that's neither among the names nor among the synonyms in the directory stays red in the price list products. No new directory entry appears while “Add new manufacturers” is off — and it's off by default.

    The brand is only in the product name

    What to turn on. The “Order of operations” window must include the “Search for a product manufacturer” operation. Leave the “Min. characters” field at 3.

    What you get. Each price list row without a directory link is split into words of the product name and the price list category, and each word, after cleaning, is compared with directory names and synonyms. If several brands match in a row, one is kept — by the rules in “If several brands are found in a product”.

    What you won't get. A brand that isn't in the directory yet won't be detected this way: the operation only compares words with the directory and adds only values of the “Manufacturer” field to it. A two-word brand like Under Armour won't be found either, and neither will words shorter than the threshold — except LG and HP.

    What to do when the manufacturer isn't detected

    What you seeWhyWhat to do
    The “Manufacturer” field is empty for all price list products The brand isn't in the field or in the product name in a form Elbuz can find: the directory name has several words, or the word is shorter than the threshold Check how names are spelled in the directory and the “Min. characters” field (how Elbuz searches for the manufacturer)
    “This operation has no additional parameters.” That's right: of the two operations, only manufacturer search has its own setting Select “Search for a product manufacturer” in the list to see the “Min. characters” field (the “Min. characters” field)
    The attributes operation was moved above manufacturer search, but the “Manufacturer” field is still empty The first search step reads an attribute with one of the nine “brand” names (Бренд, Производитель, Виробник, Brand, Manufacturer, Vendor, Марка, Торговая марка, Торгова марка), but the operation named it differently — after the price list field Map the brand column to the “Manufacturer” field instead of reordering (when the brand is in a separate column)

    FAQ

    Why is the “Manufacturer” field empty even though the operation is on?

    The operation finds only what's already in your manufacturer directory and compares names exactly. A two-word brand in the directory won't be found by the words of the product name: the comparison goes one word at a time. An empty directory means nothing is found.

    Will Elbuz find a two-word brand like “Under Armour”?

    Not by the words of the name: the comparison goes one word at a time. Such a brand is detected by an exact match of the “Manufacturer” field — map the brand column to this field — or through the Excel sheet name.

    Why doesn't “Nestlé” from the price list find the “Nestle” entry?

    Cleaning removes everything on both sides except Latin and Cyrillic letters, digits and the letters ä ö ü ß. “Nestlé” becomes “Nestl”, while “Nestle” stays as is — the strings differ. Add “Nestlé” as a synonym of the Nestle entry.

    Why is “LG” found in the product name, but the Cyrillic spelling isn't?

    Both spellings are shorter than the “Min. characters” threshold, and the exception is made only for the Latin LG and HP. The Cyrillic “ЛГ” is detected only by an exact match of the “Manufacturer” field. More: the “Min. characters” field.

    Will a repeated run overwrite a manufacturer that's already detected?

    No. Each step takes only rows that aren't linked to the directory yet. More: what happens if a run stops.

    Where to find it and who has access

    Operation
    source card → “Additional” → “Order of operations” → “Search for a product manufacturer”
    Brand column
    source card → “Columns” section → “Manufacturer” field
    Access right
    price list card, “Additional” section
    Prepare
    entries in the manufacturer directory: the operation only finds brands that are already there

    What the operations window looks like and where else this topic comes up — see the overview article.

    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