Danilo Krdzic

@nicw

Sure, here comes the screenshot:

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

@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.

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

@nicw

I havent said that. My trash orders are 0.

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

@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.

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

@nathvi

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

Next option?

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

@nathvi

Yes, I do make backups always.
Unfortunately, this did not fix it – still Analytics show wrong values, while Reports are correct as explained multiple times in this thread.

Next trick?

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

@gabrielfuentes

So to summarize removing order from the backend removes analytics while quick SQL actions do not remove it (mentioned earlier in the ticket), can you check why is that happening and tell me where analytics are stored in the database and what I should do to remove them from SQL so I can totally wipe out that info?

Anyway, replies to your questions. Screenshots attached
Reports – CORRECT:

Analytics – WRONG:

Cron Events – no errors:

This reply was modified 1 year, 6 months ago by Danilo Krdzic.

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

No, this did not help, still same issue.

So even if I remove all the data by using SQL codes I sent you, analytics data is still there and I have no idea how?

When you delete order from backend panel, what tables it affect, because obviously something is missing here:

DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;
DELETE FROM wp_comments WHERE comment_type = 'order_note';
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' );
DELETE FROM wp_posts WHERE post_type = 'shop_order';

This reply was modified 1 year, 6 months ago by Danilo Krdzic.

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

Update – This is a huge bug in the system.

It happens when you delete orders – so deleted orders are still visible in the analytics even if they do not exist anywhere on the website.

To test that quickly I cloned my DB and then used this SQL to remove all order data:

DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;
DELETE FROM wp_comments WHERE comment_type = 'order_note';
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' );
DELETE FROM wp_posts WHERE post_type = 'shop_order';

And guess what? Analytics still there. Followed all the steps that were mentioned, but Analytics data is still there from the deleted orders.

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

Already tried that, nothing helped, what now?

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)

Have you clicked on any of these orders in the analytics tab?

Doing so should take you to the order page, which should help you pinpoint the origin of these ghost orders.

Yes I did and I see nothing on the Order page, just says 0. And that is correct because it should not exist ??

On another note, I couldn’t help but notice that your site has many failed scheduled actions. It’s probable that these are happening because your server’s PHP time limit is set a bit low. Try setting the limit somewhere between 900 and 1000.

Increased it, but that should not affect wrong data.

Is there a way to clear everything from Analytics and “import” the data again? Because this is totally wrong.

Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics show totally wrong numbers and data wont reset

Thread Starter Danilo Krdzic

(@krdza93)