WP Analytics CSV file, net sales sum not equal to value in Analytics menu

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?

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?

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 3 years, 3 months ago by jobzavia.
• This reply was modified 3 years, 3 months ago by jobzavia.

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.