WooCommerce Analytics Sales Reports

  • Resolved wpforumuser

    (@wordpressforumhelp)


    2 years, 9 months ago

    Hi all.

    I migrated a site and then removed 20k customers and orders.

    When i go to WooCommerce Analytics… the Total Sales is still showing revenue.
    There are no orders or customers?

    I have cleared everything in status/tools.
    I’ve searched high and low on the internet, but just cant find a solution to clear it to zero.

    Does anyone know if it can be dumped via sql?

    Thanks 🙂

Viewing 5 replies - 1 through 5 (of 5 total)
  • Saif

    (@babylon1999)

    2 years, 8 months ago

    Hello @wordpressforumhelp,

    When i go to WooCommerce Analytics… the Total Sales is still showing revenue.

    That’s unusual!

    Could you head to WooCommerce > Settings > Advance > Features and try disabling/enabling analytics?

    Also, please check if there are any stuck sync jobs in WooCommerce > Status > Scheduled actions.

    Look forward to hearing back from you.

    Thread Starter wpforumuser

    (@wordpressforumhelp)

    2 years, 8 months ago

    Hey Saif

    When disabled, standard WooCommerce analytics shows the correct stats.
    If i enable WooCommerce Analytics it reverts to the old stats prior to reset.

    Nothing in the scheduled actions i can see…

    Is there anything in the database i can reset?

    Thanks

    Plugin Support Shameem – a11n

    (@shameemreza)

    2 years, 8 months ago

    Hi @wordpressforumhelp

    In this case, can you go to WooCommerce > Status > Tools and Clear analytics cache once again?

    Additionally, also clear the following:

    • WooCommerce transients – Clear
    • Expired transients – Clear
    • Clear template cache – Clear

    If the issue persists and you wish to proceed, you may want to look at the following tables in your database:

    • wp_wc_order_stats
    • wp_wc_order_product_lookup
    • wp_wc_customer_lookup

    Let us know how you get on with these steps or if you need further assistance.

    Thanks!

    Thread Starter wpforumuser

    (@wordpressforumhelp)

    2 years, 8 months ago

    @shameemreza

    You my friend are a legend… 🙂
    Perfect… that was exactly the data i needed to clear from the database.

    Thank you so much and have a great week…

    hrn1995 (woo-hc)

    (@aguinaldodarla)

    2 years, 8 months ago

    Hi @wordpressforumhelp

    We are happy that we were able to help! If you have a few minutes, we’d love if you could leave us a review: https://wordpress.org/support/plugin/woocommerce/reviews/

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘WooCommerce Analytics Sales Reports’ is closed to new replies.