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.

Cancel at any time!
Free Trial

#3276 - I need migrate arround 600.000 contacts from sugarcrm to an existing list in mailchimp

Closed General Question created by lae_sugar_outfitters a year ago

I've been try to make this migration through sugarchimp integration with the option ("Write your own SQL Query to automatically sync Contacts to MailChimp.") but when the migration starts my whole system and my database are stopped.

I don't want maintain the Contacts on my list manually.

Do you know a different way to do that migration and that I can also sync every changes from both sides?

  1. chad member avatar

    hutchins.chad gmail.com Verified Purchase

    a year ago

    Hello, sorry for the issues and thanks for giving this a try. SugarChimp is made exactly for this and we have customers using it exactly how you are hoping to, so I know we can get this setup for you. I have a few questions to get us started:

    Are the 600,000 contacts all of your contacts in Sugar? Or are they a subset?

    Can you post the query you're trying to use here?

    Can you check your sugarcrm.log file and the php error log on the server to see if there are any error messages being posted when the SugarChimp tries to run?

    Lastly, it looks like your 30 day free trial was set to end this week. I went ahead and extended your trial to September 18th so that we can have plenty of time to get this up and running for you.

    Let me know the answers to the questions above. Thanks!

  2. lae_sugar_outfitters member avatar

    Hi Chad

    I hope you are well

    the 600.000 contact are just a subset from "2013/01/01" until today

    my query is the following -> SELECT id FROM contacts WHERE date_entered >= '2013-01-01'

    I have no errors in my log about that.

    I have already uploaded my list with 600.000 contact into mailchimp from an excel sheet.

    now i would like to sync this list with my CRM, but the question is, if i try to sync that list with my CRM the process to sync will be faster or not?

    thankyou for extended the date of my trial

    • chad member avatar

      hutchins.chad gmail.com Verified Purchase

      a year ago

      Thanks for the info. What you tried to do looks good. It's strange to me that your original try did not work on the Sugar to MailChimp sync.

      If you go to Sugar, find the Target List that you were setting up with the date_entered query, is there anyone on it yet? If you already have your 600k people on the target list and you manually uploaded the 600k into MailChimp, you might already be done.

      If there are not 600k in the Sugar Target List, you could try a MailChimp to Sugar sync, there are a lot of factors to determine if it's faster or slower than the other direction. You can initiate that from the bottom of the SugarChimp Health Status page.

      It might be best for us to get on a call and look at this together. If you would like to do that, please pick a day and time that works for you here: https://calendly.com/fanaticallabs/sugarchimp-support

      Thanks!

  3. lae_sugar_outfitters member avatar

    Hi Chad, thanks for that. now my problem is other.

    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

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year ago

    Hello,

    I'm going to close this case out and respond to your new issue. Thanks for letting us know.

    Best Regards,
    Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Support was fantastic. Great bit of programming and we will be using it for the foreseeable future."

    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.