How to exclude the refunded in analytics

Hey @neal86,

1.May I know how I can show the refund in analytics(https://prnt.sc/134psuu)

Refunds for that period are shown in the analytics in the “Returns” section, as seen in this example from my test site.

2.How I can exclude the refund in net sales?

The “Net Sales” include deductions from refunds intentionally, but the “Gross Sales” data does exclude refunds (since that is the total amount processed on the site).

Hi, Shaun,
Thank you for your reply,
1. I have two orders is refunded in this period, but the return is 0,
2. As I see, the net sales include the refund( it doesn’t include the refund on WC), the gross sales include the refund and shipping as the( it also doesn’t include the refund on WC)

Hey @neal86,

I have two orders is refunded in this period, but the return is 0,

Do both of those two orders show as being in the “Refunded” order status in WooCommerce?

As I see, the net sales include the refund( it doesn’t include the refund on WC), the gross sales include the refund and shipping as the( it also doesn’t include the refund on WC)

Were those orders fully refunded (all products, taxes, shipping costs, etc)?

Hey @neal86,

Since there haven’t been any updates in a while, I’m going to close out this thread. However, if you still have any questions about the analytics, I’d suggest taking a look at the documentation. If that doesn’t help, feel free to create a new post. Thanks!