Configure Oracle Commerce with Oracle Product Hub

This section describes tasks you must perform to configure Commerce for the integration.

You perform these tasks in the Commerce administration interface and with the Commerce REST APIs.

Register the application and generate a security token

This integration uses the Commerce REST APIs to access Commerce data. You must register the integration within Commerce and generate a security token in order for the integration to be granted access to the data.

To generate a security token:

1. Log into the Commerce administration interface.
2. Click the Settings menu and select Web APIs.
3. Click Registered Applications from the Web APIs panel.
4. Click the Register Application button.
5. Enter a name for the integration application. Create a meaningful name that reflects the purpose of the application.
6. Click Save. The Application ID and Application Key are automatically generated and the application is added to the Registered Applications page.
7. Click on the name of the application you created.
8. Click to reveal link to display the application key. You can copy the application key to use as the security token for the Oracle Commerce connection.

For more information on managing an application within Commerce, see Register applications.

Configure the Commerce webhooks

You must configure the Publish Complete and Import Complete webhooks.. Follow these steps to configure the webhooks in the Commerce administration interface:

1. Log into the Commerce administration interface.
2. Click the Settings icon.
3. Click Web APIs and then click the Webhook tab.
4. Click the Publish Complete (Production) webhook. Enter the integration (Oracle Commerce OIC ProductHubInt Resubmit Webhook) endpoint URL in the URL box and enter the OIC username and password, under Basic Authorization.
5. Click the Import Complete (Production) webhook. Enter the integration (Oracle Commerce OIC ImportComplete Post Processing) endpoint URL in the URL box and enter the OIC username and password under Basic Authorization.
6. Click Save.

Attribute mappings

The following table shows the relationships between Product Hub product Item properties and Commerce product properties.

Commerce product property	Product Hub product item field
id	ItemNumber
displayName	ItemDescription
nonreturnable	ReturnableFlag
orderLimit	MaximumOrderQuantity
description	LongDescription
shippable	ShippableFlag
taxCode	OutputTaxClassificationCodeValue
active	ItemStatusValue
listPrice	ListPrice

The following table shows the relationships between Product Hub product Item properties and Commerce SKU properties.

Commerce SKU property	Product Hub product item field
id	ItemNumber
productId	ItemNumber of parent style Item
displayName	ItemDescription
nonreturnable	ReturnableFlag
active	ItemStatusValue
listPrice	ListPrice