Analytics Counting Refunds & Failed Orders

Hi @kfutter

Thanks for reaching out!

I understand that the refunded and failed orders are included in your WooCommerce Analytics Report.

WooCommerce Admin is pre-configured with default settings for WooCommerce Analytics.

To remove failed orders from the analytics reports, please navigate to Analytics > Settings > Excluded statuses to remove these default settings.

Image Link: https://snipboard.io/9j3NiR.jpg

As per the refunded status, this cannot be excluded from the reports.

You can find more information here: https://woocommerce.com/document/woocommerce-analytics/#analytics-settings

Hope this helps!

• This reply was modified 2 years, 2 months ago by xue28 (woo-hc).

Hi there – thanks for that info. Unfortunately, the ‘Failed’ option is already ticked. And it’s odd that you can’t remove refunded items – these are not considered valid sales for my purposes (especially for digital products that don’t get downloaded), and need to be excluded from revenue calculations. There must surely be a way to do this!

Kevin

Hi Kevin,

the ‘Failed’ option is already ticked

Thanks for confirming that. The “Failed” status should be excluded from the totals in your reports.

And it’s odd that you can’t remove refunded items

There isn’t a default option to exclude refunded orders from the orders report. Refunded orders have two rows in the report: one for the date of the original order and one for the date of refund. You might try some custom code but that’s outside our support scope.

Can you try importing historical data and see if anything changes?

https://woocommerce.com/document/woocommerce-analytics/#analytics-settings__import-historical-data

Make sure you have a full backup in place of your site and database before making any changes. You could consider using a service like Jetpack or installing a plugin like UpdraftPlus. If something goes wrong it’s nice to know that you can restore your site to the previous state.

Cheers.

Would deleting refunded orders once they’re concluded solve the issue? The obvious downside is not having access to the relevant historical data after that, but I’m not sure how much I care.

Kevin

Hi @kfutter

Would deleting refunded orders once they’re concluded solve the issue?

I wouldn’t go that route as the order details and refund record will no longer be viewable.

And it’s odd that you can’t remove refunded items – these are not considered valid sales for my purposes (especially for digital products that don’t get downloaded), and need to be excluded from revenue calculations.

To clarify, when issuing a refund, did you specify the quantity of the product(s) to be refunded? When you make a refund following the instructions here, that refunded product will not be considered as sold in Analytics.

If the numbers are not correct in your Analytics, I’d also suggest importing historical data as Mirko recommended: https://woocommerce.com/document/woocommerce-analytics/#analytics-settings__import-historical-data

Thanks. There’s no historical data to import, and the analytics I’m referencing refer only to August 2022. But I’ll click the button and try it anyway. For refunds, I always use the method you linked to, and in almost all cases, it’s a 100% refund.

Hi @kfutter

There’s no historical data to import, and the analytics I’m referencing refer only to August 2022. But I’ll click the button and try it anyway.

Thanks for giving it a try!

Could you please update us here if that resolves the issue?

Thanks!