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
- Substring replacement in any text column, including attributes.
- Regular expressions — case-insensitive pattern search and inserting the matched parts.
- The “Manufacturer” column — renaming the whole value, linked to the directory.
- Undo with the “Undo” button or from “Recent actions”.
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.
- 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:
- For undo, the program remembers the old values of the products the replacement will change.
- 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.
- It clears the “Exported” flag on the changed products (a new attribute value is written after this step).
- 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.
1
Replacement scope: the whole category with subcategories2
Without this tick the replacement will not run- No products are ticked, so the replacement applies to the whole chosen category and its subcategories.
- 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 see | Why | What 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 products | select 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 there | the case didn't match | turn on “Using a regular expression” — pattern search ignores case |
| With the regular expression checkbox on, more was replaced than needed | the pattern contains a dot, parentheses or a plus — they work as special characters | put a backslash before them: \., \(, \+ |
| “The regular expression is invalid, nothing was replaced” | an unclosed parenthesis or a special character in the wrong place | fix the pattern and try again — no product changed |
| A duplicate appeared in the manufacturer directory | there was a typo in the “Replace” field — the program created a new manufacturer | remove the extra entry in the manufacturer directory |
| “You must enter a value!” | The “Find” field in the “Find and replace” dialog is empty | Fill 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
- If you need the overall picture of working with the product list — how to work with the product list.
- If you need to write a whole value rather than part of the text — set a value in bulk.
- If you need regular expressions for processing a supplier's price list — price list regular expressions.
- If extra manufacturers are left in the directory — manufacturer directory.
