jasonhamuq

Before I do the guide, I would like to clarify something. Will the graphs go down the negative y-axis if we do a refund on the order? We usually have this scenario:
1. An order was created. We wait for a maximum of 101 days or earlier if the customer likes our product and wouldn’t want a refund.
2. If customer wants a refund, we sometimes do a partial or usually a full refund. Note that the usual request for refund happens 3-5 days after the purchase.
Now the question is, will a negative sale happen? Your screenshot doesn’t answer it. I tested on our staging site, a quite old one, where a WooCommerce version 3.3.5 is installed. I did a test order today and refunded the order. I changed the post_date and post_modified of the order in the wp_posts table in order to simulate that the order was refunded the day after the purchase. When I checked in WooCommerce->Reports->Sales by product->Certain product, the negative sale is still there. I did some adjustments on the javascript code for you to compare these two images:

Default:
https://ibb.co/KDLcCLp
Adjusted:
https://ibb.co/DMNsnNm

Given these examples, I’d like to clarify if these negative sales would ever happen? If not, then I’d proceed with the troubleshooting.