Import historical data

Hi @alexqbox ,

Thanks so much for reaching out.

I hear you’re working on importing a large number of historical orders into a new WooCommerce setup. It’s great to hear you’ve already brought in around 34,000 orders from 2018 to 2022—that’s a big job! Now that the Analytics import process is stalling, let’s walk through a few steps that can help get things moving again.

First up, try clearing the Analytics cache and rebuilding the reports:

• Head over to WooCommerce → Status → Tools
• Scroll down and click on “Clear analytics cache”

Once that’s done, go to Analytics → Settings and try starting the “Import Historical Data” process again.

Next, it’s worth checking for any stuck scheduled actions:

• Go to WooCommerce → Status → Scheduled Actions
• Filter the list to show Pending actions
• Look for anything related to wc_admin_import_orders or similar

If you spot any stuck actions, you can try running them manually. For a clearer view of what’s going on behind the scenes, I’d recommend installing the WP Crontrol plugin. It gives you more insight and control over scheduled tasks, which can really help with debugging Analytics import issues.

If things are still stalling, importing in smaller batches can help:

• In Analytics → Settings, set a more specific date range—for example, one year at a time
• Make sure “Skip previously imported customers and orders” is checked so you’re not doubling up on data
• Start the import and keep an eye on how it progresses

Breaking it into smaller chunks can ease the load on your server and help avoid timeouts or memory issues.

Give these steps a try and let us know how it goes!

Hi @alexqbox,

Thanks for the update! I’m glad to hear you found the cause and got it sorted.

If you’ve been happy with the support, we’d really appreciate it if you could leave a review here: https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/ – it helps us a lot.