↑↓ selectEnter openEsc close

    1. Elbuz

    How to find and remove a supplier's wrong price

    9 min readUpdated

    Elbuz compares each product's price across suppliers and flags prices several times off. Remove a wrong price in the same row; protection takes one button.

    When you need this:

    • Supplier wrote 121, not 1,215 — “Do not use this offer” uses the next supplier's price.
    • Stop rules on, error got through — the report shows what's missing.
    • Price list in another currency — “Looks like the whole price list is broken”.
    • Orders came in at the wrong price — listed separately, before shipping.
    • No time to watch the report — new questionable prices trigger a notification.

    Where to start: price lists “Overview” → “Price gaps” → “Turn on full protection”.

    What the “Price gaps” report does

    The report is a section of the “Overview” tab in the price lists window. “Overview” is split into the sections “Needs attention”, “Sources”, “Price gaps”, “Source reliability” and “Matching and profit”; the first and third have counters.

    In “All sources” mode, the report covers every supplier. Select a supplier in the left panel and the report narrows to it, without the orders panel and the trend. At the bottom of the section there is also “Best source per product (price spread)”: who has the product cheapest.

    Top of the Price gaps section: tabs, title, protection button, questionable-orders panel and tiles
    1Price gaps tab
    2Turn on full protection
    3Orders at a questionable price (14 days)
    4Questionable price on site tile
    5Sharp price drop (1 supplier) tile
    1. The Price gaps tab of the Overview, with a counter.
    2. Button that turns on all protections at once.
    3. Panel showing orders placed at a questionable price in the last 14 days.
    4. Tile counting products whose site price looks questionable.
    5. Tile counting single-supplier products whose price dropped sharply.

    How the app finds a questionable price

    The app compares cost price: the purchase price converted to your main currency at the exchange rate, without markup. The website price won't do, because suppliers have different markups. Neither will “Price in price list”: it comes in different currencies. If there is no cost price, “Price” is used. RRP is not part of the comparison.

    • Only products with at least two offers are checked; two price lists from the same contact count too. Enabled sources and contacts are used, and rows with a price above zero.
    • For each product, the app takes the median cost price of all its offers — the price in the middle of the row. Unlike the average, one wrong price barely moves it.
    • A gap is a price that is cheaper than the median by more than the threshold, or that many times more expensive. The threshold is the same as the filter's; while the filter is off, it is 50%, meaning half the price or double.

    “Questionable price on site” means the product is currently sold at exactly this offer's price. Questionable, not wrong: with two offers, it is often the other supplier who made the mistake, and the website shows the correct price.

    Two offers are a special case. The median of two prices is their average, so the report flags only the cheaper one: at a 50% threshold, when it's under a third of the dearer one — even if the dearer one is wrong. Before acting, open the item card and compare both price lists.

    A cause in every row

    The app determines the cause by how many times the price differs from the others. Hover over the label to see a hint on what to check.

    Cause labels
    LabelWhen it appearsWhat to check
    “Other currency · USD”the gap is close to the exchange rate of the currency your price lists come inthe price column currency of this source and of the sources it is compared with
    “Currency not converted · USD”the price list price is in a foreign currency, but no exchange rate was appliedthe “Price + exchange rate” rule on the source's “Pricing” tab
    “Extra or missing zero”the gap is close to 10, 100 or 1,000 timesthe product price in the supplier's file
    “Only 2 offers”there are two offers, and neither currency nor zero fitsboth price lists: it's unclear who is wrong
    “Price or match”everything elsethe price in the file and whether it's the same product: a different model, a bundle, a used item

    How to turn on protection so an error never reaches your website

    Why a wrong price gets through even though stop rules are on

    Stop rules catch mass file failures, not a single price. “Sharp average price jump” looks at the average price of the whole price list, and one product out of five hundred barely moves it. “Abnormal product price” does notice a single product, but only warns: the new price still goes into the price list.

    Only the low-price filter keeps a single wrong price off your website, and it is off by default. Without it, in minimum price mode (price selection) a price lower than everyone else's wins and goes to your website, feeds and Google.

    What protects against what
    ProtectionWhat it catchesWhat it does
    Protective set of stop rulesa whole price list in another currency, zeroed prices, an average price jumpdoesn't import the broken file and keeps the previous prices
    “Abnormal product price”a product price changed compared with the previous importwarns, with examples
    Low-price filtera price several times lower than the product's other suppliers havekeeps it out of price selection
    The “Price gaps” report and signalswhat has already got through, and single-supplier productsshows it and lets you take it off the website

    How each stop rule works: Price list stop rules.

    How to turn on protection from the report

    The “How to protect your prices” panel shows each protection's state and its button. Each button first explains what turns on and what happens when it fires. “Turn on full protection” in the section header adds the protective stop rule set and, if the filter is off, a 50% filter; an enabled filter keeps its threshold. Once all is on, the button is gone.

    Buttons in the “How to protect your prices” panel
    RowButtonWhat happens
    “Filter out abnormally low prices”“Turn on 50% filter”during the catalog update from all price lists, a price more than 50% below the median of other suppliers is kept out of price selection — the next supplier provides the price. The confirmation window shows how many prices will be filtered out and how many of them are on your website now
    “Stop-rules for all sources”“Turn on for all sources”the protective set: “Sharp average price jump” 50% and “Mass price zeroing” 90% — “Block”, “Price-list currency change” — “Block”, “Abnormal product price” 40% — “Warn”. These four rules get these values instead of yours; other rules don't change. A broken price list isn't imported, and the catalog keeps the previous prices

    The set is written to the global stop rules and doesn't reset sources' own rules — unlike the “Apply to all sources” button in the stop rules window. For a source with its own rules, click “Protect” in its row.

    The filter works only in the catalog update from all price lists. If that update doesn't run after scheduled price list imports, the panel warns you. Turn on “Update base catalog after loading all price lists on schedule” in system settings. The filter threshold is set in the “Ignore abnormally low supplier price, %” field — Updating the base catalog.

    The “How to protect your prices” panel
    1Filter out abnormally low prices
    2Turn on 50% filter
    3Stop-rules for all sources
    4Turn on for all sources
    1. Row describing the filter for abnormally low prices.
    2. Button that enables the 50% filter.
    3. Row describing stop-rules for all sources and which are not set up.
    4. Button that applies the protective set to all sources.

    What to check by hand

    The filter trusts the majority of suppliers, and in two cases it discards a correct price:

    • There are two offers. The filter discards the lower price even if the higher one is wrong.
    • The price is several times higher than the others. If it's the majority that is wrong, the correct price is the one discarded.

    The “What to check by hand” row shows how many such products there are now. Fix the price list or the match, and mark a legitimately different price as “Not an error”.

    How to find the supplier who makes mistakes

    The “Price gaps by source” table sums up gaps by price list. At the top are sources whose prices are currently on sale, then those with the most gaps. The row as a whole isn't clickable: each action has its own link or button.

    What a source row contains
    ColumnWhat it shows
    Nameopens the source's products
    “Compared”, “Cheaper”, “Dearer”, “On site”how many of the source's offers were compared, how many differ in each direction and how many of them are on your website now
    “Diagnosis”the most frequent cause in the source. “Looks like the whole price list is broken (N%)” — at least 10 gaps, making up at least 30% of compared rows: most often the price list is in another currency or the price is taken from the wrong column
    “Stop-rules”“Protected” — the source has the protective set on; clicking opens the rules for editing. “Protect” — writes the set to this source's own rules
    Icons on the right“Source products”, “Source settings”, “Source stop-rules”, “Write to the supplier”
    Price gaps by source panel with diagnoses and stop-rule buttons
    1Currency not converted label
    2Check the currency link
    3Protect button
    4Protected label
    5Row action icons
    1. Currency not converted — the price list looks like it is in another currency than the one applied.
    2. Check the currency — opens the source settings to verify the exchange rate.
    3. Protect — enables the protective set of stop-rules for the source.
    4. Protected — the source already has the protective stop-rules; click to edit them.
    5. Icons on the right open the source products, its settings and stop-rules.

    If the cause is the currency

    Under the “Other currency” label there is a “Check the currency” link. It leads to the source settings, and the hover hint tells you which way the error goes:

    • the source's prices are several times higher than the others — they seem to be in your main currency already but were converted at the rate once more. Check the price column currency and whether the currency is taken from the file;
    • the prices are several times lower — they seem to be in dollars, while the price list treats them as hryvnias.

    The app doesn't change the currency itself: the report can't tell who is right, and a wrong fix would spoil an honest source. Exception: “Currency not converted” on a source without a rate rule. Its row has “Turn on exchange-rate conversion”: it adds the “Price + exchange rate” rule and recalculates the price list at once; site prices follow at the next catalog update.

    How to write to the supplier

    The “Write to the supplier” envelope icon opens a new email: address from the supplier card, subject “Please check the prices in the “…” price list”, a polite request and the supplier's products with gaps — name, SKU, price from their price list. Other suppliers' prices aren't included. No email in the card — the window opens without an address.

    How to take a wrong price off your website

    The “Products with price gaps” table shows up to 300 offers: first those on sale now, then those with the largest difference. 15 rows are visible, the rest are under “Show more”. Toggles filter the rows: “On site”, “Cheaper”, “Dearer” or by cause.

    Under the product name you see “on site … UAH” if exactly this price is on sale; under the cost price, the price from the supplier's file. Tags next to the cause: “Filtered out” — the filter already keeps this price out; “Not used” — the offer was turned off manually.

    Products with price gaps table
    1On site filter chip
    2Price on the site
    3Price in the price list
    4Gap multiplier
    5On site label
    6Row action icons
    1. The chip narrows the list to products on sale at a wrong price right now.
    2. Under the name is the product's current price on the site.
    3. The original price from the price list is shown under the cost price.
    4. The gap shows how many times the cost differs from the supplier median.
    5. The red label means the wrong price is live on the site.
    6. Icons let you open the card, ignore, fix or hide the product.

    Actions are the icons on the right of the row. Each first opens a confirmation window with the consequences.

    Product row actions
    ActionWhat happensHow to undo
    “Do not use this offer”the offer is left out of price selection until this price list's next import. The catalog price is recalculated right away, in a few seconds; on the website, after the next export. If there are no other offers, the product becomes “Out of stock”“Use this offer again” in the same row
    “Fix the price”the product price becomes what you enter, with the “Fixed price” flag: catalog updates no longer change it. The field is prefilled with the suppliers' median price plus markup; with two offers, that's the average including the wrong one, so check the numberthe “Fixed price” field in the product card
    “Take off sale”the product is disabled and disappears from your website and marketplaces after the next exportthe “Status” field in the product card
    “Not an error”the product is no longer checked: it's gone from the report, signals and “Needs attention”, and the filter doesn't discard its offers. For bundles, used items, clearance sales“Check again” in the “Marked “Not an error”” list under the tables

    One supplier is wrong — “Do not use this offer”. Hold the price until the list is fixed — “Fix the price”. No other offers — “Take off sale”. “Do not use…” lasts only until the next import (why), so write to the supplier and turn on the filter. Fixing and taking off sale also need the products window.

    Confirmation window «Fix the price» with the price field prefilled
    1Fixed price explanation
    2Price field
    3Prefilled value hint
    1. The text explains that the price will be set to the value you enter and marked «Fixed price», so catalog updates no longer change it.
    2. The price field holds the proposed value, which you can edit before confirming.
    3. The hint says where the prefilled value comes from: the median of supplier prices with markup, or the product price before the drop.
    Marked «Not an error» panel
    1Marked «Not an error» panel
    2Return the check icon
    1. Products marked «Not an error» are excluded from price gap checks.
    2. This icon returns the product back to the check.

    How to check a product's price across all suppliers

    The product name opens the price list item card at “Price among suppliers” (anchor “Price comparison”): a conclusion with the cause and whose price is on the website. Below: a cost price chart with a median line and all suppliers — price list price with currency and rate, cost price, price with markup. A supplier's name opens their item.

    Price comparison section of the price product card with supplier table
    1This item label
    2Price in USD with rate
    1. This item marks the position the card belongs to.
    2. The supplier's price list price is in USD and converted at the rate shown under it.

    More on the price list item card: Price list products.

    What to do with orders placed at a wrong price

    The “Orders at a questionable price (14 days)” panel comes first in the section: this is already money and reviews. A customer order line lands here when its price is several times lower than expected:

    • the product has several suppliers — the price is below the median cost price by more than the threshold, meaning you sold it cheaper than you buy it;
    • the product has one supplier or none — the price is below the product's usual price from its 60-day price history.

    Columns: “Order” with date and customer, “Product”, “Qty”, “Order price”, “Expected price” marked “supplier median” or “usual price”, “Lost revenue”, “Status”. Above the table is the summary “Orders: N, lines: M… Lost revenue is about X”. This amount is an estimate at current prices, not accounting.

    The order number opens the document: contact the customer before shipping, and take the price off your website with the product row actions. The panel exists only in “All sources” mode. An empty panel says “No orders at a questionable price in the last 14 days.”

    A product only one supplier has

    Such a product can't be checked against a median, and the filter doesn't touch it. For it there is the “Single-supplier products: price dropped sharply” panel. It compares the current catalog price with the price before the last change.

    A product lands here if it's enabled, has one offer, and its price changed in the last 30 days, dropping by more than the threshold. Actions match the products table; “Fix the price” is prefilled with the pre-drop price. A new product without price history has nothing to compare with — the report won't see its error.

    Single-supplier products: price dropped sharply table
    1since date
    2Was price
    3Now price
    4Row action icons
    1. The product has the date since which the price changed.
    2. The price before the drop.
    3. The price after the drop.
    4. Icons let you open the card, ignore, fix or hide the product.

    How to learn about an error without opening the report

    Every 10 minutes the app looks for anything new since the last check: orders at a questionable price over the last day, questionable prices on your website and sharp price drops on single-supplier products.

    Who gets the signal
    ChannelWho gets it
    Notification feed and pop-up message in the appall employees with access to the price lists window. “Open” in the feed goes straight to the “Price gaps” section
    Browser push, email and Telegramonly those who turned on the “Price gaps” toggle in “My profile & security” (or whose manager did it in the employee card) and have access to the price lists window

    A signal reads “Orders at a questionable price: N” with three examples like “#… — product: 134 instead of ~1,250 UAH”, or “Questionable prices on the site: N”. A case is reported once per 30 days. The first notification is a summary: “Price gaps: what needs attention now”. “Not an error” products get no signals.

    The toggle takes effect after you save the profile (notification events). How to connect Telegram and email: Event notifications.

    Notifications block of the profile with event toggles
    1Price gaps toggle
    1. Toggle that subscribes you to price-gap notifications.

    Which suppliers to trust

    The “Supplier reliability (30 days)” table shows how often a supplier's price lists arrive with price problems. Reliability is the share of imports without an average price jump, currency change, zeroed prices, abnormal product price, deviation from the catalog or import block. Least reliable on top; “Gaps now” is how many of their rows are in the report.

    Check the top of the table once a week: these suppliers are worth talking to, or their prices shouldn't be used without checking. Next to it is “Price gaps by day”: a snapshot every hour, and the chart appears from the second day.

    Supplier reliability (30 days) table
    1With price problems column
    2Reliability percentage
    3Gaps now column
    1. The number of loads in which price problems were found.
    2. The share of loads without price problems, least reliable first.
    3. The supplier's current rows in the price gaps report.

    The other “Overview” sections — source health and matching — are covered in Source analytics.

    How to go through the report with AI

    The “✦ AI” button in the section header opens a chat with the consultant, who has already read the report: protection state, orders, sources and products with causes, single-supplier drops, reliability. AI changes nothing itself — it explains and tells you which report button to click. When there are gaps, the chat also offers the “Review price gaps” hint.

    What to ask
    What to typeWhat you get
    “Why is the price of Liebherr CBNes 6256 wrong on the website?”whose offer sets the price, the cause and what to click
    “Which suppliers get their prices wrong?”sources with gaps, the diagnosis and whom to talk to
    “Which orders went through at a wrong price?”order numbers and how much revenue was lost
    “What should I turn on so a wrong price never reaches the website?”which protection is missing and which button turns it on

    Scenarios

    A supplier dropped a digit

    An electronics store, price lists update every hour. A supplier sent a smartphone at 121 instead of 1,215 dollars, and that price became the lowest of ten.

    • What you see. The “Questionable price on site” tile is above zero; in the products table there is a row with “On site” and the cause “Extra or missing zero” or “Price or match”.
    • What to do. “Do not use this offer” — the next supplier provides the price. Then “Turn on 50% filter” and email the supplier.
    • Or “Fix the price” if you want to hold a specific price until the supplier fixes the price list.
    • Result. In a few seconds the catalog price is normal (recalculation takes longer on large catalogs); on the website, after the next export. The filter won't let the next such error through.

    A whole price list arrived in another currency

    • What you see. The source row shows “Looks like the whole price list is broken (N%)” and “Other currency · USD”. The same label sometimes appears on an honest source compared with the broken one: the “Check the currency” hint shows the direction.
    • What to do. Fix the currency in the broken source's settings, or click “Turn on exchange-rate conversion” if the cause is “Currency not converted”. Click “Protect” and “Write to the supplier”.
    • Result. The price list prices are recalculated; the next price list in the wrong currency won't be imported — “Price-list currency change” or “Sharp average price jump” blocks it.

    Someone already ordered at the wrong price

    • What you see. The “Orders at a questionable price” tile and a red summary in the orders panel; a signal in the feed.
    • What to do. Open the order by its number and contact the customer before shipping. Take the price off your website with a product row action.
    • Result. No new orders come in at this price, and you reached an agreement with the customer before they wrote a review.

    A product only one supplier has got cheaper

    • What you see. The product is in the “Single-supplier products: price dropped sharply” panel, for example “Was 245,010 — Now 78,247”.
    • What to do. Check the price list. If it's an error, use “Fix the price”: the field already holds the price before the drop.
    • Result. Catalog updates don't touch the price until you clear “Fixed price” in the product card.

    The price is legitimately lower: a bundle, a used item, a clearance sale

    • What you see. A row with the cause “Price or match”, although the price is correct.
    • What to do. “Not an error”.
    • Result. The product is gone from the report and signals, and the filter doesn't discard its price. To check it again, use the “Marked “Not an error”” list.

    Daily control without opening the report

    • What to do. Click “Turn on full protection” once. In “My profile & security”, turn on the “Price gaps” toggle and enter your Telegram.
    • Result. When a new questionable price or order appears, the notification feed shows a message with an “Open” button, and the email and Telegram get the same text. Checking “Supplier reliability” once a week is enough.

    No time to dig into tables

    • What to do. Click “✦ AI” in the section header and ask what to turn on first.
    • Result. AI starts with what is already selling at a wrong price and names the report buttons. Other questions — in the table above.

    FAQ

    The report flagged a price that is correct on the website. Why?

    With two offers, the report flags the cheaper one even if the more expensive one is wrong. Open the item card and compare both price lists; fix the source with the error (how it's calculated).

    I clicked “Do not use this offer”, but the wrong price came back. Why?

    The mark lasts until this price list's next import. If the supplier sent the same error again, the offer takes part in price selection again. Turn on the filter and write to the supplier.

    The filter is on, but the questionable price is still on the website. Why?

    The filter works during the catalog update from all price lists. Until it runs, the website keeps the previous price. Check that the update runs after scheduled price list imports (protection).

    Can I set a threshold other than 50%?

    Yes, in the “Ignore abnormally low supplier price, %” field of the “Updating base catalog” window. The report uses the same threshold, and “Turn on full protection” doesn't change a threshold already set. A threshold of 20 will also discard honest low prices.

    Why doesn't the email to the supplier include other suppliers' prices?

    On purpose. The email contains only the supplier's own data: name, SKU and price from their price list.

    Notifications arrive in the app, but not by email. Why?

    Outside the app, signals go only to subscribers. In “My profile & security”, turn on the “Price gaps” toggle and save the profile (signals).

    Where to find it and who has access

    Menu
    Directories → Processing price lists → List of price lists, “All sources” → “Overview” → “Price gaps”
    Other entry points
    “Open” in a notification; a row in “Needs attention”; price list item card → “Price comparison”
    Access right
    the “Price lists” window; fixing the price and taking off sale also need the products window
    Low-price filter
    “Turn on 50% filter”, and “Turn on full protection” while the filter is off, also need the “Catalog update from price lists” window
    Prepare
    matched products with at least two offers

    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