Analyics > Products Report Handling of Refunded Orders

Hi there,

I’m seeing what I think is odd behavour on the WooCommerce Analyics > Products Report.

I have a product that has been purchased 5 times in one month period on 5 seperate orders.

One of those 5 orders was refunded within the same month/period.

Looking at the top level Analyics > Products and finding the product in the full list of product, the report correctly shows I have sold 4 items with the correct revenue (5 items total less the refunded order).

However, if I drill down to report on that single product by selecting the product name or using the Show filter to the left of Date Range, the report only shows 3 items sold. Looking at the list of orders, the refunded order is shown as a negative unit value and negative revenue value. Issue is, there is no positive unit or revenue value line for this order’s original sale.

The end result is the report is misreporting units sold and revenue because of the refunded order line.

Is this expected behaviour? The handling of the refunded order doesn’t seem right. Oddly though, it is fine on the top level WooCommerce Analyics > Products report as I say.

Some screenshots:

Top level Product report: https://prnt.sc/1sa9lde
Single product selected: https://prnt.sc/1sa9ntv
Order detail showing refunded order line: https://prnt.sc/1sa9qd2

Thanks,