List Sync for SugarCRM to MailChimp Integration is killing me!

List Sync takes more time than the usual?

Syncing Lists for SugarCRM to MailChimp or vise-versa is taking longer than usual? See the use case below with our team and one of our loyal subscribers on how they troubleshooted the issue.

Subscriber:

I’m trying to sync 10 Lists from SugarCRM to MailChimp and the process began at 8:30 am and is still syncing. The process from SugarCRM to MailChimp runs well but the other direction from MailChimp to Sugar takes too long or seems stuck. Its takes 7 hours just passing 10 list, that’s not making sense to me.

Any ideas?

Cazoomi:

Thanks and just had a look at the Sync Profile.  Please note that the volume of records per list may affect the syncing time but let’s take a look.

It seems the Filter and the “Error 400” are the issue as it moves thru SyncApps yet 4 hours is where it is now. 

img_1.png

How big is your SugarCRM database?

Subscriber:

We have 250,000 Contacts.

Cazoomi:

Thanks and that is not too large of a database yet seems to be why it is taking an extended time to complete as the API has to process that record volume using the Filter you have configured in Step 5 of your Sync Profile.

A better solution or best practice would be to use a Targets List and not a Filter to make it quicker.

Are you pressing Reset & Resync as this makes the syncing longer as well since all records are looked at?

Also, please note that with 250,000 records and 1 Filter it would take a bit of time to process the entire database in SugarCRM, check Leads, Contacts, Accounts and Targets then sync to MailChimp so it is not stuck yet will take 12-24 plus hours.

Subscriber:

I did it yesterday without Filters, happened the same way and didn’t press Reset & Resync. Now, I'm syncing just 890 Contacts.

Cazoomi:

The sync is not stuck actually. It is processing sync from MailChimp to SugarCRM.

Note: Please remember that everytime you change any configuration in your Sync Profile, always Reset and Resync so that the changes or the updates will take effect.

Syncing from SugarCRM to MailChimp will take less time but from MailChimp to SugarCRM, it may take time depending on the number of records in MailChimp that will sync to SugarCRM.

For each record in MailChimp, that were not synced previously from SugarCRM, will need to be checked by SyncApps as to whether the email already exists in SugarCRM to avoid duplication.

There are two processes:

* Sync from SugarCRM to MailChimp

It will sync records based on the selected List or can be Filtered. The records will be synced directly to MailChimp without further checking.

* Sync from MailChimp to SugarCRM

All records in the specified List will be synced to SugarCRM. Each record will be checked to see if that record already existed in SugarCRM. If that record exists or synced from SugarCRM previously then that email address will be ignored. If the records does not exists then SyncApps will create a new record (Contact/Lead based on the selected type in Sync Profile) in SugarCRM.

This process will take a period of time if there are many records in SugarCRM: "Each record will be checked if already exist in SugarCRM"

A Filter, which can be found in Step 5 of your Sync Profile, can also be applied to limit records that need to be synced from MailChimp to SugarCRM.

Once an email address is checked it will be cached (in a Sync Profile) so next sync will be faster as there is no need to check SugarCRM.

As our team reviewed your SyncApps account, it has many Sync Profiles connected to one MailChimp list so it would be best practice if you have only one Sync Profile with two ways sync and the others are set to one way sync (disable sync from MailChimp to SugarCRM).

Want to know more about SugarCRM to MailChimp Integration? Press the link below:

https://support.cazoomi.com/hc/en-us/articles/210485143-SugarCRM-to-MailChimp-Integration-for-Customer-Relationships

Have more questions? Submit a request

Comments