↑↓ selectEnter openEsc close

    1. Elbuz

    How to build a consolidated price list with supplier prices

    4 min readUpdated

    Elbuz adds supplier prices next to yours in a price list for customers and dealers: a row per price list item or a column per supplier. You see where a product is cheaper.

    When you need this:

    • Compare your price with suppliers' — one column per supplier, prices color-coded.
    • Only the cheapest offer — each “supplier + product” pair keeps the row with the lowest cost price.
    • Build from supplier items, not the catalog — the “Export only products from price lists” checkbox.
    • A category tree for the customer — grouped by category, collapses in Excel.

    Where to start: template card → “Settings” tab → “What to export” card.

    What a consolidated price list can do

    Which rows end up in the file

    By default, one row is one base catalog product, and rows are sorted by category, then manufacturer, then name. To set your own order, use the “Product sorting” column in the field grid; macro fields are ignored in sorting.

    The file language is set by the “Language ID” field in the “Export limits” card on the same “Settings” tab. An empty field means the catalog's default language, not the one you're using the app in — and categories must have a name in that language, otherwise their products drop out of the file.

    This field is rarely filled in, so the file usually goes out in “whatever the default language is” — check it before the first send.

    Everything else depends on four checkboxes in the “What to export” card on the “Settings” tab.

    Settings tab of the price list template: the “What to export” card with seven checkboxes and the “Delimiters and links” card
    1Create rows per contact
    2Export only products from price lists
    3Export links (enabled)
    4Supplier field for column headings
    1. Create rows per contact — one row per supplier offer instead of one row per product.
    2. Export only products from price lists — skips catalog products that have no supplier offer.
    3. Export links — adds product links to the file; it is enabled here.
    4. Supplier field for column headings — the contact field whose value becomes the column heading.
    CheckboxWhat changes in the file
    “Create rows per contact”the product repeats as a row for each price list item linked to it. The result is a
    “Export from price lists only the products whose price was used for the base catalog product”of all price list items, only the one that supplies the product's price is used
    “Export the minimum price for identical products per supplier”for each “supplier + product” pair, only the row with the lowest cost price is kept
    “Export only products from price lists”rows come from supplier price lists instead of the catalog

    The last checkbox is stricter than it looks. When “Export only products from price lists” is on, all base catalog columns silently drop out of the file, together with their headings. So a template built from catalog fields will send your customer a file with a different set of columns after a single checkbox.

    Because of this, the “What will be exported” dialog that opens before a run from the list does not show the number of file rows for a price list: it counts base catalog products.

    With “Create rows per contact”, there will be more rows; in “only products from price lists” mode, they come from a different table entirely; and the filter on price list rows is not included in the count. The run log shows how many rows actually went out.

    Price list as a category tree

    A separate mode is the “Export category rows with products below + grouping” checkbox in the “Display mode” card. The file is a tree instead of a flat table: a row with the category name, its products below it, and all of it collapses in Excel.

    The checkbox opens a formatting block — fonts, colors, borders, your own template file. The mode works but is rarely used, so check the result on a few categories before you send such a file to a customer.

    How to filter price list rows by a condition

    On the “Export limit (filter)” tab, a price list has a second inner tab — “Products from price lists”. It is a condition builder for the fields of the price list row grid: below it, the app restates the condition in plain words, with the “Clear all” and “Save” buttons next to it.

    There are fewer operators here than on the neighboring tab for catalog products. Text has only four conditions — “equals”, “not equal to”, “empty string”, “non-empty string”. There is no “contains” and no separate “Date” type: dates are handled as text. So “price list row name contains …” can't be set here.

    Export limit tab, “Products from price lists” sub-tab with a filled name condition and its plain-language summary
    1Products from price lists tab
    2Condition operator list
    3Plain-language summary of the condition
    1. Products from price lists — the second inner tab, next to Base Catalog Items.
    2. Operator list — chooses how the field is compared with the value.
    3. Summary — the condition restated in plain words below the builder.

    This tab has a second job that's easy to miss: a condition on the contact narrows the list of suppliers for matrix columns — more on them in the next section.

    How to show a column for each supplier

    The “Show values per supplier” checkbox in a column row turns one column into a column for each supplier. Its heading is two lines in one cell: the contact's name on top, the field name below. The top-line field is set by “Supplier field for column headings” (name by default).

    The matrix includes active contacts from the “Supplier” and “Competitor” groups that have an active price list source. If the “Products from price lists” tab has a condition on the contact, the list narrows to that contact.

    When “Export links” is on, each supplier's price in the matrix becomes a hyperlink to the product page on that supplier's site. Outside the matrix, the same checkbox turns any column whose system name contains url into a hyperlink — for example, “Product link”. It is on by default in a new template.

    Count your columns in advance: ten suppliers and three price fields make thirty columns plus your own.

    Price colors

    In , two price list columns are colored — “Price from the price list” and “Cost price”: lower than yours is red, higher green, equal black. The reference is the base catalog “Price” column; without it, no colors. The plain “Price” from the price list isn't colored. has no colors: the format doesn't support them.

    The comparison doesn't convert currencies. “Price from the price list” is in the supplier's currency, while your “Price” is in the account currency. So for a supplier with prices in dollars, the whole column turns red whether they are more expensive or cheaper: 92 is always less than 4123.

    You can only trust the color in the “Cost price” column — it is already converted to the account currency. The numbers in the file are correct; only the color is misleading.

    Scenarios

    Compare your price with supplier prices

    • What to set up: the “Price” column from the base catalog and the “Cost price” column with the “Show values per supplier” checkbox; XLSX format.
    • What you get: a cost price column for each supplier; lower than your price is red, higher is green. You can trust the color here: cost price is already in the account currency.

    Only the cheapest offer from each supplier

    • What to set up: the “Create rows per contact” and “Export the minimum price for identical products per supplier” checkboxes.
    • What you get: one row with the lowest cost price for each “supplier + product” pair.

    A price list from supplier items only

    • What to set up: the “Export only products from price lists” checkbox and columns from the “Products from price lists” group.
    • What you get: rows come from supplier price lists. Base catalog columns drop out of the file together with their headings.

    What to do when rows or supplier prices are wrong

    Common problems
    What you seeWhyWhat to do
    “Product #123 was not included in the export: it doesn't meet this template's conditions (filter, category, availability, rules).” One of the selection conditions excludes the product Go through the selection conditions in the general article, and also check that the product's category has a name in the export language
    The whole “Price from the price list” column of one supplier is red The supplier gives prices in another currency, and the color compares numbers without conversion Look at the color of the “Cost price” column — it is in the account currency (about colors)
    After one checkbox, catalog columns disappeared from the file “Export only products from price lists” is on: base catalog fields drop out in this mode Clear the checkbox or build the columns from the “Products from price lists” group (about rows)

    FAQ

    Why does the dialog before a run show fewer products than there are rows in the file?

    The dialog counts base catalog products. With rows per supplier there are more rows, and in “only products from price lists” mode they come from a different table. The run log shows how many actually went out.

    Can I filter price list rows by a word in the name?

    No. On the “Products from price lists” tab, text only has “equals”, “not equal to”, “empty string”, and “non-empty string”; there is no “contains” condition.

    Which language goes into the file if the “Language ID” field is empty?

    The catalog's default language, not the language you use the app in. A category without a name in that language takes its products out of the file (about rows).

    Why is a supplier missing from the matrix columns?

    The matrix includes active contacts from the “Supplier” and “Competitor” groups with an active price list source. A condition on the contact on the “Products from price lists” tab narrows the list.

    Can I send a price list as a category tree in CSV?

    The tree with grouping and formatting is for an Excel workbook. Before you send such a file to a customer, check the result on a few categories (about the tree).

    Where to find it and who has access

    Menu
    Directories → Operations → Data export → pencil in the template row
    Access right
    the “Data export” window
    Prepare
    a “Price list (XLSX, CSV)” template and imported supplier price lists

    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