speed up sync

Hey there @onepoundcrisps we we would like to take a closer look at your store would mind letting us know the URL of the store in question. Also could you please enable remote diagnostics.

If you would like to send us this information privately please use this form to send the information. We’ll then reply in this support forum thread with our findings.

In the meantime some general tips we’ve found help to speed up the syncing process, you can try the following solutions:

1. Increase server resources: Make sure your server has enough memory and processing power to handle the syncing process efficiently. Consider upgrading your server or optimizing its configuration to handle the load.
2. Upgrade PHP version: Updating to a newer version of PHP can improve the performance of your WooCommerce store and the syncing process. Check if you’re using the latest stable version of PHP and consider upgrading if necessary.
3. Use WP CLI syncing engine: For a store of your scale, it’s recommended to use the WP CLI syncing engine. This advanced queue setup can significantly improve the syncing speed. You can find detailed instructions on how to set it up in the MailChimp for WooCommerce plugin’s GitHub page.
4. Check Action Scheduler queue: Inspect the Action Scheduler queue for any failed jobs. Go to WooCommerce -> Status -> Scheduled Actions and look for any failed jobs. If you find any, manually execute these jobs from the failed queue to resume synchronization.

By implementing these solutions, you should be able to speed up the syncing process and reduce the time it takes to sync your store. If you need further assistance, feel free to ask!

thanks I have sent contact form with info as requested

there are 284743 ?past-due actions?found so lot of them to run in background.

@onepoundcrisps Thanks for providing the information.

After taking a look at the store we were able to confirm as mentioned that the slink is slowly progressing but successfully moving along.

We advise to the use the WP-CLI method to add a bit more speed to the amount it takes for the Action Schedular to process jobs.

We have documentation on our Github wiki page here

It also may be necessary to complete a plugin audit by disabling each plugin possible to see if that helps uncover any plugin conflicts with the Mailchimp plugin.

hi not 100% sure how to run the action scheduler via command line.

can you provide the line of code needed to copy into terminal so it can run as not sure on the documentation

@onepoundcrisps Totally understandable. Using the Advanced Queue Setup with WP-CLI is not as straight forward as running a terminal command. However, I’ll do my best to break down what needs to be done.

According to the documentation under the Preparation heading it require removing “Redundant Constants” what you’ll need to do here is find the install files on your server where WordPress lives. A typical install will show these files under “public_html” once you find the installation files. doing a command of

ls

Will show the files of the WordPress install.

The goals to edit the wp-config.php file which requires knowledge of how to edit a file on a server. Unless your hosting provider has provided you with SFTP access to visually locate the file and edit it.

Once the file is open see if you see the “Redundant Constants”

Next Running the queue process

This requires a bit more advanced knowledge of how your server and WordPress file directories. I can’t provide specific instructions but as per our documentation, you’ll need to find the path to the WordPress install from the root directory. This can be found by using the “pwd” command which means print working directory.

Once you have that path you can replace the example text with the proper information for you site. in order to run the queue process.

While it’s very understandable how advanced this is and the necessity to solve the problem of how to speed up the sync. We provide this tool to be compatible with virtually any install but it requires to be applied as necessary to fit your particular circumstance.

If the information I’ve provided is still not as helpful we recommend reaching out to a Mailchimp Expert or a WooCommerce Expert for some advanced server management help.

no solution as yet to this there must be a way to import the records quicker than currently via the plugin.

The best solution to gain an efficient sync process would be to use our recommended approach of using the CLI method.

It’s important to note that it is still possible to use the Mailchimp feature set for marketing campaigns from your account while sync is still process.

While it’s understandable the advanced nature of the CLI method and encourage reaching out to a 3rd party WooCommerce/Wordpress developer with server administration skills.

I used the command line but it did absolutely nothing still 250,000 actions pending

@onepoundcrisps Thanks for getting back to us with the additional details about using the CLI method. I’ll get with one of my colleagues for insight on how to move forward to a solution. Thanks for your patience.

Thanks for your patience in the matter.

I was able to run a few test using the Advance Queue CLI Mode(AQS) and was unable to replicate this type of behavior.

However, if there is trouble running the CLI mode, could you provide a readout of what occurs when running the command?

Lastly could you provide us with an example of the command that ran exactly on your server. Again if you feel as though that should be private information feel free to use our form again.

Hi there, we’re going to close out this ticket for now since it’s been a few weeks since we’ve been in touch.

Please let us know if you still need any help and we’ll be glad to reopen and troubleshoot further. Please note, that the best way to reach us is over at the GitHub plugin page: https://github.com/mailchimp/mc-woocommerce/. From there, you can receive direct responses from the development team, log new issues, download the latest version, and track existing support tickets.