Integration Specifications
This article will help you learn about how Daasity replicates data from Salesforce Commerce Cloud, limitations to the data we can extract and where the data is stored in the Salesforce Commerce schema
Integration Overview
Salesforce Commerce Cloud empowers you to create seamless e-commerce experiences that inspire and convert today's connected shoppers. With our cloud-based e-commerce software, you can go to market faster and smarter — delivering personalized customer experiences across mobile, digital, and social platforms.
Salesforce Commerce Cloud (also known as Demandware) allows brands to build localized site, order management and fulfillment for each region in a single platform.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
Enterprise
API Endpoints
The Daasity Salesforce Commerce Cloud extractor is broken into two sections:
Salesforce B2C Commerce (SFCC) endpoints are based on this OpenCommerce API Documentation to extract data from the website.
Salesforce Order Management (SOM) endpoints are based on this Salesforce Order Management API documentation to extract order data.
These endpoints are used by Daasity to replicate data from Salesforce Commerce Cloud:
Salesforce B2C Commerce (SFCC)
Campaigns
Catalogs
Coupons
Coupon Redemption Search
Inventory Lists
Products
Promotions
Sites
Salesforce Order Management (SOM)
Accounts
Contacts
Fulfillment Order Item Tax
Fulfillment Order Line Item
Order Adjustment Group Summary
Order Delivery Group Summary
Order Item Summary
Order Item Tax Line Summary
Order Payments Summary
Order Summary
Sales Channels
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Salesforce Commerce Cloud integration illustrating the different tables and keys to join across tables.
Salesforce Commerce Cloud Schema
The Daasity Salesforce Commerce extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Salesforce B2C Commerce (SFCC)
Campaigns
Endpoint: SFCC Campaigns
Update Method: UPSERT
Table Name: [
salesforce_commerce.campaigns]
Campaign Customer Groups
Endpoint: SFCC Campaigns
Update Method: UPSERT
Table Name: [
salesforce_commerce.campaign_customer_groups]
Campaign Coupon Codes
Endpoint: SFCC Campaigns
Update Method: UPSERT
Table Name: [
salesforce_commerce.campaign_coupon]
Catalogs
Endpoint: SFCC Catelogs
Update Method: UPSERT
Table Name: [
salesforce_commerce.catalogs]
Catalog Sites
Endpoint: SFCC Catalogs
Update Method: UPSERT
Table Name: [
salesforce_commerce.catalog_sites]
Coupons
Endpoint: SFCC Coupons
Update Method: UPSERT
Table Name: [
salesforce_commerce.coupons]
Coupon Redemptions
Endpoint: SFCC Coupon Redemption Search
Update Method: UPSERT
Table Name: [
salesforce_commer.coupon_redemptions]
Inventory Lists
Endpoint: SFCC Inventory Lists
Update Method: UPSERT
Table Name: [
salesforce_commerce.inventory_lists]
Inventory List Sites
Endpoint: SFCC Inventory Lists
Update Method: UPSERT
Table Name: [
salesforce_commerce.inventory_list_sites]
Products
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.products]
Product Categories
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_categories]
Product Bundles
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_bundles]
Product Images
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_images]
Product Options
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_options]
Product Sets
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_sets]
Product Variants
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_variants]
Product Custom Attribute Values
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_custom_attribute_values]
Promotions
Endpoint: SFCC Promotions
Update Method: UPSERT
Table Name: [
salesforce_commerce.promotions]
Promotion Custom Attribute Values
Endpoint: SFCC Promotions
Update Method: UPSERT
Table Name: [
salesforce_commerce.promotion_custom_attribute_values]
Promotion Tags
Endpoint: SFCC Promotions
Update Method: UPSERT
Table Name: [
salesforce_commerce.promotion_tags]
Sites
Endpoint: SFCC Sites
Update Method: UPSERT
Table Name: [
salesforce_commerce.sites]
Salesforce Order Managment (SOM)
Accounts
Endpoint: SOM Account
Update Method: UPSERT
Table Name: [
salesforce_commerce.accounts]
Account Custom Attribute Values
Endpoint: SOM Account
Update Method: UPSERT
Table Name: [
salesforce_commerce.account_custom_attribute_values]
Contacts
Endpoint: SOM Contacts
Update Method: UPSERT
Table Name: [
salesforce_commerce.contacts]
Fulfillment Orders
Endpoint: Fulfillment Order
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_orders]
Fulfillment Order Item Adjustments
Endpoint: SOM Fulfillment Order Item Adjustment
Update Method: UPESRT
Table Name: [
salesforce_commerce.fulfillment_order_item_adjustments]
Fulfillment Order Item Taxes
Endpoint: SOM Fulfillment Order Item Tax
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_order_item_taxes]
Fulfillment Order Line Items
Endpoint: SOM Fulfillment Order Line Item
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_order_line_items]
Fulfillment Order Line Item Custom Attribute Values
Endpoint: SOM Fulfillment Order Line Item
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_order_line_item_custom_attribute_values]
Order Adjustment Group Summaries
Endpoint: SOM Order Adjustment Group Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_adjustment_group_summaries]
Order Delivery Group Summaries
Endpoint: SOM Order Delivery Group Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_delivery_group_summaries]
Order Delivery Group Custom Attribute Values
Endpoint: SOM Order Delivery Group Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_delivery_group_custom_attribute_values]
Order Delivery Methods
Endpoint: SOM Order Delivery Method
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_delivery_methods]
Order Item Summaries
Endpoint: SOM Order Item Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_summaries]
Order Item Summary Custom Attribute Values
Endpoint: SOM Order Item Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_summary_custom_attribute_values]
Order Item Adjustment Line Summaries
Endpoint: SOM Order Item Adjustment Line Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_adjustment_line_summaries]
Order Item Tax Line Summaries
Endpoint: SOM Order Item Tax Line Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_tax_line_summaries]
Order Payment Summaries
Endpoint: SOM Order Payment Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_payment_summaries]
Order Summaries
Endpoint: SOM Order Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_summaries]
Order Summary Custom Attribute Values
Endpoint: SOM Order Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_summary_custom_attribute_values]
Sales Channels
Endpoint: SOM Sales Channels
Update Method: UPSERT
Table Name: [
salesforce_commerce.sales_channels]
Last updated