↑↓ selectEnter openEsc close

    1. Elbuz

    How to map units of measurement from different files: aliases and coefficient

    2 min readUpdated

    When the universal import loads specifications, Elbuz maps different spellings of one unit — “pcs.”, “pieces”, “pc” — to one unit in the directory. Duplicate units stop appearing.

    When you need this:

    • Two suppliers write “pcs.” and “pieces” — an alias in the directory puts both files in one unit.
    • The directory already has “pcs”, “pcs.” and “pieces” — an alias stops new duplicates; you delete the old ones by hand.
    • A product is sold in packs of 12 pieces — a “pack” unit with coefficient 12 goes to the website with the directory.

    Where to start: “Directories” → “Base product catalog” → “Units”, the “Name alias” column.

    What the units of measurement directory does

    How import finds a unit of measurement

    In the universal import, the specification mapping has a “Unit” field: the import takes the value's unit of measurement from it, for example “kg” in “Weight: 5 kg”. Elbuz looks up the unit it found in the directory in this order:

    1. by “Local name” in any language;
    2. by “Name” and “Name alias”.

    The whole text is compared as is, with no abbreviation handling: to Elbuz, “pcs.” and “pcs” are different units. If no match is found, it creates a new unit with that text, and duplicates such as “pcs.”, “pieces”, “pcs” appear in the directory.

    How to map “pcs.” and “pieces” to one unit

    To make two suppliers with “pcs.” and “pieces” land in one unit, open the “Units of measurement” directory and, in the row of the unit you need, enter the second spelling in the “Name alias” column.

    • A unit has only one alias. Enter a third spelling in “Local name” for another language, or fix it in the file.
    • An alias applies to future imports. Duplicates already in the directory stay — you remove them by hand.
    • Aliases work only in the universal import. Supplier price list processing ignores aliases: it adds units of specifications from a price list to the directory exactly as they are spelled.
    Units of measurement window with the Name and Name alias columns
    1Name
    2Name alias
    1. Name — the short unit designation that is matched against the supplier file.
    2. Name alias — extra spellings of the unit that the import recognizes as the same unit.

    How to add a unit with a coefficient, for example a pack of 12 pieces

    In the “Units of measurement” window, click “Add” — an empty row appears at the top of the table; enter values by double-clicking a cell. For a pack:

    ColumnValue
    Namepack — import recognizes the unit by this, by “Local name” and by “Name alias”
    Full namepack of 12 pcs
    Coefficient12
    Base unitleave unchecked

    Then select this unit in the “Unit” field of the product card.

    The coefficient here is for reference only: Elbuz does not use it to recalculate quantities in documents, warehouse stock or prices. One pack in an order stays one pack, not twelve pieces. The value is stored in the directory and sent to the website with it by the Tunnel module; how it is used there depends on the .

    FAQ

    One supplier writes “pcs.”, another writes “pieces”. Can they be one unit of measurement?

    Yes, in the universal import. In the row of the “pcs.” unit, enter “pieces” in the “Name alias” column. The next import will use the same unit instead of creating a new one (aliases).

    I sold a pack with coefficient 12 — why did stock go down by 1, not 12?

    The coefficient is for reference only: Elbuz does not use it to recalculate quantities in documents or stock. One pack stays one unit (coefficient).

    I set an alias, but a supplier price list still created a new unit. Why?

    Price list processing ignores aliases: units from a price list are added as they are spelled. Aliases work only in the universal import.

    Suppliers write “pcs”, “pcs.” and “pieces”. Can I enter two aliases?

    No, a unit has only one alias. Enter the third spelling in “Local name” for another language — import checks it too — or fix it in the file.

    I set an alias — why are “pcs” and “pieces” still separate rows in the directory?

    An alias applies to future imports. Units that import has already created stay in the directory; you remove them by hand.

    Where to find it and who has access

    Menu
    Directories → Base product catalog → Units
    Other entry points
    product card, the “Unit” field
    Access right
    the “Units of measurement” window in “Group permissions”
    Have ready
    the unit spellings that appear in your files

    Directory columns: “Full name”, “Local name”, “Name”, “Name alias”, “Code”, “Type”, “Coefficient”, “Base unit”. To edit a value, double-click the cell.

    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