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.
- Import stop rules compare each new file with what is already in the source price list and catch mass failures: a truncated file, zeroed prices, a different currency.
- The “Block” action cancels the import of a broken file, and the price list keeps the previous data.
- The “Abnormal product price” rule shows individual products whose price changed many times over since the previous import.
- The abnormally low price filter works during the catalog update and keeps off your website a price far lower than at the product's other suppliers.
- Global rules are set once for all sources, with exceptions for individual sources.
- The “Needs attention” list collects triggered rules from all sources with a hint on what to do.
- 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).
| Rule in the interface | What it compares | Default | “Block” | Typical cause |
|---|---|---|---|---|
| “Sharp drop in item count” | By what percentage the file has fewer rows than the price list now | 50%, “Warn” | yes | file truncated, wrong Excel sheet |
| “Sharp rise in item count” | By what percentage there are more rows than now | 200%, “Warn” | yes | extra sheets or duplicates in the file |
| “Almost empty feed (threshold — rows)” | Number of rows in the file; fires when there are fewer than the threshold | 10 rows, “Warn” | yes | an error page arrived instead of the price list |
| “Mass price zeroing” | Share of rows with a zero price in the file | 90%, “Warn” | yes | the price column shifted |
| “Sharp average price jump” | The file's average price against the price list's average price, both ways | 300%, “Warn” | yes | the 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 higher | 30%, off | no | price increase, wrong currency or markup |
| “Abnormal product price (vs. previous load)” | Each product's price against its price in the previous import, both ways | 40%, off | no | some prices in another currency, a lost zero |
| “Price-list currency change” | The most frequent currency of the file rows against the price list currency now | no threshold, “Warn” | yes | the price column currency changed |
| “Loss of key fields (SKU/name)” | Share of rows where both the SKU and the name are empty | 50%, “Warn” | yes | the SKU and name columns shifted |
| “Mass duplicate items” | Share of rows that repeat a product already in the file | 30%, “Warn” | yes | doubled rows, one SKU for several colors |
| “Mass stock loss” | How much the share of in-stock items fell against the price list now | 90%, “Warn” | yes | the 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.
| Action | What happens to the data | What the source log shows |
|---|---|---|
| “Off” | The rule is not checked; the threshold is kept | nothing |
| “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.
- 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.
| Button | What it does |
|---|---|
| “Save rules” in the source section | Saves 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 window | Makes 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:
- Open the global window, set thresholds and actions, click “Save rules” and confirm. All sources get the rules, including new ones.
- For sources whose file legitimately fluctuates, open the “Log” tab, change the rows and click “Save rules”.
- Make the next change to the global rules knowing that the exceptions from step 2 will be reset.
1
Hint2
Sharp average price jump3
Save rules4
Apply to all sources- The hint explains Warn and Block and that these settings override the global ones.
- Sharp average price jump row with its threshold and action.
- Save rules stores the rules for this source only.
- 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.
| Rule | Threshold | Action | Why |
|---|---|---|---|
| “Sharp drop in item count” | 50 | Block | a truncated file won't wipe out stock |
| “Sharp rise in item count” | 200 | Warn | new products aren't held back |
| “Almost empty feed (threshold — rows)” | 10 | Block | an error page won't empty the source |
| “Mass price zeroing” | 90 | Block | a shifted price column won't produce zeros |
| “Sharp average price jump” | 50 | Block | a price list in another currency won't pass either way |
| “Product price deviation from catalog” | 30 | Warn or Off | shows sharp price increases, if you are ready to review them |
| “Abnormal product price (vs. previous load)” | 40 | Warn | individual wrong prices with examples |
| “Price-list currency change” | — | Block | prices won't be converted at the wrong rate |
| “Loss of key fields (SKU/name)” | 50 | Block | products without SKUs won't break matching |
| “Mass duplicate items” | 30 | Warn | duplicates are visible, they don't break prices |
| “Mass stock loss” | 90 | Warn | the 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
| Place | What's there |
|---|---|
| The source's “Log” tab | a red or yellow banner with rule names, the run status, a chart of stop rule frequency (Price list log) |
| Source list | red dot: the run was blocked, yellow dot: there are warnings; in the “Overview” grid, the “Anomalies” badge |
| “Overview” in “All sources” mode, “Needs attention” block | problems 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 block | a 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.
1
Import blocked by a stop-rule2
Triggered rule with fact and threshold3
Rejected file- The banner title says the import was stopped by a stop-rule.
- The rule line shows the actual value (353.2%) next to the threshold (300%).
- The rejected file line shows how many rows were rejected and that the previous data stays in the database.
1
Needs attention header2
What happened3
What to do- Block header with the explanatory hint icon.
- What happened — the problem found in the last load.
- 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.
| Protection | Reaction |
|---|---|
| “Abnormal product price”, threshold 40 | warns about products that went up by more than 40%; the prices are already in the price list |
| “Sharp average price jump”, threshold 50 | stays silent: the average rose by 40% |
| Abnormally low price filter | doesn'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 you see | Why | What 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.
1
Hint: global rules apply to sources without their own2
Sharp average price jump threshold3
Abnormal product price (vs. previous load)4
Action list5
Save rules- The hint explains that these rules apply to every source without its own rules.
- Sharp average price jump — the threshold is set in this row.
- Abnormal product price (vs. previous load) — compares each price with the previous load.
- The Action list sets Off, Warn or Block for the rule.
- Save rules writes the defaults and resets per-source settings.
Related topics
- To understand the numbers and banners of a specific run, see Price list log.
- If you have many suppliers and need to find the problematic ones, see Source analytics.
- If the filter rejects the wrong prices, see Updating base catalog.
- If it's unclear whose price wins among several suppliers, see Supplier price selection.
- If you are deciding whether to hand price lists over to Elbuz, see what it gives your store.
