↑↓ selectEnter openEsc close

    1. Elbuz

    Which fields to copy from a price list to your catalog

    11 min readUpdated

    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

    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.

    The «Updating base catalog» window on the Settings tab with the «What to update» card
    1Update button
    2Tab strip
    3Update products
    4Delete all photos before updating
    5Autosave indicator
    1. Update — starts the real run; do not press it just to look around.
    2. Four tabs: Settings, Field links, Formulas, Additional.
    3. Update products — in the Products group, copies price, availability and fields from the price list to the product.
    4. Delete all photos before updating — in the Photos and media group; a real change, saved instantly.
    5. Saved — the window has no Save button: every change goes to the database at once.

    The “Products” group

    Flags in the “Products” group
    FlagDefaultWhat it does
    “Update products”onThe main switch. Copies values from price lists to existing catalog products using field mappings. Clear it, and the run updates nothing
    “Add new products”offCreates catalog products from price list rows that aren't matched to anything
    “Auto-search descriptions for new products”offQueues 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.

    The top check explains when the step is skipped, the middle one why there are no duplicates. The bottom one shows why the step doesn't move a product to another category.
    noyesyesnonoyesThe run reaches the category stepIs “Add categories” selected?The step is skippedWas the category already createdfrom this sourceor do you have a category with thesame full name?The existing category is used — aname is addedonly if it has none in the mainlanguageA new category is created with thename from the price listIs the price list row already assigneda catalog category?The row is linked to this categoryThe row's category stays as it was
    • 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.

    The «Field links» tab: grid with the enabled Price row
    1Active
    2Field name from price lists
    3Update if value is not empty in price lists
    4Clear catalog field before updating
    1. Active — the checked Price row is included in the update.
    2. Field name from price lists — the price list column that feeds this catalog field.
    3. Update if value is not empty in price lists — empty cells in the price list do not overwrite the catalog value.
    4. 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.

    What happens to the value in the catalog
    Row flagsResult
    Both clearedThe 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
    BothWritten 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

    Common problems
    What you seeWhyWhat 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

    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