by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Free 30 day trial
Try it Now

#2807 - Syncing two independant records with same email address?

Closed Bug? created by Unitedadvisers Verified Purchase 2 years ago

Hi,
I have an issue where independent records on SuiteCRM for both husband and wife, but with a joint email address, eg familyname@xyz.com have synced to one record, and then on the write back to Suite, have overwritten the data on one record with the other persons name data.
Can you advise a workaround for this as this is obviously not a good solution where perfectly good independent records are being merged.
Happy to send you a live example if required?
Look forward to your response.
Thanks, Mark

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hello Mark,

    I understand completely where you're coming from. Unfortunately, MailChimp treats each email address as a 'unique id', causing it to be impossible to have two sets of data belonging to a single email address. There is no way to here is not a built-in solution to the issue, but I'm happy to give you a possible work-around.

    You may be able to append the beginning of their email address with '+husband' and '+wife' in your SuiteCRM, giving unique emails of 'familyname+husband@xyz.com ' and 'familyname+wife@xyz.com ' so that they now have unique email addresses. With gmail and other google domains, they will still receive all emails at 'familyname@xyz.com'. This solution will not work with all domains, so you would need to ensure that first. If it is supported, then MailChimp will see them as unique, and you will no longer have overlapping records.

    Let me know if that is a possibility.

    Thanks,
    Jon

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hello Mark,

    I just wanted to follow up with you to see if you were able to get anything working on this issue? What conclusions have you come to in regards to best manage the scenario?

    Thanks,
    Jon

    • Unitedadvisers member avatar

      Unitedadvisers Verified Purchase

      2 years ago

      Hi Jon,
      The suggestion you made regarding the +text within the email address seems to have resolved the problem - obviously not perfect, but good enough for the volume we have.
      Thanks for your help with this.
      Mark

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    I appreciate you giving us an update, Mark. Glad to hear it worked in your case. Let me know if there is anything else we can help with. I'll close this case out for now.

    Thanks,
    Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Nice product and nice team behind it. They helped us with everything we needed in order to get our system working as we wanted to."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.