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

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.
Example of using the Find and Replace rule to change texts.

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.

Example of using the Find and Replace rule to translate text.

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.
Example of using the Find and Replace rule to delete text.

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:

Manage to advertise centrally using configuration CSVs

Learn a new way to set up advertising in Mergado automatically and in bulk. Ever since we introduced the rule for importing data from CSV files, you can edit specific parts of your advertising from one place by creating configuration CSVs.

11.11.2020
Setting categories is not difficult anymore. With the smart rule in Mergado

When managing advertising for comparison engines, you need to set the correct categories according to the category tree of the specific engine. Mergado users can do it with a rule which will significantly speed up the selection of categories. See how to do it.

29.10.2020
Set up shipping for well-known comparison engines and advertising systems

A well-set offer of courier services and the price of shipping are the crucial competitive weapons of online stores advertising on search engines. In our guide, we will show you how to set the rules for the price of shipping in Mergado.

23.09.2020

Add new comment