Sync of Customers with case sensitive emails
- Olena Mykhailova (Deactivated)
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).