We stumbled upon the fact that when we export orders from Shopify, the export includes items that were returned/refunded without any indication that they were returned/refunded. For example: an order was placed for 4 items, customer requested to return 2 of them, export only shows that 4 of the item was ordered (no indication of the 2 returned or that the order is now actually only for 2 of the item). Likewise, an order was placed for the Medium variant of an item…customer requests to exchange medium for large…export of the order shows both 1 of the medium and 1 of large (with no indication that the medium was returned and the order is actually for just 1 of the large).
Chatting with Shopify Support and they admit it’s a known issue…and there’s no ETA for a fix. They recommend purchasing an app…which they can provide no support for and cannot promise that it will work correctly anyway since Shopify can’t export it’s own data accurately in the first place.
At the very very very least, wish Shopify had notified of us of this “known issue” rather than left us to discover it…the week of Christmas (busiest commerce week of the year in USA).