↑↓ selectEnter openEsc close

    1. Elbuz

    How to replace text in product names and descriptions

    9 min readUpdated

    Elbuz changes part of the text in one column for all chosen products in one run: a word in names, a domain in links, a unit in attributes.

    When you need this:

    • An extra word in a category's names — replace it with nothing.
    • One word spelled in different ways — a regular expression ignores case and finds them all.
    • A manufacturer written two ways — a replacement in the “Manufacturer” column moves products to the right directory entry.
    • Wrong thing replaced — “Undo” rolls it back within 24 hours.

    Where to start: right-click a cell in the column you need and choose “Find and replace”.

    What “Find and replace” can do

    How to replace part of the text in a column

    The operation changes part of the value, not the whole field: it finds a substring in the column and puts another one in its place. The column is the one you clicked; the dialog shows its name in the title.

    With no rows selected, the replacement runs across the whole chosen category with its subcategories, and at the tree root across the whole catalog. How the dialog protects you from this is covered in “Find and replace” without selections.

    Typical examples: remove an extra word from names (replace it with nothing), fix a manufacturer name in descriptions, replace an old domain in links, clean up units of measure in attributes.

    With no rows selected and a search or filter active, the dialog doesn't open. Then come three checks before anything is written: an empty “Find”, an unconfirmed scope and an error in the pattern stop the replacement. The “Manufacturer” column takes a separate branch — renaming the whole value
    yesnoyesnono, and the scope checkboxisn't tickedyes, or the checkbox istickedyesnoyes, pattern has an erroryes, pattern is validno“Find and replace” selectedNo rows selected, and a search orfilter is active in the grid?Red message “A search or filter isactive in the gridbut no rows are selected…”the dialog doesn't open“Apply” clicked in “Find and replace”Is the “Find” field empty?“You must enter a value!”the dialog stays openAre products selected?Reminder to confirm the scopeno replacement“Manufacturer” column?Products with exactly this name getthe new manufacturerif it isn't in the directory, it's created“Using a regular expression”checkbox?“The regular expression is invalid,nothing was replaced”Replace by patterncase-insensitiveLiteral text replacementcase-sensitive“N products changed” and “Undo”if anything changed
    • Action or result
    • Decision: the path depends on the answer

    A replacement in attributes works in the interface language you're currently using. Values of the same attribute in other languages stay untouched — to fix them too, switch the language and repeat.

    How to replace by pattern

    Without the checkbox, the program searches for the text you entered literally and case-sensitively: “Cable” and “cable” are different strings. With the checkbox, the “Find” field becomes a pattern: \d+ finds any number, \s+cm finds a unit of measure together with the spaces before it. The syntax is the same as in price list regular expressions.

    Pattern search ignores case: the pattern cable replaces both “Cable” and “CABLE”. So the checkbox is useful even without special characters — when one word is spelled differently across names.

    In the “Replace” field you can insert the matched parts of the pattern: \1 is what's in the first parentheses, \2 in the second. “Find” (\d+)x(\d+) and “Replace” \1 × \2 turn “60x90” into “60 × 90”.

    In a pattern, the dot, parentheses, plus and asterisk are special characters. A dot means any character, so the pattern 2.5 matches not only “2.5” but also “205” inside “2050”. To search for the character itself, put a backslash before it: 2\.5.

    The program catches an error in the pattern — an unclosed parenthesis, an asterisk at the start — before replacing: the message “The regular expression is invalid, nothing was replaced” appears, and no product changes.

    How to merge manufacturer spellings

    A replacement in the “Manufacturer” column doesn't work as a substring replacement but as renaming the whole value: the program looks for products whose manufacturer equals the string you entered and assigns them the new one.

    • If there's no manufacturer with the new name in the directory yet, it's created automatically — so a typo in the “Replace” field adds an extra entry to the directory.
    • The regular expression checkbox has no effect here: the manufacturer name is matched as a whole, case-insensitively — “samsung” finds “Samsung” too, but not “Samsung Electronics”.
    • The replacement can be undone like in other fields, but a manufacturer it created in the directory stays there after the undo.

    What happens if a replacement is interrupted

    A replacement across a category or the whole catalog is several separate queries in a row, with no shared “all or nothing” between them. The order is:

    1. For undo, the program remembers the old values of the products the replacement will change.
    2. It writes the new values: for the name, descriptions, meta fields and tags — separately in the product itself and separately in the product texts for the current catalog language.
    3. It clears the “Exported” flag on the changed products (a new attribute value is written after this step).
    4. It rebuilds the data the grid reads from, and only at the end counts how many products changed.

    This leads to three consequences of an interruption:

    • whatever was written before the interruption stays; a name or description may already have changed in one storage place and not yet in the other;
    • products that did change may keep the “Exported” flag — then a template with “Only export new data” won't pick them up until they change again;
    • if the interruption happened after the program remembered the old values, the operation appears in “Recent actions” with the number of products those values were saved for, and undoing it works: it restores the products that did change. Products the replacement never reached show up in the undo summary as “(N skipped — changed since)” — they're unchanged anyway. A product whose name or description changed in only one storage place lands there too, but undo still restores what changed in it. There's no bar with “Undo” in this case.

    Repeating the replacement with the same “Find” and “Replace” is safe if the replacement text doesn't contain the search text. Products the replacement already went through no longer contain the search text, so the repeat doesn't touch them.

    If the replacement does contain the search text (for example, “Intel” → “Intel Core”), a repeat adds the text a second time where the replacement already went through; for a regular expression the same happens when the result matches the pattern again. In that case, don't repeat the replacement: undo the interrupted operation from “Recent actions” and run it again.

    The repeat is recorded in “Recent actions” as a separate operation — only with the products it changed itself.

    Scenarios

    Remove an extra word from product names in one category

    What to turn on. Choose the category in the tree, turn off the grid search and filters, select no products. Click the “Name” column, open “Find and replace”, put the word in “Find”, leave “Replace” empty. The dialog warns that this covers the category with subcategories and won't run without the “Yes, apply to all products in this scope” checkbox.

    Find and replace dialog for the Name column with no products ticked
    1Replacement scope: the whole category with subcategories
    2Without this tick the replacement will not run
    1. No products are ticked, so the replacement applies to the whole chosen category and its subcategories.
    2. Without this tick the replacement will not start.

    What you get. The word disappears from the names of all products in the category and subcategories that your group can see. A “N products changed” bar with an “Undo” link appears at the bottom — only for products whose name actually changed; the “Exported” flag is cleared on the same products.

    What won't happen. Names in other languages stay as they were. Without the “Using a regular expression” checkbox, a capitalized word won't be found if you typed it in lowercase.

    Merge two spellings of one manufacturer

    What to turn on. Click the “Manufacturer” column and open “Find and replace”. In “Find”, enter the full name you want to get rid of; in “Replace”, enter the correct name exactly as it's written in the directory.

    What you get. Products whose manufacturer exactly matches the name you entered (case-insensitively) get the correct manufacturer. You can reverse the replacement with the “Undo” button.

    What won't happen. Products with a longer name, such as “Samsung Electronics” when you search for “Samsung”, won't change, and the regular expression checkbox won't help here. The old entry isn't deleted from the manufacturer directory — remove it there manually. With an empty “Replace”, nothing changes.

    What to do when a replacement goes wrong

    What you seeWhyWhat to do
    Instead of the “Find and replace” dialog, a red message: “A search or filter is active in the grid but no rows are selected…”no rows are selected while a search or filter is active in the grid — without selections the replacement would cover the whole category, not the visible productsselect the rows you need (“Select all products” respects the filter), or turn off the search and filters if you really need the replacement across the whole category
    The replacement didn't find a word that's therethe case didn't matchturn on “Using a regular expression” — pattern search ignores case
    With the regular expression checkbox on, more was replaced than neededthe pattern contains a dot, parentheses or a plus — they work as special charactersput a backslash before them: \., \(, \+
    “The regular expression is invalid, nothing was replaced”an unclosed parenthesis or a special character in the wrong placefix the pattern and try again — no product changed
    A duplicate appeared in the manufacturer directorythere was a typo in the “Replace” field — the program created a new manufacturerremove the extra entry in the manufacturer directory
    “You must enter a value!”The “Find” field in the “Find and replace” dialog is emptyFill in what to search for

    FAQ

    How do I replace a number or a piece of text by pattern?

    Turn on “Using a regular expression”: “Find” becomes a pattern, the search ignores case, and in “Replace” you can insert matched parts with \1, \2. Put a backslash before a literal dot, parenthesis or plus. A pattern with an error isn't run, and you get a message.

    Is the replacement case-sensitive?

    Without the regular expression checkbox, yes: “Cable” and “cable” are different strings. With the checkbox, no (replacing by pattern).

    Why didn't the names in another language change?

    The replacement changes names and descriptions in the texts for the current catalog language, and attributes in the interface language. Switch the language and repeat the replacement.

    How do I undo a replacement?

    With the “Undo” button in the “N products changed” bar or from “Recent actions” in the toolbar — within 24 hours, among the last five operations (what can be undone).

    How many products change if I don't select anything?

    The whole chosen category with subcategories, at the tree root the whole catalog — and only after you tick “Yes, apply to all products in this scope” (replacing without selections).

    Where it is and who has access

    Menu
    Directories → Base product catalog → Products
    Other entry points
    the right-click menu on a column cell, the bulk actions bar (“Replace”), the menu
    Access right
    the “Products” window; a replacement won't change a read-only field
    Prepare
    selected products or a chosen category — the replacement scope

    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