↑↓ selectEnter openEsc close

    1. Elbuz

    How to map columns in the wizard and check them before import

    10 min readUpdated

    Elbuz shows the supplier file's columns with sample values; you assign each a field in one click: name, price, SKU. Choices save instantly, and the file preview shows how the program read the file.

    When you need this:

    • Auto-detection picked the wrong field — sample values are right there; change the field in one click.
    • First import from a new supplier — a checklist verifies the mapping first.
    • The supplier inserted columns at the start — the log offers new addresses.
    • Wrong values are already in the price list — a repeat import with corrected mapping replaces them.

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

    What the wizard can do

    How to map columns in the wizard window

    At the top of the window there's built-in help, and it says the main thing: “On the left are your file columns with sample values. For each one, pick the catalog field to load the data into. Be sure to map the price and the name or SKU — unmapped columns are simply not loaded. Changes are saved immediately.”

    The last sentence deserves special attention: the wizard has no “Save” button. Every field choice goes to the database the moment you make it.

    Column mapping wizard with file columns, sample values, system fields and the mapped counter
    1Column number badge
    2Sample values from the file
    3Selected system field
    4Mapped counter
    1. Column number badge — the address of the column in the file.
    2. Sample values — first values of this column taken from the file.
    3. Selected system field — where the data of this column is loaded.
    4. Mapped counter — how many file columns are mapped out of the total.

    The table is split in two: the left half is called “Column in the file”, the right half “System field”. Each row is one file column: on the left, an address badge, the header as the supplier wrote it and up to three sample values, so you don't have to guess the contents. On the right, the target field.

    Click the right part of the row to pick a field. With more than fifteen options, a “Search field…” box appears at the top — type “sku”, “price”, “photo”. Two special items: “— do not import” at the top skips the column, “+ Create field…” at the bottom adds a field that's missing.

    Field picker opened on the row mapped to Name in the column mapping wizard
    1Field search box
    2Do not import option
    3Create field link
    1. Field search box — type to filter the list of system fields.
    2. Do not import — clears the mapping for this column.
    3. Create field link — adds a new custom field without leaving the wizard.

    To the right of the field name, the row has two icons: the sliders open the column settings, and the cross removes the link (its tooltip reads “Do not import this column (unlink the field)”).

    At the bottom of the window there's an “N of M mapped” counter and an “Add column” link. If a required field isn't mapped, a warning lights up next to the counter and names the missing field; for a recommended field you get the same hint, only softer.

    Below the table is the “File preview” fold, expanded by default. This is the quickest way to check yourself: the preview shows the file the way the program read it.

    For Excel, each preview column shows its letter and number, and the row number on the left is the one you enter in “Load products from row”. Hover over a column to see its address, e.g. I33.

    If instead of the table you see “Could not parse file: 0 columns. Check the format, selected sheet and header row.”, there's nothing to map yet. Most often it's the wrong sheet of the Excel workbook, the headers aren't in the first row, or the format was detected incorrectly.

    When addresses are set for each sheet separately

    For Excel sources, the “Columns” section header has a “Configure per sheet” toggle — it appears once the workbook has at least one sheet; the “Import from sheets” link next to it, once there are two or more. Tooltip: “Column addresses are set for each Excel sheet separately (the “Import from sheets” window). Off — one global set of addresses”.

    When this mode is on, the card has no field grid — instead you see “Per-sheet setup mode enabled.” and the “Import from sheets” link. In this mode the wizard opens for a specific sheet and edits that sheet's set of addresses.

    Address auto-detection doesn't work in this mode — each sheet's mapping is set by hand or in the wizard. More details: per-sheet mode.

    How to check the mapping before import

    It pays to check before you run the import: an import with wrong mapping isn't an error on screen, it's thousands of products with the wrong values in their fields.

    Four places tell you the truth about the state of the mapping:

    • The “File preview” fold in the wizard. Shows the file the way the program read it — with the sheet, header row and separator that are currently set.
    • The “N of M mapped” counter at the bottom of the wizard. M is the total number of rows in the table: columns from the file plus manual ones you added; N is how many of them have a field assigned.
    • The readiness card at the top of the source card: “Columns mapped” with a number, “Columns not mapped” or “Price or name missing”.
    • The “With address” and “No address” quick filters in the grid. The fastest way to see what's left.

    Before the first import

    One more thing worth knowing in advance: re-uploading the file doesn't reset the mapping — your fields and addresses stay for any format. For an Excel workbook the program also updates the column names, so the card doesn't keep the headers of the previous file; in the names stay as they were read the first time.

    If the preview keeps showing old data, the cause is almost always not the program but the browser cache: the browser shows the preview page from memory. Force a refresh — Ctrl+F5 (on macOS Cmd+Shift+R). If the data is still the same, the file really wasn't updated, and you need to look at the source.

    For Excel, CSV, XML and , you can check the mapping in the chat: the “✦ AI” button in the source header → “Set up columns / XML branch”.

    The consultant puts the current mapping next to a suggestion from the same engine as this window's AI mapping buttons and marks differences: a field linked to the wrong column, or the available tag instead of @available. Fixes come as a “Change price list mapping” plan, applied only by the confirm button; the previous mapping goes to the operation log.

    After the change, upload the price list again. For and , mapping is done only in the price list window.

    How to fix data after wrong mapping

    The consequences of a mistake sit in two places: in the price list products and, if you ran a catalog update after the import, in your own products. They're fixed differently.

    A repeat import fixes the price list products. Any import that read at least one row first deletes all previous rows of this price list, with their attributes and photos, then loads the file using the current mapping. So fix the addresses and run the import again: no old wrong values remain.

    • If the import didn't read a single row, the old price list rows stay as they were, wrong values included.
    • If a stop rule cancelled the import, the old data also stays — the data loaded with the wrong mapping.
    What happens to the mapping during import. The two diamonds about addresses are mapping checks: they cancel the import before the file is read, and an XML feed skips them. The “At least one row read?” and “Blocking stop rule triggered?” diamonds decide whether the new price list rows replace the old ones
    YesNoNoYesNoYesNoYesYesNoPrice list import:XML format?Mapping checks are skipped,the feed goes to processingAt least one columnwith a field and address?“Column addresses … are not filledin!”import cancelledA column with the“Consider uniqueness” flagand an address?“Column addresses are not filled infor columns flagged …”import cancelledThe file is readusing the current mappingAt leastone row read?“No data received, previousproduct list will be displayed”Blocking stop ruletriggered?New rows are discarded,old price list rows stayOld price list rows are deleted,new ones are loaded
    • Action or result
    • Decision: the path depends on the answer

    Price list values reach your catalog only through “Updating base catalog”. After the corrected import, run it again: fields linked in the update settings get the correct values. Two update options can get in the way (the rule applies to all fields except price, old price, RRP, cost price, quantity, stock status, manufacturer and category):

    • if a field has “Update if value is not empty in price lists” and that field is empty in the corrected price list, the wrong value stays in the product;
    • if it has “Update if value is empty in base catalog”, the field with the wrong value is no longer empty, and the update won't overwrite it.

    You'll have to fix such products in the catalog yourself. What a catalog update erases with no way back, and how to restore it — How to update your catalog from price lists without losing data.

    Scenarios

    First import from a new supplier

    Open the wizard, click “Auto-map columns” and go through the rows where sample values don't look like the assigned field. Expand “File preview” and go through the checklist before the first import. Result: the first import loads products with the right names and prices, and you only need to spot-check them.

    The supplier inserted columns at the start of the file

    Yesterday the price list loaded fine, today it arrived empty: the supplier added two columns on the left, and everything shifted by two positions. The price is now read from a date column, and it's empty.

    1. Open the “Log” tab of the source card. The banner shows “Empty feed: no rows loaded” and next to it “Price columns have moved — check the column addresses” with a list of moves: “Brand” 1→3, “Price, UAH” 8→10.
    2. Click “Apply new addresses” in the banner — the field addresses are rewritten to the new numbers, and a composite 1, { }, 4 becomes 3, { }, 6.
    3. Run the import again.

    The banner is yellow when all triggered rules only warn; if any rule is set to “Block”, it's red, but the shift line and the button are there too.

    The shift check doesn't always work:

    • a file that has never uploaded successfully isn't checked — there's nothing to compare with;
    • the program doesn't recognize a renamed column, only one whose header moved to another column;
    • a header row below row 30 of the sheet isn't searched for, and if fewer than two headers from the previous file are recognized in the new one, the check stays silent;
    • a column whose header repeats in the new file (two “Price” columns) isn't tracked;
    • XML feeds aren't checked at all, JSON unreliably: it has no headers;
    • a field whose address you've already fixed by hand is skipped by the check, and the button doesn't touch it.

    All the limits of the check are in the article about the price list log.

    The price went into “Old price”, and the price list is already loaded

    Change the field in the wizard and run the import again. Result: the import rebuilds the price list rows using the new mapping. If you ran a catalog update after the wrong import, run it again — what it overwrites and what it doesn't.

    What to do when it doesn't work

    Common problems
    What you seeWhyWhat to do
    “Could not parse file: 0 columns. Check the format, selected sheet and header row.” The saved mapping has no columns: the wrong sheet of the workbook, headers not in the first row, or the format detected incorrectly Expand the “File preview” fold and see what the program actually read; the format and the data start row are set in the “Source” section of the card (checking the mapping)
    “Select a field first” You clicked the address badge in a row that has no field assigned yet First pick a field in the right part of the row, then set the address (wizard window)
    The price list arrived empty or without prices, and the log shows “Price columns have moved — check the column addresses” The supplier inserted or rearranged columns, but the addresses in the card are still the old ones On the “Log” tab, click “Apply new addresses” and run the import again (about shifted columns)

    FAQ

    There's no “Save” button — were my changes in the wizard saved?

    Yes. Every field choice is written immediately; there's no separate confirm or cancel. Made a mistake? Pick another field or “— do not import”.

    Does the program check whether I picked the right field?

    No. Put the price into “Old price” and the program won't object — it will load it there. Compare the sample values in the row with the field name on the right.

    How do I add a column that isn't in the preview?

    With the “Add column” link at the bottom of the wizard: first pick a field, then enter the address. More details: where to edit the address.

    The wizard shows the right samples, but the import takes the wrong column. Why?

    Samples in the wizard are matched by the header text, while the import reads the address literally — the column letter or number. If the supplier shifted the columns, fix the addresses. More details: shifted columns.

    Can I put a column into a product attribute in the wizard?

    No, the wizard's list has no attributes. Open the field grid in the “Columns” section and click “Add field”. More details: why the wizard has no attributes.

    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 rights
    the “List of price lists” window; changing fields requires the right to edit price lists
    Prepare
    an uploaded price list file; for XML, the name of the product tag

    There's no “Column wizard” button in the toolbar, only “Add field” and “Formulas”. This means the program has nothing to show yet: the file isn't uploaded or couldn't be parsed, so it sees no column headers. File first, then mapping. How to upload a file to an existing source is described in the article about uploading a supplier price list.

    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