Syncing List is stuck

Hi @lcarlile, thank you for reaching out.

Just to get a handle on the situation you’re experiencing, could you provide a few pieces of information to help us a little more about the issue?

– What plugin version are you running?
– What version of WooCommerce are you running?
– Is there any logging errors in the plugin’s logs tab when it’s set to standard or debug?
– How many products/orders do you have in your store?
– Have you tried to uninstall or reinstall?

Thanks in advance for these details. I’ll keep an eye out for your reply.

– Kyle

Hello @khungate, appreciate the help!

plugin version: 2.1.5
Woocommerce version: 3.3.5
As of right now I do not see any logging erros
Products amount: 19
order amount: 1,813
Yes I have uninstalled and reinstalled the plugin.

is there anything you would need?

Thank you for sharing that info. Let’s do this first if we can, go to the logs and enable/save Standard debugging if you haven’t already. Next, go to the sync page and append the URL with &resync=1.

This should force a resync and populate any errors that are preventing the syncing process from completing.

When I did this for standard debugging I receive:

2018-04-13T14:55:12+00:00 NOTICE sync.started :: Starting Sync :: Fri, Apr 13, 2018 6:55 PM

When I used debug I receive:

2018-04-13T14:55:12+00:00 NOTICE sync.started :: Starting Sync :: Fri, Apr 13, 2018 6:55 PM
2018-04-13T14:56:25+00:00 NOTICE product_sync.success :: addStoreProduct :: #312
2018-04-13T14:56:25+00:00 NOTICE product_sync.success :: addStoreProduct :: #313
2018-04-13T14:56:25+00:00 NOTICE product_sync.success :: addStoreProduct :: #314
2018-04-13T14:56:26+00:00 NOTICE product_sync.success :: addStoreProduct :: #315
2018-04-13T14:56:26+00:00 NOTICE product_sync.success :: addStoreProduct :: #316
2018-04-13T14:56:27+00:00 NOTICE product_sync.success :: addStoreProduct :: #687
2018-04-13T14:56:27+00:00 NOTICE product_sync.success :: addStoreProduct :: #1360
2018-04-13T14:56:27+00:00 NOTICE product_sync.success :: addStoreProduct :: #1793
2018-04-13T14:56:28+00:00 NOTICE product_sync.success :: addStoreProduct :: #1930
2018-04-13T14:56:28+00:00 NOTICE product_sync.success :: addStoreProduct :: #1933
2018-04-13T14:56:54+00:00 NOTICE sync.started :: Starting Sync :: Fri, Apr 13, 2018 6:56 PM

It seems to be getting stuck after syncing 10 products

• This reply was modified 6 years, 10 months ago by Logan Carlile.

Hey @lcarlile – are you on a hosted WP install or is this a self hosted server? It seems as if the first round of 10 goes through just fine but then it stops. I’m asking for a valid reason – but i’ll explain once you’ve responded back with who you’re hosting with right now.

Also do you have access to your woo error logs? That may actually show something that is not inside this plugin log as well if there were any fatal errors to take a closer look at. Do you mind sharing anything you see there when you’re done?

@ryanhungate this website is hosted with Bluehost. I also have a dev of this site I tested it on that is hosted via Flywheel and it is having the same issues.

I looked inside the woo logs and under fatal errors I did notice this:

2018-04-13T15:23:54+00:00 CRITICAL Uncaught Error: Call to a member function get_id() on boolean in /www/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-products.php:57
Stack trace:
#0 /www/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-products.php(31): MailChimp_WooCommerce_Transform_Products->transform(Object(WP_Post))
#1 /www/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-api.php(70): MailChimp_WooCommerce_Transform_Products->compile('3', 5)
#2 /www/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-abstract-sync.php(208): MailChimp_WooCommerce_Api->paginate('products', '3', 5)
#3 /www/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-abstract-sync.php(94): MailChimp_WooCommerce_Abtstract_Sync->getResources()
#4 /www/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/queue/classes/worker/wp-worker.php(56): MailChim

hmm – that’s a new one. I wonder how that’s possible when we’re grabbing the post info during the loop and THEN passing that into the $woo = wc_get_product($post); call.

We would expect the product to be loaded correctly but I guess it’s not. Wonder why! I guess to fix this manually – you could add a workaround by adding in this:

if (empty($woo)) {
    return new MailChimp_WooCommerce_Product();
}

right below this $woo = wc_get_product($post); call in that file and it would allow the iteration to continue.

We will take a closer look into this, so thanks for bringing this up!

@lcarlile – just checking in to see if you were you able to implement the fix we mentioned – and to see if it solved your problem?

We’re still a little confused why the product is not being loaded by WooCommerce in that function, the Post was there, and the POST ID is there, which assumes that we can load the woo product. We’re curious to see the best way to handle this in the future. Can you provide any context on the product that’s failing?

@ryanhungate I didn’t get a chance to implement that fix yet, I see you said to add:

if (empty($woo)) {
    return new MailChimp_WooCommerce_Product();
}

right below:

$woo = wc_get_product($post);

But where is that code snippet located? Is it in the mailchimp for woocommerce plugin?

@lcarlile – My apologies for not specifying – it was in your original error log path.

/www/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-products.php line 57

@ryanhungate After adding that code snippet to that file it appears to being working now! It doesn’t get stuck at 10 orders anymore and is going through every order and product. Thank you for your help!

@lcarlile that’s good to hear. Thanks for working through that one with us.

What we really would like to know is why that product was not found by the WooCommerce function in the first place. Do you have any idea if the products that were failing had something in common? Certain product types?

We would like to know if there is some sort of fallback logic we could implement to make sure that the products are making it over if it’s something that you would like to see within MailChimp’s filters. ??

@ryanhungate There are only 20 products on the site and when I looked through them there wasn’t a certain product type that was out of the ordinary or seemed to be causing the issue, at least from first glance.