Value mappings

In this tab you can define automatically executed value mappings between values of different attributes with value sets. Learn more You can either define dependent or determining values. A dependent value mapping for an attribute effects that when a certain attribute value is selected, a specified attribute value is set for a related attribute. A determining value mapping can be used to specify for an attribute, for example, that the selecting a certain attribute value for a related attribute effects that a defined value is set for this attribute. Less information

Define dependent value mappings

Via a dependent value mapping you can specify for the selected attribute that when selecting a particular value, a specified value is set automatically for the related attribute.

In order to define a dependent value mapping, proceed as follows:

1. First select the attribute for which you want to define a value mapping.

2. In the left-hand card, click on the “Dependent values” tab.
3. In the table, click on the value for which you want to specify a dependent value and a dependent value.
4. Click on the CREATE button in the “Dependent values” card to call up the corresponding dialog box. The dialog box features two sliders where you can select a dependent attribute and a dependent value.

5. Select a dependent attribute. You can also select multiple attributes:
   • In order to select an attribute, transfer it from the left column to the right column. To do so, click on the attribute.
   • In order to deselect an attribute, transfer it from the right column back to the left column. To do so, click on the attribute.
6. Click on the button to proceed to the next slider.

7. Select a value as a dependent value. Depending on your selection in the first slider, you can also select multiple values:
   • In order to select an attribute value, transfer it from the left column to the right column. To do so, click on the value.
   • In order to deselect an attribute value, transfer it from the right column back to the left column. To do so, click on the value.

• In order to finish the process and to relate the selected value of the source attribute to the selected value of the dependent attribute, click on the ACCEPT button. If the process was successful, a corresponding message will appear and the related value appears in the table of the “Dependent values” card.
• In order to cancel the process, click on the CANCEL button.

First introduced in version 5.5.0: If an attribute with an extensive list of values is selected, no further attributes can be selected. If such an attribute was selected, it depends on a search term which values are loaded. Note: The respective search field is only show if an attribute with an extensive list of values is selected.

Define determining value mappings

1. First select the attribute for which you want to define a value mapping.
2. In the left-hand card, click on the “Determining values” tab.
3. In the table, click on the first value for which you want to specify a determining attribute and a determining value.
4. Click on the CREATE button to call up the corresponding dialog box. The dialog box features two tabs where you can select a determining attribute and a determining value.
5. Select a determining attribute You can also select multiple attributes:
   • In order to select an attribute, transfer it from the left column to the right column. To do so, click on the attribute.
   • In order to deselect an attribute, transfer it from the right column back to the left column. To do so, click on the attribute.
6. Click on the button to proceed to the next slider.
7. Select a value as a determining value. Depending on your selection in the first tab, you can also select multiple values:
   • In order to select an attribute value, transfer it from the left column to the right column. To do so, click on the value.
   • In order to deselect an attribute value, transfer it from the right column back to the left column. To do so, click on the value.

• In order to finish the process and to relate the selected value of the source attribute to the selected value of the determining attribute, click on the APPLY button. If the process was successful, a corresponding message will appear and the related value appears in the table of the “Determining values” card.
• In order to cancel the process, click on the CANCEL button.

First introduced in version 5.5.0: If an attribute with an extensive list of values is selected, no further attributes can be selected. If such an attribute was selected, it depends on a search term which values are loaded. Note: The respective search field is only show if an attribute with an extensive list of values is selected.

Edit properties of value mappings

Via their properties, value mappings can be specified further. When creating a value mapping, some properties are set by default, whereas some properties are left blank. The available properties include:

• Value: This is the value of the related attribute which is mapped to the corresponding value of the selected attribute.
• Relation type: Here you have the options “Required” and “Optional”. “Required” means that the value pairing of related attributes must correspond to the mapping. If a certain value is set for one of the attributes, the corresponding mapped value must also be set for the related attribute.* “Optional” means that the value pairing of the related attributes may deviate from the mapping.
• Order: Here you can enter an integer value that determines the order.
• Operation: The operator “equal” effects that a specified value is set for an attribute if a particular value is set for a related attribute. This operator is the default setting. It can be used for both mapping types. The operator “not” can only be used for determining mappings. It effects that a specified value is set for an attribute if a value other than the mapped value is set for the related attribute.
• Group: Here can enter an integer value that is used to group value mappings.

In order to edit properties of a value mapping, proceed as follows:

1. Double-click in the table cell you want to edit.
2. Make the desired changes and leave the table cell.
3. Possibly make further changes to other table cells.

• In order to save your settings, click on the SAVE button. If the process was successful, a corresponding message will appear.
• In order to dismiss your settings, click on the CANCEL button.

• For dependent value mappings, no settings can be made for the properties “Operation” and “Group”.
• *If the pair of attribute values deviates from the value mapping, a validation for the respective product throws an error.

Export/import dependent value mappings

Using the export and import function you can export dependent value mappings as a .xslx file, edit them in a spreadsheet software and re-import them to update the value mappings in iPIM accordingly.

