Open topic with navigation

Attribute Values Operations for Bulk Updates

The following operations allow you to modify attribute values.

Merge Attribute Values

Copies the values from the first selected attribute to the other, in the current workspace, based on the parameter settings. For dimension dependent attributes, the copy is performed across all dimensions or applicable combinations of dimensions.

Verifying Attributes for Merge

This operation can also be started from System Setup by selecting an attribute, then right-click and select Merge Attribute Values. For details about verifying the attributes before performing this operation, see the Merging Attribute Values section of the System Setup / Super User Guide here.

To merge attribute values for only some objects, go to the Search tab, and create Search Results of the objects to merge. Then either click the Collections button to save the results as a collection (which can be used for repeated updates), or click the Bulk Update button and click Next to display the Operations page and the following Merge Attribute Values parameters.

Merge Attribute Values Operation

1. In the Merge parameter, click the ellipsis button (…) to display the Select Attribute dialog, choose the attribute to copy values from, and click the Select button.
2. In the into parameter, click the ellipsis button (…) to display the Select Attribute dialog, choose the attribute to copy values to, and click the Select button.

3. For the Source Workspace field, use the dropdown to select the workspace that holds the values to be copied to the target, based on the other parameters. Values are always pasted into the Main workspace.

Consider the following example data, and assume we will choose to Overwrite existing values (as described below). Selecting the Source Workspace = Main will result in writing the T-shirt Size value of S, while selecting Source Workspace = Approved will write the XS value.

4. For the Overwrite field, choose an option to determine when to write to the target attribute. Validation errors are displayed on the Preview page when a value cannot be modified.

Consider the following data and the effects of the options as shown in the Preview images below. 'T-shirt Size' is the source attribute and 'Size' is the target attribute:

• Keep original values means the source value is only copied to the target attribute when the target attribute is blank. If the target attribute contains a value, the target value is not changed. Notice that the only value changed in this scenario is for object 18212 L B, since the source object had a value and the target value was blank. Since the other objects either had values for the target or the source was blank, none of them were modified.

• Overwrite existing values means the source value overwrites the target value, except when the source attribute is blank. If the source attribute is blank, the target value is not changed. Notice that two values changed in this scenario: object 18210 M B had its value overwritten since a value existed for the source, and object 18212 L B was overwritten since the source object had a value and the target value was blank. Objects 18213 M O and 18216 L O both had blank source values, so the target values were not overwritten.

5. For Merge Link Attributes field, if the selected attributes are both used as an attribute on a reference, a product classification link, or an attribute link, merging of those values are based on the Yes or No set in this parameter, as well as the other parameters on the operation. This option is not relevant when values do not exist on references for the selected attributes.

For example, consider the following values for the attributes 'Qty of Next Lower Package' and 'Qty of Next Higher Package' on the Case to Child reference.

Setting the operation parameters as 'Qty of Next Lower Package' for the source, 'Qty of Next Higher Package' for the target, using the Overwrite existing values, and setting Merge Link Attribute = Yes results in this preview of resulting values:

For more information about attributes on references, see the Product Attribute Link Type section of the System Setup / Super User Guide documentation here.

Note: The Merge Attribute Values operation does not delete any attributes, it can only update values. If desired, manually delete the source attribute once you confirm the merged data.

Set Value

Sets the value of the selected attribute based on a value entered manually or via a function.

Manual Values

1. Click the ellipsis button (…) on the first field and select the attribute that will be updated.

Note: The selected attribute dictates the label on the manual button. In the image below, the selected attribute requires a text value and so the label is 'abc.' If the selected attribute is numeric, '123' is displayed, and so on for each validation base type.

2. Since the manual value button is selected by default, enter the desired value in the '=' field. The value of the selected attribute will be set equal to this manual value.

Function Values

1. Click the ellipsis button (…) on the first field and select the attribute that will be updated.
2. Click the 'fx' button to indicate a function will be used.

3. Click the ellipsis button (…) on the '=' field to display the function editor.
4. Enter a function based on the requirements that will resolve to the desired value.

See the Using Function Editor topic within the Attributes documentation (here) for more information on writing functions.

2018, Stibo Systems