• Resolved RobWord

    (@robword)


    Hi
    I have had several sales this month. The dashboard on WordPress that has a summary of the WooCommerce activity states my Best Seller this month to be a product that was sold some months back, and never sold in the month it refers to. Like this month.
    Is that a bug?
    How can I get it to show the recent best seller?

    Thanks

    Rob

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • 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?

    Thread Starter RobWord

    (@robword)

    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.

    Thread Starter RobWord

    (@robword)

    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 3 years, 10 months ago by Mike Straw.
    Plugin Support laceyrod a11n

    (@laceyrod)

    Automattic Happiness Engineer

    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!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Dashboard panel reads wrong’ is closed to new replies.