WooCommerce Sales Total Mismatch

  • Resolved nahinmamun

    (@nahinmamun)


    4 years, 2 months ago

    Hi,

    I have uploaded some orders using the Order Import and Order Export plugin and can see a mismatch in the order total and sales total. There are three different total sales in WooCommerce Analytics, Advance WooCommerce Reporting plugin, and MYSQL query.

    It is likely that the Advance WooCommerce Reporting plugin is counting some products multiple times within an order. How can I ensure that WooCommerce Analytics, Advance WooCommerce Reporting plugin and MYSQL query give the same total?

    Thanks in advance.

    Nahin

Viewing 2 replies - 1 through 2 (of 2 total)
  • jessepearson

    (@jessepearson)

    Automattic Happiness Engineer

    @nahinmamun

    How can I ensure that WooCommerce Analytics, Advance WooCommerce Reporting plugin and MYSQL query give the same total?

    It should be possible to get close to the same results, but you will never get the same results due to the data will not be queried the same between plugins and direct queries.

    To get the most accurate data in the Analytics section of WooCommerce you would need to go to Analytics > Settings, then scroll to the bottom and Delete Previously Imported Data. Once that completes, you would need to import the data again.

    Plugin Support con

    (@conschneider)

    Engineer

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Kind regards,

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WooCommerce Sales Total Mismatch’ is closed to new replies.