Index Salesforce Commerce Cloud: Pull approach

This article explains how to pull data from a Salesforce Commerce Cloud instance (previously known as Demandware) to a Coveo organization. The indexed data is then used in a Coveo-powered search interface implemented in your storefront.

Prerequisites

Make sure that you have:

  • Data in your Salesforce Commerce Cloud instance.

  • Access to the B2C Account Manager (also known as the Demandware login page). To get access, you have to contact an account administrator within your organization.

  • A SLAS client created.

Index a Salesforce Commerce Cloud

  1. Log in to the SLAS Admin UI by using your own short code.

    https://<SHORT-CODE>.api.commercecloud.salesforce.com/shopper/auth-admin/v1/ui/
  2. Once logged in, you can see the Client ID and Secret fields. Copy the values of these fields and store them somewhere locally.

  3. To create a token for indexing data, you need to make a POST request to the getAccessToken endpoint of the Shopper Login API.

    You can do it by using the Postman application.

    1. Use the Client ID and Secret values from the previous steps as Login and Password respectively.

    2. Specify Basic Auth as the Authentication Type.

    3. Substitute your shortCode and organizationId

      https://{shortCode}.api.commercecloud.salesforce.com/shopper/auth/v1/organizations/{organizationId}/oauth2/token

      You’ll receive an SLAS token in a response.

      Important

      The SLAS token is valid only for 30 minutes. Once it expires, you have to create a new one.

  4. Go to your Coveo organization and add a REST API cloud source. In the Configuration tab, expand the Content to include section and paste the following JSON.

    {
      "Services": [
        {
          "Paging": {
            "PageSize": 200,
            "offset": 0,
            "OffsetType": "item",
            "Parameters": {
              "Limit": "limit",
              "Offset": "offset"
            }
          },
          "Url": "https://{shortCode}.api.commercecloud.salesforce.com/", 1
          "Endpoints": [
            {
              "Headers": {
                "Authorization": "Bearer @ApiKey" 2
              },
              "Path": "/search/shopper-search/v1/organizations/{organizationId}/product-search", 3
              "QueryParameters": {
                "q": "storefront-catalog-m-en",
                "limit": "200", 4
                "siteId": "RefArch" 5
              },
              "Method": "GET",
              "ItemType": "products",
              "ItemPath": "hits",
              "Uri": "https://zzte-053.sandbox.us02.dx.commercecloud.salesforce.com/s/RefArch/%[productName]/%[productId].html", 6
              "ClickableUri": "https://zzte-053.sandbox.us02.dx.commercecloud.salesforce.com/s/RefArch/%[productName]/%[productId].html",
              "Title": "%[productName] %[productId]",
              "ModifiedDate": "%[modified_time]",
              "Body": "%[productName] %[price] %[currency]",
              "Metadata": {
                "ec_name": "%[productName]",
                "ec_price": "%[price]",
                "ec_productid": "%[productId]",
                "ec_colors": "%[variationAttributes[?(@.id=='color')].values[:].name]"
              },
              "SubQueries": [
                {
                  "Method": "GET",
                  "Path": "/product/shopper-products/v1/organizations/f_ecom_zzte-053/products/%[coveo_parent.ec_productid]",
                  "Headers": {
                    "Authorization": "Bearer @ApiKey"
                  },
                  "QueryParameters": {
                    "siteId": "RefArch"
                  },
                  "metadata": {
                    "ec_brand": "%[brand]",
                    "ec_description": "%[longDescription]",
                    "ec_shortdesc": "%[shortDescription]",
                    "ec_category_code": "%[primaryCategoryId]"
                  }
                }
              ],
              "SubItems": [
                {
                  "ItemPath": "variationAttributes",
                  "ItemType": "variations",
                  "image": "%[coveo_parent.raw.image.link]",
                  "Uri": "https://%[coveo_parent.raw.productId]/%[id]/%[name]",
                  "ClickableUri": "https://%[coveo_parent.raw.productName]/%[id]",
                  "Title": "%[coveo_parent.raw.productName] %[id]",
                  "ModifiedDate": "%[modified_time]",
                  "Body": "%[coveo_parent.raw.productName] %[coveo_parent.raw.price] %[coveo_parent.raw.currency] %[name]"
                }
              ]
            }
          ]
        }
      ]
    }
    1 Use your short code.
    2 Specify the SLAS token from the previous step.
    3 Use your organizationId.
    4 The maximum number of products to retrieve. This is a limit set by the Salesforce Shoppers APIs.
    5 Substitute your siteId.
    6 Use your Business Manager URL and siteId in this and the next fields.
  5. Click Add source.

  6. Enable Coveo Personalization-as-you-go.

    1. On the Sources (platform-ca | platform-eu | platform-au) page, select the source you just created.

    2. Click More above the source list, and then select Edit configuration with JSON.

    3. In the parameters section, add the following:

      "UseStreamApi": {
        "value": "true"
      }
      The JSON configuration of a REST API source with a new parameter added
    4. Click Save.

    5. Contact your Customer Success Manager to activate Coveo Personalization-as-you-go (PAYG).

  7. On the Sources (platform-ca | platform-eu | platform-au) page, select your REST API source, and then Rebuild in the More menu.

Once the source is built or rebuilt, you can review its content in the Content Browser.

Add the Coveo search to your storefront

Depending on what type of architecture you use, you can add the Coveo search to your storefront by following one of the following articles: