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.
| 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. |
| 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 | 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. |