Why is the data queried by ShopifyQL missing two days?

Topic summary

Data discrepancy in Shopify analytics: a ShopifyQL query for this month’s sales shows values that differ markedly from the Shopify dashboard. When drilling into daily sales, the last two days appear empty even though orders were placed.

  • Context: Local time is March 19, so the missing days are the two most recent days.
  • Impact: Monthly totals in ShopifyQL don’t match the dashboard due to the missing daily entries.
  • Evidence: A screenshot is attached and central to understanding; it shows the daily sales table with empty values for the last two days.

Status: No cause identified and no troubleshooting steps or settings (e.g., filters, time ranges) were shared. The issue remains open with key questions about why two days of data are missing and how to reconcile ShopifyQL with the dashboard.

Summarized with AI on January 2. AI used: gpt-5.

When I checked this month’s sales data by ShopifyQL, I found that it was much different from what was displayed on the dashboard. So I checked the daily sales data and found that it was empty in the past two days, but there were indeed orders. I don’t know why. .

The local time is March 19th!

1 Like