This article walks through the steps to troubleshoot discrepancies between Shopify and Strique

Revised: This article outlines the steps to troubleshoot any discrepancies between Shopify and Strique.

If you notice any discrepancy in your data between Shopify Analytics and Strique, there are a few steps you can take to troubleshoot where this difference might be coming from.

Shopify Analytics' formula for Total Sales is:

Total Sales = Gross Sales - Discounts + Shipping + Tax - Returns.

Gift cards are excluded from this calculation.

To see more info from Shopify on why they exclude gift card sales, take a look at this article from the Shopify Community.

Revised: For further information from Shopify regarding why they exclude gift card sales, please refer to this article from the Shopify Community.

If you encounter an issue with Total Sales, ensure you're examining Total Sales in the Sales Report on Shopify Analytics, not the Shopify Homepage. On the Shopify homepage, the returns also include tax and shipping of the returned orders for that day, whereas, Shopify Analytics does not include tax and shipping. When comparing with Shopify Analytics, make sure you select the filter "Sale Kind = 'order'" on Shopify.

For reference, this is the Shopify Homepage.

Things to keep in mind:

• Order adjustments (such as item exchanges) can sometimes cause discrepancies in Shopify Analytics as these orders are counted twice: the day the order was processed and the day the order was edited. Returns are still calculated at the time they are processed like on Shopify Analytics. Strique pulls the original order data directly from the API which makes it 100% accurate.
• Total Sales in Shopify Analytics can sometimes appear slightly inflated compared to Strique, as Shopify counts tax amounts for $0.00 orders, whereas Strique does not. These tax amounts **will not show up or the original orders, but may still be included on the Shopify Analytics Total Sales metric.