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

#1396 - Leads importing days late

Closed General Question created by media Verified Purchase 3 years ago

Hello,

We have our target list pointed to Mail Chimp, but the leads are coming in late. For instance, we have a lead coming into the CRM on May 28th, but it doesn't get added to MailChimp until about a week later, on like June 7th. The cronjob is running properly every 30 minutes.

Thanks.

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years ago

    Hello, I can help with this. A couple things to check:

    1) If you go to Sugar > Admin > Schedulers > SugarChimp, on the bottom half of the page it will show you the run history of the SugarChimp scheduler. How often does it show that the SugarChimp scheduler is running? Is it every few minutes?

    2) If you go to Sugar > Admin > SugarChimp Health Status, are there any really large numbers pending to be synced? What are the numbers pending to be synced for each section?

    Thanks!

  2. media member avatar

    media Verified Purchase

    3 years ago

    1.) It says "done" for the scheduler, which is running every 30 minutes, it looks like it's running successfully. Doesn't look to be getting stuck or failing from errors.

    2.) No really big numbers. Both the pending to and pending from MailChimp show 0 at the moment.

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      3 years ago

      Thanks for the details. It sounds like things are running nicely from that perspective.

      Is it possible that the person was added to CRM on the 28th and then they weren't added to the Sugar Target List that syncs with MailChimp on June 7th, then it was added to MailChimp?

      New people that are added to your CRM system will need to be added to your synced Sugar Target List as well so that SugarChimp knows to send them to MailChimp.

  3. media member avatar

    media Verified Purchase

    3 years ago

    Thanks. I have a custom logic hook PHP script in Sugar CRM that automatically adds every new lead to the target list as they come into the CRM. So they are being added as soon as they come into the system. When I export the target list to CSV in the CRM, the leads that are missing from MailChimp are displayed in the exported target list, so they are in there according to the CRM.

    I initially stated that the leads are coming in late, but after further review, it appears some leads are making it into mailchimp, while others are not, regardless of the date (some still appear to come in a few days later). We added a new lead to the CRM today, June 9th, and that lead is in Mailchimp, while some other leads added today are still missing.

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      3 years ago

      Thanks for the details. That is all very helpful.

      A couple things to check:

      1) There are some cases where Sugar people do not make it into MailChimp. Please give this list a look to see if any of the cases match: https://www.sugaroutfitters.com/docs/SugarChimp/my-sugar-and-mailchimp-list-counts-do-not-match

      2) If the reasons on that doc are not the cause, you can check the logs for more details. Here are some steps to try: The first thing I would recommend doing is upgrading to the latest SugarChimp 7.5. You can find it in your orders https://www.sugaroutfitters.com/orders simply download the zip for Sugar 6, install via Module Loader, once you get to the license validation page, click Validate and your done upgrading. All of your synced lists will stay in place.

      Then go to Admin > SugarChimp Health Status, towards the bottom, set the SugarChimp Logger Level to Debug. After doing that perform a resync of your list. Here are the steps for that: https://www.sugaroutfitters.com/docs/SugarChimp/how-to-re-sync-a-list (if you upgrade, you can do this from the health status page, if you don't want to, go to the "How to Initiate a Re-Sync from Sugar to MailChimp" section)

      After you resync, on the Health Status page you should see the numbers in the Sugar to MailChimp section go up. Then let the SugarChimp scheduler run. Depending on the size of your list, it will process the queue after a run or two. When the Health Status page gets to zero, set the Logger Level back to Normal.

      After doing this, check MailChimp to see if the missing email address made it over. If it didn't, go to your sugarcrm log files on the server and search for the email address that didn't make it over. See if there are any messages/errors from MailChimp around that email address.

      Let me know what you find. Thanks!

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      3 years ago

      Also, I want to be sure... how is your custom logic hook adding the new leads to the target list? Are you making manual database queries? Or using the SugarBean relationship methods to add it?

      For the SugarChimp logic hooks to know that new leads are being added, you will need to use the SugarBean.

      Another alternative would be to manually add them to the SugarChimp queue, but using the SugarBean is what is recommended. Here are some details for this method: https://www.sugaroutfitters.com/docs/SugarChimp/integrate-your-target-list-add-on-with-sugarchimp

      If you want to post your logic hook on https://gist.github.com/ or email it to support@sugarchimp.com I'd be happy to give it a look.

    • media member avatar

      media Verified Purchase

      3 years ago

      Ok, that may be it. My custom logic hook is inserting the lead manually to the target list in a query, not using the Sugarbean relationship methods to add it. I'll make that switch and report back on the result.

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      3 years ago

      Ah, good to hear! If you're inserting it manually to the database that's exactly what's going on. Should be an easy fix.

      You should see that when you use the SugarBean when a Contact/Target/Lead is added to theTarget List a record will be added to the sugarchimp table. Once the SugarChimp scheduler runs, you'll see the new subscriber show up on the MailChimp side.

      Let us know!

  4. media member avatar

    media Verified Purchase

    3 years ago

    Ok, cool. That seems to have worked. I checked a few of the latest leads and can see them importing correctly.

    One more question. I tried to select all the leads in the CRM using the standard interface and add them to the target list so we could pull in any leads we may have missed, and I saw the list of a few thousand in the pending area of the health status page and they were resent, but the ones we had issues with are still not in MailChimp. The number in the pending batch was less that the number of leads in the target list, btw. Any idea how I can get those transferred or what the hiccup might be?

    For those who could potentially find this through a search, this is the logic hook SugarBean relationship code I used instead of a raw query:

    $bean->load_relationship('prospect_lists');
    $bean->prospect_lists->add('7a67ba0d-0937-5c5f-1f7d-553e9c3b080a'); //Change this to the ID of the target list you wish to add the lead to

  5. media member avatar

    media Verified Purchase

    3 years ago

    Thanks. You can close this out now.

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      3 years ago

      Will do, let us know if you need anything else. Thanks!

  6. media member avatar

    media Verified Purchase

    3 years ago

    Hello,

    Looks like we are still having some issues with some leads missing from MailChimp and I can't figure out why. They are in the Target List, but not in MailChimp. I have also tried adding them manually to the target list using the SugarBean as we discussed above using this code:

    $bean = BeanFactory::getBean('Leads', $lead_id); //I looped through the leads that were missing to added them, and also tried hard coding a lead ID.
    $bean->load_relationship('prospect_lists');
    $bean->prospect_lists->add('7a67ba0d-0937-5c5f-1f7d-553e9c3b080a'); //add lead to “Main” target list
    $bean->save();

    Thank you.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

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.