Used for: searching for a value in one field and then setting another field to this value if it is found.
Used in: "THEN"-statements and "ELSE"-Statements.
The "search for value" really comes in handy when your export channel needs to have information such as "color", "brand" or "size" in a separate field. A lot of times you have this information available in your item's description, but not in a separate field. With the "search for value" rule you can, for example, easily look for a list of colors from all of your descriptions. If Channable then finds this color in the description, it can fill the field "color" with the color that was found. In case you want to fill your "brand" field instead simply select the "brand" field instead of the "color" field below, and add a list of brands to the "search value" column.
In the screenshot below is shown how the example described above would look like in Channable.
In the example above your "color" field is set to the exact values that are typed in the "Search value" list. With the optional "replacement value" list you can set alternative values that will be used to fill the color field. For example, you might have some typos or different notations for the same color that you want to standardize to the same color notation. In that case, you could use the replacement value column as shown in the screenshot below.
When you take a field that contains a list, the "search for value" will be applied for every element in this list. When the list is empty, it will remain empty after applying this rule. If this is not desired, the empty list can be converted to text by adding this rule (see image below) before the "search for value" rule. This rule transform a 'list' type of field into a 'text' type of field automatically, while leaving it empty as well.