Elbuz gathers rows from all supplier price lists in one window. Excel, XML feed or parser — all look the same: you see what got pricier, what didn't match the catalog and what has no price.
When you need this:
- New items from a supplier — filter “Unmatched products”, then “To catalog”.
- What got pricier — the “Price increased” filter shows rows priced above the catalog card.
- A supplier delivered goods — build a goods receipt from rows at purchase prices.
- A supplier needs a list without photos — export it to XLSX.
Where to start: the source's “Products” tab → a filter button above the grid.
What the price list products window does
- Show products of one or all suppliers — in all-suppliers mode you can see who sells a product cheaper.
- Show a single item in full — prices, description, attributes, photos, other suppliers and price history.
- Filter problem rows — ready-made filters with counters.
- Change rows in bulk — category, value, text replacement, ignore list.
- Add new items to the catalog — identical items are merged into one card.
- Receive a delivery — a goods receipt from the selected rows.
- Export the filtered set to XLSX — with the grid's filter and set of columns.
How to view products of one or all suppliers
1
Filter row with counters2
Price with purchase price and margin3
Product preview panel- Filter row — the counter next to a button shows how many rows the filter will select.
- Price cell — the purchase price and the margin percent are shown right under the price.
- Product preview panel — shows the selected row in full.
There are two modes, and the difference matters. When a specific source is open, you see its rows, and every action applies only to them. When no source is selected, the window shows products from all price lists at once. This is comparison mode: one product appears from several suppliers, and you can see who sells it cheaper.
The same distinction applies to dangerous menu items. “Delete all products” in an open source removes this price list's rows; in all-suppliers mode, it removes the rows of all of them. Deletion here isn't permanent: the rows come back with the next price list upload.
Whose price goes to the catalog if several suppliers carry a product
In all-suppliers mode, one product appears as a row from each supplier that has it. The catalog card gets one price, and it is chosen by the catalog update based on the “Price selection type” field and supplier priorities, not by this window. How this works and how to make a supplier the main one — Choosing a supplier price.
1
Price selection priority, coef.2
Price selection priority, value- Price selection priority, coef. — the lower the coefficient, the more often this supplier wins when the minimum price is chosen.
- Price selection priority, value — set together with the coefficient.
Conflicts between markup rules are resolved just as clearly. Rules run in order, and once a row has received a markup, the following rules skip it — the first matching rule wins. The exception is a rule with the “Priority (discard others)” checkbox: it always applies and blocks any other markup for its products, except currency conversion.
To see what exactly applied to a specific row, use “Product markup history” in the right-click menu.
What a row shows
The first column is composite: a thumbnail, the name, and below it the SKU, manufacturer and stock status. If the stock status has a tooltip, it shows what the price list itself says, before conversion to your status.
The “Product found” column is the main working signal: a checkmark means the price list row is already matched to a catalog product.
A “Needs attention” icon may appear next to the name. It shows only for fixable defects, and the tooltip names them: no price or matched to catalog but no category. “Not matched” isn't included — it's a common working state with its own column and filter.
The “Price” column is also composite once you turn it on:
| What the cell shows | What it means |
|---|---|
| the price itself | converted to the main currency; the tooltip shows the original price list price and its currency |
| an arrow with a percentage | the price has changed since the last upload: increases in red, decreases in green; the tooltip shows old and new |
| “purch.” and a number | the purchase price, if it differs from the selling price |
| margin percentage | the share of profit in the price. Next to it, the margin at the RRP is calculated |
Which columns you see depends on your personal grid layout. This grid has dozens of columns, and usually only a few are on. If “Price” or “Stock” isn't on screen, it hasn't disappeared — turn it on in “Set up grid”.
The “Product preview” panel on the right shows the selected row in full, regardless of which columns are on: the price list price, cost price, exchange rate, shipping cost, barcodes, product and category IDs, and the row number in the supplier's file. A toolbar button turns it on and off.
How to view and edit a single price list item
The price product card shows one price list row in full, as a catalog product card shows a product. Open it with “Price product card” in the right-click row menu or the same link at the top of the “Product preview” panel. Each item opens in its own window, so two cards can sit side by side.
1
Matched badge2
Catalog product card button3
Section anchors4
Markup (read-only)5
Catalog product card- Matched badge — the row is linked to a catalog product.
- Catalog product card button — opens the linked catalog product.
- Section anchors — jump to the section you need.
- Markup — calculated, read-only.
- Catalog product card — the linked product and how it was matched.
The header shows the photo, name, supplier and manufacturer SKUs (click to copy), manufacturer, supplier and a “Matched” or “Not matched” badge. On its right: “Catalog product card” (if the row is matched) and “Supplier page” (if the row has a link). Below is an anchor bar that scrolls to a section.
| Section | What it contains |
|---|---|
| “General” | name, manufacturer, SKUs, barcodes, model, price list category and catalog category |
| “Prices” | price list price in the supplier's currency, markup (amount and percentage, read-only), price, RRP, old price, sale price, shipping cost |
| “Stock and logistics” | your stock status, the price list status, quantity, delivery time, warranty, dimensions, weight, units |
| “Description” | short and full description and instructions as the supplier sent them, without scripts; you can't edit the description here |
| “Attributes” | the supplier's specifications, and below them, for a matched row, the catalog product's attributes for comparison |
| “Media” | photos (click to enlarge, browse with arrows), links to videos and files; for a matched row, also the catalog product's media |
| “Links” | the catalog product the row is matched to, and the “Other suppliers of this product” table: contact, price list, SKU, price, quantity, status |
| “Price and stock history” | a chart of this item's price and stock by day |
| “Other fields” | your additional price list fields; the section is hidden if you have none |
On the right are two reference cards. “Supplier”: contact, price list, sheet and file the row came from, created and modified dates, row ID. “Catalog product”: the name linking to the card, “How it was matched” — the rule that found the pair, and “Other offers” — how many rows of other price lists are matched to this product.
1
Other suppliers of this product2
Price and stock chart- Other suppliers of this product — the table of the same product from other price lists.
- Chart — price and stock history as a step line.
A field saves automatically when you change it and leave it — there is no “Save” button. It's the same edit as in a grid cell, with the same field permissions: a field your group can't change is grayed out, a field hidden from viewing isn't shown. Always read-only: “Markup”, your stock status, the price list stock status and the catalog category. A failed change reverts the field and shows “Field not changed: no edit permission or the field is read-only”.
A manual edit lasts until the next price list upload, which rewrites rows from the supplier's file (what is lost on reload). To keep a value, set it with a rule — an auto-replace, a formula or a pricing rule — and for a catalog product, on the product card.
Price and stock history builds up only if the source card has the “Track product trends” checkbox selected (supplier demand analysis): each price list upload adds a point for the day. Without it, the section shows “No history yet: it builds up with every price list load”. The chart needs at least two points.
How to filter what needs attention and export it to XLSX
Above the grid is a row of filter buttons with counters. The ready-made set covers almost every daily question:
| Filter | What it shows |
|---|---|
| “Unmatched products” | price list rows with no pair in the catalog — the main working list |
| “Matched products” | the opposite: rows already linked to the catalog |
| “Uncategorized products” | no catalog category — these can't be added to the catalog in bulk |
| “Products without price” | the price wasn't recognized or wasn't in the file |
| “No markup” | no markup rule reached them |
| “Price increased”, “Price decreased” | matched rows whose price list price is higher or lower than the catalog card price |
| “No description”, “No photo”, “Without MPN” | gaps in the supplier's content |
| “Updated today” | what came in with the latest upload |
| “Stock status”, “Manufacturer”, “Supplier” | value lists with checkboxes |
Four ready-made filters are hidden by default and don't appear above the grid: “Supplier”, “Without MPN”, “No photo” and “Updated today”. They haven't disappeared — turn them on with the gear at the end of the row. The first is especially useful in all-suppliers mode, the last when you're sorting out what came in with the latest upload.
The filter set is personal: your own filters are added with the same gear, and that's also where you hide the ones you don't need.
The counter next to a button shows how many rows the filter will include. Before running any bulk action, check this number — it is the scope of the action.
How to export the filtered set to XLSX
“Export products to XLSX” in the menu builds a file from what is currently in the grid, taking the filter and set of columns into account. This is how you make a list of new items for a supplier or for yourself: turn on the “Unmatched products” filter and export.
For marketplace parser sources (Hotline, Kaspi), the menu has a second export — “Export prices to XLSX” with two views:
- “View: columns”
- each shop in its own column — handy for comparing prices across a row
- “View: rows”
- each offer in its own row — handy for filtering and summarizing
If the grid has selected rows, only those go into the file — and only the ones that pass the current filter: the selection is applied on top of the filter, not instead of it. The export limit is 1,000,000 rows; in a demo account, 100.
How to change price list rows in bulk
Select products with checkboxes and a bulk actions bar appears at the bottom. Its “All N” button selects all rows of the current filter, not just the visible page. These edits apply to price list rows; they reach product cards only through a catalog update.
| Action | What it does |
|---|---|
| “To catalog” | adds price list rows to the base catalog as new products. If the catalog category isn't set by an upload rule, the app asks you to choose it |
| “Category” | assigns a catalog category to the rows — preparation for the previous action |
| “Set value” | writes a value to a price list column in bulk |
| “Replace” | replaces part of the text in a price list column |
| “To set” | adds the selected rows to a product set |
| “More” | “Create goods receipt note” and “Add to ignore list” — for a product or a whole category |
Right-clicking a row opens a menu with the same set plus a few reference items:
- “Price product card” — everything that came in this row (item card).
- “How the product was matched” — the rule by which the row found its pair in the catalog.
- “Product markup history” — which rules applied and whether the currency was converted.
- “Add new manufacturers to the list” — adds the highlighted, unrecognized manufacturers to the directory so they're recognized from then on.
- “Add to ignore list” — so that junk from the price list is no longer loaded; see ignore rules.
- “Create goods receipt note” — a receipt document from the selected rows at purchase prices, quantity 1 per item.
What a bulk action affects
The bulk actions bar appears only when something is selected, so its scope is always the selected rows. The same items in the right-click menu work even with nothing selected. Here's what happens then:
| Right-click menu item | If no rows are selected |
|---|---|
| “Set value in bulk” | does nothing — and doesn't tell you |
| “Find and replace” | replaces text in all rows of the open source; in all-suppliers mode, in the rows of all price lists at once |
| “Change Category” | changes the category of one row — the one under the cursor |
| “Add product to base catalog” | adds one row — the one under the cursor |
“Find and replace” is the only action in this window that works on the whole price list when nothing is selected. The dialog asks what to replace with what, but not how many rows it will affect. Select rows first, then open the replace dialog.
“Set value” and “Replace” work on the column whose cell you were last in, not on a row; its name is in the dialog title. For a read-only column, the dialog doesn't open — you click, and nothing happens. The action also ends silently if your group lacks the “Edit” permission for that field.
Goods receipt: status and stock
- Only matched rows go into the document. If none of the selected rows are matched, no document is created, and the app replies: “None of the selected rows are matched to the base catalog. Only matched products can be added to the goods receipt.”
- Several rows pointing to one catalog product become one document line. The price is the highest purchase price among them.
- The quantity on each line is one; you have to correct it manually.
- The document is created unposted, and until it's posted, stock doesn't change anywhere: neither in the warehouse nor on the product card.
- The warehouse in the document is empty. The app won't let you post it without a receiving warehouse and replies “Select Recipient Warehouse”.
- Posting adds the quantity to the selected warehouse and writes a movement to the stock movement log. Unpost it, and the movement is rolled back.
How to add a supplier's new items to the catalog
Before adding, the app shows a dialog with a category choice and a summary: how many selected rows are already in which category and how many have none. Then, step by step:
- The category chosen in the dialog is assigned to all selected rows that don't yet have a pair in the catalog. You can leave the field empty, but only when all selected rows already have a category — then each keeps its own.
- Rows that have no pair in the catalog and have a category go into the catalog. A row without a category is skipped silently — that's what the “Uncategorized products” filter is for.
- Identical items are merged into one card. The merge key is the manufacturer SKU together with the name. If the “Check uniqueness by EAN” setting is on, the barcode becomes the key, and the run log gets a line saying how many items were merged.
- All other price list rows with the same key are linked to the new card, including rows of other suppliers. They get the “Product found” checkmark and won't go to the catalog a second time.
- Manufacturers of the added products are added to the directory whether or not “Add new manufacturers” is on.
- Finally, the card's completeness is calculated, field formulas are applied and the page URL is generated.
The new card gets the price and stock of the row it was created from. Choosing the best price among suppliers is the job of the catalog update, not this button.
- Start or end
- Action or result
- Decision: the path depends on the answer
If a bulk action broke off or went wrong
If a run broke off
“Set value”, “Replace” and “Category” each run as one database query for the whole set. There's no halfway: either everything changed or nothing did. The query is already on the server, and closing the window won't cancel it.
“To catalog” is a chain of steps, and it can break off between them. Then the cards created before the break stay in the catalog; they are already matched to their price list rows.
The row selection isn't cleared in that case — the last step clears it, and the run never got there. Running it again is safe and won't create duplicates: only rows without a pair go to the catalog, and the just-added ones already have a pair.
Bulk adding takes a batch processing lock while it runs. A live run refreshes the lock's timestamp as it works, and a process that crashes with an error releases the lock as it exits.
If the process was stopped before releasing the lock, later runs reply “Batch processing is already running in another process — this run was rejected”; such a lock is taken over automatically 2 hours after the last timestamp. Adding a single row takes no lock and works even during a batch update.
If you ran the wrong thing
The app doesn't keep old values: neither “Set value”, “Replace” nor “Category” logs what was there or what it was replaced with. There's no “Undo” button here.
Only one thing restores price list rows — uploading this source again. Each upload first deletes all price list rows and then writes them again from the supplier's file, so a wrong replacement disappears along with the old rows.
What is lost along with it: all manual edits to this price list's rows, not just the wrong ones, and the row selection. What survives: manual matches — they're stored in the separate “Matched products” directory, and the “Search for manually matched products” rule applies them to new rows on every upload.
Distribution rules assign categories to new rows. If this price list has no rules, the rows come back without a category — and you can't add them to the catalog in bulk until you set the category again.
If the wrong value already reached catalog cards, reloading the price list won't fix them: it repairs price list rows. The corrected values reach the cards with the next catalog update — and only for fields enabled in its “Field links”.
How many rows it can handle
Bulk actions have no row limit: each is one database query, and it doesn't matter whether there are a thousand rows or a hundred thousand. The “All N” button also selects the whole set in one query, not page by page.
The selection is stored on the server, not in the browser: it survives closing the window or reloading the page. It's cleared by “Clear selection” on the bar and by the actions that used it: adding to the catalog, adding to the ignore list, deleting rows. A price list upload also clears it for that source's rows.
What happens to a row that is gone from the price list
Price list rows don't accumulate. Each source upload first deletes all its rows and then writes again what came in the file. So an item missing from the new price list simply disappears from the list: it doesn't stay with zero stock and isn't flagged in any way.
There's one exception: if the file contained no products at all — wrong node, empty sheet, broken column mapping — the old rows aren't deleted. The source log shows “No data received, previous product list will be displayed”, and the window keeps yesterday's list. It's not “the price list didn't change” but “the price list wasn't read”: the prices are out of date.
The base catalog card matched to that row doesn't go anywhere — it lives in your catalog separately from price lists. What happens to it next depends on three catalog update settings:
| Setting | What happens to the card |
|---|---|
| “Deactivate products in the base catalog if the product is not found in price lists” | “Active” is cleared, the status is set to “out of stock”, quantity to zero |
| “Days a product stays current; after that it is deactivated” | only “Active” is cleared, and not right away, but once the set number of days has passed since the last price update; stock status and quantity stay as they were |
| “Days a product stays current; after that it is deleted” | the card is deleted from the catalog. Physically, with no rollback |
| none of the three is on | the card stays as it was — with the old price and old stock |
Both day counters apply only to cards no longer backed by any price list row, and they don't touch products with “Fixed Price” on.
How a price list fills the manufacturer and attribute directories
A price list adds two types of records to your directories: manufacturers and attributes. Both are linked to price list rows by name, not by ID — and everything else follows from that.
Manufacturers
Other spellings of a brand are linked to the right record with a synonym; a manufacturer with “Active” cleared isn't assigned to rows. How the app finds a brand and how to keep the directory clean — How to keep price list brands from cluttering the manufacturer directory; what deleting a manufacturer does to products and markup rules — Manufacturer directory.
Attributes
A price list attribute is looked up in the directory in order: first by its row in “Attribute mapping”, then by name or internal key. If nothing is found, the app creates a new attribute. That's why the supplier's “Size” and your “Diagonal” stay two different attributes until you link them in “Attribute mapping”.
To stop a supplier attribute from coming in at all, mark it as ignored in the same window: such attributes are removed from price list rows before the catalog update.
1
Attribute name from site (source)2
Base catalog attribute name3
Ignore- Attribute name from site (source) — how the attribute is named in the price list.
- Base catalog attribute name — the catalog attribute that receives the value.
- Ignore — an attribute with this flag is removed from the price list rows.
- Start or end
- Decision: the path depends on the answer
Deleting an attribute from the catalog directory is riskier than deleting a manufacturer: its values disappear from all product cards, and its row in “Attribute mapping” is left pointing at nothing. The next upload won't find that mapping, will look the attribute up by name — and, finding nothing, will create it again.
Scenarios
Add a supplier's new items to the catalog
Task: the price list has items that aren't in your catalog yet, and you need to put them up for sale.
What to do: turn on the “Unmatched products” filter, select the rows you need or click “All N” on the bar to take the whole set, and click “To catalog”. In the “Adding a new product” dialog, choose a category in “Select a category to add a product to”.
Result: each item becomes a catalog card with its row's price and stock, identical items merge into one card, and the same product's rows in other suppliers' price lists get the “Product found” checkmark. What won't happen: choosing the best supplier price — the next catalog update will re-select the card's price.
Receive a delivery from a supplier
Task: a supplier delivered goods, and you need to add them to warehouse stock at the purchase price.
What to do: turn on the “Matched products” filter, select the delivery rows and choose “Create goods receipt note” in the right-click menu. In the document that opens, choose the receiving warehouse, correct the quantities and post the document.
Result: a goods receipt with each catalog product as one line at the price list's purchase price. What won't happen: unmatched rows stay out of the document; stock won't change until it's posted, and posting needs a receiving warehouse; the product card's selling price doesn't change.
Ask a supplier for missing photos
Task: put together a list of the supplier's price list items that have no images.
What to do: open the source, turn on the “No photo” filter (if the button isn't above the grid, add it with the gear at the end of the filter row) and choose “Export products to XLSX” in the menu.
Result: a file with the price list rows that have no image link, with the columns enabled in the grid. What won't happen: if selected rows remain in the grid, only they go into the file, not the whole filtered set. Before exporting, clear the selection with the cross on the bar; its tooltip is “Clear selection”.
What to do when the window shows something unexpected
| What you see | Why | What to do |
|---|---|---|
| The list is empty | the price list hasn't been uploaded yet or was entirely filtered out by an upload rule | check the source log |
| More products than in the supplier's file | all-suppliers mode is open | select a specific source |
| Almost everything is “Not matched” | matching rules aren't set up or the price list has no SKUs | set up the rules, try AI matching |
| There's a price but no margin | no purchase price, or the markup rule didn't apply | check the “No markup” filter and pricing rules |
| The “Needs attention: matched to catalog but no category” badge | the row is linked to a product, but has no catalog category | select those rows and set the category with the “Category” button |
| The manufacturer is highlighted in red | this manufacturer isn't in the directory | menu → “Add new manufacturers to the list” |
| I deleted products and they came back | deletion here is temporary | add them to the ignore list |
| The doesn't match what's on screen | the export takes the current filter and set of columns, and if rows are selected, only those rows | clear the selection, set up the filter and columns, then export |
| I clicked “Set value in bulk” and nothing changed | no rows were selected | select rows and try again (scope of action) |
| I replaced text and far more rows changed than expected | the replacement ran with nothing selected: it went through the whole source, and in all-suppliers mode through all price lists | upload the price list again; it rewrites rows from the supplier's file (how to roll back) |
| “Batch processing is already running in another process — this run was rejected” | a run is in progress, or a lock was left by a broken-off run | wait for it to finish; a lock from a dead process is released automatically 2 hours after the run's last timestamp |
| “None of the selected rows are matched to the base catalog” | only matched rows go into a goods receipt | match the rows to the catalog first, or add them to the catalog |
| “No data received, previous product list will be displayed” | the price list file wasn't read, so the old rows stayed in place | check the source settings; prices in the window are currently out of date (what happens to a row) |
FAQ
How do I export only new, not-yet-matched products to XLSX?
Turn on the “Unmatched products” filter, make sure the counter shows the number you expect, and choose “Export products to XLSX” in the menu. The file gets the current filtered set with the columns visible in the grid.
Why do deleted products come back after a price list upload?
Deletion in this window is temporary — it removes rows from the list, not from the supplier's file. To stop items from coming in at all, add them to the ignore list.
Can I match a row to a catalog product right in this window?
No. Matching is done by rules, AI or a separate manual matching window. Here you only see the result — the “Product found” checkmark.
Whose price goes to the catalog if several suppliers carry a product?
The one the catalog update chooses based on the “Price selection type” field and supplier priorities. Until priorities are set, the cheapest one wins. Learn more: Choosing a supplier price.
Where does the margin in a row come from?
It's the share of profit in the price: price minus purchase price, divided by price. Next to it, the app calculates the margin at the RRP — how much you would earn selling at the recommended price.
How do I stop supplier attributes from creating new ones in the catalog?
“Attribute mapping” in the menu links a price list attribute to yours: the supplier's “Size” goes into your “Diagonal”, and no new attribute is created.
Where to find it and who has access
- Menu
- Directories → Processing price lists → List of price lists → source → “Products” tab
- All suppliers together
- the same tab when no specific source is selected
- Access right
- the “List of price lists” window
- Prepare
- an uploaded price list, otherwise the list is empty
- “Matched products” — the directory of links where you remove wrong matches.
- “Attribute mapping” — so that “Size” from the price list goes into your “Diagonal” attribute instead of creating a new one.
- “AI product matching” and “AI category matching” — automatic pair matching.
- “Markup settings” — the rules that turn the purchase price into your price.
- “Field formulas” — fix price list data on the fly.
- “Set up grid” — which columns to show.
- Source run log — what happened during the last upload.
The “Update my catalog” button starts a batch catalog update — it carries prices, stock and new products from price lists into your catalog.
Related topics
- If the list is empty because the price list hasn't been uploaded yet — Uploading a supplier price list.
- If almost everything is “Not matched” — Matching supplier products.
- If the data in rows is correct but product cards are out of date — Base catalog update.
- If deleted rows come back with every upload — Ignore list.
