Why Do the Sales Numbers Not Align with My Shopify Sales Reports?

Why Do the Sales Numbers Not Align with My Shopify Sales Reports?

Info
This article will help you to understand some of the discrepancies you may see between Shopify Sales Reports and the reports you make with our connectors.
There are many potential causes for missing or incorrect data in your Shopify report.

Time frame mismatch

In the API that is used for our connector, the values reported are the current total of all orders. Shopify Sales Reports calculates values of goods exchanged between the merchant and the customer within a given time frame.

For example:  If a merchant refunds a custom amount of $5 because the customer complained it took too long to ship, but no items were refunded and restocked, the -$5 difference will not appear in the Sales Reports, but will be deducted from API total.

Refund date discrepancy

Refunds are counted in the Shopify Sales Reports on the date they were refunded.  The API will count refunds on the date the order was placed.  So when comparing the two reports, refunds will not align by date range.

Data has not yet arrived

It can take up to 1 hour for data to first appear when you connect the first time to Shopify.  This is due to the limitations of the API and the amount of data available in this connector.

We initially backfill 3 months of data when you connect with us and keep this data going forward. Run a manual backfill to get up to 2 years of data from the Shopify connector.

Order Fulfillment Status mismatch

Our connector reports all orders, including unfulfilled.  To align with Shopify's reports, you can apply a filter.
Select a chart then click Add a filter from the right side panel options.



Select Create a filter. 



Name your filter then set it to Include > Order Fulfillment status (orders) > Equal to (=) > FULFILLED



Add a filter to the whole report page

Select Add a control from the toolbar. Select Drop-down list and place it on the report.



Use Order fulfillment status (orders) for the control field and Order ID (line_items_orders) for the metric. 



Then select Fulfilled.



    • Related Articles

    • Troubleshooting Shopify

      Most of the difficulties our customers have with Shopify are easy to solve independently without the need to wait for a support ticket reply. This article will help you find everything you need. Try these articles if you are having difficulty ...

    • Missing POS Location Name Data in Shopify

      If you're seeing blank or missing data or "0" values for metrics when using the POS Location Name dimension in your Shopify reports, this article will help you resolve the issue. This problem occurs when your Shopify connection doesn't have the ...

    • Why Do the Sales Numbers Not Align with My Amazon Seller Central Reports?

      There are several reasons you might see different numbers when comparing the Amazon Seller Central connector with Amazon's reports. This article will help you troubleshoot reports that show different numbers from Amazon's in-house reporting. ...

    • Shopify Data Connector User Guide

      <div style="overflow-wrap: break-word"></div> <div style="overflow-wrap: break-word"> <div><span class="KB_New_Editor_Highlights" style="background-color: rgb(193, 225, 244); border-right: ...

    • Why Do the Sales Numbers Not Align with My Woocommerce Sales Reports?

      There may be several different reasons that your WooCommerce data is not aligning. This article will help you find the cause and fix your reports. Order Status WooCommerce's API reports all orders including completed, pending, processing and more. To ...