↑↓ selectEnter openEsc close

    1. Elbuz

    How to find products that sell at your supplier but not in your store

    9 min readUpdated

    Elbuz compares supplier demand with your sales and shows what sells out there but not in your store, or is missing from your catalog. Missing items can be added right from the window.

    When you need this:

    • Hot at the supplier, zero sales for you — see “Missed Opportunities”.
    • You sell much less — the “Underperforming” table shows the gap with the supplier.
    • Unclear why a product doesn't sell — “Product analysis” checks markup, stock, photo, description.
    • The supplier sells what you don't have — the row's plus adds it to a category.

    Where to start: in the demand analysis window, pick a price list, click “Analytics” → “Calculate comparison”.

    What the sales comparison does

    How to compare supplier demand with your sales

    The “Analytics” button on the toolbar opens a second window that answers the question “which of these do we sell?”. At the top is the “How does it work?” help, and below it the “Calculate comparison” button. Until you click it, there's no comparison: it isn't calculated automatically and isn't refreshed on import.

    The calculation takes rating rows that have a match in your catalog and compares the supplier's units sold with your sales for the same period — your sales come from your orders.

    Items without don't take part in the comparison — the grid marks them with the NEW badge, and you can link them in price list product matching.

    The result is split into four states. The “Linked products breakdown” donut chart shows how they are distributed, and next to it is a second chart, “Largest gaps: supplier demand vs our sales”:

    • “Missed opportunity” — the product is hot or growing at the supplier, its rating is 50 or higher, and you have no sales at all. An item also lands here if the supplier sold more than five units and you sold zero;
    • “Underperforming” — you sell it, but less than half of what the supplier sells;
    • “Performing” — your sales are from half to one and a half times the supplier's units sold;
    • “Outperforming” — your sales are one and a half times the supplier's units sold or more.

    Two cases fall outside these descriptions. If you sell an item and the supplier sold none in the period, it goes to “Outperforming”. If neither you nor the supplier sold anything, or the supplier sold up to five units without a hot or growing trend and you sold nothing, it goes to “Performing”.

    The first check is “Missed opportunity” by trend and rating. Next, if both sides have sales, their ratio decides the state, and the lower branch handles cases where one side has no sales
    NoYesYesNoYes1.5 or more0.5 to 1.5less than 0.5NoYesNoYesNo — zero on both sidesor low supplier sales withnone of yoursRating row matchedwith a catalog product?Not in the comparison,NEW badge in the gridTrend “Hot” or “Growing”,“Rating” 50 or higherand zero sales of yours in theperiod?“Missed opportunity”Both you and the supplierhave sales?Your sales dividedby the supplier's units sold“Outperforming”“Performing”“Underperforming”Supplier sold more than 5,and you sold zero?You have sales,but the supplier sold none?
    • Action or result
    • Decision: the path depends on the answer

    Below are two tables of twenty rows each. “Missed Opportunities” shows the SKU, name, category, price, “Supplier sold”, “Rating” and “Trend”. “Underperforming” shows the SKU, name, “Supplier sold”, “Our sales”, “Gap” and “Rating”. Each row has a magnifier button — “Product analysis”.

    The Analytics modal with the linked products breakdown and the Missed Opportunities table
    1Linked products breakdown
    2Calculate comparison
    3Product analysis
    1. Linked products breakdown — a donut chart showing how linked products split into missed opportunity, underperforming, performing and outperforming.
    2. Calculate comparison — recalculates the comparison of supplier demand with our own sales.
    3. Product analysis — a magnifier button that appears in the Supplier sold cell when you hover over a row.

    “Product analysis”

    This is a quick diagnosis of one item. At the top is “Price comparison”: the supplier's price, your price and the markup; a markup above 50% is shown in red, above 30% in yellow. Below is the “Possible issues” list of five checks:

    • “Markup N% — may be too high (recommended up to 50%)”, where N is your markup;
    • “Product out of stock — customers cannot buy”;
    • “Product disabled — not displayed on the site”;
    • “No image — reduces conversion”;
    • “No product description — reduces SEO and conversion” or “Short description (N chars) — recommended minimum 100”.

    If none of the checks is triggered, you'll see “No issues found”. At the bottom is the “Open product card” button: make further edits there.

    How to add a supplier product to your catalog

    The plus in the first column is the shortest path from “the supplier sells this and we don't have it” to a ready product card. Click it to open the “Add product to catalog” dialog with the item name, the “Select category” selector and the “Open product card” checkbox (it's on by default and remembers your choice for next time).

    The buttons are “Add” and “Cancel”. A category is required: without one, the dialog replies “Please select a category” and creates nothing.

    On success, the program creates the product in the selected category and links the price list row and the rating row to it — so the NEW badge in the grid changes to the product ID — and then either shows “Product added successfully” or opens the new product card right away.

    The most useful way to work with this button: sort the grid by “Rating” (it's already sorted that way when it opens), go through the rows with the NEW badge from top to bottom, and add the ones that fit your range. This is the part of the work that makes it worth keeping the window open every week.

    Scenarios

    Add items that sell out at the supplier but are missing from your catalog

    What to do. After three imports with “Track product trends” turned on, open the window, select a price list and go down the rows with the NEW badge. On the one you need, click the green plus, choose a category in “Select category” in the “Add product to catalog” dialog and click “Add”.

    What you get. A new product appears in the selected category; the price list row, history and rating row are linked to it, and the NEW badge changes to the product ID. The item then counts in the next “Calculate comparison”, and the next rating calculation copies its “Advertise” mark to the new card if flag updating is on.

    What won't happen. Without a selected category, the product isn't created. The window has no bulk adding: each item is added separately.

    Find products in your catalog that sell well at the supplier but not in your store

    What to do. Select a price list, click “Analytics”, then “Calculate comparison”. Look at the “Missed opportunity” toggle and the “Missed Opportunities” table; the magnifier in a row opens “Product analysis” with the price, markup and list of possible issues.

    What you get. Every rating row matched with your catalog gets one of the four states based on your orders for the “Analysis period”. Which ones are “Underperforming” is shown in the second table, with the gap between the supplier's units sold and your sales.

    What won't happen. Items with the NEW badge aren't counted in the comparison. The comparison isn't refreshed when a price list is imported: after a new import, calculate it again. A product the supplier sold five units of or fewer, without a hot or growing trend, won't land in “Missed opportunity” even if you have zero sales.

    What to do when the comparison or adding doesn't work

    “Analytics” and product adding messages
    What you seeWhyWhat to do
    “No data for analysis” In the product card — there's no history for this item; in “Analytics” — the comparison hasn't been calculated yet, or there are no products matched with your catalog In “Analytics”, click “Calculate comparison” (comparison with your sales)
    “Invalid request parameters” The row data didn't reach the request, or no category was selected — most often after the window was open for a long time Reload the window and try again
    “Product not found in the price list” The price list row changed after a re-import, and the window refers to an item that's no longer in the price list Click “Refresh” on the window toolbar
    “Failed to add the product” The product wasn't created in the catalog Check the selected category and try again (add a product to the catalog)
    “Invalid request parameters” or “Product not found” The nightly cleanup removed the rating row while the “Analytics” window stayed open Close and reopen “Analytics”, then recalculate the comparison

    FAQ

    Why isn't a product with the NEW badge in the comparison?

    The comparison only takes products matched with your catalog. Link the item in price list product matching or add it with the plus.

    The price list was imported again, but the comparison is old. Why?

    The comparison isn't refreshed when a price list is imported. After a new import, click “Calculate comparison” again.

    Can I add several products to the catalog at once?

    No, each item is added separately: the plus in the row, a category, “Add”.

    I have zero sales of a product, but it isn't in “Missed Opportunities”. Why?

    That table gets products with a hot or growing trend and a rating of 50 or higher, or with more than five units sold by the supplier. If the supplier sold up to five units without such a trend, the item goes to “Performing”.

    Where do “Our sales” come from?

    From your orders for the same “Analysis period” used to calculate the supplier's units sold.

    Where to find it and who has access

    Comparison
    demand analysis window → “Analytics” button
    Adding to the catalog
    demand analysis window → plus in the first grid column
    Access right
    the “Supplier Product Demand Analysis” window in group permissions
    Prepare
    the source rating, products matched with your catalog, and your orders for the period

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

    Along with the rating, a user sees the supplier's purchase prices and your markup in the “Product analysis” tab. You can hide these figures separately: remove the group's right to the “Supplier Product Demand Analysis” window — price lists stay available.

    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