↑↓ selectEnter openEsc close

    1. Elbuz
    2. Whose price goes to the catalog

    What happens to a product that is missing from supplier price lists

    12 min readUpdated

    When a product drops out of supplier price lists, Elbuz sets it to “Out of stock” with zero quantity. Your settings decide whether it also hides the product, returns it once it's back in a price list, or deletes the card.

    When you need this:

    • A product should leave the storefront and return on its own — two checkboxes in “Product activity” do this on every run.
    • Old cards pile up for years — the deletion field removes cards with stale prices, for good.
    • A category is disabled — its products leave the storefront on the next run.

    Where to start: check the days-before-deletion field on the “Additional” tab.

    What removal from sale does

    A product dropped out of the price list: five mechanisms

    This is the flip side of the same run. There are five mechanisms, they work independently of each other, and only the first one needs no settings. Four of them live in the “Product activity” card on the “Additional” tab; the fifth is in the system settings.

    All five mechanisms together: at any moment a product is in exactly one state, and each arrow names the event that moves it on. The black dot in a ring means the card is deleted for good — there's no way back from there
    dropped out of all price lists—this step always runsback in a price list with aprice“Deactivate if not found”,current days passed,fewer than N suppliersor category disabled“Activate if found”and the product is back in aprice listdays before deletionpasseddays before deletionpassedIn price listsprice and stock are updatedZero stockproduct stays on the storefrontRemoved from the storefrontcard intact, shoppers don't see it
    • Start
    • State
    • End
    Product activity card on the Additional tab of the catalog update window
    1Deactivate products not found in price lists
    2Activate products found in price lists
    3Days until deactivation (0 = off)
    4Days until deletion
    1. Deactivate products in the base catalog when they are not found in price lists.
    2. Activate products again when they reappear in price lists.
    3. Days a product stays current before it is deactivated; 0 means off.
    4. Days a product stays current before it is deleted; the product cards are removed permanently.

    1. Stock reset — always on

    Products that didn't get an offer from any price list get a stock status with the “Out of stock” flag and zero quantity. This isn't removal from sale: the product stays active and visible on the storefront, just with zero stock.

    Two conditions the step won't work without:

    • The status is reset only if the “Stock status” is enabled, and the quantity only if the separate quantity row is enabled. The system enables both rows itself in a new account, but they may have been turned off. This is where the most common question comes from: “stock never changes”.
    • When you run a single source, the reset affects products matched to that price list, plus products that were linked to it, dropped out of it and have no offer in any other enabled price list. A run across all price lists covers the whole catalog.
    • The “Additional” tab filter narrows the reset too. Products that don't fall under the category filter or the condition builder rules keep their stock and stay linked to the supplier. The exception is sets assembled from price list rows: their stock is reset and recalculated across the whole catalog, whatever the filter and source.

    The step deliberately runs after prices are updated, not before: stock used to be reset at the start of the run, and between the reset and the restore the whole catalog sat with no stock. That in-between state no longer exists.

    2. “Deactivate products in the base catalog if the product is not found in price lists”

    A checkbox in the “Product activity” card, cleared by default. It does what the stock reset doesn't: for everything that isn't in any enabled price list.

    Such a product also gets a stock status with the “Out of stock” flag and zero quantity.

    It leaves three groups of products alone: those with the “Do not update” checkbox, products of service types, and sets themselves — both those assembled from catalog products and those made of price list rows. Products that are part of a set aren't protected by this step.

    This step is limited neither by the category filter nor by the selected source. Run an update for one price list, and you'll remove products from the storefront across the whole catalog — including those that come from other suppliers if their sources are currently disabled.

    What else removes a product from sale

    3. “Days a product stays current; after that it is deactivated”

    A field in the same card. A number above zero means that products whose last price update date is older than that many days are removed from the storefront. The product stays in the catalog — you can find it, open it and turn it back on by hand.

    Besides the days, the selection has four more conditions: a regular product type, “Do not update” cleared, “Fixed Price” cleared, and no link to a price list row. Products that never had a price update date set aren't touched either.

    4. “Fewer than N suppliers”

    This isn't a window checkbox but a system setting: “When updating the BC, set the stock status “Out of stock” if fewer than N suppliers have the product in stock in price lists”. It works only when three conditions are met at once: the setting is on, N is above zero, and the run covers all price lists.

    The system counts how many suppliers have the product in stock, and if there are fewer than N, it sets a stock status with the “Out of stock” flag and zero quantity. The product isn't removed from the storefront.

    Only rows that meet all of these count:

    • with the “In stock” status;
    • from enabled price lists without the RRP flag;
    • with stock no lower than the setting's second number — the minimum stock, 0 by default.

    A product with no such rows at all isn't touched by the step: neither one with no offers whatsoever nor one whose offers are all, say, “Pre-order”.

    5. A disabled category removes products with no setting at all

    This mechanism has neither a checkbox nor a field. Every run unconditionally removes from sale all products whose catalog category is disabled — except products with the “Do not update” flag. If you disabled a category “for later”, its products will quietly leave the storefront on the next update.

    The reverse action

    The “Product activity” card has a counterpart checkbox — “Activate products in the base catalog if the product is found in price lists”. It brings back to the storefront products that are in at least one enabled price list, except those whose category is deactivated in the price list.

    This checkbox doesn't restore stock: the regular update will do that as soon as the product arrives in a price list with a price again.

    Deletion by current days

    The “Days a product stays current; after that it is deleted” field sits next to the deactivation field in the “Product activity” card and looks just as harmless. The one difference is total: deactivation hides a product, deletion destroys its card.

    A number above zero in this field means that on the very next run, cards of products that didn't get a price within that period will be deleted from the database. With no confirmation and no preview. There's no rollback: deleted cards aren't kept anywhere.

    Nothing brings back: the product card itself, its page URL, your manual edits — name, description, SEO fields, photos you uploaded — and its links to documents and statistics.

    A repeat price list run won't bring the card back — here's why.

    The field is stored in the settings set of the window where you filled it in, but deletion runs across the whole catalog: a number entered in the window opened from one supplier's card will affect products of all the others.

    Zero in the field means “off”

    Only a number above zero turns the mechanism on. Zero and an empty field mean the same “never”. The catch is that you'll almost always see “0”: the system saves an empty field as zero, and the ∞ hint appears only when the field is truly empty. So the setting looks filled in even though it's off.

    One means a product that gets no price within a day is deleted.

    If a number is set, there's a way to check the consequences. The step writes two lines to the run log: “Removing products from the base catalog that are not in the price lists” before it runs, and the same text with the number of deleted cards after. Zero in the second line means no product met the conditions.

    The “Stop” button checks the stop signal between stages, and the last such check comes before the stock, deactivation and deletion block. Click it before that block and the run stops without reaching deletion; click it after and the block runs to the end, because each of its steps is one large query that nothing can interrupt.

    Which date the days count from

    From the product's “Date updated (price)” field. The system resets it to the current moment every time the product gets an offer from a price list — and only if the product doesn't have “Fixed Price”.

    By age, a product with a fixed price always grows older: its date doesn't move. But both day-based steps spare it — deactivation and deletion select only products with the “Fixed Price” checkbox cleared.

    The trap is elsewhere. When you clear “Fixed Price”, you remove this protection along with it, while the update date stays old — the one it had when the price was fixed. So the very next run will count the product as expired. It gets a new date only when it arrives in a price list with a price again.

    The “Do not update” checkbox in the product card, “Import protection” group, shields a product from everything at once — deletion, deactivation and value transfer.

    Apart from age, the selection has the same conditions as deactivation by days.

    What disappears and what stays in the database

    One row is deleted — the product card itself. The system doesn't clean up related records: descriptions, photos, attributes, category links and document lines stay in the database, but no longer point to anything, and neither they nor the product are visible in the interface.

    Why a repeat run doesn't bring back a deleted product

    The fix looks simple: the supplier has the product again, so run the price list and it'll come back. It won't, and here's why.

    1. The price list row still points to the deleted product ID. The system creates new products only from rows that aren't matched to anything, and this one is matched — to something that no longer exists.
    2. Until matching is rebuilt, the item simply isn't in the catalog. You can rebuild it with the “Match product” action: it clears the links across the whole price list and matches them again.
    3. Even then, it's not the same product that comes back. The “Add new products” checkbox creates a new card with a new ID: its own page URL, its own photos, its own attributes. Your edits, descriptions, SEO fields and document references to the old ID won't be restored.

    What is permanent and what comes back

    Three tables instead of one, because the difference between them is the difference between “wait for the next run” and “rebuild the cards from scratch”.

    Nothing brings back
    WhatCaused by
    Product cardA number above zero in the “Days a product stays current; after that it is deleted” field
    Manual edits to the deleted product: name, description, SEO fields, photos you uploaded, page URLThe same deletion. Matching again creates a new card with a new ID
    The deleted product's links: document lines, statistics, external links to its URLThe same deletion. The records stay in the database but no longer point to anything
    Comes back on its own with the next run
    WhatWhen
    Stock and quantity reset to a status with the “Out of stock” flagAs soon as the product arrives in a price list with a price again
    Price, if the product moved to another supplierWith the next run on current price lists
    A status with the “Out of stock” flag set by the “fewer than N suppliers” ruleAs soon as enough suppliers have the product in stock
    Comes back, but by hand
    WhatHow to bring it back
    Removal from the storefront by the “Deactivate products… if the product is not found in price lists” checkboxTurn on the counterpart checkbox “Activate products… if the product is found in price lists” and run again — this works only if the product is back in an enabled price list. Otherwise, set the status by hand
    Removal from the storefront by current daysOnly by hand: in the product card or with a bulk edit in the grid. This mechanism has no reverse step
    Removal of a disabled category's products from the storefrontEnable the category, then set the products' status by hand — it won't come back on its own

    What protects products

    Import protection section in the product card
    1Do not update
    2Fixed Price
    1. Do not update — the only switch that protects the product from everything, including deletion by days.
    2. Fixed Price — protects the price and both day-based steps: deactivation and deletion.
    Protection from the steps in this section
    ProtectionWhat it covers
    “Do not update” — a checkbox in the product card, “Import protection” groupEverything: value transfer, stock reset, both deactivations and deletion by days
    “Fixed Price”Price, RRP, cost price, old price and the supplier link; both day-based steps — deactivation and deletion. It doesn't cover the “not found in price lists” deactivation or the removal of a disabled category's products
    The product is itself a set — assembled from catalog products or from price list rowsThe “not found in price lists” deactivation
    An enabled source from another supplierThe “not found in price lists” deactivation: the product counts as found

    The protection people expect most doesn't exist: neither the category filter, nor the condition builder rules on the “Additional” tab, nor the choice of a specific source narrow removal from sale and deletion. These steps cover the whole catalog. The filter narrows only the stock reset, and not for sets.

    What to check before the first run

    Before the first run

    Scenarios

    A product that isn't in any price list should leave the storefront and come back on its own — without deleting cards

    What to turn on. On the “Additional” tab, in the “Product activity” card, select both checkboxes: “Deactivate products in the base catalog if the product is not found in price lists” and “Activate products in the base catalog if the product is found in price lists”. Leave both days fields at 0.

    What you get. A product with no row in any enabled price list leaves the storefront and gets a stock status with the “Out of stock” flag and zero quantity. Once it reappears in an enabled price list, the second checkbox returns it to the storefront on the next run, and the regular update sets its price and stock.

    What won't happen. Cards aren't deleted: only a number above zero in the days field turns that on. Products with “Do not update”, service-type products and sets are skipped. The step can't be narrowed to one supplier or category: it covers the whole catalog, so other suppliers' sources must be enabled. “Activate…” won't return a product from a disabled category.

    Cards that suppliers haven't delivered for six months should be deleted automatically

    What to turn on. First, set “Do not update” on the products you need to keep no matter what. Then, on the “Additional” tab, in the “Product activity” card, enter a period of six months to a year — 180 to 365 — in the “Days a product stays current; after that it is deleted” field.

    What you get. On every run, cards whose “Date updated (price)” is older than that period are deleted from the database. The run log shows the line “Removing products from the base catalog that are not in the price lists” with the number of deleted cards.

    What won't happen. Products with “Fixed Price” or “Do not update”, products linked to a price list row and those that never had a price update date set aren't deleted. Deleted products don't come back — what you lose.

    What to do when a product disappeared or didn't come back

    Common problems
    What you seeWhyWhat to do
    Stock never changes The stock status row is disabled in “Field links” — without it, the stock reset doesn't run at all Enable the stock status mapping, and for quantity, the separate quantity row (stock reset)
    Products disappeared from the storefront, even though you updated one price list The “Deactivate products… if the product is not found in price lists” checkbox is limited neither by the filter nor by the selected source Clear the checkbox or enable the other suppliers' sources (“not found” deactivation)
    Products disappeared from the storefront, but nothing is turned on on the “Additional” tab Every run unconditionally removes products of disabled categories from sale Enable the category and restore the products' status by hand (disabled category)
    “Removing products from the base catalog that are not in the price lists” The “Days a product stays current; after that it is deleted” field has a number above zero. The next log line is the same text with the number of deleted cards Set the field to zero so the next run deletes nothing. Deleted products can't be restored (deletion by days)
    The “Days a product stays current…” field shows “0”, and it's unclear whether deletion is on Zero means “never” — just like an empty field; the ∞ hint appears only in an empty field Nothing. Only a number above zero turns the mechanism on (zero in the field)
    The products that disappeared from the storefront are exactly those with “Fixed Price” The checkbox covers the price and both current-days steps, but not the “not found in price lists” deactivation: such products most often have no row in any price list, so this step picks them first Clear the “Deactivate products… if the product is not found in price lists” checkbox or set “Do not update” on the products you need (“not found” deactivation)
    The product is back in the price list, but it's not in the catalog The card was deleted, and the price list row still points to the deleted ID — the system treats it as matched Rebuild matching with the “Match product” action, then turn on “Add new products”. A new card appears, not the old one (repeat run)

    FAQ

    Can I find out exactly which cards were deleted?

    No. The step writes only its name and the number of deleted cards to the run log; there's no list of IDs or SKUs anywhere (step log).

    The product is back on the storefront, but it has no stock — why?

    The “Activate products…” checkbox brings back only visibility. The regular update will set the stock as soon as the product arrives in a price list with a price again (reverse action).

    Can I protect a single product from removal from sale?

    Yes: the “Do not update” checkbox in the product card, “Import protection” group, shields it from all the steps in this article (what protects products).

    Can I stop a run before deletion starts?

    Yes, if you click “Stop” before the stock, deactivation and deletion block. Once the block has started, it runs to the end (the “Stop” button).

    Can I limit deletion to one supplier?

    No. Neither the selected source nor the category filter narrows removal from sale and deletion: they run across the whole catalog (what protects products).

    Where to find it and who has access

    Menu
    Directories → Processing price lists → List of price lists → menu → “Updating base catalog”
    Other entry points
    source header → “Update my catalog”
    Access right
    the “Catalog update from price lists” row in “Group permissions”
    Prepare
    enabled “Stock status” and “Quantity” rows in “Field links”

    The “Product activity” card is on the “Additional” tab. All the ways into the window are in the article on price selection.

    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