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
  • Campaign Customer Groups
  • Campaign Coupon Codes
  • Catalogs
  • Catalog Sites
  • Coupons
  • Coupon Redemptions
  • 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 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
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