• The import and export functions can only be applied to the source attribute and a single target attribute.
• The im- and export of value mappings can only be applied to dependent value mappings.

4. Select the target attribute from the “Select attribute” menu.
   Possibly use the text search to filter the list of attributes by a search term.
5. Enter a file name in the input field “File name”.
6. Select the language for the table header from the “Header language” menu.

• In order to finish the process, click on the SAVE button. The export file is now created. Usually you can call it up via your local download folder. You can then edit the file in a spreadsheet programme and then import it again.
• In order to cancel the process, click on the CANCEL button.

4. Click on the option “Export mappings” to call up the corresponding dialog box.
5. Drag the .xslx file over the drop area and drop it there. Alternatively, click on " Browse files" to call up the import file via the file manager.
   The file is loaded into the cache and the file name of the file is shown below the drop area.
6. Select the header language of the .xslx file from the “Header language” menu.

• In order to finish the process, click on the SAVE button. A success message is shown. The value mappings are now updated according to the .xslx file.
• In order to cancel the process, click on the CANCEL button.

You can only import mappings for which a source as well as a target is defined.

Run value mappings

Via the RUN MAPPINGS button you can manually run the value mappings which were estalished for a particular attribute. These value mappings then become active in the iPIM Portal after the next synchronisation. To run a value mapping manually, proceed as follows:

4. Select a value whose mappings you want to run. You can also select multiple values:
   • In order to select a value, transfer it from the left column to the right column. To do this, click on the value.
   • In order to deselect a value, transfer it from the right column back to the left column. To do this, click on the value.

• In order to finish the process and to run the value mappings, click on the APPLY button. If the process was successful, a corresponding message will appear and the ran value mapping will be active in the iPIM portal after the next synchronisation.
• In order to cancel the process, click on the CANCEL button.

Copy dependent value mappings

Using this function you can copy a dependent value mapping and assign it to a value from the list of values of another attribute. To do so, proceed as follows:

1. First select the attribute whose value mapping you want to copy.
2. In the left-hand card, click on the “Dependent values” tab.
3. In the table, click on the value whose mapping you want to copy. Following this, the related mappings will be listed in the “Dependent Values” card.
4. Tick the mapping you want to copy. You can also tick multiple mappings.
5. Click on the COPY MAPPINGS button to call up the corresponding dialog box. Here you can select a target attribute in the first slider as well as a target value in the second slider.

6. Select an attribute that you want to assign the copied mapping to. You can also select multiple attributes:
   • In order to select an attribute, transfer it from the left column to the right column. To do this, click on the attribute.
   • In order to deselect an attribute, transfer it from the right column back to the left column. To do this, click on the attribute.
7. Click on the button to proceed to the next slider.

8. Select a value that you want to assign the copied mapping to. Depending on you can also select multiple values:
   • In order to select a value, transfer it from the left column to the right column. To do this, click on the value.
   • In order to deselect a value, transfer it from the right column back to the left column. To do this, click on the value.

• To finish the process, click on the APPLY button. If the process was successful, a corresponding message will appear. The copied mapping is now also assigned to the selected value of the selected attribute.
• To cancel the process, click on the CANCEL button.

Resolve value mappings

In order to resolve a value mapping, proceed as follows:

1. First select the attribute whose value mapping you want to resolve. Following this, the values of the selected attribute are shown in the “Value mappings” card.
2. Depending on wether you want to remove a dependent or determining value, either click on the “Dependent values” or the “Determining values” tab.
3. In the table, click on the value whose value mapping you want to resolve. Following this, the related values will be in the “Dependent values” respectively “Determining values” card on the right side.
4. In the right-hand card, tick the mapping you want to resolve.
5. Click on the REMOVE button in the footer. Following this, the  button appears.
6. Click on the  CLICK TO CONFIRM button to confirm the resolving of the mapping. If the process was successful, a corresponding message will appear.

Instead of using the REMOVE button, you can also use the "Delete" icon () icon in the respective table row to delete resp. remove individual entries.

FAQ

What is the purpose of the “Value mappings” tab?

In this tab you can define automatically executed value mappings between values of different attributes with value sets.

What is the difference between “Dependent values” and “Determining values”?

Via a dependent value mapping you can specify for the selected attribute that when selecting a particular value, a specified value is set automatically for the related attribute. Via a determining value mapping, conversely, you can specify for the selected attribute that when selecting a particular value for a related attribute, a specified value is automatically set for the selected attribute.

What is the purpose of the RUN MAPPINGS button?

Via this button you can manually run the value mappings which were established for a particular attribute. These value mappings then become active in the iPIM Portal after the next synchronisation.

Why does a product validation throw an error for a required mapping?

If the pair of attribute values deviates from a mapping defined as “Mandatory”, a validation for the respective product throws an error.

Why can some value mappings not be imported?

You can only import mappings for which a source as well as a target is defined.

Which attribute types can the import and export functions be applied to?

The import and export functions can only be applied to the source attribute and a single target attribute, and can only be applied to dependent value mappings.