↑↓ selectEnter openEsc close

    1. Elbuz

    How to select products for a bulk operation without catching extra ones

    11 min readUpdated

    Elbuz selects exactly the products you chose for a bulk operation — three or thousands — and shows the count upfront.

    When you need this:

    • Change all found products — “Select all products” takes the whole filtered set, not just visible rows.
    • Select dozens of rows in a row — Ins selects a row and moves the cursor down.
    • Unsure how many products an operation affects — the server counts the number in brackets by the menu item.
    • Replace with nothing selected — the dialog names the scope and asks for a confirmation checkbox.

    Where to start: check the “Selected” counter below the grid; if it isn't zero, press Ctrl+Shift+A.

    What selection can do

    Selections are stored on the server and don't clear by themselves — why this matters is explained in “Filtering and selection”.

    How to select products

    There are several ways to select products, and all of them write to the same table on the server.

    Ways to select and unselect
    ActionWhat it does
    Checkbox in the “Selection” columnselects one row; sent to the server immediately
    Ins keyselects the current row and moves the cursor one row down — this way you select rows in a row without touching the mouse
    Shift+↑ and Shift+↓the same, moving up or down
    “Select all products” in the right-click menuselects the whole current filtered set, not only the visible rows; the number is shown in brackets
    “All N” in the bar at the bottomthe same; the button appears when fewer products are selected than the filtered set contains
    “Unselect all products”, the cross in the bar or Ctrl+Shift+Aclears all selections

    As soon as at least one product is selected, the bulk actions bar slides up at the bottom: “Selected: N”, then “Category”, “Value”, “Replace”, “Add to set”, “XLSX”, copy, delete and a cross. What the bar shows depends on permissions — who has access. The bar itself is a reliable sign: no bar means no selection.

    The same bar appears on its own as soon as you open a window with old selections. If you see it right after opening, the selections are left over from last time.

    Bulk action bar under the product grid with three rows selected
    1Selected: 3
    2All 885
    3Clear selection
    1. Selected: 3 — the number of rows ticked in the Select column.
    2. All 885 — selects every product of the category on the server; do not click it unless you mean it.
    3. Clear selection — the cross at the right end of the bar removes all ticks.

    Grid keyboard shortcuts

    Keys that work in the product grid
    KeyAction
    Insselect a product and move one row down
    Shift+↑ / Shift+↓select and move up or down
    Ctrl+Aselect the whole current filtered set — same as the “Select all products” item
    Ctrl+Shift+Aclear all selections
    F4open the product card
    F8delete the product — the same operation as the trash icon in the toolbar
    Ctrl+Dshow matched price list products
    Ctrl+Ureset grid filters

    Ctrl+A selects the whole current filtered set — just like the “Select all products” menu item, and it erases the previous selection the same way. Keep this in mind: the key sits next to the ones you use to edit text in a cell.

    F8 deletes. It doesn't open the card or ask whether you pressed the wrong key — it goes straight to the delete confirmation. And if products are selected, it deletes all selected products, not the row under the cursor.

    What “Select all products” actually selects

    The “Select all products” item sends the whole current filtered set to the server — all five of its parts: the chosen category, column filters, active filter buttons, dropdown filter values and the search string. The server erases your previous selection and builds a new one from these conditions.

    That's why the number in brackets next to the menu item matches the number you get. On the demo database it looks like this:

    The “Processors” category, demo database
    What's on screenProducts
    Category without search — the “Total” counter882
    Same category, “Intel” typed in the search483
    How many “Select all products (483)” selects483

    A dropdown filter works the same way: pick one value in the “Brand” list, and only that brand's products get selected, not the whole category. The server counts the same number when the user group has a filtering rule: products forbidden to the group don't get selected.

    The item erases the old selection completely — before building the new one. “Select all products” means “replace the selection”, not “add to the current selection”. Both requests run in one transaction: if the new set fails to build for some reason, the old one stays in place.

    After clicking, still check the “Selected” counter: it shows exactly the number the operation will get.

    The Ctrl+A shortcut does the same, and Ctrl+Shift+A unselects all products.

    How many products each operation affects

    Operations run from the right-click menu, the bulk actions bar at the bottom or the toolbar menu. Their scope differs — and the difference isn't written anywhere in the interface.

    Operations on values have a second scope dimension — the column. “Set value in bulk” and “Find and replace” work on the column you clicked before calling them; its name is shown in the dialog title. If you haven't clicked any cell, both items do nothing and say nothing.

    What an operation gets
    OperationWhen nothing is selectedWhen products are selectedUndo
    Editing in a cell (double-click)one rowstill one row — selections are ignoredno
    “Set value in bulk”one row under the cursorall selectedyes, except photos and the “Price” column in “+/-”, “%”, “*” modes
    “Find and replace”the whole category with subcategories; at the tree root — the whole catalogall selectedyes
    “Change product category”one productall selectedno
    “Delete product” (trash icon, menu, F8)one rowall selectedno
    “Export products to XLSX file”category, column filters and filter buttonsthe same, but only selected onesnot needed
    “Add products to set”nothing: Elbuz asks you to select productsall selected; the dialog shows the first thirty and the total numberno
    “Add to price monitoring”the whole current filtered set; if nothing is set at all — the whole catalog, and the dialog warns about itonly selected onesno
    “Catalog duplicates”the current filtered setonly selected ones — checkboxes narrow the set here toono — opening the window changes nothing, but merging inside it deletes cards permanently
    Right-click context menu of the product grid with two rows selected
    1Select all products (885)
    2Set value in bulk (2)
    3Find and replace (2)
    4Delete product (2)
    1. Select all products (885) — the number in brackets is all products of the current selection.
    2. Set value in bulk (2) — works on the two ticked rows.
    3. Find and replace (2) — works on the two ticked rows.
    4. Delete product (2) — deletes the two ticked rows and cannot be undone.

    The operations themselves are covered step by step elsewhere: setting values and changing the category — in “Bulk changes in the catalog”, text replacement — in “How to replace text in names and descriptions”, deletion — in “How to delete or disable products”. Only the scope matters here, and the “Find and replace” row deserves its own section.

    What “Find and replace” does with nothing selected

    Two neighboring items in one menu treat an empty selection in opposite ways. With nothing selected, “Set value in bulk” changes the row under the cursor, while “Find and replace” runs across the whole category, subcategories included. With the tree root chosen there's no category at all — the replacement covers the whole catalog in one request.

    The replacement dialog warns about this out loud. It names the column in the title and prints the scope with the number of products — one of three messages:

    • “The replacement will apply to the selected products: N.” — when products are selected;
    • “No products selected - the replacement will apply to the WHOLE chosen category and its subcategories (N). Tick products to narrow it down.”;
    • “No products selected and the tree root is chosen - the replacement will apply to the WHOLE catalog (N). Tick products or choose a category.”

    In the last two cases the dialog shows the “Yes, apply to all products in this scope” checkbox; without it nothing is sent. The server checks this too and rejects a request with no selection and no confirmation. Still, the rule is simple: before opening “Find and replace”, check the “Selected” counter. Zero means “across the whole category”.

    The search string and the filters above the grid don't narrow this scope. So if search or any filter is on in the grid and nothing is selected, the replacement dialog doesn't open at all. Instead, a red message appears:

    “A search or filter is active in the grid but no rows are selected: the replacement would apply to the whole category, not to the visible products. Select the rows you need (“Select all” respects the filter) and try again.”

    Select the found products with “Select all products”, or turn off search and filters if you really need the replacement across the whole category.

    The left branch has a selection and needs no confirmation checkbox; the two right branches have no selection, so the replacement waits for the checkbox. With nothing selected and search or a filter on, the dialog doesn't open. The bar with “Undo” appears only when the replacement actually changed something
    yesnoyesnoyesno, rootnoyesyesno“Find and replace” on the columnyou clickedIs the “Selected” counter abovezero?Scope — selected productsIs search or a filter on in the grid?The dialog doesn't open, a redmessage asks you to select rowsIs a category chosen in the tree?Scope — category withsubcategoriesScope — whole catalogIs “Yes, apply to all products in thisscope” checked?The replacement isn't sentOld values are saved for undo, newones are written, the “Exported” flagis cleared on changed productsDid at least one product change?Bar “N products changed” with the“Undo” buttonNo undo record is kept
    • Action or result
    • Decision: the path depends on the answer

    How to check the selection before an operation

    Four things that actually work.

    1. The “Selected” counter and the number in brackets in menu items — this is exactly the number of rows the operation will get. It's counted by the server, not the screen.
    2. The bulk actions bar at the bottom appears only when the selection isn't empty. No bar — the operation runs on one row. Or, for “Find and replace”, across the whole category; and with search or a filter on, the replacement dialog won't open without a selection.
    3. “Unselect all products” before you start — the only way to guarantee there are no old selections. Ctrl+Shift+A does the same.
    4. Sorting the “Selection” column in descending order — click the header twice — gathers selected rows at the top so you can look them over. The first click does the opposite and puts unselected rows on top. You can't filter the grid by this column, only sort it.

    Before a bulk operation

    Run any operation that's new to you on about ten products you selected by hand first. Once you see the result, you can go for the whole category.

    Scenarios

    Select all products found by search

    Choose a category, type a word in the search string and open the right-click menu. The number in brackets next to “Select all products” equals the “Total” counter.

    • All found products in the category get selected, not just the visible rows.
    • Old selections are erased before the new set is built.

    Build a selection from several categories

    Select products in each category with checkboxes or the Ins key, moving through the tree from category to category.

    • Selections from all categories add up to one set: the “Selected” counter counts them across the whole catalog.
    • “Select all products” doesn't fit here: in the second category it erases the selections from the first.

    See what exactly is selected

    Click the “Selection” column header twice.

    • Selected rows gather at the top of the grid, where you can look them over.
    • Selections outside the current category aren't visible this way: reset the category with the cross on the chip above the grid.

    What to do when the wrong products got selected

    What you seeWhyWhat to do
    You clicked “Select all products” in a second category, and the selections from the first one disappearedThe item doesn't add to the selection but replaces it: old selections are erased before the new set is builtA set from several categories has to be built by hand — with checkboxes or the Ins key (what “Select all products” selects)
    “Select products to add them to the set!”Nothing is selected — Elbuz asks the server about selections, not about visible rowsSelect the products you need with a checkbox or the Ins key (how to select)
    The set dialog lists thirty products and the line “...and N more items”This is by design: the dialog shows the first thirty selected, and at the bottom — “Total going into the set: N” with the full numberCompare this number with what you expect; if it's larger — cancel and unselect the extra products (operation scope)
    “No selection set — the whole catalog will go to monitoring (N). Apply a filter or tick the products.”“Add to price monitoring” was called without any filter and without a selectionApply a filter or select products and try again
    The exported has exactly 100 rowsDemo account: exports there are limited to a hundred rowsWork in a live account

    FAQ

    How do I make sure a bulk operation runs on exactly the right products?

    Check the “Selected” counter below the grid and the number in brackets in the menu items — it's the same number, and that's exactly what the operation gets. The server counts it, so the number of visible rows means nothing.

    I typed a word in the search and clicked “Select all products”. What gets selected?

    Exactly what the grid shows: the category with subcategories, filters and the search string. In the “Processors” category with 882 products, searching for “Intel” leaves 483 — that's how many get selected. Previous selections are erased.

    Does “Select all products” add to what's already selected?

    No, it replaces it: the old set is erased and a new one is built from the current filtered set. A set from several categories is built with checkboxes or the Ins key.

    What happens if I run “Find and replace” with nothing selected?

    The dialog names the scope — the whole category with subcategories or the whole catalog — and won't send the replacement without the “Yes, apply to all products in this scope” checkbox. With search or a filter on, the dialog won't open without a selection (replacement without a selection).

    Can I filter the grid to show only selected products?

    No, the “Selection” column can only be sorted: two clicks on the header gather the selected rows at the top (checking before an operation).

    Where it is and who has access

    Menu
    Directories → Base product catalog → Products, the “Selection” column
    Other entry points
    right-click menu, the bulk actions bar at the bottom, the toolbar menu
    Access right
    the “Products” window; “Select all products” has no separate permission
    Prepare
    a filtered set of products — tree, search, filters

    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