Woocommerce Analytics Total Sales Incorrect After Update

Hey there, @weblikero! Thanks for contacting us. I’m happy to help you.

Have you updated WooCommerce to the current version? If you didn’t, please do to see if it solved the issue.

If it doesn’t, let’s try to refresh the information. Please follow the steps below and let us know how it goes:

• WooCommerce > Status > Tools >?Clear Analytics Cache
• Import Historical Data

Looking forward to your reply.

Have a wonderful day!

Hello @carolm29 and thanks for the reply.

Woocommerce is updated to latest version.
We cleared Analytics Cache twice.
Also we Imported Historical data.

Unfortunately this error persists: https://ibb.co/cCLNWW0

We kindly request your assistance in restoring the correct total sales data within Woocommerce Analytics.

Thank you for your prompt attention to this matter.

Hey, @weblikero!

Thanks for trying!

We kindly request your assistance in restoring the correct total sales data within Woocommerce Analytics.

We are here to help you investigate this and happy to assist ??

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. Then you can use the selector to search for Fatal Errors.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

Looking forward to your reply.

Have a wonderful day!

Hello @carolm29 and thanks for the reply.
Here are the requested additional info`s:

1. System Status Report – https://easyupload.io/9cjz4q
2. Fatal error logs?– no fatal error logs – https://ibb.co/Q8T2QZ2
   
   Thank you!

Thank you @weblikero,

I’m not finding anything unusual on your SSR. Can you check on your orders and confirm the high values come from the shipping options? If you believe this issue is related to the change in the shipping fees bug, it’s worth testing<span style=”box-sizing: border-box; margin: 0px; padding: 0px;”>. Can you try saving the shipping settings?as described in the advisory? That is, saving them without adding a thousand separators and, if possible</span>, without a decimal separator, too.

After this, you can try again with my colleague’s steps to Clear the analytics cache and import the storical data again.

It’d be great if you could try this on a staging site with a default theme like Storefront, and every other plugin disabled except WooCommerce. You can ask your hosting provider if they offer this feature, or you can also use a plugin like WP Staging for this.

Please keep us posted.

Thanks!
-OP

Hello @omarfpg and thank you form your reply.

Upon further investigation, we discovered that all anomalies originated from a single order placed on July 2nd.

>> https://freeimage.host/i/dWYmZRs

Is there a way to edit this order with the correct amounts?

Thank you!

Hi @weblikero,

Upon further investigation, we discovered that all anomalies originated from a single order placed on July 2nd.

I’m happy to learn checking the orders brought more light into this issue and you found the culprit for the order with an abnormally high shipping fee amount!

Is there a way to edit this order with the correct amounts?

Yes, you can change the order status to pending payment, and you’ll be able to edit it, including the shipping fee. Then, you may change it to the same status as before. After this, please clear the analytics cache and reimport the historical data.

I hope this helps!
-OP

Proble solved. Thank you!

>> https://ibb.co/3vh1wH2

Hello @weblikero,

Glad to know that we were able to help. I will mark this thread as resolved. Should you have further inquiries, kindly create a new topic here.

Meanwhile, if it isn’t too much to ask for – would you mind leaving us a review here? It only takes a couple of minutes but helps us tremendously. It would mean so much to us and would go a long way.

Thanks!