SugarChimp

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 Trial

By clicking you consent to share your profile with the developer

#1396 - Leads importing days late

Closed General Question created by media 8 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.

Fanatical Labs Provider Affiliate
8 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!

reply
media
8 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.

reply
- Fanatical Labs Provider Affiliate
  8 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.
  
  reply
media
8 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.

reply
- Fanatical Labs Provider Affiliate
  8 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!
  
  reply
- Fanatical Labs Provider Affiliate
  8 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.
  
  reply
- media
  8 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.
  
  reply
- Fanatical Labs Provider Affiliate
  8 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!
  
  reply
media
8 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

reply
- Fanatical Labs Provider Affiliate
  8 years ago
  
  Glad to hear it! For those problem ones that were already on your list you could try either doing a list re-sync (https://www.sugaroutfitters.com/docs/SugarChimp/how-to-re-sync-a-list) or create a script that finds just those members and adds them like you did here.
  
  reply
media
8 years ago

Thanks. You can close this out now.

reply
- Fanatical Labs Provider Affiliate
  8 years ago
  
  Will do, let us know if you need anything else. Thanks!
  
  reply
media
8 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.

reply
- Fanatical Labs Provider Affiliate
  8 years ago
  
  Hello, there are several reasons this could be. Look at this page to see if any of these apply: https://www.sugaroutfitters.com/docs/SugarChimp/my-sugar-and-mailchimp-list-counts-do-not-match
  
  Check each of those points with the leads you're expecting to see in MailChimp, I'm guessing you'll find the reason why they aren't showing up. Let me know if you have any other questions. Thanks!
  
  reply