↑↓ selectEnter openEsc close

    1. Elbuz

    How to write names and categories from a price list to all matched products

    4 min readUpdated

    Elbuz writes the name, description or category from a price list to all matched products in one go — even when a product is out of stock or another supplier set the price. Prices, quantity and stock status stay unchanged.

    When you need this:

    • The supplier marked a product “Out of stock” — the one-time write still gives it the enabled fields.
    • Another supplier set the price — name and category come from this price list; price, quantity and stock status stay put.
    • You need it once, not every night — the mode runs once without changing window settings.

    Where to start: four steps to run it.

    What the one-time field write does

    How to write fields to all matched products

    The “Update” button writes fields only from the offer in the filtered set: price selection, checked stock statuses and contact groups, “Additional” filters. A product without such an offer gets no price, name or category from the price list. Typical case: the supplier marked a matched product “Out of stock”, so a new name or category never reaches it.

    For this, the window opened from a specific price list's card has a separate item: the arrow next to the “Update” button → “Update fields by matching (no filters)”. It writes the enabled field links of this price list once to every catalog product matched with its rows. The mode itself doesn't change the window settings.

    Header of the «Updating base catalog» window with the Update button, its arrow and the opened menu
    1Arrow next to Update
    2Update fields by matching (no filters)
    1. The narrow arrow next to the Update button opens a menu — do not confuse it with the Update button itself.
    2. The only menu item, «Update fields by matching (no filters)», runs a field-only update without price selection or filters.
    1. Open the window with the “Update my catalog” button in the header of the price list you need. The shared set for all price lists has no arrow next to the button.
    2. On the “Field links” tab, leave on only the rows you need to write now. The mode takes all active rows except price, stock status and quantity. The grid saves immediately, and the regular update of this price list won't write disabled rows either — after the run, turn back on the ones it needs.
    3. Click the arrow next to “Update” and choose “Update fields by matching (no filters)”.
    4. Read the dialog and click “Update fields”. Progress and the result appear in the Operations center.
    Confirmation dialog for updating fields by matching, with the Update fields and Cancel buttons
    1Dialog text
    2Update fields button
    1. The text explains what will be updated: only fields enabled on the «Field links» tab, without price, stock status and quantity.
    2. «Update fields» starts writing to the catalog; «Cancel» closes the dialog without changes.

    How the one-time write differs from the “Update” button

    How the one-time mode differs from the “Update” button
    WhatThe “Update” button“Update fields by matching”
    Which productsThose whose offer passed price selection, stock statuses, contact groups and the “Additional” filtersAll products matched with rows of this price list. Price selection, stock statuses, contact groups, the “Additional” filters, and whether the price list and supplier are enabled are not taken into account
    Which fieldsAll active rows in “Field links”Active rows except price fields (price, RRP, cost price, old price, sale price), quantity and stock status — whichever price list column they come from
    Product link to supplier and price listRebuiltUnchanged
    New products, photos, attributes, field clearing, deactivation, deletion, formulasAccording to the window checkboxesNot performed
    Confirmation before runningNoneA dialog listing what will and won't change
    Result in the log“Products updated: N”“Products changed: N” — only products whose values actually changed

    Row rules work the same as in a regular update: the “Update if value is not empty in price lists” and “Update if value is empty in base catalog” checkboxes, logical conditions, protection of category and manufacturer from zero, writing texts to the price list's language version. Products marked “Do not update” are skipped. If a product is matched with several rows of one price list, the value comes from one of them — the one loaded first.

    Changed products get rebuilt category links (if the category row is on), card scoring, category and manufacturer counters, storefront table and , as after a regular run. All touched matched products get a modification date, even unchanged ones.

    The mode takes all matched products of the price list, not a subset. The “Additional” tab filter doesn't narrow it. An enabled category row overwrites the category of every matched product for which the price list gives a non-zero category. An enabled name row without the “Update if value is not empty in price lists” checkbox wipes names where the price list cell is empty. There is no rollback, so turn off rows you don't need to write before running.

    The mode runs under the same lock as a regular update, so while another run or a scheduled price list import is in progress, it gets the same refusal. It runs as a single step — there's no stop button for it in the Operations center.

    Scenarios

    The supplier has the product “Out of stock”, but a new name or category must reach the catalog

    What to turn on: once — in the window from this price list's card, the arrow next to “Update” → “Update fields by matching (no filters)”, after leaving only the name and category on in “Field links”. Permanently — check these rows in the “Force update from this source” column.

    What you get: the one-time mode writes the enabled rows to all products matched with this price list, regardless of stock status and price selection. The column does the same for checked rows on every run with “Update products”.

    What won't happen: the one-time mode won't change price, quantity or stock status. A zero category in the price list won't wipe your category, and the column won't overwrite the price of a product with a fixed price.

    Update only descriptions, leaving names and categories alone

    What to turn on: in the window from the price list card, leave only the description row active in “Field links”, with the “Update if value is not empty in price lists” checkbox, then the arrow next to “Update” → “Update fields by matching (no filters)”.

    What you get: descriptions from the price list go to all matched products where the price list cell is filled; names and categories stay as they were.

    What won't happen: the regular update of this price list won't write disabled rows either — after the run, turn on the ones it needs.

    What to do when the one-time write changed nothing

    Common problems
    What you seeWhyWhat to do
    The product is matched with the price list, but the name or category from the price list doesn't reach it The product's offer didn't make it into the filtered set: its stock status or contact group isn't checked in the grids, the “Additional” filter cuts it off, or another supplier won on price. Fields are written only from an offer in the filtered set Once — the “Update fields by matching (no filters)” item next to the “Update” button (one-time update); permanently — the “Force update from this source” column
    The one-time update showed “Products changed: 0” The product values already match the price list. Or row rules leave nothing to write: “Update if value is empty in base catalog” is set but the fields are filled; “Update if value is not empty in price lists” is set but the price list cells are empty; a logical condition failed; the price list gives zero for category or manufacturer. Or no product is matched with the price list, or all matched ones are marked “Do not update” Check the row checkboxes in “Field links” and product matching (field links)
    “Nothing to update: no fields other than price, stock status and quantity are enabled on the “Field links” tab.” The one-time mode doesn't write price, stock status or quantity, and the grid has no other active rows, or they have no source field set Turn on the rows you need and set the source field, then run again (one-time update)

    FAQ

    Will the one-time write change price or stock status?

    No. It doesn't write price fields, quantity or stock status, whichever price list column they come from. The product's link to the supplier doesn't change either — how it differs from “Update”.

    Will the “Additional” tab filter limit the one-time write?

    No. The mode takes all products matched with the price list rows. Turn off unneeded “Field links” rows before running — how it differs from “Update”.

    Can I write fields from all price lists at once?

    No. The item exists only in the window opened from a specific price list's card; the shared set has no arrow next to “Update”. Run it for each price list in turn — steps to run it.

    How do I stop the one-time write?

    You can't: the mode runs as a single step, and there's no stop button for it in the Operations center. What's written isn't rolled back — how it differs from “Update”.

    A product is matched with several rows of one price list. Where does the value come from?

    From one of them — the one loaded first. Other rows of this price list aren't used for the product — row rules.

    Where it is and who has access

    From a source card
    “Price lists” → pick a source → “Update my catalog” → the arrow next to “Update”
    Access right
    the “Catalog update from price lists” row in group permissions
    Prepare
    matched products and enabled rows in “Field links”

    How to open the update window — see 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