MuleSoft Accelerator for Retail
Mappings
Customer profile sync
Source-type mappings
The following table summarizes how representations of a customer or individual from each system will be mapped to CIM types:
| Source System | Source Type | CIM Types | Mapping Notes |
|---|---|---|---|
| B2C Commerce | Customer Profile | Individual Customer Contact Address Contact Email Contact Phone |
One B2C customer profile will map to multiple CIM objects |
| B2B Commerce Sales Cloud Service Cloud |
Person Account | Individual CustomerContact Address Contact Email Contact Phone |
Person Account is represented as record type, mapping to Account and Contact |
| Account | OrganizationCustomerContact Address Contact Email Contact Phone |
Account is mapped separately from Contacts | |
| Contact | Individual Contact Address Contact Email Contact Phone |
Similar mappings as for Person Accounts but at the Individual level only | |
| Marketing Cloud | Subscriber | Individual | Requires a data extension |
| SAP | Customer | IndividualCustomer Contact Address Contact Email Contact Phone |
Target-type mappings
The following table summarizes how representations of a customer or individual from each system will be mapped from CIM types:
| Target System | CIM Type | Target Types | Mapping Notes |
|---|---|---|---|
| B2C Commerce | Customer Individual Contact Address Contact Email Contact Phone |
Customer | Relevant fields only |
| MDM | All Types | Corresponding type | 1:1 mappings; use join tables for relationships |
| B2B Commerce Sales Cloud Service Cloud |
CustomerIndividual Contact Address Contact Email Contact Phone |
PersonAccount | Relevant fields only |
| CustomerOrganization Contact Address Contact Email Contact Phone |
Account | Address fields mapped directly | |
| Individual Contact Address Contact Email Contact Phone |
Contact | Similar mappings as for Person Accounts but at the Individual level only | |
| Marketing Cloud | Individual | Subscriber | Relevant fields only |
| SAP | CustomerIndividual Contact Address Contact Email Contact Phone |
Customer | Relevant fields only |
Sales order sync
Source-type mapping
The following table summarizes how representations of a sales order from each system will be mapped to CIM types:
| Source system | Source type | CIM Types | Mapping notes |
|---|---|---|---|
| B2C Commerce | Order | SalesOrder SalesOrderProduct | Order line items added as sales order products |
| OFBiz | Order OrderLineItem | SalesOrder SalesOrderProduct | TBD |
| SAP | Order | SalesOrder SalesOrderProduct | Order line items added as sales order products |
| Salesforce | TBD | SalesOrder | TBD |
Target-type mapping
The following table summarizes how representations of a sales order from each system will be mapped from CIM types:
| Target system | CIM type | Target Types | Mapping notes |
|---|---|---|---|
| B2C Commerce | SalesOrder | Order | Order status update only |
| OFBiz | SalesOrder SalesOrderPRoduct | Order OrderLineItems | Order status update only |
| SAP | SalesOrder SalesOrderProduct | Order OrderLineItems | Relevant fields only |
| Salesforce | SalesOrder | TBD | TBD |
Product sync
Source-type mapping
The following table summarizes how representations of a product from each system will be mapped to CIM types:
| Source System | Source Type | CIM Types | Mapping Notes |
|---|---|---|---|
| B2C Commerce | Product | Product ProductCategory ProductCatalog PriceBook | Relevant fields only |
| OFBiz | Product | Product ProductCategory ProductCatalog PriceBook | Relevant fields only |
| SAP S/4HANA | Product | Product ProductCategory ProductCatalog PriceBook | Relevant fields only |
| Salesforce | Product Pricebook | Product ProductCategory ProductCatalog PriceBook | Relevant fields only |
| PIM | Product ProductCategory ProductCatalog PriceBook | Product ProductCategory ProductCatalog PriceBook | 1:1 mappings; use join tables for relationships |
Target-type mapping
The following table summarizes how representations of a product from each system will be mapped from CIM types:
| Target System | CIM Type | Target Types | Mapping Notes |
|---|---|---|---|
| B2C Commerce | Product ProductCategory ProductCatalog PriceBook | Product | Relevant fields only |
| OFBiz | Product ProductCategory ProductCatalog PriceBook | Product ProductCategory ProductCatalog PriceBook | Relevant fields only |
| SAP S/4HANA | Product PriceBook | Product PricingCondition | Relevant fields only |
| Salesforce | Product ProductCategory ProductCatalog PriceBook | Product PriceBook | Relevant fields only |
| PIM | Product ProductCategory ProductCatalog PriceBook | Product | Relevant fields only |