The Find and Replace feature allows values in a mapped column to be changed, converted, or rephrased before they are matched or updated in the store. This is commonly used to clean up data, standardize naming, or remove unwanted text from feed values.

1. Find

Use this field to search for one or more words or phrases from the feed file.

• Multiple words or phrases can be added and separated by commas.
• The search matches any part of the word, not exact matches only.
• Supports wildcards (*) and regular expressions.
• Regular expressions can be tested here: https://regex101.com/

2. Replace with

Use this field to replace the words or phrases found in the Find field.

• Replacement values should follow the same order as the Find values.
• Multiple replacement values can be separated by commas.

Examples

(a) To find words such as woman, manicure, or similar variations, use a wildcard pattern like: *man

This matches any word that starts with man.

(b) To add multiple search conditions, separate each value with a comma.

(c) If the value contains a comma, wrap the text in double quotes (" ") and use [,] to represent the comma. Examples: "Clothes[,]" , "mm[,]"

(d) To remove all links from a description field, use the following patterns in the Find field: <a href=.?>,<a id=.?>,</a>

(e) To replace text using the value from another column, use the column name inside double curly brackets. Example: {{Description}}

Updated on: 14/01/2026