No worries! This is a common issue that some people run into due to how Shopify handles reporting. When setting up your file for import, the first thing you need to do is mark the financial status as refunded. This will tell Shopify that this particular order has been refunded. To get the order to show up in the reports you'll need to add a second transaction line for the order. The first transaction is for the original payment and the second transaction is for the refunded payment. If you only want to show that an order has been refunded, but no other information, you can stop here.


If you're working with orders that are refunded and you want them marked as fulfilled, you'll also need to map the fulfillment_status on the Order Details section, which is different than the fulfillment_status on the Line Items section, as it marks the fulfillment status for the entire order rather than just the line item. If you do not map this field when doing a refund, your order will be imported as unfulfilled.


Once you have your data mapping completed with multiple transactions you can now import your order. After the order is successfully imported, log into the Shopify admin and navigate to the order you just imported. The refund amount for the order should now show up in your reports. 


If you have any other questions about transactions please don't hesitate to reach out at support@orderimp.com.


See this article for another explanation of this process with additional details: https://orderimp.freshdesk.com/solution/articles/44001409329-how-do-i-import-refunded-orders-