Importing Historical data

Hello @jocasio,

The Historical Import relies on Action Scheduler, which is powered by the WP Cron system.

Is WP Cron operational on your store? You can check by going to WooCommerce > Status and looking in the “WordPress environment” section.

Hello Jeff,

Thanks for the reply. I’ve got WP Cron running and it shows with the green check in the WordPress environment status. I found that when importing over 1,000 orders it takes over an hour for the import process to start as the cache process is long. So in short after deactivating all other plugins other than WooCommerce and WooCommerce Admin it does load historic data but it takes a large amount of CPU use to do so. I hope they add in some form of process limit to do batches when the files to import are over 500.

I have a similar problem.

Data import failed, presumably due to too much data.

I’m happy to try again, importing only the last month’s orders for example, but can’t see any way to attempt to do so?

I hope they add in some form of process limit to do batches when the files to import are over 500

@jocasio behind the scenes, WooCommerce Admin is using Action Scheduler which defaults to 5 concurrent batches with a batch size of 25 actions. These values are filterable, see this page for more info: https://actionscheduler.org/perf/.

If you do modify the batch sizes and find that performance is closer to what you expect, please do share those values (as well as relevant hosting information) with us!

I’m happy to try again, importing only the last month’s orders for example, but can’t see any way to attempt to do so?

@siwhyatt you should be able to import the last 30 days, or select a custom start day to import from on the Analytics > Settings page:

Hm, it seems my image didn’t work. Let’s try again:

• This reply was modified 5 years, 5 months ago by Jeff Stieler. Reason: WP.com CloudUp rewrite not working?

Hi @jocasio

I hope the suggestions we passed along to you in the previous messages helped in guiding you in the right direction.

We haven’t heard from you in a while, so we’re marking this thread as Resolved for now.

Please feel free to reply to us in this thread, should the problem persist. We are happy to look into this and guide you further.

All the best!

I managed to import historical data by re-enabling the WP Cron.

My question now is, does cron have to be enabled or the analytics to work, or just for the historical import?

I.e. can I now disable again without affecting the performance of the plug-in?

Thanks,

Simon

Hello @siwhyatt,

Since Action Scheduler is used for the initial import as well as subsequent updates, you’ll either need to keep cron enabled, or have Action Scheduler run by other means.

Action Scheduler is used by core WooCommerce for database updates, as well as by extensions like WooCommerce Subscriptions (and of course WooCommerce Admin).

You can use WP-CLI to run the actions: https://actionscheduler.org/wp-cli/

Alternatively, you can use the woocommerce_disable_order_scheduling filter to force Order syncing immediately upon updating. Do note that this might have an adverse effect on any operations that you might have run on order updates (which is why we schedule the updates by default).

add_filter( 'woocommerce_disable_order_scheduling', '__return_true' );