SugarChimp

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. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#3826 - Target List with duplicate Emails

Closed Bug? created by redk - Professional Services BCN 6 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

    6 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.

    Thanks, Jon

  2. fhanoun member avatar

    redk - Professional Services BCN

    6 years ago

    Hi Jon,

    It clarifies everything.

    Thanks Bea

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    6 years ago

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

    Kind Regards, Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • SugarCRM Editions
  • Sugar Community
  • Sugar Professional
  • Sugar Enterprise
  • Sugar Sell
  • Sugar Serve
  • Sugar Market
  • Compatible Versions
  • 14.2, 14.1, 14.0, 13.3, 13.2, 13.1, 13.0, 12.3, 12.2, 12.1, 12.0, 11.3, 11.2, 11.1, 11.0, 10.3, 10.2, 10.1, 10.0, 9.3, 9.2, 9.1, 9.0, 8.3, 8.2, 8.1, 8.0, 7.11, 7.10, 7.9, 7.8, 7.7, 7.6, 7.5, 7.2, 6.7, 6.5
Rating
Rating

  • "We do a lot of highly-segmented outbound marketing and SugarChimp is exactly what we needed. The list and field syncing are great, and it allows us to do more sophisticated campaigns that exactly target certain Lead profiles in Sugar. The SugarChimp team is also really great, and they are totally committed to our success."

    Read More Reviews

Other Add-Ons of interest

ShapeMySugar : the customization that boosts CRM

ShapeMySugar : the customization that boosts CRM Logo
FEATURED

ShapeMySugar is the module you need to convince your employees to use your CRM. Thanks to this module, you are able to customize many elements of your application so that your team can make it their o...

Sage 50 UK Integration - SYNC by Commercient

Sage 50 UK Integration - SYNC by Commercient Logo
FEATURED

Your ERP Accounting data is integrated with your SugarCRM when you use Commercient’s SYNC app. SYNC Accounts, Contacts, Invoices, Sales Orders, Products, Pricing, Inventory, and more!
Integrations Marketing Sales mailchimp email marketing marketing Drip Campaigns Inbound Marketing Marketing Automation email automation chimp drip