My Sales Report is wrong after migrating to Shopify. Why is that?
It often happens so, that after migrating to Shopify users discover that their Sales Reports for the current month are distorted and have negative value, e.g. -$453.7. By contrast, reports for previous months get distorted into opposite direction and have bigger values than they actually had.
This may happen due to Shopify API peculiarities and restrictions it imposes on migrating refund transaction dates.
It goes like this: when migrating to Shopify, orders in refunded status get transferred correctly with an exact date they were created. For example, if migration to Shopify was performed on 23.03.17 and refund order was created three months earlier i.e. 23.12.16, the order will be migrated with a correct date - 23.12.16.
However, refund transaction dates can’t be migrated to Shopify backdated. Thus, if migration o Shopify was performed on 23.03.17, all refund transaction dates will be recorded as to have happened on the very same day - 23.03.17.
As the result, the refunds that took place earlier will affect the statistics of sales report of the month during which migration to Shopify was performed by reducing sales total, and adding up to sales total of previous months.
All new refund transaction dates after migration to Shopify will be recording correctly.