There is an ever growing variety of powerful transformations that you can take advantage of to modify and or correct your data so that it complies to the needs of your retailers.
How does it work?
Transformations will:
Apply to all values for a specific attribute in a channel category if the attribute is category specific
Apply to all values for a specific attribute in a channel (across categories) if the attribute is not a category specific attribute
For Example:
It will change "rose" to "red" across all categories in the Home Depot channel (The "Color" attribute being a non category specific attribute)
Transformations will not transform any channel level manual edits.
Example:
If you are appending the unit of measure "in" to values from your master data and then edit one value at the channel level, you'll have to manually add the "in" unit of measure.
Several transformations can be applied to the same attribute. Their order may impact the end result.
Here are some of the Transformations you can use:
Conditional transformations
Transformations can be based on a specific value from your Master Data.
This would allow you, for instance, to decide to apply a value transformation to your products with the value "Blue" under "Color".
Without a condition, the value transformation will be applied, in a given category, to all products.
Date specific transformations
Transformation name | Description |
Add to date | Increase date from attribute by specified amount of day(s), month(s) or year(s). |
Change date format* | Allows you to transform your current date format to another format. |
Change date to ISO | Changes the current date format to ISO format. |
Subtract from date | Decrease date from attribute by specified amount of day(s), month(s) or year(s). |
Generic transformations
Transformation name | Description |
Add attribute to multivalue | Will add, after a comma, the value from a second attribute. |
Append attribute transformation* | Will add the value from a second attribute. Let's you decide of the separator, if any. |
Append value* | Will add a typed value after the attribute. Separator, if required, needs to be typed. |
Prepend value | Will add a typed value before the attribute. Separtor, if required, needs to be typed. |
Regular expression | Finds and replace a character or group of characters and substitute it by another. |
Replace value | Finds and replace a character or group of characters and substitute it by another. |
Set default value | Sets a default value if the cell is empty. |
Split by | Split string with separator |
Split on character count | Splits string every [X] characters. |
Truncate | Truncates the value from left to right. Select the amount of characters you want to keep. |
Filter (inclusion) | To include entries in a composite based on matching a specified value, use double quotes around the attribute then a colon then double quotes around the desired value. \"ATTRIBUTE\":\"value\" Example of AND attribute filtering: (?=.*\"FIRST_ATTRIBUTE\":\"first_value\")(?=.*\"SECOND_ATTRIBUTE\":\"second_value\")
(\"ATTRIBUTE\":\"5\")|(\"ATTRIBUTE\":4\")" |
Insert value | Will add a typed value within the attribute. Let's you decide of the position within the string and the separator, if any. |
Lookup table* | Transform your attribute using a Lookup table imported in the making of your Configured Channel. |
Integer specific transformations
Transformation name | Description |
Left pad number with zeros | Allows you to add "0" in front of a number to reach a required characters length. |
Math add value | Addition |
Math divide value | Division. "Precision" allows you to pick the lenght of the decimal result (from 0 to 9 digits after the dot) |
Math multiply value | Multiplies the numeric part of the existing value by the provided value. |
Math round value | Rounding your value up or down. |
Math substract value | Subtract value. |
Set decimal places | Sets a fixed amount of decimals. |
Multivalue specific transformations
Transformation name | Description |
Extract from multivalue | Allows you to decide in a multivalue, which value you want to see in your extract. |
Join multivalue with separator | Joins all values from a multi-value into one value. |
String specific transformations
Transformation name | Description |
Remove duplicated words* | Removes duplicates from your string. |
Remove whitespace | Removes blank spaces from your string. |
Transform to "Sentence case" | First letter of the string gets capitalized. |
Transform to "Title Case" | First letter of each word gets capitalized. |
Transform to lower case | Change input to be lower case. |
Transform to upper case | All letters get capitalized. |
*Editor's pick
Change date to format allows you to adapt to different markets and retailers requirements without having to change your Master Data.
Append attribute transformation allows you to bring in value from several attributes from your Master Data, without having to create new columns in your Master document.
Append value is useful to add units to an integer or decimal like a dimension, cost or weight.
Lookup table allows you to "Find and Replace" automatically a large amount of values.
Remove duplicated words can be really useful when filling up, for example, a "Keywords" attribute limited to 500 characters.
Why can't I see the list of transformations?
If an attribute is constrained by a List of values (a dropdown list) the only transformation you can apply will allow you to find a value and replace it by a value from the pre-defined list.