↑↓ selectEnter openEsc close

    1. Elbuz

    How to keep supplier price list errors off your website

    18 min readUpdated

    Elbuz checks each supplier price list on import and catalog update, keeping errors off your website: a truncated file, prices in another currency, a sharp price jump.

    When you need this:

    • Dollar prices in a hryvnia price list: a price many times below other suppliers stays out of the catalog.
    • The file came truncated or empty: the import is canceled, yesterday's data stays.
    • Some prices changed many times over: the source log lists them as “old → new”.
    • No time to read logs: problems of all sources are in one “Needs attention” list.

    Where to start: set the rules once for all suppliers in the “Import stop rules” window.

    What the protection does

    The protection sits at two points on a price's way from the supplier's file to your website.

    A file that passed the stop rules is not on the website yet: before the catalog, the price is checked again, this time against the product's other suppliers.
    yesnoyesnoSupplier fileStop rules compare the new filewith the source's current price listDid a rule with the “Block” actionfire?Import canceledthe price list keeps the previous dataNew data in the price listwarnings in the source logBase catalog update across all pricelists:product prices are compared withthe median of all suppliersPrice below the median by morethan the thresholdand at least two offers?Price rejectedthe next supplier provides the pricePrice takes part in selectionCatalog and website
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    What each stop rule checks

    A rule fires when the value exceeds the threshold. Almost all rules compare the new file with the price list data from before this import: the . Thresholds are in percent, except “Almost empty feed” (rows) and “Price-list currency change” (none).

    Stop rules and default values
    Rule in the interfaceWhat it comparesDefault“Block”Typical cause
    “Sharp drop in item count”By what percentage the file has fewer rows than the price list now50%, “Warn”yesfile truncated, wrong Excel sheet
    “Sharp rise in item count”By what percentage there are more rows than now200%, “Warn”yesextra sheets or duplicates in the file
    “Almost empty feed (threshold — rows)”Number of rows in the file; fires when there are fewer than the threshold10 rows, “Warn”yesan error page arrived instead of the price list
    “Mass price zeroing”Share of rows with a zero price in the file90%, “Warn”yesthe price column shifted
    “Sharp average price jump”The file's average price against the price list's average price, both ways300%, “Warn”yesthe whole price list in another currency
    “Product price deviation from catalog”The row price against the product price in your catalog; only if the price list is higher30%, offnoprice increase, wrong currency or markup
    “Abnormal product price (vs. previous load)”Each product's price against its price in the previous import, both ways40%, offnosome prices in another currency, a lost zero
    “Price-list currency change”The most frequent currency of the file rows against the price list currency nowno threshold, “Warn”yesthe price column currency changed
    “Loss of key fields (SKU/name)”Share of rows where both the SKU and the name are empty50%, “Warn”yesthe SKU and name columns shifted
    “Mass duplicate items”Share of rows that repeat a product already in the file30%, “Warn”yesdoubled rows, one SKU for several colors
    “Mass stock loss”How much the share of in-stock items fell against the price list now90%, “Warn”yesthe stock column shifted

    Four rules behave in a less obvious way:

    • “Sharp average price jump” with a threshold of 100 or more catches only increases: the average can drop by 100% at most. A threshold of 50 fires when the average falls by more than half or rises by more than 1.5 times.
    • “Mass price zeroing” does not apply to a source whose previous data had no non-zero price at all: this is how price lists with only recommended prices work.
    • “Mass stock loss” measures the drop against last time, not the share itself. An in-stock item has a quantity above zero or a status like “In stock” (details).
    • “Almost empty feed” with zero rows shows “Empty feed: no rows loaded”.

    One more check works without a row in the table: “Price columns have moved — check the column addresses”. It always only warns and offers the “Apply new addresses” button. Details: Why the import is blocked or the price list arrived empty.

    What happens when a rule fires

    The result depends on the action selected in the “Action” column.

    Stop rule actions
    ActionWhat happens to the dataWhat the source log shows
    “Off”The rule is not checked; the threshold is keptnothing
    “Warn”New data goes into the price list as is“Done” status, a yellow banner “Price list imported, but anomalies detected” with the value and threshold: “Mass price zeroing — 95% (threshold 90%)”
    “Block”The import is canceled; the price list has the data of the previous successful import“Blocked” status, a red banner “Import blocked by a stop-rule” and the line “Rejected file: N rows, of which without price: M. Previous data kept in the database.”

    The import is blocked if at least one triggered rule has the “Block” action. The other rules of the same run count as warnings. A changed rule applies from the next import: data already imported is not rechecked.

    Blocking keeps yesterday's stock along with the prices. If the supplier really dropped half its range, you will keep selling discontinued items until you sort it out. The same file will be blocked again next time, so resolve a block the same day.

    A source's first import is never blocked: “Block” works there as “Warn”. On the first import, rules that need past data stay silent: item count, average price, currency, stock, abnormal product price, moved columns. Rules that assess the file itself and “Product price deviation from catalog” do fire.

    The red end of the chart is the only one where the new file does not reach the price list. A source's first import never gets there: “Block” works as a warning.
    noyesyesnonoyesNew file readStop rules compare it with thesource's current price listDid at least one rule fire?Data moved to the price listSource's first import?Data moved to the price list“Block” works as “Warn”Does a triggered rule have the“Block” action?Data moved to the price listYellow banner “Price list imported,but anomalies detected”yellow dot in the listTransfer canceledthe price list keeps the previous data“Blocked” statusred banner and red dot
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    How to set rules for all suppliers and exceptions

    The closest setting wins. For each rule, Elbuz takes the factory value, then the global value from the “Import stop rules” window on top of it, then the source's own rule on top of that, if one was saved.

    Two save buttons
    ButtonWhat it does
    “Save rules” in the source sectionSaves the whole table, all 11 rows, to the source. From then on the source ignores changes to the global rules
    “Apply to all sources” in the section, or “Save rules” in the global windowMakes the table global and erases the own rules of all sources

    A global save can't be undone. Elbuz asks: “These rules will become global for all sources. Per-source stop-rule overrides will be reset. Continue?” After you confirm, you will have to set up the exceptions again.

    Setup order:

    1. Open the global window, set thresholds and actions, click “Save rules” and confirm. All sources get the rules, including new ones.
    2. For sources whose file legitimately fluctuates, open the “Log” tab, change the rows and click “Save rules”.
    3. Make the next change to the global rules knowing that the exceptions from step 2 will be reset.
    Per-source stop-rules fold on the Log tab
    1Hint
    2Sharp average price jump
    3Save rules
    4Apply to all sources
    1. The hint explains Warn and Block and that these settings override the global ones.
    2. Sharp average price jump row with its threshold and action.
    3. Save rules stores the rules for this source only.
    4. Apply to all sources copies these rules to every source.

    How to keep a wrong price off your website

    Price errors come at three scales, and each has its own protection.

    The whole price list is in another currency or from the wrong column

    Set “Block” for three rules: “Sharp average price jump” with a threshold below 100, “Price-list currency change” and “Mass price zeroing”. A mass error then reaches neither the price list nor the catalog. A single price among thousands of rows barely moves the average, so the next two levels handle it.

    One product's price changed many times over

    “Abnormal product price” compares each product's price in the file with its price in this source's previous import. It takes the file price before markup and exchange rate, so changing your pricing rules doesn't trigger it. It fires on a change either way above the threshold, 40% by default.

    The rule only warns: new prices go into the price list. The yellow log banner shows the product count, “New prices were loaded, please check them” and up to ten “name: old → new” examples, like “Laptop 15.6": 24999 → 612”. “Needs attention” shows the first three. Off by default; silent in a blocked run.

    The price is much lower than at other suppliers

    The abnormally low price filter is the only protection that keeps a wrong price off your website on its own.

    During the base catalog update, the product price is compared with the median of its offers from enabled suppliers. If it is below the median by more than the threshold, it is left out of price selection and the next supplier provides the price.

    • The field is “Ignore abnormally low supplier price, %”, from 0 to 99; 0 turns the filter off and is the default.
    • It works only in the update across all price lists; products with a single offer are not checked.
    • Set 50. A threshold of 20 will reject honest low prices, while currency or zero errors create gaps of several times.
    • With two offers and a threshold of 50, the lower price is rejected only if it is less than a third of the higher one.

    Details: Updating base catalog.

    The price list became more expensive than your catalog

    “Product price deviation from catalog” flags rows where the price list price is noticeably above the catalog price: the catalog price is lower by more than the threshold percentage of the price list price. With a threshold of 30, a row priced 1000 is flagged when the catalog has less than 700. Products with a fixed price are skipped.

    The rule doesn't catch price drops: the check runs when the price list price may still be without markup and exchange rate. Drops are caught by “Abnormal product price”. The number of flagged rows goes to the “Suspicious” tile of the log, triggers go to the yellow banner and “Needs attention”.

    A product only one supplier has

    A wrong price for such a product reaches your website unless the error is a mass one. The filter needs at least two offers, and “Abnormal product price” only warns. No mode keeps the product's old price while importing the rest: a 40% change can be an error or a real price increase. For such products, check “Needs attention” daily.

    Recommended set for dozens of suppliers

    Set these values in the global “Import stop rules” window. If a rule blocks a particular supplier's honest files, loosen it for that source only.

    Starter set of stop rules
    RuleThresholdActionWhy
    “Sharp drop in item count”50Blocka truncated file won't wipe out stock
    “Sharp rise in item count”200Warnnew products aren't held back
    “Almost empty feed (threshold — rows)”10Blockan error page won't empty the source
    “Mass price zeroing”90Blocka shifted price column won't produce zeros
    “Sharp average price jump”50Blocka price list in another currency won't pass either way
    “Product price deviation from catalog”30Warn or Offshows sharp price increases, if you are ready to review them
    “Abnormal product price (vs. previous load)”40Warnindividual wrong prices with examples
    “Price-list currency change”—Blockprices won't be converted at the wrong rate
    “Loss of key fields (SKU/name)”50Blockproducts without SKUs won't break matching
    “Mass duplicate items”30Warnduplicates are visible, they don't break prices
    “Mass stock loss”90Warnthe supplier may really have sold out

    Also enter 50 in the “Ignore abnormally low supplier price, %” field of the “Updating base catalog” window and schedule the update across all price lists.

    “Sharp average price jump” is left at 300% in the belief that currency is under control. With this threshold the rule notices a price list that became five times more expensive but misses one that became forty times cheaper, which is exactly what dollars instead of hryvnias look like.

    Where to see that a rule fired

    Where to look for triggered rules
    PlaceWhat's there
    The source's “Log” taba red or yellow banner with rule names, the run status, a chart of stop rule frequency (Price list log)
    Source listred dot: the run was blocked, yellow dot: there are warnings; in the “Overview” grid, the “Anomalies” badge
    “Overview” in “All sources” mode, “Needs attention” blockproblems of all enabled sources: “Source”, “What happened”, “What to do”; five rows and “Show N more”; a click opens the source
    The “✦ AI” button of the same blocka review of the whole list: the cause and the fix for each row; available when the block has errors or warnings
    The “My Day” widget on the desktop“Price lists with import problems” for 7 days and “Abnormally low supplier prices ignored”
    Base catalog update log“Abnormally low supplier prices ignored: N…” with a list of price lists

    For a block during a manual import, Elbuz also shows the “Import blocked by a stop-rule” window and writes to the Operations center.

    Log tab of the Ceres source: red banner “Import blocked by a stop-rule” above the supplier health card and the row of tiles
    1Import blocked by a stop-rule
    2Triggered rule with fact and threshold
    3Rejected file
    1. The banner title says the import was stopped by a stop-rule.
    2. The rule line shows the actual value (353.2%) next to the threshold (300%).
    3. The rejected file line shows how many rows were rejected and that the previous data stays in the database.
    Needs attention block on the Overview tab
    1Needs attention header
    2What happened
    3What to do
    1. Block header with the explanatory hint icon.
    2. What happened — the problem found in the last load.
    3. What to do — the recommended action for this source.

    Scenarios

    The supplier sent some prices in another currency

    What happens. If only a small share of rows arrived in dollars, the average barely moves and the file is imported. Then the product-level protection takes over:

    • “Abnormal product price” shows these products with “old → new” examples;
    • products with several offers won't reach the website with the dollar price if the filter is on;
    • products from a single supplier reach the website with the error: fix the price with the supplier and re-import the price list.

    If the whole price list is in dollars, “Sharp average price jump” with a threshold below 100 and the “Block” action keeps the file out of the price list.

    The supplier inserted a column and everything shifted

    What happens. “Price columns have moved” fires, often along with “Mass price zeroing” or “Loss of key fields (SKU/name)”; with the “Block” action, the price list stays as it was yesterday. What to do: click “Apply new addresses” in the log banner, or fix the column addresses on the “Settings” tab, then run the import again.

    The file arrived truncated

    What happens. 300 rows instead of 20,000. “Sharp drop in item count” with the “Block” action cancels the import, and 19,700 products keep their prices and stock. What to do: ask the supplier to resend the file; the full file will pass the check on its own.

    The supplier honestly raised prices by 40%

    An honest price increase is even: most products go up by a similar percentage, and the examples look plausible, 1000 → 1400 rather than 1000 → 24.

    What reacts to a 40% price increase
    ProtectionReaction
    “Abnormal product price”, threshold 40warns about products that went up by more than 40%; the prices are already in the price list
    “Sharp average price jump”, threshold 50stays silent: the average rose by 40%
    Abnormally low price filterdoesn't react to price increases

    If the increase was blocked: make sure the change is real, raise the threshold or set “Warn” for this source on the “Log” tab, click “Save rules” and run the import. Then restore the values: the new price is already the baseline.

    What to do when a stop rule fires

    The “What to do” column of the “Needs attention” block gives a hint for each rule. The table below builds on these hints and links to sections of this article.

    What to do after a rule fires
    What you seeWhyWhat to do
    “Import blocked by a stop-rule” A rule with the “Block” action rejected the file; the price list has the previous prices and stock Find the rule in the banner. If the file is broken, ask for a new one; if the change is real, loosen the rule for the source (scenario)
    “Sharp drop in item count” The file has far fewer rows than the price list Check that the supplier sent the full file, not part of it or another Excel sheet
    “Mass price zeroing” The price column is empty or the wrong one is read Check the price column address: most often the column shifted
    “Sharp average price jump” The file's average price differs greatly from the price list's average Check the price list currency and the price column
    “Price-list currency change” The most frequent currency of the rows changed Check the price column currency in the source settings
    “Abnormal product price (vs. previous load)” with examples Prices of some products changed by more than the threshold Check the listed products in the supplier's price list and turn on the filter (filter)
    “N prices ignored during price selection: they are below the median of other suppliers” The filter rejected these prices; the next supplier provided the price Check these products in the source price list. If honest prices are rejected, raise the threshold (filter)
    “Price columns have moved — check the column addresses” The supplier rearranged the columns Click “Apply new addresses” in the log (scenario)
    The “Suspicious” tile is always zero Only “Product price deviation from catalog” fills the tile, and it is off Turn on the rule with a threshold (about the rule)

    FAQ

    Where do I set ignoring a price that is 20% lower than the average?

    In the “Ignore abnormally low supplier price, %” field of the “Updating base catalog” window. The comparison is with the median of the product's supplier prices. A threshold of 20 will also reject honest low prices, so start with 50 (filter).

    Can I keep a price that differs from the previous one by 20% out of the price list and keep the old one?

    No. “Abnormal product price” with a threshold of 20 shows such products but imports the new prices. The filter keeps a price that is too low off the website, and blocking stops a whole broken file (why).

    Why wasn't a price list in dollars blocked, even though “Sharp average price jump” is on?

    The default threshold is 300%, and the average can drop by 100% at most. Set the threshold to 50 and the action to “Block” (about the rule).

    The import is blocked. What is on the website now?

    The same as before this import: the price list has the previous prices, stock and range. Importing the same file again will be blocked again (rule actions).

    A new source was imported with a yellow banner, although “Block” is set. Why?

    On a source's first import there is nothing to block, and “Block” works as “Warn”. Blocking works from the second import.

    I changed the global rules, but one source behaves the old way. Why?

    The source has its own saved rules, and they override the global ones. Change them on the source's “Log” tab, or save the global rules again, which resets the own rules of all sources (order).

    Will I get a Telegram or email notification when a price list is blocked?

    No. Elbuz reports a block only inside the app: a window during a manual import, an entry in the Operations center, a status in the log and a red dot in the list. Check “Needs attention” or “My Day” every morning.

    The settings also have “Average price control” and “Row count change control”. Are they the same?

    No, these are old checks from the “Import quality control” group. They only write a “Warning! … check triggered” line to the import log and block nothing. “Matched products control” from the same group has no counterpart among the stop rules.

    Where it is and who has access

    Menu
    Account → System settings → “Price lists” → “Import stop rules” → “Configure”
    Rules of one source
    List of price lists → source → “Log” tab → “Import stop-rules” section
    Low-price filter
    List of price lists → menu → “Updating base catalog” → “Price selection”
    Access right
    the “List of price lists” window; for global rules, also “System settings”
    Prepare
    a source with at least one import: until then the tab has no rules section

    The global window has the subtitle “Defaults for every source”. Its table is the same as in the source section: the “Rule”, “Threshold, %” and “Action” columns.

    Import stop-rules window with default values for every source
    1Hint: global rules apply to sources without their own
    2Sharp average price jump threshold
    3Abnormal product price (vs. previous load)
    4Action list
    5Save rules
    1. The hint explains that these rules apply to every source without its own rules.
    2. Sharp average price jump — the threshold is set in this row.
    3. Abnormal product price (vs. previous load) — compares each price with the previous load.
    4. The Action list sets Off, Warn or Block for the rule.
    5. Save rules writes the defaults and resets per-source settings.

    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