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]
| 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 Managment (SOM)
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 |
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 |
Last updated