Support » Plugin: WooCommerce Admin » WP Analytics CSV file, net sales sum not equal to value in Analytics menu

  • Resolved jobzavia

    (@jobzavia)


    WP Analytics menu, CSV file, net sales summation is not equal to value that show in Analytics menu

    From dashboard i go to menu
    Analytics > Products
    then set ” Date range ” to Last week.
    then my net sales show up about 30,000 ฿

    but when i downloaded CSV. file from beside Download button . Net Sale sum up just 24,000 ฿
    _________________________________
    i try last month or even 2 day, it still not the same value.

    • This topic was modified 2 years, 7 months ago by jobzavia.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support darcie – a11n

    (@darciemg)

    Hi @jobzavia!

    WP Analytics menu, CSV file, net sales summation is not equal to value that show in Analytics menu

    I understand that in WooCommerce Analytics, the CSV you download is not matching up to Net Sales you see on the screen. That’s odd, as these should be the same data! As a first step, is the CSV you export showing all the lines that exist for Products on the screen itself?

    Analytics Products screenshot
    Link to image: https://d.pr/i/7VfTWB

    You might also see if regenerating the Analytics data helps. You can do that by following these steps:

    • Go to Analytics > Settings in your dashboard.
    • Scroll down to the “Import Historical Data” section and click the “Start” button.
    • Once that completes, try downloading a CSV again to see if there is any change.

    If you’re still not seeing Net Sales matching, are you using the analytics built into WooCommerce or have you additionally installed WooCommerce Admin?

    Thread Starter jobzavia

    (@jobzavia)

    Hello @darciemg

    is the CSV you export showing all the lines that exist for Products on the screen itself?

    – in Analytic menu, My Net sales show at upper top is same value with net sales at the buttom

    – then i count number of products in table 1 by 1 by my eye.
    Prodcuts = 24 (CSV = 24 too)
    items sold = 38 (CSV = 38 too)

    – But at the buttom of the table
    Products = 27
    items sold = 40

    In Analytic > products
    i only set Date range, i never touch another thing.

    _______________________________________________________

    -for now, i try Date range 2 days from Jul 19-20
    -for singgle day filter. CSV file show Net sales summation correctly compare with Analytics menu
    Day 19 : Net Sales = 5,671.25
    Day 20 : Ney Sales = 2,232
    They are coeect.

    -but when i filter 2 days together.

    Analytics menu show : 7,903.25 (From above 5671.25 + 2232 it sum correct)
    My download CSV. file : 7,200.25

    • This reply was modified 2 years, 7 months ago by jobzavia.
    • This reply was modified 2 years, 7 months ago by jobzavia.
    Plugin Support Summer M.a11n

    (@shrutiwpcom)

    Hi @jobzavia,

    Thanks for reaching out. Could you try deleting all previously imported orders from Analytics > Settings:

    https://docs.woocommerce.com/document/woocommerce-analytics/#analytics-settings__import-progress

    Then reimport all order data from the same page after the deletion process has been completed? This will ensure all data is present.

    As for the differences between each report type, this is expected since each account for its own report type. Depending on which report you’re viewing, taxes or refunds may be omitted to given details about that specific report. The details for each report can be found here:

    https://docs.woocommerce.com/document/woocommerce-analytics

    Last but not the least, it may be helpful to view a smaller range of dates or even a single day to compare with the orders under WooCommerce > Orders to help make sense of the data.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WP Analytics CSV file, net sales sum not equal to value in Analytics menu’ is closed to new replies.