WooCommerce status widget shows wrong numbers with HPOS enabled, Part II

I can confirm?the issue still persists. I tried turning off cache completely, that is, WP_CACHE in wp-config off, no caching module installed at server level, no opcache, no redis, no memcache, no apcu… NO server-level caching module enabled.
Opcache specifically DISABLED even via .htaccess directive, browser cache fully cleared, server’s Litespeed cache fully cleared.
The issue is within the widget itself. It’s possible it’s not even counting the actual number of orders.

Hi there @markisu72 ??

Thanks for reaching out about this. Let’s troubleshoot it together!

WooCommerce status widget shows wrong numbers with HPOS enabled

As a first step, I went ahead with testing with a test site of mine, making sure it runs the latest available version of WooCommerce (8.5.2, at the time of writing this), and HPOS is enabled.

The numbers I could see on the Orders screen, match those I see in the widget. Therefore, I am not able to reproduce the issue.

While researching in GitHub, I could find no related issues reported either.

Could you please provide us with screenshots, so that we can see what you are describing?

If you don’t already have a screenshot service installed, here are a few free options:

https://snipboard.io
https://skitch.com/
https://getcloudapp.com/
https://awesomescreenshot.com/

There is also a walkthrough guide here: https://en.support.wordpress.com/make-a-screenshot/

To get an idea of how your site is configured, could you please share a copy of your site’s System Status, as exemplified here? Once you’ve done that, paste it here in your response.

Looking forward to hearing from you!

—

Hi there @eragonsoftware ??

As requested earlier, we’d like to take a look at your site’s System Status Report (SSR) and screenshots on a separate thread, in order to better focus troubleshooting resources, as each site’s setup is unique.

Please open a new topic here: https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0.

Thanks!

Hi @eragonsoftware and @markisu72

I would like to create an issue for this for the team to look at.

With regards to the Widget, just to clarify, are you referring to the number that appears as part of the sidebar i.e. the filled-in number beside the Orders submenu?

If possible can one of you please share your?System Status Report, that will help us further troubleshoot.

You can find it via?WooCommerce > Status. Select?Get system report?and then?Copy for support. Once you’ve done that, you can paste it into your reply here.

Thanks for opening this issue.

Hi @anastas10s & @nigeljamesstevenson,

thanks for your feedback.
I need to deactivate the compatibility mode first and wait for new orders coming in, in order to show you the effect.

I will get back to you.
Best
Markus

• This reply was modified 9 months, 3 weeks ago by markisu72.

Hi @anastas10s & @nigeljamesstevenson,

I don’t feel comfortable to post the full system report here.
Is there a confident way to get it to you?

What I can share with you here is the following:

### WordPress Environment ###

WordPress address (URL): https://www.my-removed-url.de
Site address (URL): https://www.my-removed-url.de
WC Version: 8.5.2
REST API Version: ? 8.5.2
WC Blocks Version: ? 11.8.0-dev
Action Scheduler Version: ? 3.7.1
Log Directory Writable: ?
WP Version: 6.4.3
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: –
Language: de_DE
External object cache: –

### Server Environment ###

Server Info: nginx/1.24.0
PHP Version: 8.1.26
PHP Post Max Size: 2 GB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.81.0
OpenSSL/3.0.2

SUHOSIN Installed: –
MySQL Version: 10.11.6-MariaDB-1:10.11.6+maria~ubu2204
Max Upload Size: 2 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 8.5.2

###
Connected to Woo.com: ?
Enforce Approved Product Download Directories: –
HPOS feature screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –

A new order just popped in and as you can see in the screenshots, the widget does show 2 orders in processing state, while there are 3 in processing state in the order overview (and 3 is the correct amount).

Widget: https://snipboard.io/zWkXfB.jpg

Order overview: https://snipboard.io/myg1Ix.jpg

I waited several minutes but the status did not change (external cron interval is 1 min).
After switching the HPOS data sync back to enabled, the widget correctly shows 3 orders in processing state.

It seems obvious that the widget does NOT rely on the HPOS tables.

Hope, that helps.
Thanks for your support!

Markus

• This reply was modified 9 months, 3 weeks ago by markisu72.

The easiest thing for the team to check is by watching this video. I made a capture from a dashboard, in which it’s absolutely clear what we are talking about. Main widget shows 1 order is processing, while in truth there are 5 being processed, and the number in the left menu’s bullet is correct.
https://youtu.be/FOglhHfgbBw

When compatibility mode is enable the status widget is fine. Once you uncheck it then the widget is stuck. This is the the issue since the beginning of HPOS

Thanks so much for the input all.

There is a related issue in the woocommerce repo and thanks to your comments, the priority has been increased and it will be taken up soon by the development team. (this forum post has been referenced in the issue.

https://github.com/woocommerce/woocommerce/issues/40382

Hi @nigeljamesstevenson,

that’s great news! Thanks a lot for your support!

Markus