How can I calculate my total order refunds?

We cannot directly calculate your total order refunds due to the differences in our integration data, such as refunds, exchanges, and adjustments. The order is completely removed from the feed with some integrations, so it will not be recorded as a refund. We recommend confirming your refund figures directly from the e-commerce platform instead.

To calculate all order refunds recorded in Craftybase for a specific time:

1. Download your Orders CSV for the period you need.
2. Find the sum of the Grand Total column for all orders with a date in the Cancelled Date column. This will give you a total of all canceled orders.
3. Find the sum of the Adjustment column for all orders without a date in the Cancelled Date column. This will give you all adjustments made to non-canceled (active) orders.
4. Add the figures from steps 2 and 3 to derive your total order refund amount.