↑↓ selectEnter openEsc close

    1. Elbuz

    How to select products to advertise based on supplier demand

    3 min readUpdated

    Elbuz sets and clears the “Advertise” mark in product cards by supplier demand, picking items that sell steadily and won't run out tomorrow. Your ad list is the product grid filtered by this field.

    When you need this:

    • Ad budget should go to fast movers — the mark goes to items rated 50+ with steady demand.
    • The supplier ran out — the mark is cleared on the next calculation.
    • The list should update itself — it's recalculated on every price list import.
    • Marks only by hand — one setting turns off flag updating for all sources.

    Where to start: check the selection thresholds in the demand analysis window settings.

    What ad selection does

    Which products get the “Advertise” mark

    In the demand analysis window, this is the second-to-last column, before “Anomaly”: a green megaphone with the tooltip “Can advertise” or a gray minus with the tooltip “Not recommended for advertising”. The megaphone appears when all six conditions are met at once:

    • rating is at least 50;
    • “Days” is at least 2 (or a dash);
    • “Stability” is at least 30%;
    • the supplier's quantity is above zero;
    • the trend is not “New”;
    • the trend is not on the excluded list — by default it holds “Cold” and “Declining”.

    The first three thresholds and the excluded list are set in the window settings; the other two conditions are built into the app.

    The checkbox doesn't stay in the window. While “Update “Can advertise” flag in product catalog” is on in the settings, it's copied to the : in the product card, this is the “Advertise” field.

    It's copied only for items matched to the catalog. The product grid has a column for this field, and it's on the list of export fields.

    The result: a ready-made selection for your ad budget — items that sell steadily at the supplier and won't run out there tomorrow. Open the catalog, filter by “Advertise”, and hand the list over to advertising.

    “New” is filtered out by the app itself, not by a setting: this trend doesn't mean “new product”, it means “no data yet” — it's given to a product with fewer than three history points. One difference between two imports isn't demand yet, so such a product doesn't make the ad selection, however high its rating.

    If nobody has a checkmark, the stability threshold is usually to blame. In price lists with infrequent or irregular imports, “Stability” rarely reaches 30%, so you'll have to lower “Min stability %” in the settings — otherwise the column stays empty.

    When the app overwrites the mark in the product card

    The card has one “Advertise” field, filled by two parties: you by hand and the rating calculation. While “Update “Can advertise” flag in product catalog” is on in the window settings, every calculation of a source — on price list import or with the “Recalculate” button — rewrites this field in all catalog products matched to that source's rating rows.

    It rewrites in both directions: it clears a checkbox you selected if the rating row didn't earn it, and selects a cleared one if it did. A manual edit lasts until the next calculation.

    In the product card, the field is in the “Statuses and flags” section, in the “Storefront” group, next to “Popular Item” and “New product”.

    Product card, Statuses and flags section: the Storefront group with the Advertise switch
    1Advertise switch
    2Storefront group
    1. Advertise — the switch that the demand rating calculation rewrites.
    2. Storefront — the group of storefront flags: Popular Item, Best deal, New product, On sale, Advertise, Gift.

    If a product drops out of the source's rating — it no longer passes “Min quantity for analysis” or disappeared from the price list — and it had a checkmark, the calculation clears it in the card too before deleting the rating row. Products not matched to rating rows are left alone: their mark stays as you set it.

    How to keep your own value. For a single product, you can't: the calculation doesn't look at any attribute in the card. You can only keep all marks at once, by clearing “Update “Can advertise” flag in product catalog” in the window settings.

    The setting is shared by all sources. Once it's cleared, the calculation stops both setting and clearing marks in the catalog, the “Advertise” field in cards becomes fully manual, and the “Advertise” column in the analysis window keeps being calculated.

    If a product is matched to several price lists. Each source is calculated separately, from its own history, and isn't compared with other sources' scores. The mark in the card is set by whichever source was calculated last.

    A product that passes selection at the first supplier but not at the second will gain and lose the checkmark depending on whose price list was imported or recalculated later. In the analysis window, each source has its own “Advertise” column; only the field in the product card is shared.

    If the marks were set wrong, for example after you lowered a threshold. Fix the thresholds and click “Recalculate” for each source with data collection on: with flag updating on, the calculation rewrites the marks of all that source's matched products by the new thresholds. The button handles one source at a time, so go through them in turn.

    If you need to remove the marks from the catalog entirely, first turn off “Update “Can advertise” flag in product catalog” — otherwise the next price list import will set them again. Then, in the base catalog grid, filter the “Advertise (flag)” column, select the products, and use “Set value in bulk” to choose “No” for this column.

    What happens if a bulk change is interrupted, and how to undo it, is covered in the article on bulk value changes.

    Scenarios

    The list of products to advertise should build itself from items that sell steadily at the supplier

    What to turn on. In the card of each source you need, select “Track product trends”. In the window settings, in the “Advertising Settings” block, set “Min rating”, “Min days of stock”, “Min stability %”, and “Exclude trends”, and leave the “Update “Can advertise” flag in product catalog” checkbox selected.

    What you get. On every price list import and every “Recalculate”, the app decides again which of the source's products get the “Advertise” checkmark, and rewrites this mark in the catalog product cards matched to rating rows. Your ad list is the product grid filtered by the “Advertise” field.

    What won't happen. A product with the “New” trend and a product with zero quantity at the supplier won't get the checkmark at any thresholds. Unmatched price list items don't pass the mark to the catalog. A checkmark you set or cleared by hand on a matched product will be overwritten by the next calculation.

    FAQ

    Why does a product have the “Advertise” checkmark when the supplier's quantity is zero?

    The calculation doesn't set it in that case: one of the conditions is quantity above zero. So the row was calculated a while ago, and the price list has arrived since. Click “Recalculate” in the demand analysis window.

    Can I set the mark on one product and have the app leave it alone?

    No: the calculation doesn't look at any attribute in the card. You can only keep all marks at once — by turning off “Update “Can advertise” flag in product catalog”.

    The marks were set wrong after I changed the thresholds. What should I do?

    Click “Recalculate” for each source with data collection turned on: the calculation rewrites the marks of all matched products using the new thresholds (when the app overwrites the mark).

    A product is sold by two suppliers — whose score sets the mark?

    The source that was calculated last: each price list is calculated separately, and the mark in the card follows whichever price list was imported or recalculated later.

    Can I set different thresholds for different suppliers?

    No. The window settings are shared by all sources: a changed threshold applies to all suppliers from the next calculation.

    Where to find it and who has access

    Thresholds
    demand analysis window → “Settings” → “Advertising Settings” block
    Mark on the product
    product card → “Statuses and flags” → “Storefront” group → “Advertise”
    Access right
    the “Supplier Product Demand Analysis” window in group permissions
    Prerequisites
    data collection turned on for the source, and price list products matched to the catalog

    How to open the demand analysis window is covered in the main article.

    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