MailChimp Sync Woocommerce Subscriptions

Hi @ccmanz, thanks for reaching out. Syncing thousands of customers/orders shouldn’t be a problem for the plugin. It sounds like you may have a issue with the Action Scheduler itself, which isn’t part of the Mailchimp for WooCommerce plugin, however, here’s a few ideas to troubleshoot:

Identifying Stalled Queues:

• Indicator of a Stalled Queue: A clear sign of a stalled Action Scheduler is when you have pending jobs that are newer than the last completed jobs, often by an hour or more. This situation indicates that the queue isn’t processing any tasks, and actions are getting backed up.
• Immediate Action – Test by Running a Single Job: When you suspect the scheduler is stalled:
  1. Navigate to the WordPress admin dashboard.
  2. Go to ‘Tools’ and then ‘Scheduled Actions’.
  3. Filter the list to show ‘Pending’ tasks.
  4. Select a single pending task and click ‘Run’ to execute it manually.
  5. Observe if the task runs successfully.

Diagnosing the Cause of a Stalled Scheduler:

• Successful Manual Run Indicates Scheduler Issues: If manually running a task is successful, but tasks are not being processed automatically, it suggests that the scheduler itself isn’t running. The reasons could be various, including but not limited to server configuration issues, plugin conflicts, or other technical glitches.

Troubleshooting a Non-Running Scheduler:

• Check WP-Cron Configuration: Ensure that WP-Cron, the system WordPress uses for handling scheduled tasks, is correctly configured and not disabled.
• Plugin Conflicts: Deactivate other plugins temporarily to rule out conflicts that might be preventing the Action Scheduler from running.
• Server Resources and Configuration: Verify that the server has the necessary resources and configurations to handle the cron jobs, especially if there’s a high volume of scheduled tasks.
• Consult Hosting Support: Sometimes server-side restrictions or configurations can affect cron jobs. Contacting your hosting provider’s support can sometimes reveal and resolve these issues.

Preventive Measures and Regular Checks:

• Regular Monitoring: Regularly monitor the ‘Scheduled Actions’ section to catch any buildup of pending tasks early.
• Maintenance Routines: Establish routine checks and database cleanup to ensure the Action Scheduler operates smoothly.

In regards to the tags not syncing, it could be related to the Action Scheduler as well. If you can, let’s test try the above troubleshooting steps first and see if that resolves the issue.

Hello! We’re following up to inquire if the issue persists and whether you were able to implement the suggested solutions successfully. At your earliest convenience, please update us. We are here and ready to assist with additional troubleshooting if needed.

Hi,

Thanks for getting back to me. I just got back from a holiday break.

Anyways, I’d love to get this sorted out

So I tried resyncing it again but it seems to be stuck in syncing for about an hour now.

See here: https://prnt.sc/KvFTbc5vwMqR what should I do if this is still stuck?

Please advise.

• This reply was modified 10 months, 3 weeks ago by Carl M..

Hi @ccmanz, can you do us a favor and enable Remote Diagnostics in the plugin?

To enable remote diagnostics for the Mailchimp for WooCommerce plugin, follow these steps:

1. Login to the WordPress admin console.
2. Go to Plugins -> Mailchimp for WooCommerce, and click on Settings.
3. Inside the Mailchimp for WooCommerce plugin, click on the Settings tab.
4. Activate the Enable Support checkbox under Remote Diagnostics.

Please let us know your website URL as well after enabling and we’ll see if we can spot anything in your site’s configuration.

Thanks!

Hi @khungate,

I have enabled remote diagnostics – the URL is

https://paddock2porch.com.au/

Hello Carl,

Thank you for reaching out. From what I see in your logs, the synchronization is operating correctly. The data is currently being processed, and considering the volume of orders, it will take a bit of time to complete. Although I can’t pinpoint the exact start time of your re-sync, please allow it to continue. We’ll keep an eye on it from our side. In the meantime, I have a couple of suggestions:

1. Considering the substantial number of orders, I recommend implementing the advanced queue setup through the Command Line Interface (CLI) for enhanced efficiency. You can find the setup instructions here: Advanced Queue Setup in CLI Mode.
2. I’ve noticed some critical errors in your logs which might be affecting the synchronization. It may be beneficial to consult a third-party developer for troubleshooting, or you might consider temporarily disabling the problematic plugin to see if it resolves the issue. Specifically, the error reads: uncaught invalidargumentexception: unidentified action 160203 in /www/paddock2porch_155/public/wp-content/plugins/woocommerce-google-adwords-conversion-tracking-tag/vendor/woocommerce/action-scheduler/classes/data-stores/actionscheduler_dbstore.php:1085

Please feel free to reach out with any further questions. Otherwise, rest assured that we will continue to monitor the situation on our end.

Hello Carl, just a heads up – your sync is now complete. For future syncing, we suggest sticking with WP CLI to ensure smooth operation, and addressing the previously mentioned fatal error that could affect future syncs. If there’s anything more you need, don’t hesitate to reach out. Thanks for choosing the Mailchimp for WooCommerce plugin!