Boxes - Set ValueColumn If (legacy document)
For all the following boxes: If you work with prices, you may have to use the Make Valid Price- Box before.
1. Set Value/Column If Contains
If you want to set or assign a value/column for specific products only, you can use these boxes.
First define the column where the value exists.
The products all need one attribute in common that serve as the reason why you want to edit them. Insert this in the contains/compare field.
For numerical values, you can use the signs <,> and = to indicate compare or to contain.
You now can enter the value or the column to set. You can append, prepend, assign this value/column or leave it unchanged.
At handle no match you can define what happens to those products that do not contain the specified value.
2. Set Value if Column Contains
If you want to set a value if a column contains a specific word, you can use this box.
First define the column where the value exists (Intermediate or Import). (In this example brand)
In the free space fill in
1st: The word you are searching for. (In this example Nike)
2nd: The word you want to assign if Nike is found in this column. (in this example "sale:")
Choose the Mode: append, prepend or assign.
You can define if it should be an exact or a broad match.
Choose, if only the first or all found matches should be used
3. Set Value If Value In
It is basically the same as Set Value If Contains, but with this box you can set as many search terms as you want.
You can also define if it should be an exact or a broad match.
4. Set Value/Column If Empty
If the column is empty, and only in this case, you can either apply the value of another column or set a static value.
5. Set Column If not Empty
6. Add Column if Value Not Present
This box can be used to add a value from another column if it is not included already.
Pick the source "Column" from where the information should be added if it is not yet included.
Choose the "Mode" to decide whether the information should be added at the beginning (prepend) or ending (append) of the existing information in the column (if they are not part of the information already).
The optional text field could add a static word before or after added values. This could be used in order to specify the type of information that is added as "Brand:" or "Color:"
Example:
Nike Air Speed
Nike Air Vortex Color: blue
Nike Air Vector
Result:
Nike Air Speed Color: red
Nike Air Vortex Color: blue
Nike Air Vector Color: green
The color is added to Nike Air Speed and the Nike Air Vector but not to Vortex since it is already included there.
7. Set Value by Compare
This box sets a value by comparing columns.
In this example the box searches for all the prices less than 12 (€/$/..).
For the products that cost less than 12, it writes "supersale: " before the words in the column we chose to edit.
8. Set Value by Column Compare
With this box you can set up to 2 conditions that have to fit for a value to assign.
Note:
The first and the second condition are not connected. They do not form a condition together.
1- First condition: Source Coulmn
Choose the source column (here price)
Choose a value that should be compared (here 20)
Choose if the value should be >/</=...(here >=)
2.-Second condition: Optional Column
Choose the source column (here price)
Choose a value that should be compared (here 5)
Choose if the value should be >/</=...(here <=)
3- Set Value to "ATTENTION:" prepend or set a column append/ prepend or assign
9. Set Value if Greater Than
The box Set Value if Greater Than replaces all values that are greater than the value you put in the box, by a word or number you chose for Output.
Before: Price: "13€"
After: Price: "expensive"
If you work with prices, you may have to use the Make Valid Price- Box before.
10. Set Value if Match (RegEx)
With the box Set Value if Match you can search for expressions in columns and replace them by other values.
This box works wit Regular Expressions and is only intended for advanced users. Click here for the article Regular Expressions.
First define the column where the value exists. (in this example: brand)
In the RegEx field you fill in the Regular Expression you want to search.
In the line Assign you write in which term you want to assign if the Regular Expression is found.
At handle no match you can define what happens to those products that do not contain the Regular Expression.
If you chose leave unchanged in the dropdown, those fields will stay as they were before.
If you chose assign, you have to fill in what should assign if the expression is not found.
11. Set Availability
With the box Set Availability, you can chose a status for the availability of your products.
12. Set Availability by Stock
The box Set Availability by Stock, counts how many pieces of your products are left in stock.
If the number is > 0, it Sets the availability to "in stock".
In the dropdown: chose the column from your Import, which contains the number of pieces.
13. Contains String
With this box you can replace cells if they contain a specific string.
Example:
Text before: "This are red sneakers with blue stripes."
Text after: "shoes"
In this example the cell will be empty if "sneaker" is not found.
You can also put a string that should assign if the word is not found, for example "no shoes".
In this example we just search for words, but it also works with strings.