Replicate Customers from Commerce Cloud to Marketing Cloud

[jcherian99]

This is regarding the OTB interface between Commerce Cloud and Marketing Cloud for replicating customers. We were planning to use the standard extensions from Commerce and iFlows to complete this requirement.

While checking the iFlow mapping, by the standard we see that all the fields especially First Name, Last Name, Cell Phone, etc. are mapped from the “defaultPaymentAddress” node of the Commerce Cloud.

During the customer sign-up, we collect lean customer details like name, mobile#, email, etc. In order for the standard integration to work, are we expecting the data (lean data) to be populated in the “Default Payment Address” as well? I would like to know SAP’s vision with respect to the design.

[jayce_wang]

Hi Jithin,

In SAP Marketing Cloud system, there is no direct fields for mobile number and email address, instead they are saved as additional ids. And following mapping exist in AdditionalIDs Mapping step of iflow "Replicate-Customer-from-SAP-Commerce-Cloud-to-SAP-Marketing-Cloud":

customer-contactEmail -> EMAIL additional ID

defaultPaymentAddress-phone1 -> PHONE additional ID

defaultPaymentAddress-cellphone -> MOBILE additional ID

https://api.sap.com/package/SAPCommerceintegrationwithSAPMarketing/integrationflow

https://api.sap.com/integrationflow/CustomerOutbound/resources/mapping/AdditionalIDs_Mapping.mmap

Does it meet your requirement? If so, I think you can just upgrade the iflow to latest version.

Best regards,

Jayce

[jayce_wang]

Regarding to the name fields, follow mappings can be found in "Contact_Origin_Data_Mapping" steps. Also looks good.

customer-name -> ContactOriginData-FullName

defaultPaymentAddress-firstname -> ContactOriginData-FirstName

defaultPaymentAddress-lastname -> ContactOriginData-LastName

https://api.sap.com/integrationflow/CustomerOutbound/resources/mapping/Contact_Origin_Data_Mapping.m...