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:

How to streamline Google Shopping campaigns using custom_label

Are you familiar with all the options that Google Shopping offers? Manage your advertising campaigns even more effectively - with the custom_label element, you can sort the assortment, for example, according to the seasonality of the goods.

7 common Google Shopping feed flaws and how to fix them in Mergado

Google Shopping is one of the most widely used product feed formats in Mergado. In partnership with Proficio, a Google Certified Partner, we've described the seven most common issues you may encounter at the Google Merchant Diagnostic Center.

Transfer settings and data from one export to another in Mergado

Do you want to transfer already created queries and rules in one export to another in Mergado. Or be able to create a new export from the output URL of another export? All this is possible in our tool.


Add new comment