Use cases
- Replace the complete value of a field with another value of your choice. The value will be replaced only if it's an exact match.
Use the Lookup and replace value action to look for an exact match with a value and only replace it when there is an exact match.
For example, if the lookup value is "Red" and replacement value is "Brick", the output will be "Brick" only for the products that have the exact value "Red". It will not change products that have values like "Dark Red", even if though they contain "Red".
Fill found values
To automatically extract existing values from a field, click Fill found values. All the found values will be added to the When field is equal to section and then you can add what each value should be replaced with in Then change value to.
Case sensitive
If you select the Case sensitive option, it will replace the fields that contain exact values of upper and lower case letters. So if this is active (a check mark will show) and we look for the input "red", and our replacement value is "Brick", the output will be "Brick" for all products that have the value "red", but not for those that have the value "Red".