The “Base catalog and price lists” window searches your catalog and all supplier price lists at once — no opening them one by one.
When you need this:
- A customer asks about a product — do you have it, who sells it and at what price.
- Comparing supplier prices — Ctrl+D keeps only price list rows matched with the product.
- A price doesn't update from price lists — an empty right grid after Ctrl+D means it isn't matched.
- In a price list, not in the catalog — one button adds it from the row.
Where to start: “Directories” → “Base catalog and price lists” → model in the search box.
What the window does
- One search for two grids — catalog products on the left, rows from all suppliers' price lists on the right.
- Price, purchase price, margin and stock in every price list row.
- Ctrl+D — shows which price list rows a product is matched with, and the other way round.
- Manual matching of a price list row with a catalog product.
- Adding a product from a price list to the catalog, and bulk actions with rows.
How to search your catalog and price lists at once
The “Enter text to search for a product” box above the grids searches the catalog and the price lists at the same time. Type a name, SKU or model and click “Search” or press Enter.
Elbuz looks for the whole text you entered as part of the name, SKU, model, manufacturer, category or description, so “990 PRO” finds more than “Samsung SSD 990 PRO 1TB”. The × on the right clears the search, column filters and the Ctrl+D filter in both grids, returning the window to the full list.
The right grid searches all price lists of all suppliers together, so one product gets as many rows as there are suppliers that carry it. Every row shows the price, purchase price, supplier and stock.
1
Search field2
Products found- Search field — type a product name, code or article.
- Products found — matching catalog items with article and manufacturer.
Each grid also has its own filters above the columns. They narrow only their own half.
How to read a price list row
The right grid is compact so it fits next to the catalog, so one cell holds several values.
- Price — the large number is the price in your main currency; hover over it to see the price and currency from the price list file. The arrow next to it shows by how many percent the price changed since the previous upload. Below the price, in small type, are the purchase price and margin in percent; a zero or negative margin is red, so check price selection and markup rules.
- Supplier — the supplier the row came from.
- Name — the name from the price list, with the manufacturer's SKU, brand and supplier stock below it, plus a stock mark with the quantity if the price list provides one. The name and stock are shown exactly as the supplier wrote them.
- Selection — a checkbox for bulk actions with several rows.
The left grid shows your columns from the products window: if you see the SKU, photo and category there, you'll see the same here. The category path of the selected product is shown in the line below the grid.
How to see what a product is matched with: Ctrl+D
Clicking a row doesn't link the grids to each other. To see the link, use a shortcut.
- Ctrl+D in the left grid — the right grid shows only the price list rows matched with the selected catalog product.
- Ctrl+D in the right grid — the left grid shows the catalog product the selected price list row is matched with.
- Ctrl+U in the narrowed grid — removes the filter. After Ctrl+D in the left grid, the right one is narrowed, so press Ctrl+U in the right grid. Ctrl+U also clears that grid's column filters.
1
Selected catalog product2
Matched price list product3
Product found mark- The product selected in the base catalog grid is highlighted.
- The right grid narrows down to the price list product linked to the selected catalog product.
- The checkbox shows that the price list row is matched to a catalog product.
An empty right grid after Ctrl+D means the product isn't matched with any price list row, so price lists don't update its price and stock. Ctrl+D on a price list row that isn't matched with any product changes nothing.
How to link a price list row to a product
- Find the product with the general search.
- Click the product in the left grid.
- Click the price list row in the right grid.
- Click “Match price list products with base catalog products” (the second button above the right grid) and confirm.
If you haven't selected a row in one of the grids, Elbuz tells you: “To match products, select a product from the base catalog!” or “To match products, please select a product from the price list!”. The match is saved to the matched products directory and applies on every price list upload from then on.
You can link several price list rows of one product (for example, from different suppliers) at once: tick them in the “Selection” column and click “Match” — the confirmation lists the ticked rows.
What else you can do with price list rows
- “Add product to base catalog” (the first button) — creates catalog products from the selected price list rows if you don't have that product yet. Elbuz first asks which category to add them to.
- “Update my catalog” — opens catalog update from price lists across all price lists.
- “Additional Operations” (☰) — bulk actions with price list rows: change the category or values, add to a set, ignore a product, markup statistics and comparison.
The left grid works just like the products window: F4 opens the product card, F8 deletes the selected product. F8 in the right grid deletes the price list row after confirmation, or all ticked rows if any are ticked.
Scenarios
A customer asks about a product — do you have it, and who carries it
- Type the model in the general search and click “Search”.
- The left side shows whether the product is in your catalog; the right side shows which suppliers carry it, at what price and in what quantity.
- If the product isn't in your catalog but is in a price list, select the row and click “Add product to base catalog”.
Compare supplier prices for one product
- Find the product and click it in the left grid.
- Press Ctrl+D: the right grid keeps only this product's price list rows — the price and stock at each supplier.
- Ctrl+U in the right grid brings back the full list.
A product's price doesn't update from the price list
- Click the product on the left and press Ctrl+D. If the right grid is empty, the product isn't matched.
- Press Ctrl+U in the right grid, then find this product's price list row with the general search.
- Select the product on the left and the row on the right, and click “Match”.
What to do when something goes wrong
| What you see | Why | What to do |
|---|---|---|
| “To match products, select a product from the base catalog!” | No product is selected in the left grid | Click a product on the left and try again |
| “To match products, please select a product from the price list!” | No row is selected in the right grid | Click a price list row on the right and try again |
| The right grid is empty after Ctrl+D | The product isn't matched with any price list row, or the general search filters out its rows | Clear the search with the × and press Ctrl+D again; still empty — match it manually |
| The list stays narrowed after a search | A Ctrl+D filter or a column filter is active | Ctrl+U and the × next to “Search” |
FAQ
How do I see which suppliers carry a product?
Find the product with the general search: the right grid shows rows from all price lists. To keep only the rows matched with it, click the product on the left and press Ctrl+D.
How do I get the full list back after Ctrl+D?
Press Ctrl+U in the grid that was narrowed: after Ctrl+D in the left grid, press it in the right one, and vice versa. Or click the × next to “Search” — it resets everything.
How do I add a product from a price list that isn't in my catalog?
Select the row in the right grid and click “Add product to base catalog”. Elbuz asks which category to add it to.
Can I see just one price list?
In this window, the right grid always covers all price lists. Filter the “Supplier” column or open the price list in the price lists window.
Can the window pair products with price list rows automatically?
No, matching here is manual. Automatic matching is in the product matching window and in matching rules.
Where to find it and who has access
- Menu
- “Directories” → “Base catalog and price lists”
- Access rights
- this window, the products window, and the price list products grid in the price lists window
- Prepare
- at least one uploaded price list
The window opens maximized. The left grid is “Products from the base catalog”, the right one is “Price list products”. Both are the same grids as in the products and price lists windows, with the same columns, filters and menus.
Related topics
- If you need to match a whole price list with the catalog, not just one row — Matching supplier products.
- If a pair was matched by mistake and needs to be unlinked — Matched products directory.
- If a product is matched but the price in the catalog is outdated — Catalog update from price lists.
