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

#3826 - Target List with duplicate Emails

Closed Bug? created by OLGA MARTOS LOZANO 3 years ago

HI Team,

I have a target list in SugarCRM and by SQL sentence I get the list of Contacts than I want to sync in MailChimp.
The SQL sentence gets 8 records but checking that Contacts in SugarCRM I see many duplicate emails.
When the sync is completed, I check the target List in MailChimp and there is** only one synced Contact**.
Is because the duplicate emails? I know that the email is the unique ID but I'm not sure about this behaviour.

I hope you can help me.
Thank you very much

Beatriz Reviejo
Business Analyst

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years ago

    Hello Beatriz,

    Thanks for reaching out on this. It sounds like you have described the issue. If there are 8 records in the crm with the same email address, only 1 record can get synced to MailChimp. It will behave as a 'last in' scenario, where the last record to get updated in SugarCRM will then update the MailChimp record. However, all activities such as opens, clicks, and unsubscribes will be related to the 8 Contacts inside of Sugar.

    I hope that clarifies everything. Let me know if you have any further questions.


  2. fhanoun member avatar


    3 years ago

    Hi Jon,

    It clarifies everything.


  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years ago

    Thanks, Beatriz. I'll close the case out now. Let us know if we can help with anything else.

    Kind Regards,

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "SugarChimp is working great. We're able to sync all of our lists and subscriber fields between MailChimp and SugarCRM. SugarChimp Support also did a great job supporting us as we were setting everything up."

    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.