Commerce Cloud connects the customer journey and drives success from anywhere with customer-centric commerce built for every industry.

Completely connect your digital customer journey.
- Personalize engagement with customer-centric commerce.
- Unify data, personalize every interaction, and grow revenue across channels with automation, AI, and a single source of truth.
Connect commerce to the customer journey.
- Convert more customers and drive loyalty with a seamless customer journey from marketing to sales, commerce, fulfillment, service, and beyond. Build with your choice of clicks- or code-based tools.
Adapt quickly with an agile, scalable, and secure platform.
- Innovate at the speed of your customers, scale easily across the globe, and meet any level of demand. Extend your commerce with a partner ecosystem of apps to deliver experiences like augmented reality, marketplaces, and more.

What can you do with this Integration?

Salesforce Commerce Cloud Import Integration will provide the following abilities:
- Authenticate using API Client via OAuth.
- Ingest customer information for a specific list
- Ingest of Customer resources, for example:
  - customer information
  - name, gender, email
- Ingest Product resource, for example:
  - a list of products
  - product information
- Ingest Inventory and Product Inventories resource, for example:
  - list of inventories
  - product inventory allocation
  - product inventory stock level
  - product inventory ID
- Ingest Category and Product Assignments resource, for example:
  - category information
  - product belongs to each category
- Ingest Store resources, for example:
  - all stores
  - store information including id, address, postal code, country, inventory id
- Ingest Catalog resources, for example:
  - catalog info
  - assigned product counts

Prerequisites

Basic Knowledge of Treasure Data
Basic knowledge of Treasure Data CLI
Basic knowledge of Salesforce Commerce Cloud
Basic knowledge of Open Commerce Cloud API
Commerce Cloud Account Manager System Access

Limitations

Incremental loading is only supported for Creation Date, not Modified Date
A large volume of data may cause low performance
In preview mode, the connector does not support generating the detailed data preview because of time restrictions on fetching the data preview.

An Inventory List with no product is still inserted as one record, the properties belong to the Product Inventory List and will be null.

About Incremental Data Loading

Create the API Client on Commerce Cloud Account Manager System

These steps are necessary to create the credentials that are needed to define the authentication for your integration.

Navigate to the Salesforce Cloud Commerce UI and login. For example, Account Manager UI.

Integrations > Salesforce Commerce Cloud Import Integration > image2021-6-29_11-22-1.png

Select API Client.

Select Add API Client.

Type values for:

- Display Name
- Password
- Confirm Password

Select Access Control to enable it.

In the Organizations area, select your organization.

In the Roles area, select Add.

Select the appropriate role. For example, Sandbox API User.

Select Add.

After the role is added, select all the sandboxes associated with it.

Select Add.

Scroll down to Open ID Connect.

Add Default Scopes:

- mail
- roles
- tenantFilter
- profile

Add Redirect URI. For example:

https://admin.us01.dx.commercecloud.salesforce.com/oauth2-redirect.html

Scroll to the Token Endpoint Auth Method section.

Select client_secret_basic.

Select JWT for Access Token Format.

Select Save.

You are taken back to the API Client screen.

Write down or save in a secure location the API Client ID and Password.

These are used as Authentication credentials to integrate with your SFCC instance.

Enable the API Client to Access the Data API

These steps enable your API Client to be used with the Data API and Salesforce B2C Commerce Cloud connector.

Open Business Manager. For example:

https://{YOUR_INSTANCE_URL}.commercecloud.salesforce.com/on/demandware.store/Sites-Site/default/ViewApplication-DisplayWelcomePage

Select Administration.

Select Open Commerce API Settings.

Select Type as Data.

The configuration for Data API appears.

Type or copy the following into the text field:

{ "_v": "21.6", "clients": [ { "client_id": "your_api_client_id", "resources": [ { "methods": [ "get", "post", "put", "patch", "delete" ], "read_attributes": "(**)", "write_attributes": "(**)", "resource_id": "/**" } ] } ] }

For Select Context choose Global (organization-wide).

Integrations > Salesforce Commerce Cloud Import Integration > Screen Shot 2021-05-18 at 11.20.52.png

Select Save.

Wait for at least 3 minutes.

Your API Client is ready to be used with Data API and Salesforce B2C Commerce Cloud connector.

Use the TD Console to Create Your Connection

Create a New Connection

In Treasure Data, you must create and configure the data connection prior to running your query. As part of the data connection, you provide authentication to access the integration.

Open TD Console.

Navigate to Integrations Hub > Catalog.

Search for and select Salesforce B2C Commerce Cloud.

Integrations > Salesforce Commerce Cloud Import Integration > Screen Shot 2021-06-29 at 10.23.14 AM.png

Choose Create Authentication.

The following dialog opens:

Integrations > Salesforce Commerce Cloud Import Integration > Screen Shot 2021-06-29 at 10.26.36 AM.png

Type or select the required information:

Parameter	Description
API Client ID	Key which you got after create your application on Commerce Cloud's Account Manager Application.
API Client Password	The password for your API Client when you create on Commerce Cloud's Account Manager Application.
Base URI	URL for accessing your Business Manager Application. Example value https://xxxx.commercecloud.salesforce.com/

Type a name for your connection.

Integrations > Salesforce Commerce Cloud Import Integration > Screen Shot 2021-06-29 at 10.29.48 AM.png

Select Continue.

Transfer Your Data to Treasure Data

After creating the authenticated connection, you are automatically taken to Authentications.

Search for the connection you created.

Integrations > Salesforce Commerce Cloud Import Integration > Screen Shot 2021-06-29 at 10.37.51 AM.png

Select New Source.

Type a name for your Source in the Data Transfer field.

Select Next.

