P2P - Multi-Supplier and Multi-Category Support for External Webshops


The P2P shopping basket provides improved support for determining the supplier and purchasing category based on the data provided by the external webshop's OCI inbound message. The supplier is determined based on the DUNS number. The purchasing category is determined based on the classification code and standard. The supplier and purchasing category are shown in the shopping basket.

Setup in the P2P system:

A. To use the purchasing categories determined by the product classification/commodity codes provided in the external webshop's OCI inbound message:

  1. In Data Management > Purchase > External Webshops, configure an external webshop with no default purchasing category.

  2. Create a cross-reference file. The cross-reference list defines the used product classification standard and classification/commodity codes and the corresponding purchasing category in the P2P system. The list includes source code: <product classification code> and target code <purchasing category code>.
  3. Create a .csv file in the following format:

  4. Import cross-reference lists to Data Management > Purchase > Cross-References (requires the Manage cross-reference lists user right).

  • Activate the cross-reference list. Otherwise, the system does not use the cross-references.
  • Inherit the list if needed.
  • The system can import up to 50 000 rows of cross-references.
  • The system allows only one active cross-reference list with the same source and target standard under one organization.
    • If you import a file with the same name and with the same source standard and target standard under the same organization, the system asks you if you want to replace the existing one.
    • If you opt to replace the existing list based on the above rule, the system transfers the active/inactive status of the old list to the new list.
  • The system does not allow duplicate source and target codes in a cross-reference list.
    • The system saves only one source and target code from the duplicate lines when importing the cross-reference list.
  • You can edit the imported cross-reference codes, that is add and delete lines in the user interface.

B. To use the supplier determined by the DUNS number provided in the external webshop's OCI inbound message:

  1. Configure in the Data Management > Purchase > External Webshops an external webshop with no supplier.
  2. Define the supplier DUNS number in P2P Administration > Supplier > Identifiers.


The P2P shopping basket uses primarily the information provided in the external webshop's OCI inbound message to determine the purchasing category and supplier. The cross-reference lists are used in the P2P shopping basket so that the classification code of the product in the external webshop's OCI inbound message, in the NEW_ITEM_EXT_SCHEMA_TYPE and NEW_ ITEM_EXT_CATEGORY_ID fields, is mapped to the purchasing category based on the cross-reference source and target codes.

The supplier is determined by the DUNS number defined in the OCI inbound message, the NEW_ITEM_VENDOR field, if the same DUNS number is defined in the P2P Administration supplier data.

If the required product classification code and supplier DUNS number are not defined in the P2P system, the shopping basket checks these from the external webshop's configuration. If the purchasing category and supplier are not defined there either, the user needs to manually enter those on the purchase requisition.

With the correct settings, the products from the external webshops can automatically have the correct purchasing category and supplier information on the purchase requisition even if products are from multiple purchasing categories and/or from multiple suppliers.