WordPress.org

Resolved Danilo Krdzic
(@krdza93)

1 year ago

So the problem I have is that my Woocommerce Reports show the correct data (84 orders, 119 products purchased, 14000eur revenue) but when I go to Woocommerce Analytics I see insane numbers (600 orders, 900 products purchased, 98000eur revenue). Shows orders on the dates that had 0 orders.

Tried to clear cache on Woocommerce Status > Tools – did not help
Cleared Transients as well.
Reimported historical data and deleted it then, nothing happens.

Found in DB I found “transient_wc_report” with some of the insane numbers, removed everything with “transient_wc_report” did not help either, it keeps “recreating” transients to the DB.

How is possible to fix this? To completely remove analytics data and reimport historical data ?

Viewing 11 replies - 16 through 26 (of 26 total)

← 1 2

Thread Starter Danilo Krdzic
(@krdza93)

11 months ago

@nathvi

Did that – still the same – no change in numbers.

Next option?

Plugin Support wpnomad a11n
(@wpnomad)

10 months, 3 weeks ago

Hi @krdza93 ,

Found in DB I found “transient_wc_report” with some of the insane numbers, removed everything with “transient_wc_report” did not help either, it keeps “recreating” transients to the DB.

As I understand, you tried deleting the transient directly from the database — is that right? If so, then I suspect there may be something wrong with the database user permission or the database itself, which would explain why this can’t be deleted and the inconsistency in analytics as well.

Can you please check with your web host to check the database and database logs and ensure it’s running fine?

Alternatively, you can download the database and open it on your computer or on another server by importing there and check if you can delete the transients. You can do so on your computer by using a database management software like TablePlus.

Thread Starter Danilo Krdzic
(@krdza93)

10 months, 3 weeks ago

@wpnomad I am the host and server is at my place – nothing to do with permissions. We are spinning around as I said I already cleared transient_wc_report from the DB in the first post and that was suggested 1 month later…

They come back once I visit analytics page – so transients do not exist until I visit analytics page.

I tried many different outcomes like first to remove it, then clear cache and all other Status>Tools options, and visit analytics lastly, but it still shows wrong numbers.

Plugin Support nicw.a11n
(@nicw)

10 months, 2 weeks ago

Hi @krdza93

At a point in this thread you mention orders in the trash can showing up in your analytics report. Could you confirm how many orders you have in your trash, and whether these make up the balance of the total of 600 orders showing in analytics?

We currently have a bug report which identifies this as an issue on certain installations but the overall cause is not yet clear to our developers. I may be related to HPOS testing. Have you tested HPOS yet?

Thread Starter Danilo Krdzic
(@krdza93)

10 months, 2 weeks ago

@nicw

I havent said that. My trash orders are 0.

Plugin Support nicw.a11n
(@nicw)

10 months, 2 weeks ago

Hi @krdza93

Apologies, I misread. Thank you for confirming that for us though, now we know the orders are not coming through from trash.

At this point, I would suggest creating a staging site to see if you can reproduce the issue on a clone of your existing site. If you can, then I would run a conflict test on the staging site. A staging site is often part of a hosting plan, or can be created using the plugin WP Staging.

The best way to determine if the issue is being caused by a theme or plugin is to temporarily switch your theme to any default WordPress theme or Storefront and disable all plugins except for WooCommerce. Then test to see if the issue is resolved.

To figure out which plugin is causing the problem – reactivate your other plugins one by one, testing after each, until you find the one causing conflict.

Here’s a more extensive explanation in our docs: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

—–

Tools to help you troubleshoot:

Meks Quick Plugin Disabler is a plugin you can install which will remember what plugins you currently have active so it’s easy to switch them back on. Link: https://wordpress.org/plugins/meks-quick-plugin-disabler/

Thread Starter Danilo Krdzic
(@krdza93)

10 months, 2 weeks ago

@nicw

Only woocommerce active from plugins, and twenty twenty three theme – still same issue… Repeated all the previous solutions you all mentioned, with only woocommerce and default theme, nothing has happened.

Plugin Support nicw.a11n
(@nicw)

10 months, 1 week ago

Thank you for trying that. Could you please share a screenshot of your import settings – I’m specifically interested in the excluded and actionable statuses, but also in the import historical data section of the page.

Link to image: https://d.pr/i/JNVSlZ

Thread Starter Danilo Krdzic
(@krdza93)

10 months, 1 week ago

@nicw

Sure, here comes the screenshot:

oacstudio
(@oacstudio)

10 months ago

Hi @krdza93,

Thank you for the screenshot. That looks correct.

Let’s try and take a peek at your database. Could you try the following:

* Take a full site backup.
* Activate https://wordpress.org/plugins/wp-phpmyadmin-extension/
* With it enter phpmyadmin and look at some of the orders that are not suppose to be there. Take any data from them i.e. name or address and try to find them via the database:

Image Link: https://d.pr/i/G4Zz4e

Are you able to locate them in your database that way maybe?

Kind regards,
Thread Starter Danilo Krdzic
(@krdza93)

10 months ago
@oacstudio

Nothing by searching for address, name, and similar.
But.
Since I know there were no orders before certain date on new site, I found this by searching wc_order_stats for same order ID as on old site:

Removing this entry from DB that order has dissapeared from the Analytics.
So data is there in that table but I cannot go through 3000 orders to get their IDs and remove it manually.

So I wrote the SQL code to go through wc_order_stats and for each order_id try to find the same ID in the table woocommerce_order_items – if there is no same data, that means this is an “orphan order” so I removed it.

MAKE SURE TO CREATE A BACKUP OF THE DB!
I AM NOT RESPONSIBLE IF SOMETHING GETS MESSED UP!
```
DELETE a
FROM cwd_wc_order_stats a
WHERE NOT EXISTS (
    SELECT 1 
    FROM cwd_woocommerce_order_items b
    WHERE b.order_id = a.order_id
);
```
After that just clear Analytics Cache from Woocommerce – Status – Tools.

This is solution 🙂

Viewing 11 replies - 16 through 26 (of 26 total)

← 1 2

The topic ‘WooCommerce Analytics show totally wrong numbers and data wont reset’ is closed to new replies.