↑↓ selectEnter openEsc close

    1. Elbuz

    Supplier demand analysis: which products are selling out

    11 min readUpdated

    Elbuz calculates supplier demand from how stock shrinks between price list imports: units gone, how steadily they sell, and days until stock runs out.

    When you need this:

    • Deciding what to reorder — products are sorted by demand rating, best sellers on top.
    • An item is running out at the supplier — the “Days” column turns red under a week of stock.
    • Choosing products to advertise — Elbuz sets and clears the “Advertise” mark in product cards itself.
    • The supplier sells what you don't — NEW items go into your catalog with one button.

    Where to start: select “Track product trends” in the source card and wait for three imports.

    What demand analysis does

    What to turn on to get numbers

    Data collection doesn't turn on by itself: the checkbox is set in each source card separately and is cleared by default. That's why the most common state of this window is an empty grid with the message “Select a price list for analysis”, even if your price lists have been importing daily for ten years.

    The checkbox is called “Track product trends” and sits in the source card: the “Products” section, “Cleanup and service” subheading.

    Once it's selected, every following starts saving the stock and price of each price list row to the history.

    Source card, Products section: the «Track product trends» checkbox under the «Cleanup and service» subheading
    1Track product trends
    2Cleanup and service
    1. Track product trends — the checkbox that enables demand tracking; without it nothing else appears.
    2. Cleanup and service — the subheading of the Products section that holds this group of checkboxes (opened with Configure).

    After that you need time, and no button or setting can shorten it:

    • One import gives one data point. Rows will appear in the rating, but their sell-through will be zero: there's nothing to compare yet.
    • Three imports on different days is the minimum for trends to start working. Until there are three points, all products have the “New” trend.
    • Four or more — Elbuz starts comparing the first half of the history with the second, and the trend is no longer just “New” or “Stable”.

    Two more conditions worth knowing in advance.

    Starting stock must be at least the “Min quantity for analysis”. The default is 5. An item with less stock at the start of the “Analysis period” isn't rated. The check uses the period's first point, not the oldest one: a product at three units a month ago that now arrives by the five hundred is rated.

    The price list must contain live stock levels. If the supplier always puts the same number in the quantity column (a nominal “1000” or “in stock”), there will be no difference between imports, and so no demand: all products get the “Cold” trend and a rating close to zero.

    This isn't a bug — it's Elbuz's honest answer to a file with no movement. Before digging into the numbers, open the price list and check whether the quantity in it changes.

    Sometimes it's the reverse: the quantity column holds cumulative sales, not stock — a number that grows daily. Then, in the source card's “Availability” section, switch “Quantity field type” from “Stock” to “Sales”, and Elbuz will count sell-through as an increase rather than a decrease. The same option affects stock statuses, so switch it deliberately.

    Before you open the window for the first time

    What happens if you turn off data collection

    If you clear the “Track product trends” checkbox, imports of this source stop adding history points and recalculating the rating. What has already been collected isn't deleted: the history, the rating rows in the window and the “Advertise” marks in product cards stay as they were after the last import with the checkbox selected.

    The nightly cleanup removes only the history of products that disappeared from the price list, and Elbuz stops marking disappeared products together with data collection. So the history of a disabled source stays until you delete the source itself: deleting a source removes both its history and its rating.

    The “Recalculate” button ignores this checkbox and uses the old history. The “Analysis period” counts back from today, so after a pause longer than the period it holds no points. Then no product passes the “Min quantity for analysis”, the source's rating rows are deleted, and matched products lose the “Advertise” mark if catalog flag updating is on.

    If you select the checkbox again, the next import adds a point to the saved history. Points older than the “History depth (days)” are dropped. After a short pause, numbers resume with a gap for the pause. After a pause longer than the history depth, no old points remain, and the three-import count restarts.

    Where the numbers come from and what date they reflect

    The mechanism has three steps, and all three happen without you.

    Snapshot. On every price list import with the checkbox selected, Elbuz adds one point to the history of each row: date, quantity, price. There's one point per day — a second import on the same day overwrites it rather than adding a new one. History is kept as far back as the “History depth (days)” allows; by default, 30 days.

    Calculation. Right after the snapshot, Elbuz recalculates all metrics for each product of the source and writes one row per product.

    Display. The window reads rows that are already calculated. It computes nothing on the fly, so it opens equally fast for a few hundred items and for seven thousand.

    A row's numbers refer to the last calculation, not the moment you open the window. That calculation ran on this source's last import: if the price list hasn't been imported for three days, the grid shows three-day-old “Quantity”, “Sold” and “Days”. Don't compare them with the current price list — they don't have to match.

    A snapshot isn't taken on every run. If a blocked the import, the run ends before the data reaches the price list — and there will be no history point for that day at all.

    So a gap in a product's chart has two different causes: either the price list wasn't imported that day, or it was imported but rejected. You can see which one in the price list log.

    The “Recalculate” button on the toolbar recalculates metrics from the collected history; new points come only with price list imports. With no history, it replies “Rating recalculated. Processed: 0”: not an error, just nothing to process. It works on one source, so in all-suppliers mode with no price list selected it replies “Select a price list”.

    If “Recalculate” was interrupted. The button sends one request and waits while the server processes the source's products in batches of 500 history products, writing each batch separately. Only after the last batch does it remove rows of products that didn't pass the filters, reorder the “#” and “# in cat.” positions, and copy the “Advertise” mark to the catalog.

    If the work stopped midway, some rows have new numbers and the rest old ones, outdated rows stay, and catalog positions and marks aren't updated. If the server doesn't respond, “Loading...” disappears, the button becomes active again, and a red message appears: “The request failed: the server did not respond or returned an error. Please try again.”

    Retrying is safe. One rating row is stored per product in a source, and a repeated calculation overwrites it rather than adding a second one. If a database error occurred during the calculation, Elbuz deliberately doesn't delete rows that weren't recalculated, so as not to remove a live rating instead of an outdated one.

    The same calculation also runs on every price list import with the checkbox selected, so the next import will also bring the rows back in order.

    A price list import enters at the top and adds a history point; the “Recalculate” button goes straight to the calculation and adds no point. Outdated rows are removed only when all batches pass without an error
    NoYesYesNo — the row isn't writtenthis timeYesNoPrice list import finishedIs the source's“Track product trends” checkboxselected?History and rating rowsstay as they wereSnapshot: a “date — quantity —price” point,one per day. Points older than“History depth”are dropped, products thatdisappearedfrom the price list are markedinactive“Recalculate” buttonCalculation of the source's productsin batches of 500Is stock at the start of the “Analysisperiod”at least the “Min quantity foranalysis”?The rating row is overwritten:metrics, trend, “Advertise”Did all batches passwithout a database error?Rows of products that dropped outare deleted.Before that, “Advertise” is clearedfrom their cardsif flag updating is turned onOutdated rows are left untouched“#” and “# in cat.” are reordered.“Advertise” is copied to the cardsof matched products if flag updatingis turned on
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    How to change the “Analysis period”

    The first field in the window settings is “Analysis period (days)”, from 7 to 90, 30 by default. This is the window over which all row metrics are calculated: sell-through, speed, trend, stock forecast.

    You can change it: enter a new number, save the settings and click “Recalculate”. Until then the grid says “The rating has not been calculated” — that's normal: rows are tagged with their period, and none have the new tag yet. After recalculation, the new period's numbers appear, and the export and daily email use it too.

    Seven days versus thirty isn't “more precise” or “rougher” — they answer different questions. Thirty days: “what does this supplier sell in general”; seven: “what is selling right now”. An item dead for a month that sold ten a day last week gets lost in the thirty-day window and comes first in the seven-day one.

    There's no point in setting a period longer than the “History depth (days)”: history older than the depth is deleted by the nightly cleanup, and the extra days of the period simply find nothing. If you need a 60-day window, first raise the depth — and wait for the history to build up.

    How to export the rating to a file

    The “Export” icon produces an xlsx file named like supply_rating_2026-08-17_143005.xlsx. There are twelve columns: “#”, “SKU”, “Name”, “Category”, “Manufacturer”, “Quantity”, “Price”, “Sold”, “Sell-through %”, “Rating”, “Trend”, “Stability”. Rows are sorted by rating in descending order, and the entire filtered set is exported. If nothing matches the filters, no file is created — Elbuz replies “No data for analysis”.

    One thing worth knowing before you open the file:

    • It's not “what you see on screen”. Only the supplier, price list, trend and category are passed to the export. The search bar and the grid's row filters don't make it into the file: if you narrowed the grid down to twenty items, the file will contain the source's entire rating.

    Who gets the daily demand email

    Daily at 16:00, Elbuz sends an email with the subject “📊 Product Demand Report” and the date. It lists up to twenty products from all your sources with a “Hot” or “Growing” trend and a rating of 50+, grouped by supplier; items unmatched in your catalog get the NEW badge. On top is a summary: “Hot products”, “Growing”, “Total analyzed”.

    The email goes to users with the “Product Trends” checkbox on in the “Notifications” block of their card. If nobody is subscribed, it's still sent — to the admin user. Hence the most common question about it, “who ordered this”: nobody, it's the default. To target it, turn the checkbox on for whoever needs it.

    Another daily task, at 3:00, cleans up the history: it deletes records of products that disappeared from the price list more than “Keep inactive (days)” ago, and together with the history it removes rating rows that have no data left behind them.

    Until then, these items are visible in the window with numbers as of the last calculation — so for up to thirty days the rating may show products the supplier no longer has.

    Scenarios

    See what is selling at the supplier right now, not over a month

    What to do. In the window settings, set “Analysis period (days)” to 7, click “Save”, then select a price list and click “Recalculate”. Repeat “Recalculate” for each source you need.

    What you get. Metrics, trends and “Advertise” checkboxes are calculated for the last seven days. The export and the daily email use the same period.

    What you won't get. The setting is shared, so the period changes for all sources. A source you haven't clicked “Recalculate” for and that hasn't been imported since the change will show “The rating has not been calculated”. You can't keep the thirty-day picture alongside the seven-day one: one calculation is stored per product.

    Scenarios for picking products to advertise and finding products you don't have are in the articles “Picking products to advertise” and “Products you don't sell”.

    What to do when the window is empty

    What you see in the demand analysis window and what to do about it
    What you seeWhyWhat to do
    “Select a price list for analysis” The window is open in all-suppliers mode, and no price list is selected Select a supplier, then a price list — or open the window from the source card (where to find it)
    “The rating has not been calculated. Click the “Recalculate” button.” A price list is selected, but it has no rows: the “Track product trends” checkbox is cleared, there's no history yet, or stock at the start of the period is below the “Min quantity for analysis” Select the checkbox in the source card and wait for the next import. If you've just changed the “Analysis period”, click “Recalculate” (what to turn on)
    “Rating recalculated. Processed: 0” The recalculation ran, but there was nothing to process — there's no history This isn't an error. Data appears after a price list import with the checkbox selected (where the numbers come from)
    “Select a price list” “Recalculate” was clicked in all-suppliers mode: recalculation works on one source at a time Select a price list in the filter and try again
    All products have the “New” trend There are fewer than three history points — the price list has been imported on only one or two days Wait for the third import (what to turn on)
    Almost all products are “Cold”, with a rating close to zero Stock barely changes between imports: the price list contains a constant, not a live number Open the supplier's file and check the quantity column; if it contains cumulative sales, switch “Quantity field type” to “Sales” (what to turn on)
    A “📊 Product Demand Report” email arrives every day, even though nobody subscribed If nobody has the “Product Trends” checkbox turned on, the email goes to the admin user Turn the checkbox on in the user card of whoever needs the email (daily email)

    FAQ

    Why is the window empty even though the price list imports every day?

    History collection is off by default. Select the “Track product trends” checkbox in the source card and wait for an import: rows appear after the first import, trends after the third (what to turn on).

    How many imports does it take for trends to appear?

    Three, on different days: one history point is written per day, so two imports in one day give one point. Until there are three points, all products have the “New” trend.

    Why don't the numbers in a row match the current stock in the price list?

    A row shows the state as of the last calculation, and the calculation runs on price list import. If it hasn't been imported for three days, the grid shows three-day-old numbers (what date the numbers reflect).

    Why doesn't the “Recalculate” button add data?

    It recalculates metrics from the history already collected. New points appear only with a price list import. “Processed: 0” means there's no history yet.

    Does Elbuz forecast my sales?

    No. It shows demand at the supplier, and a product that sells well there may not sell in your store: different customers, price and storefront. You can compare it with your own sales in “Analytics”.

    Can I compare suppliers with each other?

    Not here: the rating is calculated within one source. Who's cheaper and who lets you down is shown by source analytics.

    Where to find it and who has access

    The window has no menu item: you open it from the list of price lists (all suppliers) or from a source card (one price list).

    From the list of price lists
    Directories → Processing price lists → List of price lists → menu → “Supplier product demand analysis”
    From a source card
    “Products” tab → header menu → “Products” → “Supplier product demand analysis”
    Access right
    the “Supplier product demand analysis” window in group permissions
    Turn on data collection
    the right to edit source card settings
    Prepare
    a source with the “Track product trends” checkbox selected and three imports on different days

    When opened from the list of price lists, the window has “Supplier” and “Price list” selectors at the top. When opened from a source card, the window is already filtered to that price list and has no selectors. Without the right to the window, you get “Permission Denied!” — both for viewing and for every action inside.

    Price lists window: the burger menu is open, with the «Supplier product demand analysis» item among its neighbours
    1Supplier product demand analysis
    2Burger menu button
    1. Supplier product demand analysis — opens the demand rating window; the neighbouring items are other price list tools.
    2. Burger menu button — in the left panel toolbar of the Price lists window; it opens this menu.

    Related topics

    • If there's no history point for some day and you need to find out whether the price list was imported — Price list log.
    • If you need to choose between suppliers based on prices and reliability — Source analytics.
    • If you need the history of your own price in the catalog — Product price history.
    • If the quantity column in the price list comes as words rather than numbers — Stock statuses.

    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