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.
- I know which category the product is inThe tree on the left, including subcategories
- I know the name, SKU or barcodeThe search bar in the toolbar, eight fields at once
- I'm looking for products with a feature: no photo, no price, price upFilters above the grid with live counters
- I want to export to Excel which products went up in price over a period, and by how much“Catalog analytics”: price changes over 7, 30 or 90 days and the “Export” button
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.
1
Search box with the query2
Total counter- Search box — the query Intel filters the grid after about a second.
- 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:
| Button | Which 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.
1
Products without price2
Brand3
More4
Filter settings5
Clear filter- Products without price — a filter button with a live counter.
- Brand — drop-down list of brands.
- More — the remaining filters with their number in brackets.
- Filter settings — choose which filters are shown.
- 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.
1
Matrix columns2
Rows3
Row density: Normal / Compact- Matrix columns — switches that add attribute, option, supplier price and stock columns.
- Rows — variants, product card and grouping modes.
- 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 see | Why | What to do |
|---|---|---|
| “Total” shows one or a few products, although the catalog has hundreds | A 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” mark | Expand “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 products | Neither 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 opens | Open 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
- If you need the big picture of working with the product list, see how to work with the product list.
- If the products are filtered and you need to select them for an operation, see how to select products.
- If the “Matched” and “Unmatched products” filters show the wrong products, see matching supplier products.
- If you need to count products without photos across the whole catalog, see catalog analytics.
