Order Data Map - Salesforce B2C Commerce Integration

The following tables detail some of the data mapping when orders are imported from B2C Commerce to Order Management. They include special attributes used to override certain mapped fields.

Note: When an order contains a shipping or billing address with a country region that Order Management doesn't recognize, it's suspended and alerted. Alternatively, you can configure Order Management to accept unrecognized country regions. For more information, contact Support.

Order Data

B2C Commerce value Order Management value Notes
document_no order_id  
domain_id catalog_guid The guid is derived from the id.
creation_date order_checkout_date  
buyer_email order_bill_email  
buyer_no customer_guid The guid is derived from the number.
currency_code iso_currency_cd  
invoice_to_address_id   Used to look up billing address and phone information.
source_code, source_code_group_id source_code_guid The guid is derived from the code and group id.
created_by order_agent_cd, order_agent_label Both OM properties are set to the created_by value. However, if created_by is "storefront," then neither property is set.
customer_locale_id iso_culture_cd, localization_guid If the locale is neutral, the iso_culture_cd is set based on the bill-to address. If the bill-to address is neutral, the iso_culture_cd is set based on System.Globalization. The localization_guid is derived from the id.
remote_host CUSTOMER_IP attribute Overwrites any B2C Commerce attribute that is mapped to the CUSTOMER_IP attribute.
order_line_item_group_pos   Used to set the ship-to properties.
order_payment_instrument_pos   Used to copy payment Decision Manager attributes to the order.
order_price_adjustments, order_coupon_line_item_pos order_price_adjustment The values are summed to generate the order_price_adjustment value.
attribute_values   Mapped to order attributes.

Order Line Item Data

B2C Commerce value Order Management value Notes
position order_item_line_id  
line_item_text order_item_description If no value, defaults to "Product Line Item."
quantity_value order_item_quantity, order_item_quantity_ordered Order Management only allows integer quantity values. A non-integer value returns an error.
net_price_value, quantity_value, based_on_net_price order_item_unit_price If the based_on_net_price flag is true, order_item_unit_price is calculated from these values.
base_price_value, tax_rate, based_on_net_price order_item_unit_price If the based_on_net_price flag is false, order_item_unit_price is calculated from these values.
tax_value order_item_tax  
tax_rate order_item_tax_rate  
tax_value, based_on_net_price_flag order_item_product_tax If the based_on_net_price flag is true, order_item_product_tax is equal to tax_value.
base_price_value, tax_rate, based_on_net_price_flag order_item_product_tax If the based_on_net_price flag is false, order_item_product_tax is calculated from these values.
gift_flag order_item_gift  
gift_message   If this functionality is enabled, the gift message is set as an attribute.
bundle_flag   Set to true for bundle products, which are converted to kit items in Order Management. Set to false for the individual items belonging to the bundle or kit, which appear in the dependent_order_product_line_item_pos section rather than the order_product_line_item_pos section.
sku item_guid The item guid is derived from the sku.
omFulfillmentSite attribute site_guid If omFulfillmentSite is included, the site guid is derived from it.

Data Override Attributes

Data Attribute Name Description
Payment Methods omPaymentInstrumentMethod Set the omPaymentInstrumentMethod attribute on a payment associated with an order to specify the payment method. This attribute overrides the payment_method field on the order. Assign this attribute a string value that matches a payment method in Order Management.
B2C Commerce Site Catalog Mapping omSite Set the omSite attribute on an order to specify the site. The Site Map in the Demandware Provider uses it to associate an Order Management catalog with the order. This association overrides the domain_id field on the order, which is normally used to map to a catalog. Assign the attribute a string value that matches one of the domain ids in the Site Map.
X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.