↑↓ selectEnter openEsc close

    1. Elbuz

    How to map price list columns: where the name, price and SKU are

    3 min readUpdated

    Elbuz reads a supplier file using column mapping — “file column → system field” pairs: where to take the name, price and SKU from. Elbuz maps the first file itself, and later uploads are read the same way.

    When you need this:

    • New supplier connected — columns are mapped automatically; just check them.
    • Import stopped with “Column addresses are not filled in” — a log button opens the “Columns” section.
    • Name or stock is split across columns — the address joins or sums them, no formulas.
    • Supplier rearranged the columns — Elbuz spots the shift and suggests new addresses.

    Where to start: source card → “Columns” section → “Column wizard”.

    What column mapping can do

    What mapping is: column address and system field

    Mapping is made of pairs. Left: the column address — the column letter in an Excel workbook, its number or, for XML, the tag name. Right: the system field — where Elbuz puts what it reads. A clean system has fifty target fields plus your custom fields — from “Name” and “Price” to “ISBN Barcode” and “Nutri-Score (Nutritional Value)”.

    The hint above the grid in the card puts it this way: “Map file columns to system fields. “Name” is required, “Price” is recommended. Click a row for fine column settings.”

    Only one field is required — “Name”. “Price” is recommended: without it Elbuz warns you but still works. The other fields are up to you: a column with no field assigned is simply not imported. That's not an error or a loss: often half the columns in a supplier price list are of no use to you.

    Scenarios

    New supplier: from file to first import

    Upload the file — auto-mapping maps the columns on its own. Open the “Column wizard”, fix fields where the sample values don't fit the field, and go through the checklist before the first import. Result: the first import brings in products with correct names and prices.

    An import stopped with “Column addresses are not filled in”

    In the error log, click “Fill in column addresses”, then “Auto-map columns” in the wizard, and set an address at least for “Name”. Result: both mapping checks pass and the import reads the file. Why each version of the error appears — see the breakdown below.

    Prices in the file are in US dollars

    Set the currency on the column, not with a formula: in the “Column wizard”, open the “Price” column settings, choose USD in the “Currency” group and leave “Exchange rate” at 0. Result: repricing multiplies the price by the rate from the currency directory — if the price list's markup types include “Price + exchange rate”. Don't also add {Price list: Price} * {CURRENCY_RATE_USD} — the rate would be applied twice. Step by step — price list in US dollars.

    The supplier changed the file

    A new file doesn't reset the mapping: fields and addresses stay as you set them. If columns have moved, the log shows “Price columns have moved — check the column addresses”. Result after “Apply new addresses”: the addresses are rewritten to the new column numbers — what it looks like.

    What to do when an import stops because of the mapping

    Common problems
    What you seeWhyWhat to do
    “Column addresses for loading data from the price list are not filled in!” Not a single column in the price list is mapped: no column has an address. This is the first of two mapping checks Map at least “Name” or “Manufacturer SKU”. The error log has a “Fill in column addresses” button that takes you straight to the “Columns” section (column wizard)
    “Column addresses are not filled in for columns flagged “Consider uniqueness”!” Columns are mapped, but none of them has both the “Consider uniqueness” checkbox and a filled-in address. This is the second check — it runs only after Elbuz has confirmed that at least one column is mapped Select “Consider uniqueness” for the “Name” or “Manufacturer SKU” column and make sure its address is filled in (column settings)
    “Import canceled!” Appears on the next line after the check above Map the columns and run the import again
    “Load error” The window data couldn't be loaded: the request to the server failed Try again; if it keeps happening, check that you have access to the “List of price lists” window (who has access)

    FAQ

    Do I have to map every column in the file?

    No. Only one field is required — “Name”; “Price” is recommended. A column with no field assigned is simply not imported, and usually half the columns in a supplier price list are like that. Map what you need.

    The supplier sent a new file — will the mapping be lost?

    No. Fields and addresses stay as you set them; for Excel, only the column names are updated. But the address is read literally: if the supplier rearranged the columns, the log offers “Apply new addresses”. Learn more: shifted columns.

    The import fails with “Column addresses for loading data from the price list are not filled in!”. What should I do?

    No column has an address. Use the “Fill in column addresses” button in the log to go to the “Columns” section, and set an address at least for “Name”. Learn more: common problems.

    I've mapped the columns — are the products in my catalog now?

    No. The mapping only says where to take values from: supplier products go into the price list. Linking them to your catalog is a separate task: product matching and category matching.

    Can I check the mapping in a chat with AI?

    Yes, for Excel, , XML and : the “✦ AI” button in the source header → “Set up columns / XML branch”. Learn more: checking the mapping.

    Where to find it and who has access

    The “Column mapping wizard” window has no menu item of its own — it opens only from the source card, in the “Columns” section.

    Menu
    Directories → Processing price lists → List of price lists
    From the source card
    “Columns” section → “Column wizard” button; the same section has the field grid, where you can edit addresses without the wizard
    From the source connection wizard
    the “Check” step shows the same mapping table
    From the “Import from sheets” window
    the wizard button for the selected sheet of an Excel workbook
    Access right
    the “List of price lists” window (in “Group permissions” — “Price lists”)
    Changing fields
    permission to edit price lists
    Have ready
    an uploaded price list file; for XML, the name of the product tag

    The “Columns” section is available in the card of any file source. Site parsers don't have it: they collect data from web pages, not from file columns.

    The Columns section of a price list source: toolbar with the Column wizard button and the field grid with column addresses
    1Column wizard
    2Column address
    3Section hint
    1. Column wizard — opens the step-by-step assistant that matches price list columns to product fields.
    2. Column address — the letter or number of the file column that feeds each field.
    3. Section hint button next to the heading — explains that Name is required and Price is recommended.

    Take away an employee's import settings tab, and they won't see the “Columns” section at all, together with the field grid and the wizard button. The price list products stay available. This way a manager can see what was imported without access to the source settings.

    You can also hide just the “Columns” section and keep the rest of the tab: it has its own permission block, labeled “"Settings" tab: the "Columns" section” in “Group permissions”. Clearing the checkbox removes both the section tile in the card contents and the section itself; the other import settings stay in place.

    The “Check” step of the source connection wizard shows the same mapping table. Learn more: What to check at the “Check” step.

    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