How to Find and Replace Text in Fields During Import

In this tutorial, we’ll learn how to find and replace specific text within a field during the product import process using Custom Fields in Products Sync Master.

Example: Replace Text in Product Names

Let’s say you want to replace the word “Green” with “Red” in the Product name field.

To do this, create a new Custom Field and select the Formula type. Use the following structure for your formula:

[your_field_name] => TEXT_FOR_SEARCH => TEXT_FOR_REPLACE

Example Formula:

[Product name] => Green => Red

Step 2: Select the Created Field for Import

After saving the formula, go to the Information section and select the new custom field for import:

That’s it — the system will automatically replace all specified text during the import process.