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.
Note: When using the "replacement value" list, make sure you enter a replacement value on the same line for every value you have in the "Search value" list. If you want to keep the same value as the value in the "Search value" list, fill in the same value in the "replacement value" list. You either have to fill in the right list completely or you have to leave it empty (which preserves the values in the "Search value" list).