Why don't my Shopify sales match my Shopify reports dashboard?

Possible reasons why Airboxr and Shopify sales data don't match.

Saptarshi Nath

17.01.2023

FAQ

There are a few different reasons why your Airboxr output may not perfectly match Shopify's reporting dashboard.

Refund dates

Airboxr imports the data from your orders and then aggregates them to provide you with the output. We always tag the refund to the original order date. If an order is received in January and refunded in February, we will reduce the sales in January by the value of refunds. On the other hand, Shopify will reduce your sales in February.

As business owners, it is essential for us to know what causes refunds—it is therefore essential to tag the refunds to the right order, instead of the date of refunds. In the above example, if you wanted to find out what drove refunds in January, you can easily do so with Airboxr.

Shopify APIs

Shopify provides access to its data through three developer sources: Rest APIs, GraphQL (short for Graph Query Language), and ShopifyQL. All Airboxr reports are created through GraphQL and all Shopify reports are created through ShopifyQL. This is because ShopifyQL is available for apps that work inside Shopify Admin. Since Airboxr works within spreadsheets, ShopifyQL is not available to us.

Since the data comes from two slightly different sources, some amount of discrepancy is expected. That said, unless your discrepancy is over 10%, it shouldn't affect your decision-making.

Differences in Shopify sales data in Airboxr compared to Shopify's dashboard arise due to refund date tagging and data source discrepancies. Airboxr tags refunds to the original order date, which can differ from Shopify's approach, and uses GraphQL for reports, while Shopify uses ShopifyQL, leading to some expected discrepancies in data.