Interface between your enterprise resource planning (ERP) and the K&K Onlineshop
You can access your individual catalogue assortment in the Keller & Kalmbach online shop via OCI interface from your merchandise management system. You can continue to use your merchandise management system as usual - with all authorizations and settings - and access current product data and search options directly and on a daily basis. This saves you the time-consuming maintenance of article data or the import of catalogue data into your merchandise management system.
Open Catalog Interface, short OCI, is a standard interface for the exchange of product information between independent systems. It enables the transfer of product data in the form of digital catalogues between ERP (Enterprise Resource Planning) or merchandise management systems and online platforms.
The open standard was developed by SAP and is now supported by various software manufacturers worldwide. SAP also coined the term punchout, which refers to access to an external product catalog.
The goal of OCI is to integrate eCommerce platforms for research and product selection processes into the ERP system without having to store all product data in detail separately. The resulting product information is integrated into the B2B ordering process and the order transmission is then carried out directly from the ERP system.
Order processing via OCI is explained below using a possible example scenario.
Max is a buyer for a medium-sized company. He would like to order products online from Keller & Kalmbach in the categories fasteners, fastening technology and hand tools, among others, but at the same time process the order via his ERP system.
The ordering process must meet the following requirements for his company:
- An additional entry of the order in the ERP system must be avoided at all costs
- The articles to be ordered must be sorted into the merchandise categories of the ERP system This is necessary to determine important key figures and statistics
- An internal approval process already integrated and lived in the ERP system must be retained
- The cost centers existing in the ERP system must be assigned to the articles to be ordered in order to guarantee a needs-based accounting
The Open Catalog Interface (OCI), a standardized, open catalog interface that connects the customer's ERP system with the Keller & Kalmbach online shop, meets the requirements of Max. After leaving the ERP system, the customer is transferred to the K&K online shop where he can fill his shopping cart.
He can then transfer the filled OCI shopping cart to his ERP system. In this way, all relevant product information such as price, quantity, item description and delivery time as well as additional customer or product relevant information such as classification (e.g. eClass or UNSPSC) and customer item number are transferred to the customer's ERP system.
Now Max has all the necessary information in his ERP. The open purchase order can now run through the internal approval workflow. After the final approval it is only necessary to send the order directly to Keller & Kalmbach via EDI interface or automated e-mail.
If all or the majority of the points apply to your company, please do not hesitate to contact us.
In order to jump from your merchandise management or your Procument system to the K&K OCI-Shop, the following parameters must be stored. You will receive the parameters for your company directly from us. Please contact us for this.
|No.||Parameter name||Parameter value||Type|
|2||USERNAME||you will receive from K&K - Request now||Fixed value|
|3||PASSWORT||you will receive from K&K - Request now||Fixed value|
|4||USERID||dynamic user name from your software||Dynamic system field|
|6||HOOK_URL||Return URL of your software||Return value|
To give you an impression of how the Keller & Kalmbach online shop looks after an OCI jump or to enable you to test the access parameters provided to you, we provide you with a test option here. After you have entered your parameters and click "Test parameters" you will be taken to the OCI shop. Here you can add items to your shopping cart and after you have used the OCI transfer shopping cart button, you will see the data that the Keller & Kalmbach online shop provides via OCI.
Fields and, as an example, field contents that are transferred from the Keller & Kalmbach online shop to your ERP during a standard OCI shopping cart transfer are listed in the table. Individual change requests for the assignment of field contents to the OCI code can be configured flexibly.
|OCI code||Maximum data length||Explanation||Example|
|NEW_ITEM-DESCRIPTION||40||Article description||DIN 933, hexagon head bolt, Steel 8.8 galvanised, M5x60|
|NEW_ITEM-MATGROUP||10||Product classification without hyphens||23110101|
|NEW_ITEM-UNIT||3||Unit of measure as ISO code||C62|
|NEW_ITEM-LEADTIME||5||Delivery time in working days||1|
|NEW_ITEM-VENDOR||10||K&K supplier number at the customer||KK123456|
|NEW_ITEM-MATNR||40||Customer item number||Your ITEM.No.|
|NEW_ITEM-LONGTEXT_N:132||nonrestricted||Long text||Threaded close up to the head.|
|NEW_ITEM-EXT_SCHEMA_TYPE||10||Classification system and version||ECLASS-9.1|
|NEW_ITEM-EXT_CATEGORY_ID||60||Product classification without hyphens||23110101|
for OCI:The abbreviation OCI has a different meaning in finance, where it stands for Other Comprehensive Income. In corporate accounting, this stands for other comprehensive income (OCI), which includes income, expenses, profits and losses that have not yet been realized. OCI is used here to show changes in value that do not reflect the value creation of the company.
In the software world, the abbreviation OCI stands for Open Container Initiative, which is a project of the Linux Foundation to define open standards for virtualization at operating system level.