Elbuz connects a new supplier's price list with a three-step wizard and finds the name, price and other columns by their headers; AI handles unfamiliar headers.
When you need this:
- A spreadsheet with headers: columns are mapped by the header dictionary, and the import starts right away.
- Unusual headers: what the dictionary misses goes to AI.
- Price list by email or on FTP: columns are mapped on a sample file; mailbox and server are set later in the card.
- Not clear what the source lacks: until it's ready, the card shows what's done and what isn't.
Where to start: “List of price lists” → “Add” → the source connection wizard.
What source connection can do
- A three-step wizard: supplier, how the file is received, column check; on a typical price list the third step is skipped.
- Formats: Excel, , , and archives; the app recognizes a feed with the wrong extension by itself.
- Automatic column mapping: by the header dictionary, and whatever is left, through AI.
- The source card: turning the source on, file actions, settings sections with search, status dots in the list.
How to go through the source connection wizard
The wizard opens with the “Add” button in the left panel header, or with the “Connect source” button in an empty window. The window title is “New supplier source”. The “Add” button menu has up to three items:
- “Source for “‹supplier›””: appears when a supplier is selected in the list, and fills it in;
- “New source…”: always there;
- “Stock price list for “‹source›””: appears when a main source without a stock price list is selected.
If nothing is selected in the list, the menu has exactly one item.
Step 1. “Who”
Every source belongs to a supplier. Pick an existing one in the “Search supplier” field, or switch to “New supplier” and enter the name and contact type. The customer group isn't in this list, only suppliers and other contact groups. The list shows only active contacts, so the wizard won't show a deactivated supplier.
You can leave the “Source name” field empty: the placeholder says as much, “optional — we will fill it in”. The app names the source as “‹Type› — ‹Supplier›”. You need your own name when one supplier has several sources and you have to tell them apart in the list.
Step 2. “From where”
Six tiles are six ways to receive the file. Under the selected tile, its fields appear:
- File, as well as E-mail and FTP: the drop zone “Drop the price file or click — xlsx, csv, xml, zip” and the “Choose file” button.
- URL: “File URL”, “Login (if required)”, “Password (if required)”.
- Site : the “Ready-made parsers” list (shops and marketplaces we support ourselves) or “Universal parser” for any website, where the selectors are set up manually.
- : the “Ready-made API integrations” list. Pick a supplier; you'll enter the access parameters later.
After you click “Next”, the step is locked by a banner with stages: “Saving the source…”, “Uploading and parsing the file…”, “Detecting columns…”, “Starting the import…”. It isn't decoration: this is exactly when the file is uploaded to the server and parsed.
“Next” seems dead. In fact, a red message appears below: “Select or create a supplier”, “Choose a source type”, “Choose a price file”, “Enter the file URL”, “Pick a ready-made parser from the list or enter a website link”, “Pick a supplier from the ready-made API list”. It stays for three seconds, so it's easy to miss.
The source appears in the list as soon as the app has created it, before the wizard finishes. So if you close the window with the cross mid-way, the supplier and source don't go anywhere: you can finish setting them up in the card.
1
New supplier / Existing switch2
Supplier search3
Source name (optional)4
Three wizard steps- Switch between creating a new supplier and choosing an existing one.
- Search field for picking the supplier.
- Source name field; it can be left empty and is filled in automatically (the field is partly hidden under the button bar when the supplier list is open).
- The three steps: Who, From where, Check.
1
File2
URL3
E-mail4
FTP5
API6
Site parser- File — upload an xlsx, csv, xml or zip price.
- URL — direct link to a file.
- E-mail — a file arriving as an email attachment.
- FTP — a file on a server.
- API — a request to a service.
- Site parser — scraping the supplier's site pages.
1
Sample file dropzone2
Hint about automatic retrieval settings- Drop the supplier's price file here or click to choose one.
- Retrieval settings (e-mail or FTP) are set later, in the source card.
What to check at the “Check” step
Here the app shows how it mapped the file columns to system fields: “Review the automatic mapping of file columns to system fields. The “Name” field is required, “Price” is recommended.”
This step may not appear. If automatic mapping found both the price and a key field (name or SKU), the wizard asks nothing and starts the import right away. Step 3 appears when one of these wasn't found.
At the bottom are “Back”, “Open import settings” and “Done and import”; “Next” is hidden on step 3. For email and FTP the middle button is “Set up file retrieval”, and it becomes the main one: you've given a sample file, and what's left is to tell the app where to get such files from now on.
API and site parser have no third step. When you click “Next” at “From where”, the wizard creates the source, closes and opens the settings window: “Site data import settings” for a parser, the access parameters window for API. These modes have no column table and no “Done and import” button: there is no file yet, so nothing to import.
You can go back by clicking step titles, but not forward: the wizard replies “Finish the current step first”. On the first two steps the Enter key works as “Next”.
“Could not parse file: 0 columns. Check the format, selected sheet and header row.” The file was uploaded, but nothing could be read from it: usually the wrong Excel sheet, or the headers aren't in the first row. “Done and import” then disappears, leaving only the link to the source card. Fix it there:
- the row to read products from: the “Load products from row — starting from” field in the “What data to load” subsection of the “Products” section;
- the format: the “File format” switch in the “Source” section;
- sheets of a multi-sheet workbook: the “Configure per sheet” switch in the “Columns” section header; once it's on, the “Import from sheets” link appears next to it.
- Action or result
- Decision: the path depends on the answer
1
Mapping hint2
Column in the file3
System field4
Set up file retrieval5
Done and import- The hint asks you to review the automatic mapping; “Name” is required and “Price” is recommended.
- This column lists the headers of the file the supplier sent, with sample values.
- This column shows the system field each file column is loaded into.
- Opens the source settings (file retrieval) so you can adjust the loading setup.
- Creates the source and starts the first import.
Which files are supported
| Format | Extension | How it is mapped |
|---|---|---|
| Microsoft Excel | xls, xlsx, xlsm | columns are matched by headers |
| CSV | csv, txt, tsv | columns are matched by headers |
| XML, YML feed | xml, yml | tags are matched by the dictionary, then by AI; you set whatever is left manually |
| BMEcat catalog | xml or another allowed one | automatically, from the file content |
| DATANORM price list, versions 4 and 5 | a number (.001), csv, txt, tsv or a ZIP archive | automatically, from the file content |
| JSON | json | manually, by column numbers |
The app doesn't read PDF: if the supplier sends the price list as a PDF, ask them for the same price list in Excel or CSV.
An archive works too: zip, 7z or gz; a gz can contain only XML. The app detects the format first by extension and, if that doesn't work, by file type. The app sets no size limit; only the server limit applies.
About XML with the wrong extension: suppliers often name a feed “price.txt” or give it no extension. The app looks inside (it reads the first thousand characters) and, if it sees signs of a YML catalog or RSS, loads the file as XML. So an odd name alone is no reason to rework the file by hand.
“This file type is not supported for upload!” means the file's extension and type didn't match any row in the table above. Most often it's an error page the supplier's website returned instead of the file, or a document in a format that isn't on the list.
“An empty file has been uploaded!” means no file was selected or it is empty.
“Email attachments skipped because this file type cannot be a price list: …” means the email had an attachment the app doesn't treat as a price list. A double dot in the name is fine: cennik.pl.xlsx loads as a regular Excel file.
How to map columns
Column mapping answers the question “what's in which column of the file”. In the table, “Column in the file” is on the left (what the supplier sent), and “System field” is on the right (where the data goes).
There is only one required field: “Name”. Price is recommended: without it, the import won't stop. But the source card will show the warning “Required field “Price” is not mapped”, and in the wizard, without a name, the “Done and import” button is inactive with the hint “Map the required “Name” field first — open the card”.
There is only one button above the table: “Auto-map columns”. Everything else is elsewhere:
- “Add column”: at the bottom, in the “N of M mapped” summary row;
- “File preview”: to the right of the table, so you can see the column address without scrolling;
- “Configure column”: an icon at the end of each mapped row; it opens detailed settings for that column;
- “Manual column”: not a button but a row label. It marks a column the app didn't see in the file and whose address you set via “Add column”.
The app maps columns by itself right after the file is uploaded. “Auto-map columns” fills in only columns that aren't linked to anything yet: it compares their headers with system field names and passes what it couldn't match to AI. It doesn't touch columns that are already mapped. Learn more: How the app maps columns by itself.
The import stops with “Column addresses for loading data from the price list are not filled in!”: the columns in the card were left unmapped. A special case is “Column addresses… are not filled in for columns that have the “Consider uniqueness” flag!”: the addresses are missing exactly in the columns the app uses to tell products apart.
Neither check applies to XML sources: there, addresses are structure branches and tag names. So a feed with empty mapping goes through without a warning, and it's the empty import result that stops it.
You can type a column address by hand: letters A–ZZ or a number; a compound address is comma-separated. Learn more: how to write a column address.
Automatic mapping isn't supported for JSON: specify its columns yourself (about JSON). Compound addresses, uniqueness and other mapping details are in the article Price list column mapping.
1
Column address in the file2
System field name3
Column wizard4
Row mapped to the Name field- Column address shows which file column feeds each field.
- Name column lists the system fields.
- Column wizard maps columns automatically.
- The Name field is mapped to column 1.
How the source card works and what the source is missing
Clicking a source in the left panel opens its card on the right: a header with the name, counters and buttons, and the “Settings” tab.
The “Three steps…” bar
While the source isn't ready (no file, columns not mapped or no import yet), the top of the “Settings” tab shows a bar explaining “Three steps to get products into the system…” with four tiles: “Price file”, “Columns mapped”, “Matched with catalog”, “Last run”. Clicking a tile takes you to the right section, and “Last run” opens the log.
Once there is a file, the columns are mapped and an import has run, the bar disappears: the source header shows the same numbers.
Header: turning the source on and file actions
Above the source name is the contact group badge; below it, the supplier, the file name with a ▾ arrow (a file icon if it matches the source name), the active switch and the status. On the right are the “Products”, “Matched”, “To match” and “Updated” counters, and below them the “Import” button and other actions.
1
Activity toggle2
File menu arrow3
Import button- Toggle that turns the source on or off, next to the status pill.
- File icon with an arrow that opens the file menu.
- Import button.
- The active switch: an enabled source takes part in shared processing and is loaded on schedule. A disabled one gets the “Disabled” status and stays in the list, dimmed; you turn it back on with the same switch. Learn more: how to disable a source.
- The file name menu: “Download” saves the price file; “Open” views the file in Office Online (XLS up to 5 MB only); “Make a copy” creates a new source with the same settings for a supplier you choose; “Create a site parser” creates a second supplier source that opens product pages using links from the price list.
“Create a site parser” checks the price list first. If a parser already exists, the app tells you it's in the supplier's source list.
If no column is mapped to the “Product link (URL)” field, the app asks you to map one and import the price list. Otherwise it shows the “Supplier site parser” window with what will be overwritten: the price with the website price, availability and stock with the product page data. Empty values don't overwrite the file data.
1
Group badge2
Download3
Make a copy4
Create a site parser- Badge with the contractor group above the title.
- Download the source file.
- Create a copy of the source.
- Create a site parser from this source.
What the colored dots in the list mean
In the left panel, each source has a colored dot. The “?” sign in the top row of the panel, next to the “Add” button, shows what it means:
- gray: the source is still being set up (no file uploaded or columns not mapped) or it is disabled;
- green: all good, the source is ready to import or was imported without errors;
- red: the last import didn't go through: it failed, was canceled or was stopped by a stop rule; open the source log;
- orange: stop-rule warnings fired in the last import, for example price deviation; details are in the log;
- pulsing: an import is running right now.
The dot next to a supplier shows the worst status among its enabled sources. So if a supplier has five price lists and one of them breaks, you'll see it without expanding the list.
1
Help mark2
Status dot legend- Question mark that opens the help.
- Legend explaining each colored status dot.
How to find a source in a long list
The “Search source…” field narrows the list by the text you type. Clear it with the cross in the field or the Esc key.
The funnel button next to the search opens filters. It's hidden when there's nothing to choose from: the list has one contact group and no sources with errors or anomalies. Filters apply to the list on the left and to the grid on the “Overview” tab in “All sources” mode; they don't narrow the “All products” tab.
| Filter | What it keeps | When it's shown | After the window is reopened |
|---|---|---|---|
| Contact group | contacts of the selected group; their count is next to the name | the list has at least two groups | the choice is kept in this browser |
| “With errors” | sources with a red dot, already expanded | there's at least one such source in the selected group | cleared |
| “Anomalies” | sources with an orange dot, already expanded | there's at least one such source in the selected group | cleared |
Clicking a selected filter again clears it. The counter on the button shows how many filters are selected, even when their rows are collapsed.
Headers of contacts outside the main group are highlighted in their group's color, if one is set, and the hint above the contact name shows the group. The “Supplier” group isn't colored, so the others stand out. The color is set in the “Contact groups” directory.
1
Search field2
Filter button3
Group filter4
State filter5
Header in a group color- Source search field.
- Button that expands the filter rows.
- Filter by contractor group.
- Filter by state: with errors, anomalies.
- A contractor header tinted in its group color.
What's on the source's “Settings” tab
The row of links at the top of the tab is “Source”, “Columns”, “Products”, “Prices”, “Availability”, “Additional”, “Schedule”; a click scrolls to the section. Sections your group has no right to aren't shown in the row.
For XML and JSON, right below “Columns” there is the “XML structure” (or JSON) section with branches for categories, products, attributes and photos. “Prices” and “Availability” sit side by side in two columns; in a narrow window, one above the other.
Hover over the “?” icon next to a section title to see its explanation.
On the right of the row is the “Find a setting…” field. It filters the form in place: it keeps fields with the word you need visible and expands collapsed subsections that contain a match. If nothing is found, the app says “Nothing found — try another word.”
1
Find a setting field2
Decimal separator- Search field that filters the settings form.
- Matching field: decimal separator.
The “Source” section
How the file is received is a row of buttons, File · URL · E-mail · FTP, with the selected one's fields below. A source connected via a ready-made integration has an “API” row with the “API settings” button instead of buttons, and “File format” isn't shown: the integration module sets it.
The card opens on the method that actually delivers the file. During loading, configured methods run in turn (URL, email, FTP, API), each overwriting the file, so the last one's file is imported. That's why the card shows the last configured method and, if there are several, warns with an orange line: “Several delivery methods are configured…”.
The “URL” method has the “File URL” field, with the collapsed “File access” subsection below it.
The “File access” summary row shows what is set: “login and password”, “headers: N”, “private Google file” or “no authorization”. Inside are “Login”, “Password”, “HTTP request headers” (one per line, “Key: Value”; an example is under “?”), the “Private Google file (access via service email)” checkbox and the “Supplier account login settings” button.
1
Source method buttons2
File URL field3
File access summary4
File upload and data import dates5
Import filters- Row of methods: File, URL, E-mail, FTP.
- Field with the file address.
- File access with its summary.
- Dates of the last file upload and data import.
- Import filters.
1
Login and password2
HTTP request headers3
Private Google file toggle4
Supplier account login settings- Login and password fields.
- HTTP request headers field.
- Toggle for a private Google file.
- Button for the supplier account login settings.
Below, for all methods:
- “File format”: a switch to override the format if the app detected it wrong;
- the date row “File upload: … · Data import: …”: when the file was last received and when products were last loaded from it;
- “Import filters”: “Process the price list only if the file has changed” and “Show products in Trash that are not assigned to catalog categories”.
The “Products” section
The section is made of collapsed subsections. Each has a summary row and a “Configure ▾” button, so you can see what's set without expanding it.
| Subsection | What's in it | Summary row |
|---|---|---|
| What data to load | loading attributes and photos, product option checkboxes, “Load products from row” from/to, “Price list password”, CSV separators, automatic categorization | “N of M on” |
| Cleanup and service | removing duplicates, log of deleted products, trend tracking | “N of M on” |
| Stock | stock price list only: what to do with products that aren't in the file | “N of M on” |
| Product condition | the default condition and the words the app uses to recognize discounted, used and refurbished products (learn more) | default condition, “Product condition” column, your own words or “shared words” |
| New products | catalog category, language and shop for new product cards | category · language · shop |
1
What data to load summary2
Product condition3
New products summary- The summary shows how many data options are enabled out of the total.
- Product condition shows the current condition setting in one line.
- New products shows how newly found products are handled.
The “Prices” and “Availability” sections
“Prices”: “Load products with price” from/to, “Price multiplicity”, “Delivery cost”, “Decimal separator” and “Thousands separator” (how numbers are written in the file), the “RRP price list” checkbox and the “Which markup rules to apply” list. The “?” next to the list explains how the markup modes differ.
For an Excel source with “Configure per sheet” on (in the “Columns” section), this block is shorter: it has no price from/to, multiplicity, delivery cost or either separator. In this mode the import takes them only from the sheet settings, so instead of the fields there’s an explanation and the “Import from sheets” button, which is where you set these values for each sheet (what else you set per sheet).
“RRP price list” and the markup rules stay in the card in either mode, because they apply to the whole price list. Values set in the card earlier aren’t erased: turn per-sheet mode off and they work again.
“Availability”: the warehouse for the price list products and “Quantity field type”, either “Stock” or “Sales”.
1
Decimal separator2
Which markup rules to apply3
Quantity field type- Decimal separator field.
- Choice of which markup rules to apply.
- Quantity field type: Stock or Sales.
1
Per-sheet settings note2
Import from sheets button3
Which markup rules to apply- The note explains that price range, rounding step, delivery cost and number separators are set per sheet.
- The Import from sheets button opens the per-sheet settings.
- Which markup rules to apply stays a source-wide setting.
The “Additional” section
Buttons for price list processing windows: “Order of operations”, “Category detection”, “Price list category matching”, “Distribution rules”, “Regular expressions”, “Markup types”, “Product matching settings”, “Field formulas”, “Ignore rules”, “Text replacement rules”. At the bottom is the collapsed “Source details” subsection: “The name of the price list in the list”, “Website URL”, “Note”.
How to rename a source, that is, a price list
Where: source card → “Settings” → “Additional” → “Source details” → the “The name of the price list in the list” field.
This is the source's name in the list on the left. There's no save button: the card saves by itself, and “Saved” appears at the bottom of the window. While the field is empty, the app labels the source with the name set at creation or, if there's none, with the file name, domain or source type.
No “Additional” section means your group has no right to the source settings (who has access).
1
Price list name in the list- Field with the name under which the source is shown in the list.
Scenarios
The supplier emails the price list, and the columns need mapping once
What to turn on. In the wizard, choose the “E-mail” tile and give the file from the latest email as a sample. At the “Check” step, click “Set up file retrieval”.
What you get. The columns are mapped on the sample, and the source card is open where you set the mailbox and the email selection rule. Next: the price list arrives by email.
The Excel workbook has several sheets, and the headers aren't in the first row
What to turn on. In the source card, “Products” section, “What data to load” subsection: the “Load products from row — starting from” field. For sheets, turn on “Configure per sheet” in the “Columns” section header, then open the “Import from sheets” link that appears next to it.
What you get. A file in which the wizard couldn't read a single column gets parsed, and you can map the columns. More about sheets: Multi-sheet Excel.
The supplier provides an XML feed named “price.txt”
What to turn on. Nothing: choose the “URL” or “File” type as is.
What you get. The app sees signs of a YML catalog or RSS inside and loads the file as XML. The wizard maps the tags through AI.
What to do when the file isn't parsed
| What you see | Why | What to do |
|---|---|---|
| “Could not parse file: 0 columns” | The wrong sheet of the Excel workbook, or the headers aren't in the first row | Set the row and the sheet in the source card (the “Check” step) |
| “This file type is not supported for upload!” | The file's extension and type didn't match the list of formats; most often the supplier's website returned an error page instead of the file | Open what was downloaded and compare the format with the table (which files are supported) |
| “Couldn't read the file as an Excel workbook: it is password-protected, damaged or not an Excel file (e.g. a web page saved with an .xls extension). Open it in Excel, save it as .xlsx without a password and upload it again.” | The workbook is password-protected or damaged, or it isn't an Excel workbook at all, for example a web page or a PDF | Open the file in Excel, save it as .xlsx without a password and upload it again; for a PDF price list, ask the supplier for Excel or CSV (which files are supported) |
| “Column addresses for loading data from the price list are not filled in!” | The columns in the card were left unmapped | Map them in the “Columns” section; the only required field is “Name” (about columns) |
| “Could not match automatically” | The column headers didn't match system field names, and AI didn't match a single field either; on a demo account AI is turned off completely | Map the columns yourself (about columns) |
FAQ
Do I have to map the price?
No. The only required field is “Name”: without a price, the import still runs, but the source card shows a warning. Learn more: how to map columns.
Why didn't the wizard show the “Check” step?
Automatic mapping found both the price and the name or SKU, so there was nothing to check, and the import started right away. Learn more: the “Check” step.
Can I upload a price list in JSON format?
Yes, the format is supported. There's no automatic column mapping for JSON, so you'll have to enter the column addresses manually.
How do I rename a price list?
Source card → “Settings” → “Additional” → “Source details” → the “The name of the price list in the list” field. It saves by itself. The supplier contact's name doesn't change. Learn more: source name.
I closed the wizard mid-way. Is the source gone?
No. The source appears in the list as soon as the app creates it, before the wizard finishes. Finish setting it up in the card.
Email is set up, but the card opened with a URL. Are the settings gone?
No. If several methods are configured, the card shows the one whose file gets imported, the last in the URL, email, FTP, API order, and warns about the conflict. Switch the method to see the email fields.
Where it is and who has access
- Menu
- Directories → Processing price lists → List of price lists
- Wizard
- the “Add” button in the left panel header
- Source card
- click a source in the left panel
- Access right
- the “List of price lists” window; the wizard is a separate right
- Prepare
- a sample file from the supplier, even for email and
Related topics
- For the big picture from file to website: How to upload a supplier price list to Elbuz.
- If the columns are mapped and it's time to load products: How to import a price list and get prices into your catalog.
- If the file should arrive on its own: Ways to receive a price list from a supplier.
- If you need a compound column address or the uniqueness flag: Price list column mapping.
