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
- Take the brand from a separate column — directory matching runs even without the operation.
- Find the brand among the words of the name, the category or the sheet name — after punctuation is stripped.
- Filter out short words — the “Min. characters” threshold, with an exception for LG and HP.
- Pick one brand out of several — using a sequence of four rules.
- Safely repeat an interrupted run — a repeat doesn't overwrite manufacturers that are already detected.
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.
- 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.
| Order | Where the words come from | How they're compared |
|---|---|---|
| 1 | product name | word for word with the directory name |
| 2 | price list category | word for word; this step always runs |
| 3 | Excel sheet name | the 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 directory | What cleaning turns it into |
|---|---|
| Samsung | Samsung |
| Bosch, | Bosch |
| (Bosch) | Bosch |
| A-DATA | ADATA |
| Black&Decker | BlackDecker |
| BLACK & DECKER | BLACK DECKER — already two words |
| Xiaomi/Redmi | XiaomiRedmi |
| Nestlé | Nestl |
| Krüger | Krü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 list | What was found |
|---|---|
| Smartphone SAMSUNG Galaxy S24 | Samsung — case doesn't matter |
| Washing machine Bosch, 8 kg | Bosch — cleaning removed the comma |
| TV LG 55 | LG |
| SSD A-DATA 512GB | A-DATA — the hyphen was removed on both sides |
| Coffee Nestlé Classic 200 g | Nestlé, not Nestle: “é” disappeared in the price list and in the directory too |
| Coffee machine De’Longhi Magnifica | De’Longhi |
| Drill Black&Decker 500W | Black&Decker |
| Drill BLACK & DECKER 500W | nothing — after cleaning it's two words |
| T-shirt Under Armour size L | nothing — 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 see | Why | What 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
- If you need the big picture — Product manufacturer and attributes from a supplier price list.
- If names are red because the brand isn't in the directory — How to keep price list brands from cluttering the manufacturer directory.
- If you need to extract the brand from the name text into a separate field — Regular expressions for a price list.
- If a markup rule with a manufacturer filter doesn't work — Pricing rules: the filter needs a filled-in “Manufacturer” field.
- If “by manufacturer” matching finds no pairs — Matched products directory.
