Will no longer sync & stuck in a loop

Hi @walkinverse, thanks for reaching out. When you have a minute, check out this support thread: https://www.ads-software.com/support/topic/not-syncing-8/. Most specifically, the last comment on the first page about the http_worker_lock site transient. If you’re able to delete that, it may do the trick.

Let us know how it goes. If that doesn’t work, we’ll be happy to look at your install closer.

Thanks,
Kyle

Where do I run this from?

Once I ran this below – everything synced up perfectly:

delete_site_transient( ‘http_worker_lock’ );

Hi @walkinverse, you can delete the site transients several different ways, but the easiest way might be using this plugin if you’re not familiar with doing it through the database: https://www.ads-software.com/plugins/transients-manager/.

Give that a try if you’d like and let us know what happens. Also, in a few weeks, we should have the latest version of our plugin that will take care of this automatically.

Thanks!

Added the plugin and “http_worker_lock” does not exist. ANy ideas?

Hello? Any ideas? It does not work, no matter what I do. It will not sync.

@walkinverse this to me sounds like you’ve got some caching going on – and the values from the site options might not be clearing out correctly when you’re deleting the plugin. Are you deleting the plugin from the admin area or are you doing that through FTP?

Also – have you verified with MailChimp support that your store is currently active? If you would like – please reach out to me directly ( ryan at vextras.com ) and send me a temporary API key so that we can try to troubleshoot this a bit further. I would like to see if the store ID’s match up or if you’ve not connected a store etc.

@walkinverse because you reached out directly through mail – just wanted to post this here that we will work out the issue – and then come back to post a solution afterwards.

@ryanhungate any update for the update to the plugin? I’ve been holding off doing newsletters, but I need to send something. Thanks!

@walkinverse sorry for the radio silence – we did just release version 2.1.10 on Tuesday, so if you haven’t updated the plugin yet – please do so now.

Also – If for whatever reason it’s still stuck in a syncing state and not moving, you can click the tab for Sync and then in the browser add &resync=1 and click enter… the button for re-syncing should show up again for you to start over.

If that’s still not working – I would just attempt to uninstall -> reinstall one more time with the new version, and that should do the trick for you!

Hi @ryanhungate,

I did do all that. Please see the link. I made screenshots, and documented what is going on.

https://www.ads-software.com/support/topic/still-will-not-sync-after-new-update-and-using-old-data/

@walkinverse – just to be clear – did you uninstall and reinstall the plugin just recently, or did you simply do the re-sync option? The answer actually makes a difference in what I would want to do next.

@ryanhungate Yes, I deleted everything, re-downloaded the plugin, installed and activated. Then in mailchimp I went ahead and reconnected. Unfortunately, it still cannot find all the products.

This is the same on all my sites using the plugin.

Video of screencast
https://www.dropbox.com/s/ffmj0uukas4mmji/Recording%20%2355.mp4?dl=0

Bestseller feature is also not working as it only pulled in one category and wrong colors for best sellers.

In the videocast in the link above it shows my other site with the most current update also. It is weird.

UPDATE
This is happening with a lot of inventory, this is an example of just one case. In my main site, the issue is worse as I have thousands of products.

Just looked at the log and items are missing. I also have seen an error with variations.

2018-10-05T12:18:26+00:00 ERROR product_sync.error :: addStoreProduct :: 14423 :: <p>variants.item:0.price: Schema describes number, string found instead</p> on 1493 in /home/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-api.php

Now the log shows that both item 06 and 09 were synced, but in mailchimp only one is showing.

2018-10-05T12:18:25+00:00 NOTICE product_sync.success :: addStoreProduct :: #14406
2018-10-05T12:18:25+00:00 NOTICE product_sync.success :: addStoreProduct :: #14409

What mailchimp shows:
https://www.dropbox.com/s/8j8zyhq458510br/Screenshot%202018-10-05%2012.50.33.png?dl=0

What wordpress shows:
https://www.dropbox.com/s/vzcn2u4520cvzit/Screenshot%202018-10-05%2012.47.51.png?dl=0
https://www.dropbox.com/s/oouvqj68nk8h575/Screenshot%202018-10-05%2012.48.00.png?dl=0

• This reply was modified 6 years, 5 months ago by walkinverse.
• This reply was modified 6 years, 5 months ago by walkinverse. Reason: more details
• This reply was modified 6 years, 5 months ago by walkinverse.

@ryanhungate any update on this?

@ryanhungate hello? Still does not work.

Hi @walkinverse, thanks for the follow-up information. At first glance, it looks like there may be an issue with how some of the variations are being pulled into the product list when building a campaign. We’ll investigate further and report back as soon as we find something.

Oh one last question, are you’re seeing the right SKU data for these products under a subscriber/customer that bought them?