Pricing rule

A cleansing rule of this type can be used to convert price data during the transformation of the imported supplier data. For example, the cleansing rule can be used to convert price data imported in a foreign currency into your own currency.

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

  1. From the “Choose rule type” menu, select the rule type “Pricing rule”.
  2. Click on the Add button to call up the corresponding dialog box.
  1. Enter a name for the cleansing rule in the input field “Title”.
  2. From the “Order” menu, select the appropriate option. You can choose between:
    • Before transformation: The attribute value modification also affects the supplier attributes.
    • After transformation: The attribute value modification only affects the iPIM Supply attributes.
  3. From the “Attribute” menu, select the iPIM Supply attribute that represents the price data that are to be converted.
  4. Possibly enter a short description in the input field “Description”.
  5. Possibly tick the “Activate rule” checkbox to activate the rule.
  6. Possibly tick the checkbox “Internal rule” to specify that the rule is an internal rule. Internal rules can be used as subordinate rules for certain rule types.
In this example, the values of the attribute “Selling price (VK)” are multiplied by 1.5, whereby the result of the multiplication is rounded up to a value with the decimal places “.99”. Finally, the currency is replaced by “US Dollar (USD)”.
  1. Specify a conversion rule:
    1. Click on the Add button. Following this, a set of input fields appears.
    2. From the “Operation” menu, select a calculation operation:
      • Absolute offset: If this operation is used, a specified fixed value is added to the respective attribute values*.
      • Relative offset: If this operation is used, a percentage share of the respective attribute value is added to them*.
      • Multiplier: If this operation is used, the respective attribute values are multiplied by a specified factor.
    3. Enter a value in the input field “Value”. Depending on the configuration, this value is either multiplied with or added to the respective attribute values.
  2. Possibly add further conversion rules:
    1. Click on the Add button. Following this, another set of input fields appears.
    2. Configure the conversion rule as described.
    3. Possibly add further conversion rules.
  3. Possibly specify a rounding strategy. To do so, tick the corresponding rounding strategy and configure it as desired:
    • Round up: When this rounding strategy is used, decimal numbers are always rounded up. Enter the decimal places in the input field (e.g. 0.99 for rounding to x.99).
    • Round off: When this rounding strategy is used, decimal numbers are always rounded off. Enter the decimal places in the input field (e.g. 0.99 for rounding to x.99).
    • Commercial rounding: When this rounding strategy is used, the respective attribute values are round up respectively rounded off to specified number of decimal places. Enter the number of decimal places in the input field.
    • Round half down: When this rounding strategy is used, values ≥ 5 are rounded up where as values < 5 are rounded off. Enter the number of decimal places in the input field.
  4. Possibly configure a test run and carry it out in order to check if the configuration of the rule is valid.
  • In order to finish the configuration, click on the Save button. If the process was successful, a corresponding message will appear. The cleansing rule of is now set up.
  • In order to cancel the process, click on the Cancel button.
Note
  • *If you want to subtract the specified value instead of adding it, enter a negative value in the input field.
  • **If you do not specify a rounding strategy, the respective attribute values are always round up respectively rounded down to values with four decimal places.
INFO
In order to remove a conversion rule, click on the button in the respective row.