Totals always blank or zero

  • Resolved jomo

    (@jonathanmoorebcsorg)


    5 years, 8 months ago

    Money spent totals are always blank or zero and none of the searching works.
    When clicking on an individual user, the orders can be seen but the Money spent total remains zero.

    There are no errors logged even with debug on.

    I’ve tried activating at network level and individual site level.

    • Standard woocommerce site – Registered column works but Money spent is always zero even if User detail shows orders.
    • multilingual woocommerce site with polylang – Registered and Money spent columns are blank. User detail shows orders but Money Spent is zero
    • non-woocommerce site – non-dismissable banner for requiring WooCommerce to be active
    • Multisite network level – no Money spent, user detail does show orders from main site
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jomo

    (@jonathanmoorebcsorg)

    at the moment this is looking more like a woocommmerce bug in class-wc-data-store.php – looking at v.3.5.7
    get_total_spent() filters a database query by wc_get_is_paid_statuses()
    however this function returns statuses like by default array( ‘processing’, ‘completed’ )
    This returns no results since in the database these statuses are called wc-processing, wc-completed etc.
    If woocommerce_valid_order_statuses_for_payment filter is hooked and wc-processing, wc-completed are added, then results start appearing in the Money Spent…

    Thread Starter jomo

    (@jonathanmoorebcsorg)

    this is a weird caching issue, activating/deactivating other plugins (eg admin columns) seemed to resolve

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Totals always blank or zero’ is closed to new replies.