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.
#3276 - I need migrate arround 600.000 contacts from sugarcrm to an existing list in mailchimp
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?
-
"Hi there! I just wanted to drop a note and tell you that Chad Hutchins is a GREAT guy! He really helped me get setup with you guys and made it very..." - MNGHLLC
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
7 years 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!
7 years ago
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
7 years 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!
7 years ago
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
7 years ago
Hello,
I'm going to close this case out and respond to your new issue. Thanks for letting us know.
Best Regards, Jon