Besides prices, Elbuz copies names, descriptions, photos, attributes and categories from price lists to your catalog without wiping your values.
When you need this:
- Supplier names and descriptions — a “Field links” row copies a price list column into a field.
- Some descriptions are hand-written — “Update if value is empty in base catalog” fills only empty ones.
- Empty cells in price lists — “Update if value is not empty in price lists” protects your values.
- Name from one price list, price from the cheapest — use “Force update from this source”.
Where to start: “Updating base catalog” → “Field links” tab → turn on the rows you need.
What field settings can do
- Turn on data groups: product updates, attributes, photos, videos, files.
- Copy price list categories to the catalog without duplicates.
- Set which price list column goes into which field.
- Protect your values from empty price list cells.
- Write a field only on a condition or always from one price list.
- Write fields once to all matched products, outside price selection.
What to copy to the catalog: the “Settings” tab
The window has four tabs: “Settings”, “Field links”, “Formulas” and “Additional”. The first tab answers “what to copy”, the second “from where and to where”, the fourth “which products, and what to do with those that are gone from the price lists”.
The main card on the first tab is called “What to update”, and the hint under it says it plainly: “A sensible set is already selected — running it gives a result without extra setup.” That's true: by default, exactly what you need to update prices and stock is turned on, and nothing that damages data.
The “Price selection” card and the stock status and contact group grids on the same tab decide which offer a product takes its values from — whose offer goes into the product.
Field explanations are hidden behind the “?” icon next to the field name. There's no “Save” button: checkboxes, fields and grid rows are saved right away, and a “Saved” indicator shows at the bottom.
1
Update button2
Tab strip3
Update products4
Delete all photos before updating5
Autosave indicator- Update — starts the real run; do not press it just to look around.
- Four tabs: Settings, Field links, Formulas, Additional.
- Update products — in the Products group, copies price, availability and fields from the price list to the product.
- Delete all photos before updating — in the Photos and media group; a real change, saved instantly.
- Saved — the window has no Save button: every change goes to the database at once.
The “Products” group
| Flag | Default | What it does |
|---|---|---|
| “Update products” | on | The main switch. Copies values from price lists to existing catalog products using field mappings. Clear it, and the run updates nothing |
| “Add new products” | off | Creates catalog products from price list rows that aren't matched to anything |
| “Auto-search descriptions for new products” | off | Queues a background job: search the cascade sites for descriptions and photos for new products without a description, have AI check the result and save it once the probability threshold is reached |
“Add new products” is the only flag the program can clear for you: if the source has the RRP price list flag, this checkbox is cleared and locked. The logic is simple: a recommended price list isn't meant for creating products.
The “Attributes and options” group
Four flags: “Add attributes” (on, works only for newly created products), “Update attributes” (off, this is for existing products), “Delete attributes” (off — irreversible) and “Update options” (off).
The “Photos and media” group
Seven flags, and the order between them isn't obvious.
- “Add photo” — only for new products, and only when “Update photo” is off. Select both, and the second one works while the first silently does nothing.
- “Update photo” — photos for products already in the catalog.
- “Check whether the photo exists (by link)” — on by default. Adds a photo from the price list if the product didn't have that link yet. It adds, it doesn't replace.
- “Check for photo existence (flag)” — adds photos only if the product has no images at all.
- “Delete all photos before updating” — irreversible.
- “Add video” and “Add files”.
How to copy price list categories to the catalog
“Add categories” copies the category structure from the price list to your catalog. “Apply formulas” is on by default and recalculates fields with formulas during the run. The formulas themselves are set in a separate window on the “Formulas” tab; they're shared across the whole catalog and aren't tied to a specific price list. This is a run flag, not the “Apply formulas” button in the price list window: the button recalculates price list rows here and now, the flag turns on recalculation inside the catalog update.
- The step works both in a run for one source and in a run for all price lists, including the nightly one. In a run for all, categories are copied from each active price list in turn; child price lists and RRP price lists don't take part in this step.
- The program remembers created categories by source and by the category name in the price list, so later runs don't create duplicates. Your own category with the same full name also counts as existing.
- Price list products without a category are linked to the found or created category; products that already have a category keep it.
If you rename a category created by a run, the next run finds it by source, doesn't create a new one and doesn't overwrite your name: the program writes a name only to a category that has no name in the main language yet — a newly created one or one left without a name.
- Start or end
- Action or result
- Decision: the path depends on the answer
Deleting such a category also deletes all its subcategories and the catalog products for which it's the main category, with their descriptions, photos and attributes. Products linked to it only as an additional category stay. Price list rows from this category lose both the category and the product match. If “Add categories” stays on and the supplier keeps sending this category, the next run for this source or for all price lists recreates it.
In a clean system, the first click on “Update” copies prices and stock and leaves photos and descriptions alone. “Check whether the photo exists (by link)” works only together with “Add photo” or “Update photo”, and “Apply formulas” only when the “Formulas” tab has at least one formula.
Which price list column goes into which field: “Field links”
The second tab sets which price list column goes into which catalog field. No row means the field isn't updated from the price list, however many times you click “Update”.
The grid fills itself in: each time the window opens, it adds rows for all product fields it doesn't have yet. But it adds them turned off. Exactly five rows are on from the start:
- price;
- recommended price;
- cost price;
- quantity;
- stock status.
Names, descriptions, photos and attributes aren't copied from the price list until you turn their rows on yourself.
1
Active2
Field name from price lists3
Update if value is not empty in price lists4
Clear catalog field before updating- Active — the checked Price row is included in the update.
- Field name from price lists — the price list column that feeds this catalog field.
- Update if value is not empty in price lists — empty cells in the price list do not overwrite the catalog value.
- Clear catalog field before updating — off here, so existing catalog values stay until replaced.
You set a row's source by double-clicking in the “Field name from price lists” column. The hint behind the “?” icon next to the card title says exactly that: “Specify a field from the price list to update values in the base catalog.” The cross on the right clears the source without touching the row's other settings. Some fields get a source filled in automatically, where the price list has a field with the same name, but the row itself stays off until you turn it on.
How to keep an empty cell from wiping your values
Each row has two flags, and their combination decides whether the price list overwrites what's already in the catalog. This is the most important table in the article.
| Row flags | Result |
|---|---|
| Both cleared | The value from the price list is always written, even an empty one. An empty price list cell leaves the catalog field empty too |
| “Update if value is not empty in price lists” (the default) | An empty price list cell changes nothing. A filled one overwrites |
| “Update if value is empty in base catalog” | Written only if the catalog field is empty. A value you filled in stays safe |
| Both | Written only if the catalog field is empty and the price list has a value. An empty cell or zero in the price list leaves an empty catalog field alone, and a value you filled in stays safe too |
These two flags don't apply to every field. On quantity and stock status they don't work at all: the price list value is always written there, empty or not. On price, recommended price, cost price and old price the flags work as on other fields, but fixed price overrides them: a product with a fixed price keeps its prices whatever the flags. Category and manufacturer have their own rule, no flags needed: a zero from the price list doesn't wipe them.
The most common data loss is a cleared “Update if value is not empty in price lists” flag on a name or description: an empty price list cell wipes the value, and the previous one isn't saved anywhere. Before the first run, check that it's set on every text row you turn on.
What the program does on top of your rules
- Prices of products with a fixed price aren't touched: not by a regular update, the “Force update from this source” column, clearing fields or copying the price from stock, even if the price comes from a non-standard price list column. The flag clears itself on the first run with “Update products” after the date set in the bulk price change dialog of the product list.
- Zero doesn't wipe category and manufacturer. If the price list gives zero in these fields, the catalog keeps what it had.
- Text fields are written to the source's language version. Name, descriptions, meta tags, page title, tags and additional fields go into the language version of the price list's language, and if it matches the system language, into the main one too.
- The program fills service fields itself. Every run forcibly turns off the mapping to the “Supplier name” field: if you turned it on, it'll be off again next time.
How to write a field only on a condition or always from one price list
The last two grid columns are “Boolean condition for base catalog field” and “Boolean condition for the price list field”. They turn a simple “copy” into “copy only if”. You can use both conditions at once; they combine with “and”. This setting is rarely needed.
The “Force update from this source” column is visible only when the window is opened from a specific price list's card. It bypasses the usual selection: the value comes from this source even if another supplier won on price. This happens at the end of the run, after all stock resets; otherwise a deferred reset would overwrite the forced status.
- The column works on every run for all price lists and for this price list with “Update products” selected (the nightly run turns it on itself), only for marked rows, and only when the price list and the supplier are enabled.
- The column respects a fixed price just like a regular update, and a zero from the price list doesn't wipe category and manufacturer.
- A marked “Category ID” row immediately rebuilds the product's category list together with parity categories, including for products without a selected offer, for example “Out of stock”.
To write fields once, without marking rows in the grid, use a one-time update.
Scenarios
Fill empty descriptions from the price list without touching ones written by hand
What to turn on: in “Field links” of the set you need, turn on the description row, set the source field by double-clicking in the “Field name from price lists” column, and select “Update if value is empty in base catalog”.
What you get: the price list value goes only into products where the field is empty or contains zero. If the row also has “Update if value is not empty in price lists” (the default), an empty price list cell leaves such a field alone until the supplier provides a description. Descriptions you filled in stay as they are.
What won't happen: this flag doesn't affect quantity and stock status; the price list always writes there.
Add a new supplier's range together with its categories
What to turn on: open the window with the “Update my catalog” button in this price list's header, select “Add new products” and “Add categories” on the “Settings” tab, and click “Update”.
What you get: price list categories that aren't in the catalog yet are created with names from the price list. Existing ones (created earlier from this source, or yours with the same full name) are found, and there are no duplicates (copying categories).
What won't happen: the nightly run doesn't take product adding from this checkbox but from a system setting. For a price list with the RRP flag, “Add new products” is cleared and locked.
What to do when a field didn't update or became empty
| What you see | Why | What to do |
|---|---|---|
| Prices updated, but names and descriptions didn't | is on only for the five fields the program turns on itself: price, RRP, cost price, quantity, stock status | Turn on the rows you need in “Field links” and set the source field by double-clicking (field links) |
| A product's name or description became empty | The mapping is on, the “Update if value is not empty in price lists” flag is cleared, and the price list cell is empty | Set this flag on all text rows. The previous value can't be restored (empty cell) |
| Stock never changes | The stock status row is off in “Field links”; without it, the stock reset step doesn't run at all | Turn on the stock status mapping, and a separate quantity row for quantity (field links) |
| A “Status: … Error: …” popup appears | A server request failed: editing a grid cell, recalculating content cost or loading the “Formulas” tab | Repeat the action. If it keeps happening, check the error log |
FAQ
Why wasn't a zero from the price list written to my numeric field?
While the row has “Update if value is not empty in price lists” set, zero counts as an empty value and isn't written. Clear this flag for such a field — four flag combinations.
Can I take the name from one price list and the price from the cheapest one?
Yes. In the window opened from the card of the price list you want the name from, mark the name row in the “Force update from this source” column. The price is still picked by the usual selection — forced update.
I selected “Add photo”, but existing products didn't get photos. Why?
“Add photo” works only for new products and only when “Update photo” is cleared. For products already in the catalog, you need “Update photo” — the “Photos and media” group.
I turned on the “Supplier name” mapping, and after the run it's off again. Why?
It's a service field: the program fills it itself and turns this mapping off on every run — what the program does on top of your rules.
Will “Add categories” overwrite my categories?
No. Products that already have a category keep it, and the next run won't rename a category you renamed back — copying categories.
Where to find it and who has access
- From the source card
- “Price lists” → source → “Update my catalog” → the “Settings” and “Field links” tabs
- Access right
- the “Catalog update from price lists” row in group permissions
All entry points and the difference between a single price list's set and the shared set: How to update your catalog from price lists.
Related topics
- For the overall picture of updating — How to update your catalog from supplier price lists.
- If fields are set up and the update should run on its own — How to run a catalog update manually and on schedule.
- To make sure nothing gets wiped before the first run — How to update your catalog without losing data.
- If a field needs to be recalculated with a formula during the update — Base catalog field formulas.
