Support » Plugin: WooCommerce Admin » Woocommerce dashboard showing no data.

  • Resolved edicolablack

    (@edicolablack)


    Hi, as requested, I’m reposting my question here, instead of the Woocommerce support forum:

    I’ve to report a problem I’m meeting whilst using Woocommerce: the dashboard is not properly showing any data. All values are stuck at 0, even thought I did sell something and it does show it correctly on the WP dashboard.

    Before trying to contact your support, I tried to search for some solutions to the problem and found that others did meet the same problem in the past; I then tried to «Rebuild reports data» in the Status->Tools section, as suggested here: https://github.com/woocommerce/woocommerce-admin/issues/1441

    But it didn’t work. Then I tried to check the log and found the following warning:

    2019-12-17T05:04:45+00:00 CRITICAL Uncaught Error: Call to undefined method WC_Order::get_report_customer_id() in /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php:477
    Stack trace:
    #0 /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php(449): Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::update(Object(WC_Order))
    #1 /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/ReportsSync.php(489): Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::sync_order(104972)
    #2 /membri/edicolablack/wp-includes/class-wp-hook.php(288): Automattic\WooCommerce\Admin\ReportsSync::orders_lookup_import_order(104972)
    #3 /membri/edicolablack/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
    #4 /membri/edicolablack/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
    #5 /membri/edicolablack/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_Action.php(22): do_action_ref_a in /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php alla riga 477

    My knowledge are limited, so I’m not sure what the problem is caused from and how to solve it.
    Could you kindly tell me what’s the origin of the problem and how to fix it, possibly in simpliest way possible, please?

    Woocommerce Ver.3.8.1
    Worpress Ver.5.3.0
    Woocommerce Admin Ver.0.23.1

    Thank you for your attention.

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

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Support mother.of.code

    (@imazed)

    The Mother of Code | Automattic Happiness Engineer

    Hey @iamthefixer, can you please open your own topic on this? The issues may be unrelated, and to keep everything clear it’s best if you keep all information relevant to your own issue in a topic that’s dedicated to it. Thanks!

    @edicolablack we’ve released version 0.23.3, can you update to that version and let us know if that resolves things?

    edicolablack

    (@edicolablack)

    Hi @imazed,
    I made sure to update Woocommerce Admin to the last version, 0.23.3, then tried to rebuild the data and made sure to clear the cache of the site.
    Still no data showed.
    The only change I noticed is that there was no fatal error warning reported in the log, after running the data rebuild, as it happened the previous times; still, that didn’t solve the dashboard showing no data about products sold and money earned: only 0 everywhere. Even tried to manualy change the period showed to make sure it would cover all of the 2019, even attempted back to 2018(when I wasn’t still using Woocommerce, but who knows? :3), but always showing only 0 for each table.

    Should I try to completely remove Woocommerce Admin and then reinstall it?

    • This reply was modified 3 months ago by edicolablack.
    • This reply was modified 3 months ago by edicolablack. Reason: Fixed an error and added a possible solution
    Plugin Support mother.of.code

    (@imazed)

    The Mother of Code | Automattic Happiness Engineer

    Thanks for all of that info! Yes, I think uninstalling and then reinstalling is a good idea.

    If that doesn’t solve it, I’d like to rule out that there isn’t a plugin conflict happening. You can read more about plugin and theme conflicts here:
    https://docs.woocommerce.com/document/woocommerce-self-service-guide/

    The best way to determine if the issue is being caused by a theme and/or plugin is to do the following:

    1. Temporarily switch your theme back to the Storefront theme (it’s free)
    2. Disable all plugins except for WooCommerce and WooCommerce Admin
    3. Test to see if the issue has been resolved.
    4. If that resolves the issue, then slowly re-enable features until you find the one that’s causing the conflict.

    This is best done on a staging site. That’s a copy of your live site, so you can test things out without making changes to your actual site. Some hosting companies offer a staging site service within their hosting plans. If yours does not, there is a great free plugin that will allow you to build a complete staging site with a few button clicks: https://wordpress.org/plugins/wp-staging

    Thanks in advance!

    edicolablack

    (@edicolablack)

    Hi @imazed,
    as you suggested, I tried to completely disinstall and reinstall the plugin.
    That didn’t solve the problem and now the fatal error warning showed up again on the log:

    2019-12-27T13:44:17+00:00 CRITICAL Uncaught Error: Call to undefined method WC_Order::get_report_customer_id() in /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php:477
    Stack trace:
    #0 /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php(449): Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::update(Object(WC_Order))
    #1 /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/ReportsSync.php(489): Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::sync_order(105317)
    #2 /membri/edicolablack/wp-includes/class-wp-hook.php(288): Automattic\WooCommerce\Admin\ReportsSync::orders_lookup_import_order(105317)
    #3 /membri/edicolablack/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
    #4 /membri/edicolablack/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
    #5 /membri/edicolablack/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_Action.php(22): do_action_ref_a in /membri/edicolablack/wp-content/plugins/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php alla riga 477

    About the theme, I’m using a Storefront child theme.

    For the attempt at deactivating each plugin and then reactivate them, it may not be so easy, because I need most of them to make the site works properly and can’t really deactivate the site for a long period of time; if it can help, I’ll copy&paste the list of all active plugins on my site. Maybe you could immediatly notice some plugin which you know may cause incompatibility problems:

    Advanced Ads 	  	by Thomas Maier, Advanced Ads GmbH – 1.16.1
    Better Robots.txt - Index, rank & SEO booster + Woocommerce 	  	by Pagup – 1.3.0.1 – Non testato con la versione attiva di WooCommerce	
    Child Theme Generator 	  	by Serafino Corriero – 2.2.5
    Content Views 	  	by Content Views – 2.2.0
    Header Footer Code Manager 	  	by 99robots – 1.1.6
    Loco Translate 	  	by Tim Whitlock – 2.3.1
    MapPress Maps for WordPress 	  	by Chris Richardson – 2.53.3
    Microthemer 	  	by Themeover – 6.0.3.9
    Post Expirator 	  	by Aaron Axelsen – 2.4.0.1
    Quotes for WooCommerce 	  	by Pinal Shah – 1.6.3
    Redirection 	  	by John Godley – 4.5.1
    SI Captcha Anti-Spam 	  	by fastsecure – 3.0.3 – Non testato con la versione attiva di WooCommerce	
    Widget Options 	  	by Widget Options Team – 3.7.4
    Advanced Shipment Tracking for WooCommerce 	  	by zorem – 2.7.6
    WooCommerce Conditional Product Fees for Checkout Premium 	  	by Multidots – 3.2
    Advanced Flat Rate Shipping For WooCommerce 	  	by Thedotstore – 3.6.2
    WooCommerce Admin 	  	by WooCommerce – 0.23.3
    WooCommerce Breadcrumbs 	  	by Anthony Hortin – 1.0.5 – Non testato con la versione attiva di WooCommerce	
    WooCommerce 	  	by Automattic – 3.8.1
    Yoast SEO 	  	by Team Yoast – 12.7.1
    WP File Manager 	  	by mndpsingh287 – 5.5
    WP Mail SMTP 	  	by WPForms – 1.8.1
    WP-Optimize - Clean, Compress, Cache 	  	by David Anderson, Ruhani Rabin, Team Updraft – 3.0.15
    WP Post Signature 	  	by allnull – 0.4.0
    WP Snow Effect 	  	by WPManiax – 1.1.10
    WPForms Lite 	  	by WPForms – 1.5.7 

    I’ll check the WP-Staging plugin; gotta see if it’s a viable option for my site situation.

    • This reply was modified 3 months ago by edicolablack. Reason: Fixed a typo
    • This reply was modified 3 months ago by edicolablack.
    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    @iamthefixer If you need support then per the forum guidelines please start your own topic.

    https://wordpress.org/support/forum-user-guide/faq/#i-have-the-same-problem-can-i-just-reply-to-someone-elses-post-with-me-too

    You can do so here.

    https://wordpress.org/support/plugin/woocommerce-admin/#new-post

    I have removed your replies, please start your own topic as requested.

    s10dulkar

    (@s10dulkar)

    i cant see option to rebuild reports data in status>tools any idea why so ?my dashboard shows zero for all reports

    Plugin Support mother.of.code

    (@imazed)

    The Mother of Code | Automattic Happiness Engineer

    @s10dulkar please open a new topic for your request, as per @jdembowski’s recommendations above.

    @edicolablack let us know how things go with WP Staging, I think that’s your best option here!

    edicolablack

    (@edicolablack)

    Hi @imazed,
    a little update on the problem: whilst trying to fix another problem with Woocommerce Admin(https://wordpress.org/support/topic/orders-tab-not-working/), I’ve found that the fix works also for this problem, so they have probably a common origin.

    Tweaking a bit around, I found a temporary fix:
    I’ve to go to Analytics > Settings, click “Delete Previously Imported Data”(it’ll not work if I don’t delete all the data, everytime), refresh the page, start the Import, then go back to Woocommerce > Status > Scheduled Actions > Pending and manualy start each session of the import(it’ll not start by itself; even tried to wait for a few hours, but it would only work if I started it manualy). And I’ve to repeat this operation after every new order; it doesn’t update itself automaticaly, so it’s not really practical or convenient to use.

    The problem, as reported in the other topic, is that it is only a temporary fix that I’m forced to repeat everytime I receive a new order; it’ll not update itself automaticaly.

    For example, I received a new order and the customer immediatly paid it; checked the dashboard, but the data was not updated. Waited a couple of hours, but no change happened. I then repeated the procedure reported above and, finaly, the data updated. But I needed to repeat it again with the next order and will need to repeat it after each future order, making it really inconvenient to use.

    • This reply was modified 3 months ago by edicolablack. Reason: Fixed a typo
    Plugin Support Mike W

    (@nixiack8)

    Hi @edicolablack,

    We have released a new version of the Admin – if you update to it, are you still having the same issue? Please let us know!

    Hi @nixiack8,
    unfornatly, no. The problem persist.

    The only pseudo-solution I found to make it work has been to disable the ALTERNATE_WP_CRON, following some suggestions I found online about this dashboard problem; this finaly made the dashboard auto update, but also gave me quite a few other headaches in other parts of the site, like producing doubles of every single page with different url ending in /?doing_wp_cron, which forced me to use a redirection plugin and a little fix to the .haccess(not an easy one, seeing how my host manage it and theoricaly doesn’t allow modification to it) to solve it. So is not really a stable solution which I would suggest to implement in the long run, but allowed me to make the dashboard work properly for now. Still would prefer if it worked properly without this kind of workaround.

    edicolablack

    (@edicolablack)

    Nope, nope, nope…

    My pseudo-solution stopped working, without me making any change to the site or the plugin. A customer paid an order this night at 00:20, and yet the dashboard didn’t update his data at this hour. The update scheduled action is again pending for hours without any idea if and when it’ll start by itself.

    If Cron is really triggered only by users visit on the site, it should have been triggered at least 39 times(between 00:00 and now), as this is the reported number of visit by Google Analytics.

    Gotta try some new fix, but I’m out of ideas…

    edicolablack

    (@edicolablack)

    A little update:
    The Run button to manualy force the pending scheduled action to start is not appearing anymore.

    https://i.postimg.cc/mrK6sBRb/No-Run-Button.png

    Now that Woocommerce Admin has been integrated in Woocommerce, is working perfectly and without any need for me to fix anything.

    So the ticket can be closed.

Viewing 13 replies - 1 through 13 (of 13 total)
  • You must be logged in to reply to this topic.