Learn how to work with the Find and Replace rule. It speeds up your work in the feed

Article published 20. 10. 2020
| 3 minutes read

Set up advertising as you need by using a handy tool for editing text in an XML feed. With the Find and Replace rule, you can replace, remove, or fix bugs on products across the entire feed. Let’s show you how to use the rule and set it up for your online store.

  1. Using the Find and Replace rule
  2. Applying the Find and Replace rule

Using the Find and Replace rule

1. Replacing text with new content

Let’s look at the application of the Find and Replace rule. Example: you sell water filters, and you named a product as XYZ Filter Cartridge in the XML feed.

Create a rule that finds the phrase “Filter Cartridge” in the product names and replaces it with “Filter”.

  1. In the Rules section, click the New Rule button.
  2. Name the rule and select the Find and Replace rule type.
  3. Select the element that contains the product description and enter the search text in the Find field.
  4. Fill in the new required text in the Replace field.
  5. Save the rule and check the new names in the Products section after regenerating the data.

2. Translating the selected text and replacing it with a new one

You can also use the rule when translating text that you need to replace with a new one. To create it, follow the same procedure as for the previous text replacement.

3. Deleting the unwanted text

The product name sometimes contains a term that search engines do not support – whether it is the word ACTION (XY filter – ACTION), the exclamation mark (XY filter !!!!), or the domain of your store (XY filter – www_​filtersforeveryone_​en). With the Find and Replace rule, you delete them.

  1. Select products that contain the word ACTION in the name.
  2. Create a new rule using the procedure above.
  3. In the Find box, type the word ACTION and leave the Replace box blank. The ACTION word thus disappears from the name.

4. Using a rule when creating macros

You can also use this rule in Mergado to create your macros. They do not yet include the option of creating more Find and Replace pairs – we plan to add a function.

5. Replace the selected text with another using regular expressions

The rule also supports a quick search in the Find field using regular expressions, including a backreference in the Replace field.

6. Setting up multiple pairs in one rule

Use this option to apply the Find and Replace rule to multiple pairs at once, and you don’t need to create separate rules for each combination. You can also use regular expressions for a quick search.

Applying the Find and Replace rule

You can also set the rule for specific product queries. It brings benefits in the form of improved speed when synchronizing the store and reducing the risk of errors when replacing text in other categories.

Make it easier to edit the feed with Mergado. Try it for 30 days for free.

Read more:

Author / Lukáš Horák / 20. 10. 2020

Lukáš takes care of most of the Czech and English communication in Mergado. Through blogs, e‑mail, and social networks, he regularly supplies readers with e‑commerce news and news and tips from Mergado. In his time off, he enjoys simple things like badminton, digging the hidden gems of the 80’s, and seafood served with red wine.

Add new comment

The content of this field is kept private and will not be shown publicly.
By submitting a comment, you agree to the processing of personal data.