Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info

This data connector is in Beta. For more information, contact support@treasuredata.com.


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

...

  • 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

  • The application secret should not contain the %  character. Due to an internal issue with the SFCC authentication server, any secret the contains the % character, is not able to authenticate.
  • 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  

...

Numbered Headings
start-numbering-with1
start-numbering-ath5
Navigate to the Salesforce Cloud Commerce UI and login. For example, Account Manager UI.


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 Scroll totheToken Endpoint Auth Methodsection.
Select client_secret_basic.
Select JWT for Access Token Format.

Select Save.

You are taken back to theAPI Clientscreen.



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.

...

Numbered Headings
start-numbering-ath5
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:
Code Block
{ "_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).

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.

...

Numbered Headings
start-numbering-with1
start-numbering-ath5
Open Open TD Console.
Navigate to to Integrations Hub   >  Catalog.
Search for and select Salesforce B2C Commerce Cloud.

Choose Create Authentication.

The following dialog opens:


Type or select the required information:
ParameterDescription

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.

Select Continue.


...

Numbered Headings

Excerpt Include
Data Placement
Data Placement
nopaneltrue

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

...