iPIM duplicate check – novomind iPIM Documentation

A validation rule of this type can be used to check imported item data whether items with the same attribute values as the imported items already exist in the iPIM system. For example, this can be used to prevent that items with the same supplier item number are imported more than once.

The validation rule only considers items which were synchronized with iPIM and exist there in the form of products.
In the process of a transformation, the validation rule is applied to the transformed iPIM Supply attributes.

Set up the validation rule

In order to set up a validation rule of this type, proceed as follows:

From the “Choose rule type” menu, select the rule type “iPIM duplicate” check.
Click on the button to call up the corresponding dialog box.

Enter a name for the validation rule in the “Title” field .
Optional: Enter a short description in the field “Description” field .
If not already ticked, tick the “Activate rule” checkbox to activate the rule.
Optional: Tick the “External rule” checkbox to define the rule as an external rule so that the validation result is also visible in iPIM SSP.
Optional: Tick the “Internal rule” checkbox to define the rule as an internal rule. An internal rule can be used as a subordinate rule of validation rules of particular ruletypes (since version 5.4.2).

From the “Attribute” menu , select the imported iPIM Supply attribute that is to be compared to a particular attribute in the iPIM system.
From the “Search attribute” menu , select the iPIM attribute with which the imported iPIM Supply attribute is to be compared.
Possibly add further attribute pairs:
1. Click on the button . Following this, another set of input fields appears.
2. Define the attribute pair as described above.
3. Repeat these steps for any further attribute pair.
Determine the behaviour in case of an unsuccessful validation. In order to do so, select the appropriate option from the “Result of validation rule hits” menu :
- Error: The corresponding items are marked as invalid.
- Warning: The corresponding items are flagged with a warning.
- Rule: A subordinate rule is carried out. Select the subordinate rule from the menu (since version 5.4.2).
Possibly configure a test run and carry it out in order to check if the configuration of the rule is valid. To do so, click on the button .

In order to finalise the setup of the validation rule, click on the button . The dialog box closes. The newly created validation rule is shown in the table.
In order cancel the setup of the validation rule, click on the button .

In order to deselect a selected attribute, click on the

button in the row of the attribute.

Use cases

Check imported item numbers for duplicates

This section uses an example to explain how to set up a validation rule that checks whether the system already contains items from the same supplier that have the same supplier item number as the newly imported items:

Select the option “iPIM Duplicate check” from the “Choose rule type” menu .
Click on the button to call up the corresponding dialog box.

Enter a name for the validation rule in the “Title” field .
Tick the "Activate rule" checkbox to activate the validation rule.
From the “Attribute” menu , select the imported IPIM-Supply attribute that you want to compare with an attribute in the iPIM system.
From the “Search Attribute” menu , select the iPIM attribute to which the imported iPIM-Supply attribute should be compared. In this example, it is the same attribute that represents the supplier item number.

Determine the action to take in the event of a validation failure. To do so, select the appropriate option from the “Result of validation rule hits” menu.
Select the "Only look for duplicates for the same supplier" checkbox to specify that the imported item numbers should be matched only with item numbers from the same supplier.
Click on the button to finalise the setup of the validation rule. The dialog box closes, and the newly configured validation rule appears in the validation rules table.