Your software
My Mautic version is: 4
My PHP version is: 8
My Database type and version is: MySQL
My problem
I am new to Mautic this month. Or Contacts email addresses are all at-Work email addresses. In our CRM, when a Contact moved to a new Employer we change their email address and ALL the History is still in the CRM against them.
But - Mautic uses Email_Address as a unique-key (This is my understanding so far).
So - how can we ensure that Mautic does not create a NEW contact - but keeps all the Mautic past history against the new email address?
Steps I have tried to fix the problem:
I have searched the forums for an hour and not seen any help on this.
Another common Use Case - in some countries women change last_name when they get married:
So they also will be the same Contact but a Changed email address.
I think if you edit the record and change the email address the history will remain with the same contact as the other unique identifier is the contact ID.
If the new person completes an opt in form, for example, and uses a different email address then a new contact will be created.
I will need to think how we achieve this: as the synch between our CRM and Mautic will at day 1 be based on ‘matching email address’: but after that we’ll need to handle:
new contacts in the CRM - to sync to mautic as new contacts: on email address
existing contacts in CRM - to sync to mautic; to update the email address but at the same Contact_ID.
Have you achieved that kind of a setup OK ? Maybe it is more straight forward than I am imagining?
if you doing this via api, you can retrieve the contact ID by querying on the old email address, then edit the contact based on the contact ID and add the new email address to that record.
I have this working in a sync between mautic and another system connected via an n8n workflow.