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

#4644 - SugarChimp table - multiple records for the same contact

Closed Bug? created by SuperEd Verified Purchase 2 years ago

I'm trying to debug slow SugarChimp performance following a sugar upgrade and noticed that there are a lot of records for the same Contact in the SugarChimp table. Is that normal? Will the contact be synchronised once per sunc regardless of how many records there are, or will there be a sync operation for every individual record?

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Happy to help. Yes, having records from the same contact in the SugarChimp table is normal as there may be different pieces of data being synced for that record. Can you tell me more about the slow SugarChimp performance you're experiencing?

    Thanks, Heidi

  2. paulrogan member avatar

    SuperEd Verified Purchase

    2 years ago

    Thanks. The health status page never quite gets completed ... there are always items pending to/from MC.

    The schedular is running every 10mins, and is running as expected. Also the /#SugarChimp/layout/adminbatches page is fine ... there's the occasional error but generally ok.

    One thing to note is that our target list has 84,117 Total Entries, and there's quite a lot of activity -- maybe 500 changes a day

  3. paulrogan member avatar

    SuperEd Verified Purchase

    2 years ago

    i think what might be happening is that while the schedular is running there are changes that add items to the sugarchimp table and so as soon as the script finishes there are still more to sync, and so it never finishes

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    That amount of changes shouldn't be an issue at all. I'm wondering if there are old items in the queue that could be cleared out. There are a couple of things we can check:

    1. Can you take a screenshot of the Health Status page and send it along to mailchimp@fanaticallabs.com?
    2. Let's check the queue to Mailchimp. It's possible records from previously syncing lists got stuck and aren't moving across to Mailchimp so it appears there's more in the queue than we would expect to move.  From your Health Status page, can you change /health-status to /admin and send a screenshot of the page (I don't need all of the entries, I'm just looking for the top 10 rows or so) to mailchimp@fanaticallabs.com?

    Happy to also hop on a call together if you prefer to do some troubleshooting. If you'd like to do that, feel free to schedule one here: https://calendly.com/fanaticallabs_support/sugarchimp-support-meeting

    Best, Heidi

  5. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Thanks for sharing those screenshots with me through mailchimp@fanaticallabs.com. I think we're now seeing data move as it should but please let me know if you have any further concerns.

    Best, Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Amazing product and amazing people. Thanks a lot for all the help at any question! :D"

    Read More Reviews