How can I calculate my total order refunds?

We cannot directly calculate your total order refunds due to the differences in how our integrations data such as refunds, exchanges, and adjustments. With some integrations, the order is completely removed from the feed, 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 period:

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 a total of all adjustments made to non-canceled (active) orders.

4. Add together the figures from steps 2 and 3 to derive your total order refund amount.