↑↓ selectEnter openEsc close

    1. Elbuz

    How to work with the product list in the catalog

    9 min readUpdated

    The “Products” window shows your whole catalog in one grid: filter, select, and change hundreds of products in one operation instead of one by one.

    When you need this:

    • Hundreds of products lack a price — a filter button finds them, “Set value in bulk” prices all selected.
    • Raise one brand's prices — filter by brand; the “%” mode recalculates them.
    • A typo in category names — “Find and replace” fixes it in every name.
    • Selections left from yesterday — the “Selected” counter shows them before an operation.

    Where to start: filtering vs. selection, then the “Selected” counter below the grid.

    What the “Products” window can do

    Catalog work always follows one path: filter, select, change. Each step has its own article.

    • Find products — the category tree, search bar, filter buttons and column filters narrow the list down to what you need.
    • Select products — with a checkbox, the Ins key or the whole filtered list at once; this is also where you see how many products each operation will affect.
    • Change in bulk — one value, a price with markup or a category for all selected products.
    • Replace text — a word in names, descriptions and attributes, with undo available for 24 hours.
    • Delete or disable — what disappears along with a product and how to remove a product from exports without losing it.
    • Check catalog status — how many products lack photos, prices and attributes, price movement over a period, and export to Excel.

    Filtering and selection are different things

    Filtering is what the grid shows right now. It's set by four independent things: the category in the tree, the filters above the grid, column filters and the search bar. Together they give the number in the “Total” counter in the bar below the grid. How to set them is covered in “How to find products in the catalog”.

    Selection is the checkboxes in the “Selection” column. Their number appears in the neighboring “Selected” counter. Here's what you need to know about these checkboxes:

    • Selections are stored on the server, not in the window — in a separate table tied to your user account. Two open catalogs share one set of selections.
    • Closing the window doesn't clear them. Neither does signing out. There's no clearing at sign-in and no nightly cleanup: a selection stays until you clear it or run an operation that takes the selections over, such as adding to a set or deleting.
    • The “Selected” counter ignores all filter conditions. It counts all your selections across the whole catalog, regardless of which category you're in or what you typed in search.
    • The catalog grid and the product matching window have separate sets of selections. Products selected for editing won't end up in linking with a price list.
    Status strip under the grid: Total and Selected counters
    1Total
    2Selected
    1. Total — products shown in the grid for the current category and filters.
    2. Selected — products that a bulk operation will receive.
    Two independent paths: filtering shows the list on screen, selection decides what a bulk operation gets
    only when no product isselectedCategory in the treeFILTERING: “Total” counterwhat the grid shows right nowFilters above the gridColumn filtersSearch barCheckbox in the “Selection” column,Ins, Shift+arrowsSelections are stored on the serverunder your user account“Select all products”SELECTION: “Selected” counterstays after the window is closedBulk operation: set value,find and replace, change category,delete
    • Action or result
    • Stored data

    This section protects you from this mistake. Yesterday you selected five hundred products and didn't finish with them. Today you opened the catalog, switched category, filtered three products and clicked “Set value in bulk”. The operation runs on yesterday's five hundred, not on the three on screen. What can be undone is covered in “What can be undone”.

    Checking takes a second: look at the “Selected” counter in the bar below the grid. If it isn't zero but you meant to work with three rows, press Ctrl+Shift+A or choose “Unselect all products” in the right-click menu, and start from a clean slate.

    The full routine before an operation is in the “Check before an operation” checklist.

    Scenarios

    Set a price for products that have none and keep updates from overwriting it

    Choose a category in the tree, click the “Products without price” filter button, then “Select all products” in the right-click menu. Click a cell in the “Price” column and open “Set value in bulk”. Keep the “Fixed” mode, enter the price and leave “Set the “Fixed price” flag” on. If needed, fill in “Date to remove the “Fixed price” flag”.

    • All selected products get the price, not just the visible rows, and all of them get the “Fixed price” flag: a base catalog update won't overwrite their price.
    • The “Set the “Sale product” flag” checkbox in this dialog is also on by default. If you don't clear it, all selected products become sale products.
    • After the change, a “N products changed” bar with “Undo” pops up at the bottom, and the operation also stays in “Recent actions”. Undo restores the old price, but it doesn't remove the “Fixed price” and “Sale product” flags the dialog set.

    Raise prices for one brand by a percentage

    Choose a category, pick the brand in the “Brand” filter list, then “Select all products”. Click the “Price” column, open “Set value in bulk”, choose the “%” mode and enter the percentage; a minus lowers the price. “Rounding step” rounds up: with 10, a price of 103.21 becomes 110.

    • Only selected products with a price above zero are recalculated. Products with a zero price stay at zero.
    • The “+/-” (add an amount) and “*” (multiply by a factor) modes work the same way.
    • These modes can't be undone. Before running, compare “Selected” with the number of the brand's products.

    Fix a word in the names of a whole category

    Press Ctrl+Shift+A so no selections are left, choose the category and click a cell in the “Name” column. Open “Find and replace”, fill in “Find” and “Replace”, read the scope line and tick “Yes, apply to all products in this scope”.

    • The replacement runs across the whole category, subcategories included. If search or a filter is on in the grid, the dialog won't open without selections — a red message asks you to select rows. To replace only in the products found, select them with “Select all products” — then the replacement runs on the selected ones.
    • The “Exported” flag is cleared only on products whose name actually changed. On the rest, the replacement leaves the flag as is, so because of this replacement a template with “Only export new data” won't pick them up.
    • After the replacement, “N products changed” with an “Undo” button pops up at the bottom. If nothing changed, there's no bar.

    What to do when the grid doesn't behave as expected

    What you seeWhyWhat to do
    You've just opened the window, and the “Selected: N” panel is already showing at the bottomThe was kept from last time: selections are stored on the server and aren't cleared by closing the window or signing outPress Ctrl+Shift+A or “Unselect all products” (filtering and selection)
    “Select product”The AI text generator or the landing page was called without an active row: both work on a single productHighlight a row with a left click
    “Operation failed!”The server rejected the edit: the field is read-only for your group, or the chosen value isn't in the column's directoryAsk an administrator to open the field for editing; in a directory column, pick a value from the list instead of typing it (who sees what)
    A cell edit isn't saved, and there's no error“Disable editing” is on in the grid settings, or the group has no right to edit this fieldTurn off the switch in the grid settings or give the group the right (who sees what)

    FAQ

    Why does “Selected” show a number when I haven't selected anything?

    Selections are stored on the server under your user account and aren't cleared when you close the window or sign out. The number is everything you selected earlier and didn't clear. Ctrl+Shift+A or “Unselect all products” clears them all.

    Can I undo a bulk change?

    Partly: “Find and replace” and “Set value in bulk” on selected products are undone with the “Undo” button or from “Recent actions” — the last five operations within 24 hours. Deletion, category changes, photos and prices in the “+/-”, “%” and “*” modes can't be undone (what can be undone).

    Does the grid calculate prices itself?

    No. Prices come from pricing rules, and values from price lists reach the catalog during a base catalog update. The grid shows and changes what's already in the catalog.

    Can I change products in plain words, without the grid?

    Yes, through the AI consultant in the “Products” window: it prepares a plan with the number of products and an “Apply” button — see “Catalog status” and edits through the consultant. You can't delete products from the chat.

    Can my colleagues see my selections?

    No. Selections are tied to your user account: each employee has their own set, and two catalogs you have open share one set. The catalog grid and the product matching window have separate sets.

    Where to find it and who has access

    Menu
    Directories → Base product catalog → Products
    Other entry points
    desktop shortcut, “Catalog analytics”, a metric in the export summary
    Access right
    the “Products” window; separately — adding, deleting, changing the category, side panel
    Module
    not required; translation appears once you have two languages

    The “Products” window is your .

    The window opens maximized to the whole desktop and stays just as fast on a catalog of half a million products: the browser receives only the visible rows, and the rest load as you scroll.

    Wherever another window asks you to pick a product, the same grid opens in selection mode: the toolbar is trimmed and cell editing is turned off.

    Products window with the category panel, the Processor category selected and the status strip under the grid
    1Category panel
    2Search box
    3Filters
    4Total
    5Selected
    1. Category panel — the category tree; clicking a category reloads the grid.
    2. Search box — search by name, SKU, MPN, brand or ID.
    3. Filters — opens the filter panel above the grid; the chip next to it shows the current category.
    4. Total — how many products the grid currently holds.
    5. Selected — how many products are ticked for bulk operations.

    Global search (Ctrl+K) also finds products, but it opens the product card, not the grid. If you need a list rather than one product, go to the “Products” window.

    Apart from the right to the window, there are separate rights for fields and a filter rule:

    • A read-only field can't be changed by cell editing or by a bulk operation: the server checks the right on every edit.
    • A filter rule in group permissions narrows the catalog itself for a group: “Select all products” won't select what the rule hides, replacement runs only on allowed products, and deletion clears the selection from forbidden ones.

    Field rights also apply in the product card: a field without “View” isn't shown there, and a field without “Edit” opens as read-only. The search bar, filters, “Select all products”, “Find and replace” and export to can't be restricted by separate rights.

    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