Integration: Salesforce Commerce Cloud

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.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

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.

Integration Availability

This integration is available for:

  • Pro (V1 and V2)

NOTE: You are considered V2 if...

  • You are a Growth customer
  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com

API Endpoints

The Daasity Salesforce Commerce Cloud extractor is broken into two sections:

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)

The embedded diagram houses the ERD for the Daasity Salesforce Cloud Commerce integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.

Salesforce Commerce 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
JSON Element Database Column
campaign_id campaign_id
description description
enabled enabled
start_date start_date
end_date end_date
creation_date created_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(campaign_id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Campaign Customer Groups

  • Endpoint: SFCC Campaigns
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.campaign_customer_groups
JSON Element Database Column
campaign_id campaign_id
customer_groups customer_groups
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(campaign_id + customer_groups + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Campaign Coupon Codes

  • Endpoint: SFCC Campaigns
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.campaign_coupon
JSON Element Database Column
campaign_id campaign_id
coupons coupon_code
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(campaign_id + coupons + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Catalogs

  • Endpoint: SFCC Catelogs
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.catalogs
JSON Element Database Column
id catalog_id
creation_date created_at
last_modified updated_at
online online_status
name::default catalog_name
assigned_product_count assigned_product_count
category_count category_count
owned_product_count owned_product_count
recommendation_count recommendation_count
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Catalog Sites

  • Endpoint: SFCC Catalogs
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.catalog_sites
JSON Element Database Column
assigned_sites::id catalog_site_id
id catalog_id
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(assigned_sites::id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Coupons

  • Endpoint: SFCC Coupons
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.coupons
JSON Element Database Column
coupon_id coupon_id
creation_date created_at
last_modified updated_at
description description
enabled coupon_enabled
single_code coupon_code
total_codes_count total_coupon_codes
type coupon_code_type
redemption_limits::limit_per_code limit_per_code
redemption_limits::limit_per_customer limit_per_customer
system_codes_config::code_prefix coupon_code_prefix
system_codes_config::number_of_codes max_coupon_codes
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(coupon_id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Coupon Redemptions

  • Endpoint: SFCC Coupon Redemption Search
  • Update Method: UPSERT
  • Table Name: salesforce_commer.coupon_redemptions
JSON Element Database Column
coupon_id coupon_id
coupon_code coupon_code
customer_email customer_email
order_no order_no
creation_date created_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(coupon_id + order_no + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Inventory Lists

  • Endpoint: SFCC Inventory Lists
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.inventory_lists
JSON Element Database Column
id inventory_list_id
creation_date created_at
last_modified updated_at
default_in_stock default_in_stock
on_order_inventory_enabled on_order_inventory_enabled
use_bundle_inventory_only use_bundle_inventory_only
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Inventory List Sites

  • Endpoint: SFCC Inventory Lists
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.inventory_list_sites
JSON Element Database Column
id || ':' || assigned_sites::value inventory_list_site_id
id inventory_list_id
assigned_sites::value site_name
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + assigned_sites::value + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Products

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.products
JSON Element Database Column
id product_id
brand brand
name::default product_name
type::bundle product_is_bundle_flag
type::bundled product_part_of_bundle_flag
type::item product_item_flag
type::master product_master_flag
type::option product_option_flag
type::part_of_product_set part_of_product_set_flag
type::part_of_retail_set part_of_retail_set_flag
type::retail_set product_retail_set_flag
type::set product_set_flag
type::variant product_variant_flag
type::variation_group production_variation_group_flag
short_description::default::source short_description
long_description::default::source long_description
page_description::default page_description
page_keywords::default page_keywords
page_title::default page_title
ats available_to_sell
default_variant_id default_variant_id
ean ean
in_stock in_stock
link product_rl
manufacturer_name manufacturer_name
manufacturer_sku manufacturer_sku
maser::master_id product_master_id
online_flag::default@[site_id] online_flag
owning_catalog_id owning_catalog_id
owning_catalog_name owning_catalog_name
price price
price_currency price_currency
primary_category_id primary_category_id
searchable searchable
unit unit
upc upc
creation_date created_at
last_modified updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Product Categories

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.product_categories
JSON Element Database Column
id product_id
assigned_categories::catalog_id catelog_id
assigned_categories::category_id category_id
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + assigned_categories::catalog_id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Product Bundles

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.product_bundles
JSON Element Database Column
id product_id
bundled_products::id bundled_product_id
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + bundled_products::id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Product Images

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.product_images
JSON Element Database Column
id product_id
image::alt::default alt_image_text
image::dis_base_url product_image_url
image::title::default image_title
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + image::title::default + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Product Options

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.product_options
JSON Element Database column
id product_id
product_options::id product_option_id
product_options::custom_name custom_name
product_options::default_product_option_value default_option
product_options::description::default description
product_options::name product_option_name
product_options::selected_option_value selected_option
product_options::shared shared_product_option_flag
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id +product_options::id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Product Sets

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.product_sets
JSON Element Database Column
id product_id
product_sets::id component_product_id
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id +product_sets::id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Product Variants

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.product_variants
JSON Element Database Column
id product_id
variants::product_id product_variant_id
variants::ats available_to_sell
variants::in_stock in_stock
variants::link product_variant_url
variants::online online_flag
variants::orderable orderable_flag
variants::price price
variants::price_currency price_currency
variants::searchable::default@[site_id][1] searchable
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + variants::product_id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Product Custom Attribute Values

  • Endpoint: SFCC Products
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.product_custom_attribute_values
JSON Element Database Column
id product_id
key custom_attribute_key
value custom_attribute_value
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + key + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Promotions

  • Endpoint: SFCC Promotions
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.promotions
JSON Element Database column
id promotion_id
name::default promotion_name
promotion_class promotion_class
currency_code currency_code
archived archived_flag
enabled enabled_flag
disable_globally_exclusion disable_global_exclusion_flag
exclusivity exclusivity
assignment_information::campaign_id campaign_id
assignment_information::schedule_type promotion_schedule_type
assignment_information::end_date promotion_end_date
creation_date created_at
last_modified updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Promotion Custom Attribute Values

  • Endpoint: SFCC Promotions
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.promotion_custom_attribute_values
JSON Element Database Column
id promotion_id
key custom_attribute_key
value custom_attribute_value
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + key + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Promotion Tags

  • Endpoint: SFCC Promotions
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.promotion_tags
JSON Element Database Column
id promotion_id
tags::tag_id tag_name
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + tags::tag_id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Sites

  • Endpoint: SFCC Sites
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.sites
JSON Element Database Column
id site_id
display_name::default site_name
storefront_status site_status
description description
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Salesforce Order Management

Accounts

  • Endpoint: SOM Account
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.accounts
JSON Element Database Column
Id account_id
IsDeleted is_deleted
MasterRecordId master_record_id
Name name
FirstName first_name
LastName last_name
Salutation salutation
MiddleName middle_name
Suffix suffix
Type typ
RecordTypeId record_type_id
ParentId parent_id
BillingStreet billing_street
BillingCity billing_city
BillingState billing_state
BillingStateCode billing_state_code
BillingPostalCode billing_postal_code
BillingCountry billing_country
BillingCountryCode billing_country_code
BillingGeocodeAccuracy billing_geocode_accuracy
BillingLatitude billing_latitude
BillingLongitude billing_longitude
ShippingStreet shipping_street
ShippingCity shipping_city
ShippingState shipping_state
ShippingStateCode shipping_state_code
ShippingPostalCode shipping_postal_code
ShippingCountry shipping_country
ShippingCountryCode shipping_country_code
ShippingGeocodeAccuracy shipping_geocode_accuracy
ShippingLatitude shipping_latitude
ShippingLongitude shipping_longitude
Phone phone
PhotoUrl photo_url
Industry industry
Website website
NumberOfEmployees number_of_employees
Description description
CurrencyIsoCode currency_iso_code
OwnerId owner_id
AccountNumber account_number
HasOptedOutOfEmail has_opted_out_of_email
PersonContactId person_contact_id
IsPersonAccount is_person_account
PersonEmail person_email
PersonMailingStreet person_mailing_street
PersonMailingCity person_mailing_city
PersonMailingState person_mailing_state
PersonMailingPostalCode person_mailing_postal_code
PersonMailingCountry person_mailing_country
PersonMailingGeocodeAccuracy person_mailing_geocode_accuracy
PersonMailingLatitude person_mailing_latitude
PersonMailingLongitude person_mailing_longitude
PersonBirthDate person_birth_date
PersonHomePhone person_home_phone
PersonMobilePhone person_mobile_phone
PersonTitle person_title
PersonDepartment person_department
PersonEmailBouncedDate person_email_bounced_date
PersonEmailBouncedReason person_email_bounced_reason
PersonHasOptedOutOfEmail person_has_opted_out_of_email
AccountSource account_source
Sic sic
SicDesc sic_desc
CreatedById created_by_id
CreatedDate created_at
LastActivityDate last_activity_date
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastReferencedDate last_referenced_date
LastViewedDate last_viewed_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Account Custom Attribute Values

  • Endpoint: SOM Account
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.account_custom_attribute_values
JSON Element Database Column
id account_id
key custom_attribute_key
value custom_attribute_value
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + key + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Contacts

  • Endpoint: SOM Contacts
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.contacts
JSON Element Database Column
Id contact_id
IsDeleted is_deleted
MasterRecordId master_record_id
AccountId account_id
IsPersonAccount is_person_account
CanAllowPortalSelfReg can_allow_portal_self_reg
DoNotCall do_not_call
LastName last_name
FirstName first_name
Salutation salutation
MiddleName middle_name
Suffix suffix
Name name
MailingStreet mailing_street
MailingCity mailing_city
MailingState mailing_state
MailingPostalCode mailing_postal_code
MailingCountry mailing_country
MailingLatitude mailing_latitude
MailingLongitude mailing_longitude
MailingGeocodeAccuracy mailing_geocode_accuracy
Phone phone
Fax fax
MobilePhone mobile_phone
ReportsToId reports_to_id
Email email
Title title
Department department
CurrencyIsoCode currency_iso_code
OwnerId owner_id
EmailBouncedReason email_bounced_reason
EmailBouncedDate email_bounced_at
IsEmailBounced is_email_bounced
HasOptedOutOfEmail has_opted_out_of_email
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastActivityDate last_activity_date
LastReferencedDate last_referenced_date
LastViewedDate last_viewed_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Fulfillment Orders

  • Endpoint: Fulfillment Order
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.fulfillment_orders
JSON Element Database Column
AccountId account_id
Id fulfillment_order_id
OrderSummaryId order_summary_id
OwnerId owner_id
IsDeleted is_deleted
IsSuspended is_suspended
CurrencyIsoCode currency_iso_code
FulfillmentOrderNumber fulfillment_order_number
OrderId order_id
InvoiceId invoice_id
DeliveryMethodId delivery_method_id
FulfilledFromLocationId fulfilled_from_location_id
FulfilledToName fulfilled_to_name
FulfilledToStreet fulfilled_to_street
FulfilledToCity fulfilled_to_city
FulfilledToState fulfilled_to_state
FulfilledToPostalCode fulfilled_to_postal_code
FulfilledToCountry fulfilled_to_country
FulfilledToLatitude fulfilled_to_latitude
FulfilledToLongitude fulfilled_to_longitude
FulfilledToGeocodeAccuracy fulfilled_to_geocode_accuracy
FulfilledToEmailAddress fulfilled_to_address
FulfilledToPhone fulfilled_to_phone
ItemCount item_count
Status status
StatusCategory status_category
Type type
TypeCategory type_category
GrandTotalAmount grand_total_amount
TotalProductAmount total_product_amount
TotalAdjustmentAmount total_adjustment_amount
TotalDeliveryAmount total_delivery_amount
TotalProductTaxAmount total_product_tax_amount
TotalAdjustmentTaxAmount total_adjustment_tax_amount
TotalDeliveryTaxAmount total_delivery_tax_amount
TotalAmount total_amount
TotalTaxAmount total_tax_amount
TotalDeliveryAdjustAmount total_delivery_adjust_amount
TotalDeliveryAdjustTaxAmount total_delivery_adjust_tax_Amount
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastViewedDate last_viewed_date
LastReferencedDate last_referenced_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Fulfillment Order Item Adjustments

  • Endpoint: SOM Fulfillment Order Item Adjustment
  • Update Method: UPESRT
  • Table Name: salesforce_commerce.fulfillment_order_item_adjustments
JSON Element Database Column
Id fulfillment_order_item_adjustment_id
IsDeleted is_deleted
FulfillmentOrderItemAdjustmentNumber fulfillment_order_item_adjustment_number
CurrencyIsoCode currency_iso_code
FulfillmentOrderLineItemId fulfillment_order_line_item_id
FulfillmentOrderId fulfillment_order_id
OrderItemAdjustmentLineSummaryId order_item_adjustment_line_summary_id
CampaignName campaign_name
CouponName coupon_name
PromotionName promotion_name
Description description
TotalTaxAmount total_tax_amount
Amount amount
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastViewedDate last_viewed_date
LastReferencedDate last_referenced_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Fulfillment Order Item Taxes

  • Endpoint: SOM Fulfillment Order Item Tax
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.fulfillment_order_item_taxes
JSON Element Database Column
Id fulfillment_order_item_adjustment_id
IsDeleted is_deleted
FulfillmentOrderItemAdjustmentNumber fulfillment_order_item_adjustment_number
CurrencyIsoCode currency_iso_code
FulfillmentOrderLineItemId fulfillment_order_line_item_id
FulfillmentOrderId fulfillment_order_id
OrderItemAdjustLineSummaryId order_item_adjustment_line_summary_id
CampaignName campaign_name
CouponName coupon_name
PromotionName promotion_name
Description description
TotalTaxAmount total_tax_amount
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastViewedDate last_viewed_date
LastReferencedDate last_referenced_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Fulfillment Order Line Items

  • Endpoint: SOM Fulfillment Order Line Item
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.fulfillment_order_line_items
JSON Element Database Column
Id fulfillment_order_item_tax_id
IsDeleted is_deleted
FulfillmentOrderItemTaxNumber fulfillment_order_item_tax_number
CurrencyIsoCode currency_iso_code
FulfillmentOrderLineItemId fulfillment_order_line_item_id
FulfillmentOrderId fulfillment_order_id
OrderItemTaxLineItemSummaryId order_item_tax_line_item_summary_id
FulfillmentOrderItemAdjustmentId fulfillment_order_item_adjust_id
Type type
Amount amount
Description description
Rate rate
TaxEffectiveDate tax_effective_date
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastViewedDate last_viewed_date
LastReferencedDate last_referenced_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

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
JSON Element Database Column
id fulfillment_order_line_item_id
key custom_attribute_key
value custom_attribute_value
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + key + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Adjustment Group Summaries

  • Endpoint: SOM Order Adjustment Group Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_adjustment_group_summaries
JSON Element Database Column
Id order_adjustment_group_summary_id
IsDeleted is_deleted
Name name
Description description
CurrencyIsoCode currency_iso_code
OrderSummaryId order_summary_id
OriginalOrderAdjGroupId original_order_adj_group_id
Type type
TotalAmount total_amount
TotalTaxAmount total_tax_amount
GrandTotalAmount grand_total_amount
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Delivery Group Summaries

  • Endpoint: SOM Order Delivery Group Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_delivery_group_summaries
JSON Element Database Column
Id order_delivery_group_summary_id
IsDeleted is_deleted
Description description
CurrencyIsoCode currency_iso_Code
OrderDeliveryGroupSummaryNumber order_delivery_group_summary_number
OrderSummaryId order_summary_id
OriginalOrderDeliveryGroupId original_order_delivery_group_id
OrderDeliveryMethodId order_delivery_method_id
EmailAddress email_address
PhoneNumber phone_number
DeliverToName deliver_to_name
DeliverToStreet deliver_to_street
DeliverToCity deliver_to_city
DeliverToState deliver_to_state
DeliverToCountry deliver_to_country
DeliverToLatitude deliver_to_latitude
DeliverToLongitude deliver_to_longitude
DeliverToGeocodeAccuracy deliver_to_geocode_accuracy
GiftMessage gift_message
IsGift is_gift
DeliveryInstructions delivery_instructions
DesiredDeliveryDate desired_delivery_date
PromisedDeliveryDate promised_delivery_date
TotalLineAmount total_line_amount
TotalLineTaxAmount total_line_tax_amount
TotalAdjustmentAmount total_adjustment_amount
TotalAdjustmentTaxAmount total_adjustment_tax_amount
TotalAmount total_Amount
TotalTaxAmount total_tax_amount
GrandTotalAmount grand_total_amount
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

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
JSON Element Database Column
id order_delivery_group_summary_id
key custom_attribute_key
value custom_attribute_Value
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id +key +  __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Delivery Methods

  • Endpoint: SOM Order Delivery Method
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_delivery_methods
JSON Element Database Column
Id order_delivery_method_id
OwnerId owner_id
IsDeleted is_deleted
Name name
Description description
CurrencyIsoCode currency_iso_code
ProductId product_id
ReferenceNumber reference_number
Carrier carrier
ClassOfService class_of_Service
IsActive is_active
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastViewedDate last_viewed_date
LastReferencedDate last_referenced_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Item Summaries

  • Endpoint: SOM Order Item Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_item_summaries
JSON Element Database Column
Id order_item_summary_id
IsDeleted is_deleted
Name name
Description description
CurrencyIsoCode currency_iso_Code
OrderSummaryId order_summary_id
OriginalOrderItemId original_order_item_id
OrderDeliveryGroupSummaryId order_delivery_group_summary_id
Status status
Product2Id product_2_id
ProductCode product_code
LineNumber line_number
Type type
TypeCode type_code
Quantity quantity
QuantityAllocated quantity_allocated
QuantityCanceled quantity_canceled
QuantityOrdered quantity_ordered
QuantityFulfilled quantity_fulfilled
QuantityReturned quantity_returned
QuantityReturnInitiated quantity_return_initiated
QuantityNetOrdered quantity_net_ordered
QuantityAvailableToCancel quantity_available_to_cancel
QuantityAvailableToReturn quantity_available_to_return
QuantityAvailableToFulfill quantity_available_to_fulfill
ListPrice list_price
UnitPrice unit_price
TotalPrice total_price
AdjustedLineAmount adjusted_line_amount
TotalAdjustedLineTaxAmount total_adjusted_line_tax_Amount
TotalTaxAmount total_tax_amount
TotalAdjustmentAmount total_adjustment_amount
TotalAdjustmentTaxAmount total_adjustment_tax_amount
TotalLineAmount total_line_amount
TotalLineTaxAmount total_line_tax_amount
TotalLineAdjustmentAmount total_line_adjustment_amount
TotalLineAdjustmentTaxAmount total_line_adjustment_tax_amount
TotalAdjustmentDistAmount total_adjustment_dist_amount
TotalAdjustmentDistTaxAmount total_adjustment_dist_tax_amount
ServiceDate service_date
EndDate end_Date
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Item Summary Custom Attribute Values

  • Endpoint: SOM Order Item Summary 
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_item_summary_custom_attribute_values
JSON Element Database Column
id order_item_summary_id
key custom_attribute_key
value custom_attribute_value
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + key + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Item Adjustment Line Summaries

  • Endpoint: SOM Order Item Adjustment Line Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_item_adjustment_line_summaries
JSON Element Database Column
Id order_item_adjustment_line_summary
IsDeleted is_deleted
Name name
Description description
CurrencyIsoCode currency_iso_code
OrderItemSummaryId order_item_summary_id
OriginalItemSummaryId original_item_summary_id
OriginalOrderItemAdjustmentLineItemId original_order_item_adjustment_line_item_id
OrderAdjustmentGroupSummaryId order_adjustment_group_summary_id
OrderSummaryId order_summary_id
TotalTaxAmount total_tax_amount
Amount amount
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Item Tax Line Summaries

  • Endpoint: SOM Order Item Tax Line Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_item_tax_line_summaries
JSON Element Database Column
Id order_item_tax_line_summary_id
IsDeleted is_deleted
Name Name
Description description
CurrencyIsoCode currency_iso_code
OrderSummaryId order_summary_id
OrderItemSummaryId order_item_summary_id
OriginalOrderItemTaxLineItemId original_order_item_tax_line_item_id
Type type
Rate rate
Amount amount
TaxEffectiveDate tax_effective_date
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Payment Summaries

  • Endpoint: SOM Order Payment Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_payment_summaries
JSON Element Database Column
Id order_payment_summary_id
OwnerId owner_id
IsDeleted is_deleted
Method method
CurrencyIsoCode currency_iso_code
OrderSummaryId order_summary_id
PaymentMethodId payment_method_id
LastPaymentGatewayLogId last_payment_gateway_log_id
LastPaymentGatewayMessage last_payment_gateway_message
FullName full_name
Type type
AuthorizationReversalAmount authorization_reversal_amount
AuthorizationAmount authorization_amount
CapturedAmount captured_amount
BalanceAmount balance_amount
PendingAuthorizationAmount pending_authorization_amount
PendingReverseAuthAmount pending_reverse_auth_amount
PendingCaptureAmount pending_capture_amount
PendingRefundAmount pending_refund_amount
RefundedAmount refunded_amount
AvailableToRefundAmount available_to_refund_amount
AvailableToCaptureAmount available_to_capture_amount
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Summaries

  • Endpoint: SOM Order Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_summaries
JSON Element Database Column
Id order_summary_id
OwnerId owner_id
IsDeleted is_deleted
OrderNumber order_number
CurrencyIsoCode currency_iso_code
OriginalOrderId original_order_id
AccountId account_id
ChangeOrderId change_order_id
TotalAmount total_amount
GrandTotalAmount grand_total_amount
TotalAdjDistAmount total_adj_dist_amount
TotalAdjDistTaxAmount total_adj_dist_tax_amount
BillingStreet billing_street
BillingCity billing_city
BillingState billing_state
BillingPostalCode billing_postal_code
BillingCountry billing_country
BillingLatitude billing_latitude
BillingLongitude billing_longitude
BillingGeocodeAccuracy billing_geocode_accuracy
BillingEmailAddress billing_email_Address
BillingPhoneNumber billing_phone_number
OrderedDate order_date
TotalTaxAmount total_tax_amount
Status status
Description description
SalesChannelId sales_channel_id
PoNumber po_number
TotalAdjustedProductAmount total_adjusted_product_amount
TotalAdjustedDeliveryAmount total_adjusted_delivery_amount
TotalProductAdjDistAmount total_product_adj_dist_amount
TotalDeliveryAdjDistAmount total_delivery_adj_dist_amount
TotalAdjustedProductTaxAmount total_adjusted_product_tax_amount
TotalAdjustedDeliveryTaxAmount total_adjusted_delivery_tax_amount
TotalProductAdjDistTaxAmount total_product_adj_dist_tax_amount
TotalDeliveryAdjDistTaxAmount total_delivery_adj_dist_tax_amount
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastViewedDate last_viewed_date
LastReferencedDate last_referenced_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Order Summary Custom Attribute Values

  • Endpoint: SOM Order Summary
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.order_summary_custom_attribute_values
JSON Element Database Column
id order_summary_id
key custom_attribute_key
value custom_attribute_value
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + key + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Sales Channels

  • Endpoint: SOM Sales Channels
  • Update Method: UPSERT
  • Table Name: salesforce_commerce.sales_channels
JSON Element Database Column
Id sales_channel_id
OwnerId owner_id
IsDeleted is_deleted
SalesChannelName sales_channel_name
CurrencyIsoCode currency_iso_code
ExternalChannelNumber external_channel_number
Description description
CreatedById created_by_id
CreatedDate created_at
LastModifiedById updated_by_id
LastModifiedDate updated_at
LastViewedDate last_viewed_date
LastReferencedDate last_referenced_date
Daasity: shop_id __shop_id
Daasity: account_id _account_id
Daasity: MD5(id + __shop_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Related Resources