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
- Integration Availability
- API Endpoints
- Entity Relationship Diagram
- Salesforce Commerce Schema
- Related Resources
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:
- 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)
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
- Campaign Customer Groups
- Campaign Coupon Codes
- Catalogs
- Catalog Sites
- Coupons
- Coupon Redemption Search
- Inventory Lists
- Inventory List Sites
- Products
- Product Categories
- Product Bundles
- Product Images
- Product Options
- Product Sets
- Product Variants
- Product Custom Attribute Values
- Promotions
- Promotion Custom Attributes
- Promotion Tags
- Sites
- Salesforce Order Management (SOM)
- Accounts
- Account Custom Attribute Values
- Contacts
- Fulfillment Orders
- Fulfillment Order Item Adjustments
- Fulfillment Order Item Taxes
- Fulfillment Order Line Items
- Fulfillment Order Line Item Custom Attribute Values
- Order Adjustment Group Summaries
- Order Delivery Group Summaries
- Order Delivery Group Custom Attribute Values
- Order Delivery Methods
- Order Item Summaries
- Order Item Summary Custom Attribute Values
- Order Item Adjustment Line Summaries
- Order Item Tax Line Summaries
- Order Payment Summaries
- Order Summaries
- Order Summary Custom Attribute Values
- Sales Channels
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 |
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