What is an OCI connection?

OCI is short for Open Catalogue Interface, which means that the Spend Cloud is able to connect to a webshop. People can use this connection to order products in your webshop without leaving the Spend Cloud. This is beneficial for the person placing orders, the organiziation they are ordering for and for the supplier itself.

Why use OCI connections to improve processes?

It takes a lot of work to keep information updated when not using OCI connections, since you have to provide extensive administration. With every price change (temporary or permanent), suppliers have to contact customers and process data correctly. This makes the process prone to error. Corrections take up extra time and result in extra costs.

Processing with OCI connections means processing with data (products and agreements about price and volumes) that is always up to date and automatically available. The process is thus less prone to error. OCI connections are also not a Spend Cloud exclusive functionality. They are able to work for every customer willing to invest time and effort. A uniform way of working is within reach!

In short: OCI connections are the solution

How do OCI connections work in the Spend Cloud?

A user logs in to the Spend Cloud and sees with which suppliers an OCI connection is set up. For suppliers with whom we don't have a connection, other orderings options are available such as predefined articles in their own catalog or a custom order line.

By clicking on the logo, the user is taken to the supplier's webshop and is also logged in immediately. The user can then select the desired articles in the usual way and fill the shopping cart.

When the order request is complete, the user is sent back to the Spend Cloud, whereby the shopping cart of the webshop is copied by the Spend Cloud. The order request is not yet placed as an order with the supplier at that time, but will first go through the approval process within the Spend Cloud. The order is automatically offered to the supplier with an order number for processing only after the approval process is completed.

The process looks like this:

How do I implement an OCI connection?

The Spend Cloud uses a connection based on the standard OCI from SAP, a commonly used standard for exchanging catalogs and systems through the "punch-out" technique. Data can be exchanged through this punch-out. For more information about this technique and the realization of connection possibilities, you can consult the SAP manual.

In short, the configuration of an OCI connection requires you to:

  1. Make sure the webshop is accessible with a dynamic URL.
  2. Redirect your webshop to the Spend Cloud.
  3. Ensure shopping cart data and the webshop are compatible.
  4. Make sure the webshop can receive orders from the Spend Cloud.
  5. Provide Visma | ProActive with the information needed to complete the configuration.

When this project has priority and you have the technical skills, it will usually take about a day. You will find more details below.

Login automatically into the webshop?

To access a webshop from the Spend Cloud, it must be possible to access it via a URL, in which the login details of the webshop can be entered dynamically. The Spend Cloud can then provide correct data to the webshop, so the user is automatically logged in.

An example of a URL from supplier Quick Office Supplies:

https://b2b.quickofficesupplies.nl/invoke/EINL/ocilogin?USERNAME=$username&PASSWORD=$password&OCI_VERSION=3.0&HOOK_URL=$hook_url

Note! $username and $password are variables. These are credentials for logging into the webshop and should be provided by the supplier (Quick Office Supplies). When the username or the password of the user contains special characters, the Spend Cloud will encode them in the URL link. For example the username purchaser@proactive.nl will return in the URL as purchaser%40proactive.nl

So the username has to be decoded at the supplier's side and we advise not to use special characters. $hook_url is also a variable, but this variable is supplied by the Spend Cloud Procurement module and will need to be used as described in the following paragraph.

Redirect to the Spend Cloud

After the user has compiled the order in the webshop, the articles must be sent to the Spend Cloud Procurement module by a form post. When you automatically log into the webshop, the Spend Cloud indicates to which address the shopping cart should be sent (the hook URL variable). This value needs to be stored by the supplier in the webshop so the contents of the shopping cart can be sent back to the Spend Cloud Procurement module.

In the example of the URL of Quick Office Supplies, the hook URL is shown as boldly marked below:

https://b2b.quickofficesupplies.nl/invoke/EINL/ocilogin?USERNAME=$username&PASSWORD=$password&OCI_VERSION=3.0&HOOK_URL=$hook_url

An example of a hook URL:

https://spend.cloud/proactive-frame.nl/customer/oci.php?hash=$hash&supplier_id=$supplier_id&administration_id=$administration_id&delivery_address_id=$delivery_address_id

Multiple variables need to be used when posting the shopping cart back to the Spend Cloud Procurement module.

Offer shopping cart content

Upon return, the contents of the shopping cart must be offered to the Spend Cloud. Data like the article number, prices, number of items, etc. must be offered using the OCI standard (via a form that is posted). The Spend Cloud bases the order on this information. You can find an example of what this looks like on the next page.


An elaborate description of all the fields that you can provide is described in detail in the SAP manual under the heading "4.2 Fields and Field Checks". Below a table that describes the standard field interpretation of the Spend Cloud Procurement module.

Other fields can be mapped (such as NEW_ITEM-CUST_FIELD1) on the side of Visma | ProActive. Below you will find a few points of attention, which have to be configured and tested on both sides with the Visma | ProActive contact person:

Processing The Order

After the order request has gone through the approval process in the Spend Cloud Procurement module, the order request can be entered as an order offered to the supplier. Depending on the possibilities of the supplier the order can be offered as follows:

It is preferred that an order file contains all the information required for the supplier when placing the order. It is not desirable that only an order number is provided where the previously saved order will be processed. This is not desirable because, during the approval process in the Spend Cloud, mutations can take place on the original in the webshop compound order. Numbers can change, but articles can also be removed from the original order in the webshop.

If the processing methods do not apply to the supplier, alternatives may be discussed with us.

What will orders I receive look like?

Example of an XML file you will receive

Via this link, you will download a zip file that contains two XML files. One with the XML-tags ("standard order + order lines") and the other prefilled ("standard order + orderlines.xml prefilled"), based on a placed order. The tags can be manually configured on the side of Visma | ProActive, so all the necessary information to process the order successfully will be sent to the supplier.

Note: All the information the supplier sends in the punch-out can be returned to the supplier.

Below are two screenshots of the XML files. The first uses XML tags and in the second screenshot, you can see how tags are filled. The first screenshot (with XML tags):



Second screenshot (XML tags filled):

What information does Visma | ProActive need?

We need this information to configure the OCI connection:

Based on this information, we will perform a test in consultation with the supplier, whereby the supplier must monitor whether the order has been received correctly. In particular, if the order is posted, it must be checked whether all fields are filled accurately.
After a positive test, we will configure the following:

After the go-live, we will add the supplier to a list of suppliers with which an OCI connection has been set up.

Help setting up an OCI connection as a supplier?

If the supplier webshop is unable to connect via OCI, there's always our partner that can aid suppliers in realising an OCI connection. Click the logo below to get more information:

"We support B2B suppliers in offering an OCI catalog or expanding an existing webshop with OCI options. The standardized solution that we offer connects the supplier assortment with the purchasing package of the business customer. If desired, there is the possibility for a demo. Connections have been arranged within 3 days, depending on how fast the supplier can act."

Do you have any questions?

If you have any questions regarding this document, please contact the relevant project consultant. You can receive the contact information through the customer who wishes to use the OCI Webshop to make a connection with the project consultant. Or check the image below or visit Visma | ProActive's website for more contact information.