Add or overwrite your data with static values
Learn how to add or overwrite your data with static values using rule boxes in Data View or Dataflow in Productsup.
Introduction
While optimizing your product data in Data View or setting up your column connections in Dataflow, you may need to add a static value to all products in a specific column. There are several methods to overwrite or add static data. You can:
Note
When adding multiple rule boxes to one column, mind the order of your rule boxes. Productsup executes the rules from top to bottom.
Assign a static value
To replace the current data in the column with a new static value across all products:
Go to Data View from the site's main menu.
Choose the needed export channel or the intermediate stage in the drop-down menu on the left.
Select Edit in the attribute's column where you want to apply the rule box.
Select the Add Box drop-down menu.
Search for and select the Static Value rule box.
Enter a value into the Value field.
Select assign in the drop-down menu.
Select Save to apply the rule box.
Append or prepend a value
To append or prepend a value to an attribute, you can use the Static Value rule box or the Append/Prepend Value rule box. To add the Append/Prepend Value rule box, follow these steps:
Go to Data View from the site's main menu.
Choose the needed export channel or the intermediate stage in the drop-down menu on the left.
Select Edit in the attribute's column where you want to apply the rule box.
Select the Add Box drop-down menu.
Search for and select the Append/Prepend Value rule box.
Select whether to append or prepend a value in Mode.
Enter a value in the Value field.
Select Save to apply the rule box.
Append or prepend a value if the column is not empty
To append or prepend a value to all non-empty product rows:
Go to Data View from the site's main menu.
Choose the needed export channel or the intermediate stage in the drop-down menu on the left.
Select Edit in the attribute's column where you want to apply the rule box.
Select the Add Box drop-down menu.
Search for and select the Append/Prepend Column if not Empty rule box.
Select whether to append or prepend a value in Mode.
Enter a value in the Value field.
Select Save to apply the rule box.
Add a value if it fits a specific character limit
Some export channels may restrict the number of characters in the attribute's string to a specific limit. You can define the maximum length of your attribute values and append or prepend a value only if it fits the length requirements.
Go to Data View from the site's main menu.
Choose the needed export channel or the intermediate stage in the drop-down menu on the left.
Select Edit in the attribute's column where you want to apply the rule box.
Select the Add Box drop-down menu.
Search for and select the Add Value if Fits rule box.
Select whether to append or prepend a value in Mode.
Enter the value you wish to append or prepend in the Text field.
Enter the characters limit in the Max Length field.
Select Save to apply the rule box.