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

#3304 - My sugarchimp isn't syncing SugarCRM to mailchimp

Closed Bug? created by lae_sugar_outfitters a year ago

Hi

i have a mailchimp list with 554499 contacts and the same list in CRM has 572941 contacts.

both schedulers are active but the sugarchimp scheduler are very slow and this is the sugarcrm.log

Thu Sep 7 07:46:03 2017 [24844][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:47:02 2017 [28420][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:48:02 2017 [31969][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:49:02 2017 [3193][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:50:03 2017 [6795][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:51:02 2017 [10348][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:52:02 2017 [14150][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:53:03 2017 [17684][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:54:02 2017 [21283][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:55:02 2017 [24773][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:56:02 2017 [28339][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:57:02 2017 [31961][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run
Thu Sep 7 07:58:02 2017 [3049][1150][FATAL] Job a23cc482-4afd-b328-6b46-59b13ef0c604 (MailChimp List Cleaned Emails to SugarCRM Job) failed in CRON run

i realy need your help as soon as possible.

cheers

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year ago

    Hello,

    The numbers you're showing on the lists are not necessarily indicative of issues with the sync. There are a number of reasons that the numbers could be off, but generally the Target List contains records with bad email addresses (no email address, invalid, opted out) or duplicates. The best next course of action would be to find a specific record on the Target List that should be on the MailChimp List but is not.

    From there, check his email address in SugarCRM is good and valid. If so, then edit his name (add a middle initial), and let the scheduler run the next time around. If that person is still not in MailChimp after 20 minutes, then go back to Sugar admin > Health Status. We can check the batch call sent to MailChimp by changing the url from "action=health_status" to "action=adminbatches". On this page, you can click through the batch calls to look for any errors on the operations. If you find any, download the batch using the link and send them over to support@sugarchimp.com and I will see what's going on.

    Let me know what I can help with next.

    Thanks,
    Jon

  2. lae_sugar_outfitters member avatar

    My exactly matter is that the list in my mailchimp account was imported by an excel sheet, so after that around 1 week ago, I synced that list with my CRM through sugarchimp with custom sql option "contacts.date_entered >= '2013-01-01'. "

    now after one week i have many new contacts that i can't find in mailchimp

    i hope that you can help me.

    today I have a SugarChimp Support Meeting at 9am.

    cheers

  3. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Hello Andres,

    We last spoke about a week ago and were unable to get the schedulers running during the support call. Do you have any updates here that you could share?

    Thanks,
    Jon

  4. fanatical_jon member avatar

    Jon S Provider

    a year ago

    Hello again,

    I'm going to close this case out for now. Let me know if you make any progress on the schedulers and need something from me.

    Best Regards,
    Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "SugarChimp is exactly what we needed, it syncs nicely between MailChimp and Sugar. The added MailChimp dashlet is very sophisticated. Works great – thank you!"

    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.