Transformation rules

The transformation of the imported item data is based on user-defined transformation rules. Simple attribute mappings form the basis of a transformation rule. An attribute mapping relates a supplier attribute to the respective iPIM Supply attribute. Attribute mappings can be extended by cleansing rules and validation rules.

Define attribute mappings

In order to define an attribute mapping for allocating the imported supplier attributes to the corresponding iPIM Supply attributes, proceed as follows:

1. Click on the  button below the attribute mapping table to call up the corresponding dialog box.

4. Add the next attribute mapping. To do so, click on the button . Then appears a new table entry. Select a supplier attribute and a corresponding iPIM Supply attribute. Repeat this procedure for every required attribute mapping.

• In order to to complete the configuration of the attribute mappings, click on the button . The dialog box closes. The attribute mappings are now configured.
• In order cancel the configuration, click on the button .

New automatic attribute detection

Using this ation you can trigger an automatic attribute detection. This function registers the supplier attributes from the import file and ideally maps them automatically to the the corresponding iPIM Supply attributes. In order to use the automatic attribute detection, proceed as follows:

1. From the menu  below the table, select the option “New automatic attribute detection”.
2. Click on the button  to call up the corresponding dialog box. Here, the “Supplier attribute” column lists the registered supplier attributes. In the “iPIM Supply attribute” column you can see the possibly already mapped iPIM Supply attributes. The status traffic light colors indicate the mappings status of each attribute.

3. Make the possibly necessary adjustments to the attribute mappings:
   • The supplier attribute could be mapped to an iPIM Supply attribute. At this point no further action is required.
   • There already exists an active mapping between a supplier attribute and an iPIM Supply attribute. You can specify wether this mapping is applied of wether the mapping is to be overwritten:
     • In order to apply the existing mapping, activate the button.
     • In order to overwrite the existing mapping, activate the button and select the desired iPIM Supply attribute from the drop-down menu.
   • The supplier attribute could not be mapped to an iPIM Supply attribute. You need to map it manually. To do so, choose the matching iPIM Supply attribute from the menu in the “iPIM Supply attribute” column . Possibly use the text search to filter the list of attributes by a search term.

• In order to finalise the attribute recognition, click on the button . The dialog box closes and a success message is shown. The attribute mappings are now shown in the table.
• In order cancel the attribute recognition, click on the button .

Save as mapping profile

In order to save an assembly of attribute mappings, price attributes, context attributes and localized attributes as a mapping profile, proceed as follows:

1. From the menu below the table, select the option “Save as mapping profile”.
2. Click on the  button to call up the corresponding dialog box.

Use mapping profile

In order to call up a mapping profile that contains a particular assembly of attribute mappings, proceed as follows:

1. From the menu below the table, select the option “Save as mapping profile”.
2. Click on the button to call up the corresponding dialog box.

Apply cleansing and validation profile

Via this action you can select an existing cleansing and validation profile in order to add the corresponding rules to the transformation configuration. In order to do so, proceed as follows:

1. From the menu below the table, select the option “Apply cleansing and validation profile”.
2. Click on the button to call up the corresponding dialog box.

• In order to finalise the selection of the cleansing and validation profile, click on the button . The dialog box closes. The corresponding cleansing and validation rules are shown in the respective sections of the transformation configuration.
• In order cancel the process, click on the button .

Replenish attribute mapping

Using this action, you can add additional attribute mappings for the still unmapped supplier attributes. In order to do so, proceed as follows:

1. From the menu below the table, select the option “Replenish attribute mapping”.
2. Click on the button to call up the corresponding dialog box where the still unmapped supplier attributes are listed.

5. Optional: Add further attribute mappings and configure them.

• In order to finalise the replenishment of the attribute mappings, click on the button . The dialog box closes. The newly added attribute mappings are shown in the table.
• In order cancel the process, click on the button .

Configure value mappings

For an attribute with a multiple value set, a mapping between the values of the supplier attribute value set and the value set of the corresponding iPIM Supply attribute is made. In order to customize the value mapping for an attribute with a value set, proceed as follows:

1. In the table row of the attribute mapping, click on the button to call up the corresponding dialog box. Here you can see a list of any value pairs that have already been mapped and the supplier attribute values that have not yet been assigned a value from the value set of the iPIM Supply attribute.

2. Make the desired changes:
   • In order to map a new value to a supplier attribute value that has already been mapped, select the desired value from the drop-down menu in the “iPIM Supply attribute values” column .
   • In order to map a value to a supplier attribute value that has yet to be mapped, select the the value from the menu in the “iPIM Supply attribute values” column.
   • In order to remove a supplier attribute value from the table, click on the button in the respective table row. Following this, the supplier attribute value vanishes from the table.
   • In order to remove a supplier attribute value from the table, click on the button  in the respective table row. Following this, the supplier attribute value vanishes from the table.
   • Since version 5.6.2: In order to ignore multiple supplier attribute values at once, mark the respective cells and click on the button  below the table. In order to mark multiple table rows, use “Shift + mouse-click” resp. “Strg + mouse-click”.
   • Since version 5.6.2: In order to remove multiple supplier attribute values at once, mark the respective cells and click on the button below the table. In order to mark multiple table rows, use “Shift + mouse-click” resp. “Strg + mouse-click”.
   • In order to add a supplier attribute value manually, enter the supplier attribute value in the “Supplier attribute” field  and click on the button . Following this, a new table row is shown. Afterwards select the matching value from the menu in the “iPIM Supply attribute values” column.

• In order to save your settings, click on the button . The dialog closes and a success message is shown. The value mappings are now set up.
• In order to cancel the process and discard your settings, click on the button .

Map units of measurement

First introduced in version 5.5.3: Using this function you can map imported units of measurement which deviate from the default unit of measurement to attributes for which a default unit of measurement is specified. Hereby, the units of measurement are imported in a separate column in the import file. This section shows the function using the example of the following catalog file:

1. Import the catalog file as described here.
2. Go to the transformation overview and specify the attribut mappings as described here. Though, omit the supplier attribute that represents the unit of measurement.
3. In the table row of the attribute that represents the weight, click on the button to call up the configuration page for the attribute mapping.

5. Go back to the catalog process overview and carry out a transformation as described here. In the process, a validation error for the weight attribute occurs.
6. Go back to the transformation overview.

7. In the table row of the attribute, click on the button to call up the corresponding dialog box.

11. Carry out another transformation. In the process, a warning for the weight attribute occurs.
12. Call up the transformation report and scroll to the corresponding warning.

14. Go back to the catalog process overview and carry out another transformation. This one is supposed to be without errors and warnings. Afterwards you can approve the imported items and synchronize them with iPIM.

Assigned profiles

First introduced in version 5.5.3: Via the button you can call up an overview of the mapping profiles as well as the cleanser and validation profiles that are assigned to the active catalog.

Map imported attributes

In this example, the supplier attributes that were imported via the catalog file shown above are mapped. The supplier attributes are assigned the appropriate iPIM-Supply attributes.

1. Via the action menu  below the table, select the “New automatic attribute detection” option.
2. Click the button to open the corresponding dialog box. The “Supplier attributes” column lists the supplier attributes recognized from the import file.