Woocommerce-admin: Net Revenue numbers don't match

[JScott-MSI]

Describe the bug
The Net Revenue total on the Revenue page and the Orders page match, however they do not match the Net Revenue on the Product page or the Net Revenue on the Categories page. However the Product and Category page Net revenues match each other.

Woo Admin 1.8.1
Woo 3.7.0

To Reproduce
Run the analytics reports

Expected behavior
If these are representing Net revenue the total should be the same in all reports, if they are not calculating the same way they need to be labeled in a way that represents what is actually calculated.

Screenshots
If applicable, add screenshots to help explain your proble

Desktop (please complete the following information):

• OS: iOS
• Browser Firefox
• Version Latest

[JScott-MSI]

Also a pop-up would be nice describing how the totals are calculated.

[rrennick]

I can confirm the net totals are not the same in my dev install.

[LevinMedia]

@JScott-MSI thanks for the report - I've run into similar things in my own testing, and I've seen other issues directly related to this popping up elsewhere too:

For example: https://github.com/woocommerce/woocommerce-admin/issues/2836

I'm going to do a deep dive on what's going on here and come back with a master issue to resolve the issues.

cc: @psealock

[JScott-MSI]

@LevinMedia It's got to be more than coupons, we didn't have $70k in coupons in 2018. Somewhere along the line I noticed that the number of orders matched up, but the number of items sold didn't. I'll have to try to recreate that as I don't remember specifically. I think it was a difference between the woo-admin report and the legacy report. I'll post that if I find it again.

[LevinMedia]

@JScott-MSI understood! Any additional information you can provide will be very helpful in solving this one. Thanks!

[Mikcx]

We are seeing a difference in 'Revenue' figures within Analytics > Revenue and Analytics > Products for example. The Analytics > Revenue figure matches that of WooCommerce > Reports.

I initially thought that it was only down to many instances of duplicate orders which were showing within 'Products' report:

... so carried out a reset of the analytics records, and re-imported.

Now the figures are closer, but the revenue figures are still not matching. Now that all the duplicates are out of the way, I can see that the difference is now being caused by Subscription renewals which have a coupon applied, so that the renewal is going through each month at £0.00 instead of £1.99. WooCommerce > Reports shows the product sales as 3x 0.00 whereas the Analytics > Products reports as 3x £1.99 = £5.97.

[Mikcx]

...a bit more digging into the calculations, it would seem that our example can be worked out (now that the duplicates were cleaned by emptying/re-importing) - but the title of 'Net Revenue' on the products report doesn't seem to be a real 'net revenue' or what is actually being summed is not correct :

[psealock]

the title of 'Net Revenue' on the products report doesn't seem to be a real 'net revenue' or what is actually being summed is not correct :

Thanks so much for the detailed analysis @Mikcx ! Indeed, the Net Revenue displayed in Products Report is not correct. We're hoping to address this in the coming sprint.

[rrennick]

A bit of further research shows that partial refunds are not attributed to products so the product & category totals do not have the partial refunds deducted. I'll investigate tomorrow to see if coupons & fees are similar.

[rrennick]

I've found the following discrepancies

• Rounding - Amounts in the order stats table are rounded to wc_decimals while they aren't in the product lookup table
• wc-auto-draft orders are still imported (fixed in a local branch)

• amounts deducted from order net revenue not deducted from product net revenue

  • coupons
  • partial refunds

• amounts added to order net revenue not added to product net revenue

  • fees