↑↓ selectEnter openEsc close

    1. Elbuz

    How to find products in the catalog: tree, search and filters

    5 min readUpdated

    Elbuz narrows a catalog of thousands of items to the products you need in seconds: by category, by a word from the name or SKU, or by a ready condition like “no photo”.

    When you need this:

    • You know the SKU or barcode: search covers the whole category, not just visible rows.
    • You need products without photos, prices or descriptions: a filter button picks them, its number shows how many upfront.
    • You work with one catalog branch: the tree shows a category with its subcategories.
    • The list doesn't fit on screen: compact density shows almost twice the rows.

    Where to start: pick what you know: category, name or a feature.

    What search and filtering can do

    • The category tree shows the products of a category together with its subcategories.
    • The search bar searches by name, SKUs, brand, barcodes and ID, on the server, across the whole category.
    • Filter buttons pick out products with a feature, and the number on a button shows how many will remain.
    • Column filters and sorting narrow and order the list by any field.
    • The “View” menu adds columns for attributes, supplier prices and stock, and switches the row density.

    Everything you set here is the filtered set: what the grid shows and the number in the “Total” counter. Bulk operations don't apply to the filtered set but to the selected products. Why these are different things is explained in “Filtered set vs. selection”.

    Where to start searching

    You can narrow the list with the category tree, the search bar, the filters above the grid and the column filters. They combine with each other in any order, so start with what you know about the product.

    How to show the products of a category

    The category panel on the left is collapsed by default. To expand it, click the vertical tab or the double arrow in the panel header. You can drag the panel width with the mouse; both the width and the collapsed or expanded state are remembered in your browser.

    Clicking a category reloads the grid: the program requests the products again with the new category. The tree has its own search bar for category names and a menu with actions: expand and collapse all, refresh, clear the filter, show categories as a table, delete a category.

    Products are shown together with subcategories, and you can't turn this off. Pick “Computers”, and the grid will also contain processors, cases and everything further down the tree. Keep this in mind before a bulk operation: “the whole category” means “and all its children too”.

    The selected category appears as a chip in the bar above the grid. The cross on the chip has the tooltip “Show all products (reset category)” and returns the tree to the root. Each category has a live product counter next to it.

    How to find a product by name or SKU

    The search bar in the toolbar has the placeholder “Search: name, SKU, MPN, brand, ID...”. The search runs on the server: it doesn't look through the rows loaded in your browser but through the whole category you're in. The query is sent 400 milliseconds after you stop typing, so the server isn't hit on every letter.

    It searches the fields that are marked for the search index with a checkbox in a separate grid settings window.

    The demo database has eight such fields: Manufacturer, Name, Category, Manufacturer SKU, Supplier SKU, SKU (internal), ISBN barcode, barcode. The condition is “contains”, and the fields are combined with “or”: a match in at least one field shows the product.

    If no field is marked, a fallback set is used: ID, manufacturer, manufacturer SKU, SKU and name.

    Click in the empty search bar to open the “Recent searches” list with what you searched for before; “Clear history” is there too.

    Search for Intel in the Processor category: Total drops to 483
    1Search box with the query
    2Total counter
    1. Search box — the query Intel filters the grid after about a second.
    2. Total — the number of matching products, 483 out of 885.

    The search bar doesn't only narrow what you see: it also applies to selection. The “Select all products” item sends the whole filtered set to the server together with the search, so the number in brackets and the number of selected products match. See what exactly “Select all products” selects.

    How to find products with a feature: no photo, no price

    The filter panel is hidden: you open it with the “Filters” link above the grid. The number of active filters is shown next to the link, and the panel state (open or closed) is remembered.

    The default set has twenty-three filters. Thirteen are shown in the panel right away, the rest are in the filter settings window. The panel itself shows five, then a “More” link with the number of hidden ones. The set is personal: each employee has their own, so what you turn off or rename won't change for a colleague.

    There are two kinds of filters. List filters are drop-down value lists with checkboxes: the panel has two, “Brand” and “Stock status”. Three more exist but aren't in the panel: “Status” and “Card completeness” are turned off by default, and “Source” is only available in the filter settings window. Filter buttons are ready-made conditions you just click:

    Filter buttons in the default set
    ButtonWhich products it shows
    “Unmatched products”products that have no with price list rows
    “Matched products”the opposite: products linked to price lists. A catalog product gets the “Matched” mark after manual matching or after “Update my catalog” in “Price lists”. So right after a price list is imported, before the catalog is updated, the button may show only a few products
    “Products without price”the price is zero
    “No description”the short or the full description is empty
    “No full description”specifically the full description is empty, the one that goes into exports
    “Without attributes”not a single attribute is filled in
    “No photo”there are no images at all
    “No barcode”all four fields are empty at once: EAN, , UPC and
    “Price up” / “Price down”the price went up or down at the last catalog update
    “Included in export”products marked for export

    The filter settings window has seven more buttons that aren't added to the panel by default: “Disabled”, “Without SKU”, “Without brand”, “Zero stock”, “Added this week”, “Price changed”, “Archived”. You can also build your own conditions there.

    Each filter button has a number. Read it like this: how many products will remain if you add this filter to the category and the panel filters already pressed. So in the “Processors” category with 882 products, the “Products without price” button shows 391, not the number of such products in the whole catalog.

    The search bar and column filters are counted in these numbers too: type something into the search, and the numbers on the buttons are recalculated for the new filtered set.

    The gear in the panel opens the “Grid Filters” window, where you turn filters on, hide them and build your own. The cross next to it clears all panel filters at once.

    Filter panel of the Products window in the Processor category
    1Products without price
    2Brand
    3More
    4Filter settings
    5Clear filter
    1. Products without price — a filter button with a live counter.
    2. Brand — drop-down list of brands.
    3. More — the remaining filters with their number in brackets.
    4. Filter settings — choose which filters are shown.
    5. Clear filter — resets all active filters.

    How to filter a column, sort and compact the grid

    Below the column headers there is a filter row: you type a value right into the column. Each column also has a filter menu with its own conditions. Clicking a header sorts, you drag column borders with the mouse and reorder columns by dragging, and the layout is saved for you. Ctrl+U clears the grid filters.

    The “View” menu at the right end of the toolbar changes how the grid shows data:

    • “Matrix columns”: five toggles that add separate columns to the grid: category attributes, option attributes only, only attributes marked as filters, supplier prices and stock by warehouse.
    • “Rows”: show product variants and group rows.
    • “Row density”: “Normal” (52 pixels) or “Compact” (36 pixels). In compact mode almost twice as many rows fit on the screen.

    All “View” toggles are saved in your browser and survive a restart.

    The View menu with display modes
    1Matrix columns
    2Rows
    3Row density: Normal / Compact
    1. Matrix columns — switches that add attribute, option, supplier price and stock columns.
    2. Rows — variants, product card and grouping modes.
    3. Row density — Normal or Compact row height.

    The grid keeps only the visible rows in the browser. When you scroll down, the program loads the next batch. So what you see on screen is never the whole filtered set: a category may have nine thousand products while the browser holds thirty rows. The “Total” counter tells you how many there really are.

    Scenarios

    Find a product by the supplier's SKU

    Reset the category with the cross on the chip above the grid and type the SKU into the search bar. The search runs through the fields marked for the search index; in the demo database they include “Supplier SKU” and barcodes.

    • Every product whose SKU appears in at least one of these fields is found.
    • To open the card of a found product, press F4.

    Collect the products of a category that have no photo

    Select a category in the tree, open the “Filters” link and click the “No photo” button. Even before you click, the number on the button tells you how many such products the category has.

    • The grid shows only products without a single image, including subcategories.
    • To add photos to all of them at once or to disable them, select the whole filtered set. See how to select products.

    View category attributes as a table

    Select a category and, in the “View” menu, turn on “Matrix columns” with category attributes.

    • Each attribute becomes a separate column that you can filter and sort like any other.
    • The toggle is saved in your browser and survives a restart.

    What to do when the list is wrong

    What you seeWhyWhat to do
    “Total” shows one or a few products, although the catalog has hundredsA filter button is pressed. Most often it's “Matched products” right after a price list import: until “Update my catalog”, only products matched manually or added from the price list have the “Matched” markExpand “Filters”: the pressed button is highlighted, and the “Clear filter” cross shows the number of active filters. Click the cross. If there are no filters, clear the search bar and select “Open all products” in the tree
    The grid is empty, although the catalog has productsNeither you nor the main system user has a saved column layout, so the grid has nothing to show. Normally the program fills it in by itself when the window opensOpen the menu → “Set up grid” (the “Grid configuration” window) and save the set of columns

    FAQ

    Why does the grid show thirty rows while “Total” says nine thousand?

    The grid keeps only the visible part of the list in the browser and loads the next part as you scroll. The number of rows on screen says nothing about the size of the filtered set; the “Total” counter does.

    Why doesn't the number on a filter button match the number of such products in the catalog?

    It counts how many products will remain if you add this filter to the category, the pressed filters, the search and the column filters. In a category with 882 products, “Products without price” shows 391: that's how many there are in this category, not in the catalog.

    Why does “Matched products” show one product, although the price list is already matched?

    Matching during a price list import links price list rows to your products, but the “Matched” mark on the catalog products themselves is set by “Update my catalog” in “Price lists” (or by manual matching). Update the catalog, and the button will show all linked products.

    Can I save a filtered set under a name?

    No. The category, filters and search last until you change them. Only the set of columns, the filter panel state and the “View” toggles are kept between sessions.

    Why does the grid contain products that aren't in the selected category?

    These are products from its subcategories: the tree always shows a category together with everything below it, and you can't turn this off (category tree).

    Why doesn't search find a product by the field I need?

    Search only runs through the fields marked for the search index in the grid settings. Mark the field you need there (search bar).

    Where to find it and who has access

    Menu
    Directories → Base product catalog → Products
    Access permission
    the “Products” window; search and filters can't be restricted by separate permissions
    Other entry points
    the gear in the filter panel opens the “Grid Filters” window

    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