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

#1758 - Syncing Contacts and Account Fields

Closed General Question created by tony1 7 years ago

I am evaluating SugarChimp and have a question that I am sure is beyond the scope of support for this product but maybe it is an easy answer as I am sure it has to be a common one.

I want to get very granular in our mailchimp lists - where we want to send blasts to Sugar accounts that have a particular product and version and potentially other criteria. This is easy with field mapping if I only need to send/sync to the primary email contact of that account. However, is there a way I can say to send to all 'contacts' associated with this account (account name) which has this particular account criteria only in the account record? Otherwise I am limited to sending to one email within the organization.

The only other option I see is to also add this criteria to the contacts but this would increase workload substantially having to update each one every time there is a change.

Maybe I am over thinking this and there is a simply solution?

Thanks, Tony

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    7 years ago

    Hi Tony, all good questions.

    As you've found, the Field Mapping tool works for fields that live directly on the Contacts module. You cannot sync data from related modules right now in a very straight-forward way. The best way to sync Contacts and data based on related module today is to follow the steps here:

    This method uses calculated fields to bring in the related field mapping data into the Contacts module so it can then be accessible in the Field Mapping tool. Once you can map that data to MailChimp, you can then segment on it in MailChimp.

    I don't think you're over-thinking this at all. We get a lot of requests for this. Our next major release will include a couple features that will help with exactly this. 1) You will be allowed to create filters that tell Sugar who should be on your syncing list from Sugar (only Contacts who's parent Account has A, B, C products, etc). and 2) In the Field Mapping tool, you will be able to sync related parent module data to MailChimp (actually sync to MailChimp that the Contact's parent Account has products A, B, C so you can segment). This will be able to work without the extra work of calculated fields.

    Give the calculated field suggestion a look and let me know if you have any questions.


  2. tony1 member avatar


    7 years ago

    Calculated fields appears would do the trick but it also appears this option is not available in the CE version. :(

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      7 years ago

      Ahh, got it. I forgot that was only in Sugar Pro and above.

      Other than waiting on the new release (we do not have an exact release date yet), someone could customize this for you using custom code and logic hooks.

      Another option might be to prepare an import file for MailChimp. You could create the custom fields or Groups on your MailChimp list. Then export the data from the Sugar database (might have to use sql queries and pull it out of the database) including the email address it is associated with. When you import it into MailChimp you can have it update those specific fields on the MailChimp list. This might get you most of the way there, it would at least let you segment on the fields you want to from the MailChimp side.

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      7 years ago

      Another option I forgot about is to use something like Process Manager:

      It's the perfect replacement for workflows and calculated fields in Sugar CE and SuiteCRM.

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    7 years ago

    Hey Tony,

    I just wanted to reach out to see if you had any more questions regarding the syncing of related modules?

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    7 years ago

    We were able to get everything setup through a support call, so I am going to close this case. Let us know if you have any more questions regarding the syncing of related fields!

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "The SugarChimp plugin was exactly what we needed to launch our Email Marketing from the contact base we had built in Sugar. Heidi gave clear steps and..." - Joell Denison

    Read More Reviews