↑↓ selectEnter openEsc close

    1. Elbuz

    How to upload a supplier price list to Elbuz

    4 min readUpdated

    Elbuz fetches supplier price lists — by email, link, FTP, or API — and moves prices and stock into your catalog. No manual price edits each morning.

    When you need this:

    • A new supplier — the wizard connects it in three steps: supplier, file delivery, column check.
    • The file names columns its own way — the app matches them by header, the rest goes to AI.
    • A new file arrived — the source's products are fully replaced; manual catalog matches stay.
    • Prices should reach your site unattended — scheduled uploads update the catalog and exports.

    Where to start: “List of price lists” → “Add” → source connection wizard.

    What price list upload can do

    • Connect a source with the wizard — three steps: supplier, how to get the file, column check.
    • Map the columns — the app matches them by header on its own; only “Name” is required.
    • Run the import — in the background, with a notification when it finishes.
    • Update the price list — a new file replaces the source's products; manual matches stay.
    • Get prices to the catalog and website — with a button or as a chain after the schedule.
    • Fetch the file without you — from a link, email, , or , on a schedule.
    • Fix a price list after a bad file — by importing again; the log shows what went wrong.
    • Remove a supplier — turn the source off for a while or delete it.

    What this means for your business is covered separately: what it gives your store.

    How the app gets the price list file

    You choose the source type once, on the wizard's second step. After that, the app fetches the file the same way every time.

    Source typeWhat it is
    FileExcel, CSV, XML and YML, BMEcat, DATANORM, JSON, or an archive (all formats)
    URLa direct link to the file
    E-mailan email with an attachment
    FTPa file on a server
    APIa request to a service
    Site parsercollecting data from website pages

    For E-mail and FTP, the wizard asks for neither the mailbox nor the server password. It asks for a sample file — the same drop zone as for the “File” type: “First attach a sample file from the supplier — we will map the columns from it. Automatic retrieval settings (e-mail or FTP) come next, in the source card.”

    Without a file there's nothing to match: columns are mapped on at least one sample, and only then does the app learn to pick up such emails itself — the price list arrives by email.

    Ready-made website parsers and ready-made API integrations are chosen only in the wizard — from the “Ready-made parsers” and “Ready-made API integrations” lists. The source card shows a parser or API only once it's already linked.

    From file to website: the price list's path

    To get a supplier's products and prices into the app, you need three things: create a source, show the app where the name and price are in the file, and run the import. The first time, the wizard does this. After that, the same source updates with one button or on a schedule.

    1. Open the list of sourcesList of price lists
    2. Go through the wizard: “Who” → “From where” → “Check”Source connection wizard
    3. Check that the “Name” field is mappedSource card, “Columns” section
    4. Run the import and wait for it to finishSource card, then “Operations”
    5. Move prices to the base catalogUpdating base catalog
    6. Set up automatic file fetching and a scheduleSource card, “Source” and “Schedule” sections

    What to do to get the price list uploaded

    How to make the file arrive on its own

    Before parsing, the import fetches a fresh file itself if the source allows it: from a link, by email, from FTP, or via an API. It's all set up in the card's “Source” section; each method is covered in Ways to get a price list from a supplier:

    When to fetch the file is set in the card's “Schedule” section: turn on “Auto-load” and click “Configure” — a window with the schedule opens. The schedule is on, but nothing happened in the morning? See Schedule and task queue.

    Schedule section of a source card with Auto-load and the Configure button
    1Auto-load
    2Configure
    1. Auto-load — the scheduled download of the price list.
    2. Configure — opens the schedule settings window.

    To keep a broken file out of the price list, set up stop rules with the “Block” action.

    Source section of a URL-based price list with the access options expanded
    1File URL
    2HTTP request headers
    3Private Google file
    1. File URL — the link the price list is downloaded from.
    2. HTTP request headers — extra headers such as an API key, one per line.
    3. Private Google file — access to a closed Google file through the service email.

    Scenarios

    The supplier posts a price list at a dated link every day, and prices should reach the marketplaces on their own

    What to turn on. In the “Source” section, enter the link, replacing the date with the macro {get_date("d.m.Y")}. In the “Schedule” section, turn on “Auto-load” and click “Configure”. In the app settings, turn on “Update catalog after import” and “Build exports after update”.

    What you get. The app inserts today's date, and if there's no file at that address, it tries earlier days — up to five days back. After all price lists are uploaded on schedule, the base catalog updates, and then the export templates are rebuilt.

    What won't happen. No new products appear in the catalog until “Add new products” is on: without it, only existing products update. A manual “Import” of a single source doesn't start this chain, so the catalog keeps the old price after it.

    The supplier has two price lists: one for prices, one for stock

    What to turn on. Select the main source in the list and click “Add” → “Stock price list for “‹source›””. This item appears when the main source doesn't have a stock price list yet.

    What you get. The stock price list is added as a separate source linked to the main one. Details: Stock price list and linked supplier price lists.

    FAQ

    Where are price list settings?

    There's no separate settings window: everything is in the source card. Open “List of price lists” and click the source on the left. The card's sections are in the row at the top; if one is missing, your group hasn't been given rights to it. Details: source card.

    The supplier sent a broken file, and it's already imported. What do I do?

    Import the correct file: the price list rows are replaced entirely, and matches are applied again. Then update the catalog. Details: How to fix a price list after a bad file was imported.

    The import finished, but the website shows the old price. Why?

    The import only brings data as far as the supplier's products. Next come the base catalog update and building the exports; a manual import of a single source doesn't start them. Details: when prices reach the catalog.

    How many suppliers and price lists can I connect?

    As many as you need: there's no limit on the number of suppliers or sources. There's no separate fee per supplier or price list either: you pay by the number of products, based on the larger of two lists: “Base catalog” or “Price Lists”. Details: pricing and plan.

    Why use this if I can put the price list together in Excel?

    A spreadsheet has to be opened and checked by a person every day. In Elbuz, column mapping, product pairs, and markup are set once and apply to every new file on schedule (scenario). Stop rules keep a broken file off your website, and the log shows how the upload went.

    What's the difference between turning a source off and deleting it?

    A disabled source keeps all its settings; only bulk runs and the schedule skip it. Deleting removes everything with no way back. Details: How to temporarily turn off or delete a source.

    Where to find it and who has access

    Menu
    Directories → Processing price lists → List of price lists
    Other entry points
    the “Connect source” button in the empty window
    Access right
    the “List of price lists” window; the connection wizard has a separate right
    Prepare
    a sample file from the supplier — even for e-mail and FTP

    Inside the window, rights are split further: upload settings, the price list file, column addresses, uploaded products, upload rules, markup, stock, parser settings, and the product side panel each have their own. So you can show a manager the uploaded products without letting them into the source settings.

    On the left of the window is the list of suppliers and their sources; on the right is the card of the selected source. To find a source in a long list, see panel search and filters.

    If there are no sources yet, the window shows “No supplier sources yet”, three steps, and a “Connect source” button:

    1. Connect a supplier source — a file, link, e-mail, FTP, API, or website .
    2. Map the file's columns to system fields, and its categories to your catalog.
    3. Run the import — the supplier's products will appear in the catalog.
    Left menu with the Directories section and the Processing price lists group expanded
    1List of price lists
    1. List of price lists — opens the window where all supplier sources are managed.

    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