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.
#1054 - Does the Basic plan support the transfer of contacts FROM Mailchimp?
We are testing the sync. Data is sent TO Mailchimp but not sent to CRM from Mailchimp. e.g. we have a Wufoo form which adds a subscriber to a MailChimp list. The list is connected to a Target List and the default module in Sugar TL is set to LEADS. Mailchimp subscribers are not being added to Sugar. The license key installed is valid. I have included an extract from the log files which might help (see below).
Sugar 6.5.20 Sugarchimp: 7.1.4 basic Linux OS CENTOS 6 SugarChimp Health Status is all good (green) with nothing in the queue to sync back to sugar...
Sat Jan 3 09:11:28 2015 [3][1][FATAL] SugarChimp:debug:1420276288: Instantiate SugarChimp_Job Driver SugarChimp_Job_AddWebhook Sat Jan 3 09:11:28 2015 [3][1][FATAL] SugarChimp:debug:1420276288: Run SugarChimp_Job_AddWebhook Start Sat Jan 3 09:11:28 2015 [3][1][FATAL] SugarChimp:debug:1420276288: Run AddWebhook action for list d11a25cf0d with params: Array ( [0] => Array ( [id] => 9c5d70df-f869-bc2b-749b-54a7b036ca5f [param1] => [param2] => [param3] => [param4] => [param5] => )
)
Sat Jan 3 09:11:29 2015 [8864][-none-][FATAL] SugarChimp:error:1420276289: Mailchimp_Webhooks_Receiver cannot process webhook, no list id is provided
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Helper::add_webhooks_to_lists status: Array
(
[success] => Array
(
[d11a25cf0d] => Array
(
[id] => exists
)
)
[error] => Array
(
)
)
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_SugarToMailchimp->delete_jobs delete the jobs that we just ran: DELETE FROM sugarchimp WHERE mailchimp_list_id = 'd11a25cf0d' && name = 'AddWebhook'
ORDER BY date_entered ASC
LIMIT 500
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Original Start time 1420276264 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Current time 1420276289 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time since last check 1 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Elapsed time 25 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time used 0.0833333333333 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_SugarToMailchimp->get_next_job_name_to_process get oldest job: SELECT name FROM sugarchimp WHERE mailchimp_list_id = 'd11a25cf0d' ORDER BY date_entered ASC LIMIT 0,1 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_SugarToMailchimp->get_next_job_name_to_process There are no jobs to be processed for the list. Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Original Start time 1420276264 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Current time 1420276289 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time since last check 0 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Elapsed time 25 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time used 0.0833333333333 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver::end Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver::end The scheduler ran successfully Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Original Start time 1420276264 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Current time 1420276289 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time since last check 0 Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver::end final result: Array ( [status] => success [message] => There are no more jobs to run. [elapsed_time] => 25 )
Sat Jan 3 09:11:45 2015 [3][1][FATAL] SugarChimp:debug:1420276305: SugarChimp_LogicHook List After Add Person e6c00887-0d6b-d048-6a1f-52be7c82dd4c Sat Jan 3 09:11:45 2015 [3][1][FATAL] SugarChimp:debug:1420276305: SugarChimp_Helper::check_list_person_added the list is not synced with mailchimp, carry on Sat Jan 3 09:11:46 2015 [3][1][FATAL] SugarChimp:debug:1420276306: SugarChimp_LogicHook List After Add Person e6c00887-0d6b-d048-6a1f-52be7c82dd4c Sat Jan 3 09:11:46 2015 [3][1][FATAL] SugarChimp:debug:1420276306: SugarChimp_Helper::check_list_person_added the list is not synced with mailchimp, carry on
-
"The team is always proactive in assisting with any questions. Keep up the great work! Great product and great support!"
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
9 years ago
Hi there, the basic edition does include support for MailChimp to Sugar syncing.
The issue is that the changes on the MailChimp side are being made using the MailChimp API from Wufoo. Because of how the MailChimp webhooks are setup, it's possible for duplicate calls.
It's recommended that you send the Wufoo form data directly to Sugar and then have SugarChimp send the data to MailChimp. No changes are required on the SugarChimp side to make it work this way.
If it's not possible to do this with Wufoo, you can edit your List's Webhook in MailChimp by going to your list > Settings > Webhooks and under the "Only send updates when a change was made by..." field check the "via the API" checkbox. This will allow the webhooks to fire when calls are made from Wufoo via the API, the only issue is that it will also fire when SugarChimp makes API calls from Sugar. MailChimp may be smart enough to limit the amount of circular calls that come in, but this can act weird sometimes.
Let me know if you have any other questions about this one. Thanks!
9 years ago
Hi, yes the first option appears to works well. We'll keep an eye on it and if there are issues we will link Wufoo directly to Sugar. Thank you.
9 years ago
Good to hear. Thanks!