Last 7days product sales history - data inconsistency

Shopify Plus
, , ,

Topic summary

Issue: “Last 7 days” product sales history appears inconsistent/broken since last week’s update in Shopify Plus analytics.

Reproduction: A ShopifyQL query executed via the GraphQL shopifyqlQuery endpoint returns incorrect results for a 7‑day window:

  • FROM products SHOW sum(quantity_purchased), sum(purchase_sessions)
  • GROUP BY product_id WHERE quantity_purchased > 0
  • SINCE -7d UNTIL today LIMIT 10000
    (ShopifyQL is Shopify’s analytics query language; GraphQL is the API method used to run it.)

Impact: Data used for marketing and stock management is unreliable due to the 7‑day sales history inconsistency.

Related regression: A prior update reportedly caused order tag filters in the admin to stop working for orders created before that update.

Ask: Looking for workarounds or ways to handle the data inconsistency until a fix is available.

Status: No solution or official acknowledgment is provided in the thread yet; the issue remains open.

Summarized with AI on January 20. AI used: gpt-5.
1

Hello,

The last 7days product sales history is not working since last week update. You can quick test this by running simple GrapQL query:

query {
shopifyqlQuery(query: “FROM products SHOW sum(quantity_purchased), sum(purchase_sessions) group by product_id WHERE quantity_purchased>0 SINCE -7d UNTIL today LIMIT 10000”) {
__typename
… on TableResponse {
tableData {
rowData
columns {
name
dataType
displayName
}
}
}
parseErrors {
code
message
range {
start {
line
character
}
end {
line
character
}
}
}
}
}

  • The previous update caused the order tags filters in backend admin to stop working - on orders before the update

On our end we are using data from this report in marketing, stock management, etc

Anyone has found a way to handle the data inconsistency?

Thank you