Dashboard panel reads wrong

Hi @robword. When you say “the dashboard on WordPress that has a summary of the WooCommerce activity,” are you referring to the WooCommerce > Dashboard page? That should honor the date range you have selected for all the data it shows.

Does it seem like the reports are just missing recent data? For example, if you look at the Orders or Products reports (in the “Analytics” menu), do those look correct? Is any of the other analytics data wrong?

Hi, NO.
There is the WooCommerce Dashboard and then there is the main WordPress Dashboard.
On the Main dashboard there is a small Widget that summarises the WooCommerce page.
There is an error there.

Thanks

Rob

Hi @robword, thanks for the clarification. Were you able to check the other analytics pages for similar errors? Was the dashboard widget the only place that seemed to be wrong?

Either way, this seems like it could be a caching issue of some sort. Do you have caching on your site? If so, I would try resetting the cache.

Before cache clearance
Robert De Niro (Celebrity Sunday) Art Print Poster
top seller this month (sold 1)

After cache clearance
Robert De Niro (Celebrity Sunday) Art Print Poster
top seller this month (sold 1)

All the other parts of the widget work fine and say the correct data. Just that one.

Rob

Hi @robword, thanks for checking. I’ve reached out to our devs about this and will follow up once I hear back from them.

Hi @robword

Do you have the ability to run database queries on your site? If so, can you run this (You may have to replace wp_ with the WordPress database prefix for your site):

SELECT order_id, order_item_meta.meta_value as qty, order_item_meta_2.meta_value as product_id
FROM wp_posts as posts
INNER JOIN wp_woocommerce_order_items AS order_items
ON posts.ID = order_id
INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta
ON order_items.order_item_id = order_item_meta.order_item_id
INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta_2
ON order_items.order_item_id = order_item_meta_2.order_item_id
WHERE posts.post_type IN ( 'shop_order' )
AND posts.post_status IN ( 'wc-completed','wc-processing','wc-on-hold' )
AND order_item_meta.meta_key = '_qty'
AND order_item_meta_2.meta_key = '_product_id'
AND posts.post_date >= '2020-08-01'

Please share the results of that query, along with a copy of your site’s System Status. You can find it via WooCommerce > Status.
Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

If you can also check the product ID for the Robert De Niro (Celebrity Sunday) Art Print Poster, that would help. You can get that from the address of the Edit product page:

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

It’s the number between ?post= and the next & character.

• This reply was modified 4 years, 3 months ago by Mike Straw.

Hi there,

This thread has been inactive for a bit, so I’m going to mark it as Resolved now. Please feel free to open a new one if you still need assistance or have further questions.

Cheers!