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

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

Closed Bug? created by lae_sugar_outfitters 7 years 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

    7 years 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

    lae_sugar_outfitters

    7 years ago

    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

    7 years 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

    6 years 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
  • "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