by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

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

Closed Bug? created by UA Professional Services Spain SL (ESB42725150) Verified Purchase 5 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

    5 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

    5 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

      UA Professional Services Spain SL (ESB42725150) Verified Purchase

      5 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

    5 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
  • "The team is always proactive in assisting with any questions. Keep up the great work! Great product and great support!"

    Read More Reviews