Import Historical Data Got Stuck and Admin Dashboard Not Loading

Hi @d88pak,

Thank you for reaching out.

I’m sorry to hear you’re experiencing issues with importing Analytics historical data and encountering a 503 Bad Gateway error on your Admin Dashboard.

This is quite unusual, but I’d be happy to help you out. Before we can dive deep into troubleshooting, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

• System Status Report, which you can find via WooCommerce > Status > Get system report > Copy for support.
• Fatal error logs (if any) under WooCommerce > Status > Logs. You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

Once we have more information, we’ll be able to assist you further.

Hi @ckadenge,

I was able to complete the import by changing the “Date Type” to Date created. However, the WooCommerce widget is still showing the zero sales.

Screenshot: https://prnt.sc/LZJEFkCAIR01

When I changed the Date type to date completed, import gets stuck.

Any suggestion?

Thanks!

Hi there!

I can understand your concern, Issue regarding data imoprt get stuck for date type comlpeted.

Can you please try the following?

• Clear your site cache
• Navigate to?Analytics > Settings
• Go to the section “Import Historical Data“, select “All” and UNCHECK the box to “Skip previously imported customers and orders“
• Click Start

Does that make a difference??

If that does not help, To provide accurate assistance, let’s take a closer look at your site’s configuration. Could you please send me a copy of your site’s System Status Report?

This can be done by following these steps:

1. Go to your WordPress dashboard.
2. Navigate to WooCommerce > Status.
3. Click on ‘Get system report’.
4. Then click ‘Copy for support’.
5. Paste this information into a new Gist at https://gist.github.com.

Once you’ve completed that, please paste the Gist link here in your reply.

While you’re in the WooCommerce Status section, could you also check the Scheduled Actions tab for any pending or failed actions? The status of these actions can provide insight into the operations of your site, including the analytics data import.

With the additional details from the System Status Report and Scheduled Actions, I’ll aim to identify the issue and guide you toward a resolution.

Looking forward to your response.

Hi @shahzeenfarooq ,

I was able to complete the process using Date Created. However, the widget still doesn’t show the Sales data.

I will try your suggestion on cleaning the browser cache also and report back.

Thanks!

Hi @d88pak,

I will try your suggestion on cleaning the browser cache also and report back.

Sounds like a plan, please try the suggested steps and do let us know how it goes.

Cheers.

Hi Team,

After a day (or two). It started showing the sales on Widget. I am not sure of the detail how did that happen. Probably it was not catching up for sometime.

Thanks!

Hi @d88pak,

After a day (or two). It started showing the sales on Widget. I am not sure of the detail how did that happen. Probably it was not catching up for sometime.

This can sometimes happen due to caches, large volumes of data being processed, or due to server latency. However, I’m glad to hear that it’s now working properly.

If you continue to experience any delays or have further questions, please don’t hesitate to reach out. We’re here to help you.