↑↓ selectEnter openEsc close

    1. Elbuz

    How to change a value, price or category for many products at once

    19 min readUpdated

    Elbuz changes all selected products in one operation: writes a value, recalculates the price or changes the category, with no card-by-card editing.

    When you need this:

    • A sale on a group of products: the “%” mode lowers prices, and “Fixed Price” keeps price list updates from restoring them.
    • A characteristic for hundreds of products: an attribute column in the grid takes a value like any field.
    • Moving products to a new category: “Change product category” rewrites the categories of every selected product.
    • A wrong value was written: “Undo” rolls it back within 24 hours.

    Where to start: select the products, click a cell in the column you need and right-click.

    What bulk changes can do

    How many products an operation affects depends on the selection and on the operation itself: see the scope table. Deleting products has its own article: “How to delete or disable products”.

    How to write one value into many products

    The operation writes one value into one column of all selected products. You don't pick the column in the dialog; it uses the column of the cell you clicked before opening the menu. Its name is in the field label: “Enter a value for the field - Name”. If you haven't clicked a cell, the menu item does nothing.

    You can change only what is editable in the grid. Calculated columns such as markup, date created and view count can't be changed, and the menu item simply won't work on them. If the field you need isn't in the grid, turn it on in the column settings: you can't bulk-change what the grid doesn't show.

    The left branch is an empty value, where “Images” asks about deleting photos. The bottom fork shows when you get “N products changed” with the “Undo” button after the write, and when the grid simply refreshes
    yesconfirmednoyesnono: no right to the fieldor the value isn't in thelookup listyesyesno“OK” clicked in the “Set value” dialogIs the value empty?Question “Do you want to clear thevalues in the selected field?”for “Images”: about deleting allphotosAre any products selected?The change applies to all selectedproductsThe change applies to the row underthe cursorDid the server allow the change?“Operation failed!”no product changedValue written“Date updated” set to now,“Exported” clearedSelected products and a regularvalue,not “Images” and not a “+/−”, “%”, “*”price recalculation?“N products changed” and “Undo”if the value changed for any productThe grid simply refreshes, no undo
    • Action or result
    • Decision: the path depends on the answer

    Four different dialogs

    The window looks different depending on the selected column.

    Column typeWhat you'll see
    regular text or number fieldan input with suggestions: the program offers values that already appear in this column
    lookup field or flaga drop-down list instead of an input, so you can't misspell a value
    “Images”a file picker: one photo for all selected products, up to 350 KB, images only
    “Price”a separate window with markup modes, described below

    Product characteristics change the same way: turn on attributes of the selected category in the grid, click the column with the characteristic you need and open the same menu item.

    An empty value doesn't mean “skip”, it means clear the field. The program asks again, but for the “Images” column the question is different and more serious: all photos of the selected products are deleted together with their files, and you can't get them back because there are no photo backups.

    How to recalculate prices with a markup

    The “Price” column opens an extended dialog. You can choose one of four modes:

    Set value dialog for the Price column with markup modes, rounding step and flags
    1Fixed, +/-, %, *
    2Rounding step
    3Set the “Fixed price” flag
    1. Four modes — substitute a number, add, add a percentage, multiply.
    2. Rounding step — rounds the price up to a multiple of this value.
    3. Set the “Fixed price” flag — without it a price list update would restore the previous price.
    ModeWhat it does
    “Fixed”sets the price to the number you enter, the same for all selected products
    “+/−”adds the number to the current price; with a minus, subtracts it
    “%”adds a percentage to the current price; with a minus, lowers it
    “*”multiplies the price by the number; with a minus, divides by it

    The “Rounding step” field rounds the result up to the nearest multiple: with a step of 5, a price of 103.21 becomes 105.00; with a step of 10, it becomes 110.00.

    Two flags are set with the price and are on by default. “Fixed Price” keeps the next catalog update from price lists from overwriting the new price; without it, the supplier's price comes back. “Sale product” marks the product as on sale. “Date to remove the “Fixed price” flag” removes the protection automatically when the sale ends.

    The three recalculation modes (“+/−”, “%”, “*”) work only with products whose price is greater than zero. They silently skip products with an empty or zero price: there is nothing to multiply. To set a price for such products, use the “Fixed” mode.

    The “Fixed” mode on selected products can be undone like a regular value write. Recalculation with “+/−”, “%” and “*” can't be undone. For regular pricing, a bulk operation isn't the best tool anyway: use markup rules, which are applied automatically at every catalog update.

    How to change the product category

    The menu item opens a category tree listing the categories the selected products already have. Check all categories where the product should appear on the website, and check “Main category” for exactly one of them. The program won't save without a main category, or with two main categories at once.

    By default, the operation replaces the set of categories instead of adding to it: all previous links of the selected products are deleted, and only the ones you just checked remain. If you need to change only the main category and keep the other links, turn on “Change only main category”.

    With it, each selected product is linked to the new main category, and the link to the former main category is removed if its checkbox in the tree isn't checked. The product's other categories stay as they were, and additional categories checked in the tree aren't added in this mode.

    The main fork is the “Change only main category” flag: without it, the set of categories is rewritten from scratch; with it, the set stays. If the server didn't accept the change, the window stays open and the selection is kept
    nonetwo or moreoneno: connection dropped orserver rejected ityesoffon“Save” clicked in the categorychange windowHow many categories have the“Main category” flag?“You must select a main category!”“There can only be one maincategory!”Did the server accept the change?“Operation failed!”the window stays openthe grid selection is kept“Change only main category” flag?All product-category links aredeletedChecked categories are added oneby oneThe main category is set“Exported” clearedA link to the new main category isaddedthe link to the former main categoryis removedif it isn't checked in the treeother links stayProduct options get the mainproduct's categoriesThe window closesthe grid selection is cleared
    • Action or result
    • Decision: the path depends on the answer

    Product options move together with the main product; you don't need to select them separately. A category change can't be undone.

    A product isn't limited to one category in the tree: it belongs to a category through a link and is shown on the website in every category that's checked. The main category is needed for the page URL and breadcrumbs.

    What you can undo

    Only two operations can be undone, and with limits:

    • Only two operations can be undone: “Find and replace” and “Set value in bulk”, the latter only when it ran on selected products.
    • Can't be undone: deletion, category change, bulk photo upload, and prices in the “+/-”, “%”, “*” modes. A “Fixed” mode price is rolled back, but the “Fixed Price” and “Sale product” flags set by the dialog stay. A replacement in “Manufacturer” is rolled back with its directory link, but the manufacturer it added to the directory stays.

    Don't count on undo as insurance: it protects you from a mistake you just made, it isn't a backup.

    Bulk changes: what happens if a run is interrupted and how to undo it

    Products change in bulk in three ways: “Updating base catalog” from price lists, “Set value in bulk” and “Find and replace” in the catalog grid, and the “Apply formulas” button. None is all-or-nothing: each writes changes in parts, and an interruption leaves exactly what was already written. Undo differs for each, so they are covered separately below.

    Which products the operation affects

    • “Set value in bulk”: if products in the catalog grid are selected with checkboxes, the value is written to all selected products, not only to those visible on the current page. If nothing is selected, only the row under the cursor changes.
    • Your selection is kept until you clear it. A product you selected earlier and then hid with a filter or left on another page is still affected by the operation. The “select all” button selects everything in the grid's current filtered set: the category, column filters and the search box, and it clears the previous selection.
    • “Find and replace”: if nothing is selected, the replacement runs across the whole selected category with its subcategories, and if the tree root is selected, across the whole catalog. Column filters and grid search do not narrow this scope. So if search or a filter is active in the grid and no rows are selected, the replace dialog does not open. 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.” Without search or filters, the program asks you to confirm a category-wide replacement with a separate checkbox.
    • “Updating base catalog” ignores selections in the price list grid. It processes the whole selected price list or all price lists at once. You can narrow it only with conditions on the “Additional” tab of the update settings.

    The program has no limit on the number of products in one operation.

    How to undo a bulk change in the catalog grid

    After “Set value in bulk” and “Find and replace”, a “N products changed” message with an “Undo” button appears at the bottom for 15 seconds. You can also do this later: the clock button in the catalog window opens the “Recent actions” list, and you can undo any operation from it.

    • If someone has already changed the field in a product after your operation, undo leaves that product alone. The message shows how many such products were skipped: “(N skipped — changed since)”.
    • If the operation changed nothing (all products already had that value), there is nothing to undo, and no button appears.
    • The program keeps only your last five bulk operations, and none older than one day. A sixth operation pushes out the oldest undo, and operations older than 24 hours disappear from the list.
    • No undo is recorded when “Set value in bulk” changes only the row under the cursor (nothing selected), when a price is set as a markup rather than a number, or when the “Images” column is cleared. Clearing images deletes product photos together with their files, and they cannot be restored.

    Updating base catalog: interruption and rerun

    The update runs in stages: prices and product fields, adding new products, stock and status, profit, photos and others. Each stage is written to the catalog right away, separately from the next ones. There is no single undo for the whole run.

    • If you click “Stop”, the run stops at the nearest point between stages, not in the middle of one: a stage that has already started runs to the end. The log shows “Import interrupted by the user!”. What earlier stages managed to write stays in the catalog.
    • If the run breaks off on its own (server failure, error), what was written before that also stays. There is no completion message in the log then: the last line is the stage where everything stopped.
    • If you start an update while the previous one is still running, the second start is rejected with the message “Batch processing is already running in another process — this run was rejected”. While a run is in progress, it refreshes its lock between stages, so a second start cannot take it over. When a run finishes, including a crash on an error, the lock is released at once, and you can start a new run without waiting. Only if the process on the server was killed or the server restarted does the lock remain. New starts are then rejected until two hours have passed since the interrupted run started or since the last stage it completed.
    • If a scheduled price list import is in progress, a manual update start is rejected with the message “Scheduled price list import is in progress — catalog update start was rejected”.
    • A rerun recalculates products from price list data with the same settings. It does not restore what the interrupted run already erased. If a field in the update settings has “Clear catalog field before updating” checked, that field is erased at the prices and product fields stage, right before new values from the price list are written, and only when “Update products” is on. It is erased only in products matched to the price list being updated (all catalog products when updating from all price lists), subject to the conditions on the “Additional” tab. Products marked “Do not update” are not cleared, and products with “Fixed Price” keep their price fields. The field stays empty in every product the run does not write a new value to after clearing. This happens if the run breaks off between clearing and writing, if a product is in none of the price lists when updating from all of them, if the price list row fails the write conditions for that field (empty cell, logical condition), or if the field mapping row itself is disabled but its clear checkbox is left on.

    If “Days a product stays current; after that it is deleted” is filled in the update settings, products missing from price lists for that many days are permanently deleted from the catalog. There is no undo for this, and the change log will not bring them back either.

    Applying formulas

    The “Apply formulas” button recalculates fields using all active formulas, each one separately. If a formula has an error, the program skips it, runs the rest, and then shows a list of formulas that failed. This operation has no undo button: to restore values, fix the formula and apply it again.

    What the log shows and how to find what changed

    • “Operation log” shows the update's progress by stage: how many products were updated, how many were added, when the operation was interrupted. It does not list product names. Log lines are kept for 14 days, and operation summary cards for 90 days.
    • To see which products changed and what value they had before, use the “Operation history” tab, but only if the “Value change history” setting is on. If it is off, the catalog update records no details at all.
    • For a catalog update, history is recorded only when the run reaches the end. A run stopped with the “Stop” button or broken off by a failure does not appear in history.
    • In “Operation history”, previous field values are restored one product at a time, with the button in the row. There is no bulk restore there. History records are kept for 7 days.

    How an interruption affects “Find and replace” specifically, and whether it's safe to repeat the replacement, is covered in “How to replace text in product names and descriptions”.

    What happens after you run it

    None of the three operations goes into the background job queue. The program runs it in a single request to the server while “Processing data, please wait...” is on screen, or, in the category change window, a progress indicator under the “Save” button. The grid refreshes only after the server responds.

    How to see that the change happened

    • “Set value in bulk” on selected products shows “N products changed” at the bottom only when a ready value is written to the column. If you recalculated “Price” with “+/−”, “%” or “*”, added or cleared “Images”, or changed only the row under the cursor, there's no counter: the grid simply refreshes.
    • The program sets the current date in the “Date updated” column for all selected products and clears the “Exported” flag, even for products whose value didn't change. Filtering the grid by these two columns shows which products the operation touched. “Change product category” does the same.
    • “Change product category” doesn't show a count. After a successful save, the window closes and all products in the grid are deselected, so the “Selected” counter drops to zero. To repeat the operation on the same products, select them again.
    • If the server rejected the change (your group has no right to change this field, or the selected value isn't in the column's lookup list), “Operation failed!” flashes and disappears together with the waiting message, and no product changes.
    • If the connection to the server drops during “Set value in bulk”, you'll see “Operation failed!” and the grid won't refresh. Refresh the grid and check the column before running it again.
    • In the category change window, a dropped connection or a server rejection ends with “Operation failed!”: the window stays open, the selection in the grid is kept, and the “Save” button becomes available again.

    Is it safe to repeat

    • Writing the same number or text again with “Set value in bulk” gives the same result; nothing is added twice.
    • The “+/−”, “%” and “*” modes calculate from the current price. Running them again adds the markup to the already changed price once more, and these modes can't be undone. Before repeating after an interruption, check in the grid whether the prices have already changed.
    • “Change product category” without “Change only main category” works in steps: it deletes all category links of the selected products, adds the chosen categories one by one, then sets the main one. If interrupted between steps, products may lack some or all chosen categories. Rerunning with the same categories is safe: it deletes and rewrites the links.

    When changes reach exports and the website

    Bulk operations don't export anything themselves and don't queue an export. New prices, values and categories reach the website or marketplace at the next export run: manual or on the schedule set for that export.

    The cleared “Exported” flag matters for exports with “Only export new data” on (tunnel, , CommerceML, ). They take only products without this flag. “Set value in bulk” clears it on all selected products, “Find and replace” only where the replacement actually changed something. With this option off, an export sends its whole product selection, changed products included.

    How to stop an update from overwriting your edit

    An edit in a cell is written to the product immediately and isn't protected by anything on its own. There's one exception: if you enter a price greater than zero in a cell, the program sets the “Fixed Price” flag on the product automatically.

    After that, two things can go through the same products.

    • A bulk operation in the grid, “Set value in bulk” or “Find and replace”, overwrites the field in all products in its scope, including those you edited by hand. These two operations don't check the “Fixed Price” and “Do not update” flags.
    • The base catalog update overwrites the fields checked in its settings with values from the price list. To keep your value, use product flags:
      • “Do not update”: the update skips the product completely, including prices, fields, stock and status;
      • “Do not update attributes” and “Do not update photo” protect only the characteristics or only the photos; the update changes the rest of the product;
      • “Fixed Price”: the price, RRP, purchase price and old price, as well as the supplier link, stay yours; the update changes the other fields. If “Date to remove the “Fixed price” flag” is filled in, the flag is removed at the first catalog update after that date;
      • for a single field, the update settings have the “Update if value is empty in base catalog” mode: the update then fills the field only where it's empty or zero and leaves the values you entered alone.

    These flags are grid columns, so you can also set them in bulk: select the products and run “Set value in bulk” on the column you need.

    Scenarios

    Lower prices on a group of products for a sale

    What to turn on. Select the products, click the “Price” column, open “Set value in bulk”. Choose “%” with a negative number, e.g. -10. Leave “Set the “Fixed price” flag” and “Set the “Sale product” flag” on, and put the sale end in “Date to remove the “Fixed price” flag”. For round prices, fill in “Rounding step”.

    What you get. Each selected price drops by 10% of the current one, the products get the fixed price and sale flags, and the catalog update from price lists won't overwrite the new price. After the date, the first catalog update from price lists removes the “Fixed Price” flag, and the price follows the supplier again.

    What won't happen. Products with a zero or empty price won't change. You won't see the “N products changed” counter or the “Undo” button: a price change can't be undone, so check the result on two or three products first. Running it again lowers the prices once more.

    Move products to a new category and remove them from the old ones

    What to turn on. Select the products and open “Change product category”. Uncheck the old categories, check the new one and set it as “Main category”. Leave “Change only main category” off.

    What you get. The selected products keep only the checked category, and it becomes the main one. Product options follow the main product. Price list rows matched to these products also get the new category. The products lose the “Exported” flag, so they go into the next export with “Only export new data”.

    What won't happen. The window won't show how many products changed and won't offer an undo. After a successful save, the products in the grid are deselected.

    What to do when a change goes wrong

    What you seeWhyWhat to do
    The menu item doesn't open a dialogthe column isn't editable, or no cell was selectedclick a cell in the column you need; calculated fields can't be changed
    One product changed instead of allthe products weren't selected, so the operation took the row under the cursorselect the products with checkboxes and repeat
    The price wasn't recalculated for some productsthe skipped ones have a zero or empty priceset their price with the “Fixed” mode
    The next day, prices went back to the old onesthe “Fixed Price” flag was off, and the price list update overwrote the pricerepeat with the flag on, or set up the markup as a rule
    Products disappeared from all categories except onethe category change replaced the set of linksset the categories again; next time turn on “Change only main category”
    All product photos disappearedan empty value was written to the “Images” columnthey can't be restored; upload the photos again
    “Do you want to clear the values in the selected field?”The field was left empty in “Set value in bulk”, so the program asks whether you really want to erase the value“No” if it was a typo
    “ALL photos of the selected products (N) will be deleted along with their files. This cannot be undone — there are no photo backups.”The same empty field, but in the “Images” column: for it, an empty value doesn't mean “clear the field”, it means deleting all pictures together with their filesCheck the number of products in the question; the button is called “Delete photos”, and it can't be undone (what you can undo)
    “Failed to undo the operation”The operation has already been undone, or its snapshot was removed: snapshots are kept for 24 hours and only for the last five operationsFix it by hand (what you can undo)
    “(N skipped — changed since)”Someone else changed some of the products after your operation; the undo deliberately leaves them aloneReview these products separately (what you can undo)
    “No bulk operations yet”You have no saved operations: either there really were none, or they're all older than 24 hoursNothing

    FAQ

    How many products will change if I haven't selected any?

    In “Set value in bulk”, one: the one under the cursor. In “Find and replace”, the whole category with its subcategories, or the whole catalog at the tree root, and only after you check a separate box. Details: how many products each operation affects.

    I made a mistake in a bulk value change across several hundred products. How do I undo it and restore everything?

    Click “Undo” in the “N products changed” bar, which stays for fifteen seconds. If you missed it, use the “Recent actions” clock icon in the grid toolbar: it holds your last five operations from the past 24 hours (what you can undo).

    Why do new prices go back to the old ones after a catalog update?

    The update from price lists overwrites the price if the product doesn't have the “Fixed Price” flag. In the bulk price change dialog, this flag is on by default; if it was turned off, there's no protection.

    How do I change a product characteristic in bulk?

    Turn on attributes of the selected category in the grid, click the column with the characteristic you need and open “Set value in bulk” or “Find and replace”. Keep in mind that the change affects values only in the current interface language.

    How do I add another category to products without removing the existing ones?

    The category change dialog shows all categories the selected products already have: keep their checkboxes and add the new one, and don't turn on “Change only main category”, because with it the program changes only the main category and doesn't add new additional ones.

    Can I see how a product's price changed over a month, like a chart?

    Yes: in the product grid, click the mini chart in the “Price dynamics” column to open “Product price history”. It works if “Keep price history” is on; the history starts from the day you turned it on (product price history).

    Where to find it and who has access

    Menu
    Directories → Base product catalog → Products
    Other entry points
    right-click on the grid, the bulk actions bar at the bottom or the menu in the toolbar
    Access right
    the “Products” window; “Change category” has a separate right; a read-only field won't change
    Prepare
    selected products: check before the operation
    Products grid with the right-click context menu open, showing the bulk operations
    1Set value in bulk
    2Find and replace
    3Change product category
    1. Set value in bulk — writes one value into all selected products.
    2. Find and replace — changes part of the text in a column.
    3. Change product category — moves products to other categories.

    None of the operations asks “Are you sure?” twice, and only two of them can be undone (what you can undo). Try your first bulk change on two or three selected products and check the result in the grid.

    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