The Source Table dialog opens.

Edit the following parameters:

Integrations > Salesforce Commerce Cloud Import Integration > d63b3e0c-bb0c-42e1-ac47-d7a453b90ff0.png

Parameters	Description	Description of Data Types
Data Type	The data objects that you want to ingest into Treasure Data:
	Customers From List	The customer info from a specific customer list
	Products	Product info of Salesforce Commerce Cloud account
	Categories and Product Assignments	Product category info and products belong to each category
	Inventory Lists and Product Inventories	Inventory list and product in each inventory list
	Stores	Store info, location, and inventory belongs to stores
	Catalogs	Product catalog info and count of products for each catalog
Customer List ID	The customer List ID you want to import customer information from
Incremental loading	Select to ingest only newly created data since the previous ingestion.
Created From	The specific time you would like to ingest the data (`YYYYMMDDHH` format).

Select Next.

The Data Settings page can be modified for your needs or you can skip the page.

Optionally, edit the following parameters:

Integrations > Salesforce Commerce Cloud Import Integration > Screen Shot 2021-06-29 at 10.48.43 AM.png

Select Next.

Data Preview

Data Placement

Available Configuration

Configuration name	Type	Available when	Required	Sample value	Description
base_url	STRING	default	yes	https://xxxx.example.com	SFCC’s instance base url
catalog_id	STRING	target = categories	no	test	Catalog’s ID
client_id	STRING	default	yes	abcdef	Application’s ID
client_secret	STRING	default	yes	abcdef	Application’s Secret
customer_list_id	STRING	target = customers	yes if target = customers	test	Customer List Id
incremental	BOOLEAN	target = customers target = products target = catalog	no	true	Ingest incremental or not
initial_retry_wait	LONG	default	no	1	First wait time when retrying (in seconds)
inventory_list_id	STRING	target = inventory_lists	no	test	Inventory List’s ID
last_value	STRING	target = customers target = products target = catalog	no	2021-05-25T02:49:29.000Z	The timestamp to start ingest data
levels	LONG	target = categories	yes if target = categories	0	Level of sub-category to ingest when target = categories
maximum_retries	LONG	default	no	5	Maximum number of retry
maximum_retry_wait	LONG	default	no	120	Max wait time when retrying (in seconds)
site_id	STRING	target = products target = stores	yes if target = stores	test	The Site ID
target	ENUM (customers , stores , categories , products , catalogs , inventory_lists )	default	yes	customers	Target data type to ingest

Sample Configuration

Customers

in:
  type: salesforce_commerce_cloud
  client_id: xxx
  client_secret: yyy
  base_url: https://{realm_id}-001.sandbox.us01.dx.commercecloud.salesforce.com/
  target: customers
  customer_list_id: phu_test
  last_value: 2021-05-25T02:49:29.000Z
  incremental: true

Products

in:
  type: salesforce_commerce_cloud
  client_id: xxx
  client_secret: yyy
  base_url: https://{realm_id}-001.sandbox.us01.dx.commercecloud.salesforce.com/
  target: products
  site_id: phu_test
  incremental: true
  last_value: 2021-05-25T02:55:28.000Z

Stores

in:
  type: salesforce_commerce_cloud
  client_id: xxx
  client_secret: yyy
  base_url: https://{realm_id}-001.sandbox.us01.dx.commercecloud.salesforce.com/
  target: stores
  site_id: phu_test2

Inventory Lists and Product Assignments

in:
  type: salesforce_commerce_cloud
  client_id: xxx
  client_secret: yyy
  base_url: https://{realm_id}-001.sandbox.us01.dx.commercecloud.salesforce.com/
  target: INVENTORY_LISTS

Catalogs

in:
  type: salesforce_commerce_cloud
  client_id: xxx
  client_secret: yyy
  base_url: https://{realm_id}-001.sandbox.us01.dx.commercecloud.salesforce.com/
  target: catalogs
  incremental: true
  last_value: 2021-05-26T02:55:28.000Z

What can you do with this Integration?

Prerequisites

Limitations

About Incremental Data Loading

Create the API Client on Commerce Cloud Account Manager System

Navigate to the Salesforce Cloud Commerce UI and login. For example, Account Manager UI.

Select API Client.

Select Add API Client.

Type values for:

Select Access Control to enable it.

In the Organizations area, select your organization.

In the Roles area, select Add.

Select the appropriate role. For example, Sandbox API User.

Select Add.

After the role is added, select all the sandboxes associated with it.

Select Add.

Scroll down to Open ID Connect.

Add Default Scopes:

Add Redirect URI. For example:

Scroll to the Token Endpoint Auth Method section.

Select client_secret_basic.

Select JWT for Access Token Format.

Select Save.

Write down or save in a secure location the API Client ID and Password.

Enable the API Client to Access the Data API

Open Business Manager. For example:

Select Administration.

Select Open Commerce API Settings.

Select Type as Data.

Type or copy the following into the text field:

For Select Context choose Global (organization-wide).

Select Save.

Wait for at least 3 minutes.

Use the TD Console to Create Your Connection

Create a New Connection

Open TD Console.

Navigate to Integrations Hub > Catalog.

Search for and select Salesforce B2C Commerce Cloud.

Choose Create Authentication.

Type or select the required information:

Type a name for your connection.

Select Continue.

Transfer Your Data to Treasure Data

Search for the connection you created.

Select New Source.

Type a name for your Source in the Data Transfer field.

Select Next.

Edit the following parameters:

Select Next.

Optionally, edit the following parameters:

Select Next.

Data Preview

Data Placement

Available Configuration

Sample Configuration

Customers

Products

Stores

Inventory Lists and Product Assignments

Categories

Catalogs