Commerce Connect 13 + ODP
7 min
This integration exports data from Commerce Connect 13 and imports it into Optimizely Data Platform (ODP)
To integrate Commerce Connect 14 with ODP, use one of the following:
- Commerce Connect + ODPCommerce Connect + ODP (recommended)
- Commerce Connect 13 or 14 + ODPCommerce Connect 13 or 14 + ODP
Optimizely Commerce Connect 13 contains an Optimizely Data Platform (ODP) export job to export data, including orders, customers, and products, to ODP.
Setting keys
- episerver:odp.ExportCatalog – Export products to ODP. The default is true.
- episerver:odp.ExportCustomers – Export customers to ODP. The default is true.
- episerver:odp.ExportOrders – Export orders to ODP. The default is true.
- episerver:odp.IncludeProducts – Include products and variations and packages. The default is true.
- episerver:odp.ProductBatchSize – Batch size when sending products to ODP. The default is 50.
- episerver:odp.OrderBatchSize – Batch size when sending orders to ODP. The default is 50.
- episerver:odp.CustomerBatchSize – Batch size when sending customers to ODP. The default is 50.
MarketKey settings
The MarketKey settings define the collection of MarketKey, which the ODP job uses to get Commerce Connect's data to ODP. MarketKey contains 3 properties:
- MarketId – ID of the market, such as US or SWE, to filter Orders or Products when collecting data.
- AccessKey – ODP’s credential.
- EndpointUrl – The URL that receives the data from Commerce Connect.
You can use one of two formats to set the MarketKey collection.
Format 1
<add key="episerver:odp.US.AccessKey" value=""/>
<add key="episerver:odp.US.EndpointUrl" value=""/><add key="episerver:odp.SWE.AccessKey" value=""/>
<add key="episerver:odp.SWE.EndpointUrl" value=""/>Format 2: Added from Customized Commerce 13.37.0
- Support catalog setting with one or multiple values – When a catalog is present:
- The job checks if there are any LineItem in the order that belongs to a catalog, then filters the orders by catalog.
- The job filters products by catalogs.
- The job sends customers to every endpoint or access key because customers are unrelated to catalogs.
- Configuration setting format – The job uses scope to create a group, which is any valid string used as a setting
- Keys – Catalogs and MarketIds keys containing multiple catalog names or market IDs are separated by ;.
Examples of format setting
- Empty catalog – This format can replace the old setting format.
<add key="episerver:odp.EndpointUrl.Alias0" value="Alias0_endpoint"/>
<add key="episerver:odp.AccessKey.Alias0" value="Alias0_accesskey"/>
<add key="episerver:odp.MarketIds.Alias0" value="US; SWE" /><add key="episerver:odp.EndpointUrl.Alias1" value="Alias1_endpoint"/>
<add key="episerver:odp.AccessKey.Alias1" value="Alias1_accesskey"/>
<add key="episerver:odp.MarketIds.Alias1" value="SWE" />- One catalog
<add key="episerver:odp.EndpointUrl.Alias0" value="Alias0_endpoint"/>
<add key="episerver:odp.AccessKey.Alias0" value="Alias0_accesskey"/>
<add key="episerver:odp.Catalogs.Alias0" value="Fashion"/>
<add key="episerver:odp.MarketIds.Alias0" value="US; SWE " /><add key="episerver:odp.EndpointUrl.Alias1" value="Alias1_endpoint"/>
<add key="episerver:odp.AccessKey.Alias1" value="Alias1_accesskey"/>
<add key="episerver:odp.Catalogs.Alias1" value=" Other catalog "/>
<add key="episerver:odp.MarketIds.Alias1" value="SWE" />- Multiple catalogs
add key="episerver:odp.EndpointUrl.Alias1" value="Alias1_endpoint"/>
<add key="episerver:odp.AccessKey.Alias1" value="Alias1_accesskey"/>
<add key="episerver:odp.Catalogs.Alias1" value=" Fashion; Other catalog "/>
<add key="episerver:odp.MarketIds.Alias1" value="US" />