↑↓ selectEnter openEsc close

    1. Elbuz

    Product manufacturer and attributes from a supplier price list

    4 min readUpdated

    On every price list import, Elbuz detects the product manufacturer and copies color, weight or material from file columns into product card attributes.

    When you need this:

    • The brand is hidden in the name “Smartphone Samsung Galaxy S24” — the app finds it and uses your directory's spelling.
    • Color and volume are separate columns — the catalog update turns them into attributes.
    • Duplicates and typos in the manufacturer directory — synonyms keep them out; auto-adding is a deliberate choice.
    • “Manufacturer” is empty for some products — the log shows how many items were matched.

    Where to start: import a price list and check the red manufacturer names in its products.

    What the manufacturer and attribute operations do

    How the app matches price list text to directories

    Both operations are added to every new source automatically and are almost never turned off. So they are already working for you — the only question is what they manage to find.

    Both do the same thing: take text from the price list and look for a matching entry in your directory. The manufacturer is looked up in the “Product manufacturers” directory, the attribute in the “Attributes” directory. In both cases the comparison is the same — an exact name match. Not “similar”, not “begins with”, but one string matching another.

    Search for a product manufacturerSaving values from fields to attributes
    What it takes from the price listthe “Manufacturer” field, an attribute with a “brand” name (nine variants, listed in the manufacturer article), words of the product name, the category from the price list, the Excel sheet namevalues of the columns marked with the “Product attribute” or “Product option” checkbox
    What it matches againstthe “Product manufacturers” directory and manufacturer synonymsthe catalog “Attributes” directory
    If there is no matchthe “Manufacturer” field stays unlinked to the directory — or a new entry is created in the directorythe value stays in the price list without a link to the directory
    Default position in the pipeline70140 — the last one
    Own parameters“Min. characters”, 3 by defaultnone
    What it writes to the logthe line “Manufacturer search: matched / not found in the directory” and two numbersthe line “Copying field values into attributes”, and only if any marked columns were found at all

    Where to see the result

    The manufacturer is visible. The price list product grid shows “Manufacturer” and “Manufacturer ID” columns. A name with no link to the directory is shown in red with the tooltip “The manufacturer is not in the manufacturer directory”. It's the fastest way to see gaps in the directory. For reference: a 526-item price list we checked had 96 red names.

    Price list product grid with manufacturer names in red that are missing from the manufacturers directory
    1Red manufacturer name
    2Manufacturer ID column
    1. A manufacturer name drawn in red means the name is not in the manufacturers directory.
    2. In the Manufacturer ID column these rows show 0 because there is no link to the directory.

    Price list attributes are not visible anywhere until the base catalog update runs — see “Where to see attributes” for details.

    Log. After every import — a — the operations write the following to the log:

    • Manufacturer search — the line “Manufacturer search: matched / not found in the directory”, then two numbers separated by a slash: how many price list items are linked to the directory and how many have a name but no link. The second number is exactly the red names from the grid, no counting by eye.
    • The manufacturer search writes its own name at the “debug” level, which is hidden in the log by default.
    • The attribute operation writes the line “Copying field values into attributes” — but only when it has found at least one marked column. It passes an empty result silently.

    Scenarios

    New supplier: brand and attributes from the first run

    What to do. Before the first price list import, go through the checklist below.

    Before the first run

    What you get. After the run, the brand is detected for products whose spelling is in the directory; the other names are red in the price list products. Attributes appear in the product cards after the catalog update.

    What you won't get. The operation won't add brands that are missing from the directory while “Add new manufacturers” is off — how to decide whether to turn it on.

    FAQ

    What happens if I remove these operations from the list?

    The brand is no longer taken from product name words, but a manufacturer from a separate file column is still linked to the directory when the import ends. Without the attribute operation, option products aren't linked to the main product and the option value isn't added to the name.

    Why doesn't the attribute operation write anything to the log?

    It writes a log line only when it has found at least one column with the “Product attribute” or “Product option” checkbox. No marked columns, no line. How to mark columns — in the attributes article.

    Products get duplicated because the SKU sometimes has a Latin “C” and sometimes a Cyrillic one. Is there anything for this?

    Yes, the price list operation “Clean up homoglyphs (Latin ↔ Cyrillic look-alikes) in name, SKU and manufacturer”. It isn't added by default: add it above the manufacturer search and catalog matching. It doesn't remove duplicates that were already created. Details: about homoglyphs.

    The brand wasn't detected for all products. How do I quickly find which brands are missing?

    Open the price list products: a manufacturer name without a link to the directory is red there. The second number in the “Manufacturer search” log line shows how many such rows there are. Details: where to see the result.

    Do I need to add these operations to every new source?

    No. Both operations are added to every new source automatically. You change the set and order of operations in the “Order of operations” window — how to do it.

    Where to find it and who has access

    The operations window and the column wizard have no menu item — you open them from the source card.

    Price list operations
    source card → “Additional” section → “Order of operations”
    Other entry points
    price list list → row menu → “Processing rules” group
    “Product attribute” checkbox
    source card → “Columns” → “Configure column” → “Value processing” group
    Product manufacturers
    Directories → Manufacturers
    Catalog attributes
    Directories → Base product catalog → Attributes
    “Add new manufacturers” setting
    Account → System settings → “Price lists” → “Import and parsing”
    Access right
    price list card (“Additional” section) and, separately, the “Product manufacturers” window
    Prepare
    an imported price list and entries in the manufacturer directory

    In the “Order of operations” window, the list of this price list's operations is on the left and the “Operation guide” panel is on the right. Select “Search for a product manufacturer” in the list.

    Its description and its only setting appear on the right. While nothing is selected, the panel shows “Select an operation in the list on the left — its description and parameters will appear here.”; for the attribute operation it says “This operation has no additional parameters.” — and that's true: only the manufacturer search has a parameter.

    The “Order of operations” window with the manufacturer search operation selected and its guide panel on the right
    1Search for a product manufacturer
    2Min. characters
    3Saving values from fields to attributes
    1. Search for a product manufacturer — the operation selected in the list; its description appears on the right.
    2. Min. characters — words shorter than this are ignored when searching for a brand.
    3. Saving values from fields to attributes — the last operation in the list by default.

    The order of operations, the “Add an operation” and “Set for all” buttons, and the drag-and-drop rules are covered separately — order of operations during price list import. This article covers what these two operations do with the data.

    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