Uploading a price list
A section about the file itself.
Where to get it, how to tell the app where the name, price and SKU are, in what order processing operations run and how to read the import log. It also covers multi-sheet Excel workbooks, text replacement rules, regular expressions and a separate stock price list.
Subsections
Connecting and importing a price list
How to connect a supplier source, run a price list import, fix a bad file and set a supplier aside for a while.
Price list column mapping
How to show the app where the name, price and SKU are in a supplier's file: auto-mapping, the wizard, column addresses, fields and file formats.
- How to map price list columns: where the name, price and SKU are
- How Elbuz maps price list columns on its own and when it calls AI
- How to map columns in the wizard and check them before import
- Column address: how to join columns, take the first non-empty one or set fixed text
- Price list fields and column settings: reference
- How to map an XML, BMEcat, DATANORM, JSON or CSV price list
Price list run log
The price list run log: what the supplier sent, why an import was blocked and at which step a run failed.
Supplier demand analysis
Supplier demand analysis: which of their products sell, how to read the metrics, picking products for ads and finding products you don't carry.
Manufacturer and attributes from price lists
How Elbuz detects a product's brand from a price list, moves file columns into specifications and why the manufacturer directory fills up with duplicates.
Articles in this section
- How to find and remove a supplier's wrong price
The “Price gaps” report in Elbuz: find a supplier's wrong price, take it off your website in one click and turn on protection against new errors.
- How to import a price list from several Excel sheets
Your supplier put several price lists in one file: how to pick the sheets you need, set column addresses for each sheet separately and avoid importing a hidden one.
- How to keep supplier price list errors off your website
Price list stop rules in Elbuz: what each of the 11 rules checks, which threshold and action to set, and how to keep a wrong supplier price off your website.
- How to transfer availability from a separate stock file into the main price list
How to connect a supplier's separate availability file as a stock price list and transfer stock, quantities and prices into its main price list: setup, product pairs, three checkboxes.
- How to work with products from supplier price lists
The price list products window in Elbuz: “Unmatched products” and “Price increased” filters, bulk actions on price list rows, XLSX export, the preview panel and the “Needs attention” badge.
- Source analytics: what broke, who lets you down and who sells cheaper
What broke in your price lists and how to fix it, which suppliers let you down and who sells cheaper — all on the price lists “Overview” tab.
- Order of operations during price list import
What each of the fourteen price list processing operations does, why the default order is already right, and when to change it by hand.
- Option products from a price list: how to group variants of one product
How price list rows become variants of one product: the column flag, the six flags on the source card, and why only the shared variant family name reaches the catalog.
- Regular expressions for price lists: how to extract values from text
How to extract a SKU, volume or manufacturer code from free text in a price list: regular expression rules, tested examples, the parentheses trap and the honest limits of the tool.
