Sync of Customers with case sensitive emails

Owned by Olena Mykhailova (Deactivated)
Jun 02, 2022
2 min read

Here you can find information about the synchronization of Customers with case-sensitive emails and what the result are in Magento and Salesforce.

 

Case 1 Create a Customer in Magento with abc@test.com email, sync it to Salesforce

Result: In Salesforce Contact/Lead will be created with the email abc@test.com

 

Case 2 Create a Customer in Magento with ABc@test.com email, sync it to Salesforce

Results:
2.1 If try to create a customer with the email ABc@test.com message appears "A customer with the same email address already exists in an associated website." (because abc@test.com was created before)

2.2 If remove abc@test.com customer and create ABc@test.com it will be synced with the existing Salesforce Contact/Lead with email abc@test.com

2.3 If create a customer with the email ABcd@test.com it will be synced to Salesforce Contact/Lead abcd@test.com (email changed to lowercase)

 

Case 3 Create a Customer in Salesforce with abc@test.com email, sync it to Magento

Result: Salesforce converts all emails to lowercase. If Magento has a Customer email in uppercase ABc@test.com after reverse sync it becomes in lowercase abc@test.com

 

Case 4 Create a Customer in Salesforce with ABc@test.com email, sync it to Magento

Result: Salesforce converts all emails to lowercase. If Magento has a Customer email in uppercase ABc@test.com after reverse sync it becomes in lowercase abc@test.com

 

Case 5 From Magento to Salesforce only one Lead will be created. But Salesforce does not have a check when creating Leads with the same emails.

5.1 Duplicates Lead/Contact has the same email but different data (name, address)

  • Contact de-duplication option = Automatically

If in Salesforce Org there are few duplicates and we re-sync Contact in reverse order, all duplicates will be removed. But if we sync some of the duplicates first, the main Contact will be overwritten with new data (name, address) but duplicates will be removed.

  • Contact de-duplication option = Leave duplicates

If in Salesforce Org there are few duplicates and we re-sync Contact in reverse order, duplicates will NOT be removed. But if we sync some of the duplicates first, the main Contact will be overwritten with new data (name, address).