My Mautic version is: 4
My PHP version is: 8
My Database type and version is: MySQL
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.
I do see in the forums that Mautic can have more than email address per person -and will only send email to the main email - so that may be a route to solve this
- copy their Old_address to a secondary_email field
- change their email to their New_Email value.
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.
Thanks @robm that’s helpful.
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.
Thanks @robm that’s very helpful.