productCounts query limitation

GraphQL Admin API Troubleshooting
26

@Luke, the issue is that the productVariantsCount GraphQL call returns incorrect results. The example you shared here isn’t just about one store; it’s returning incorrect results for many stores. This is why, until Shopify provides a reliable way for us to get accurate counts, we need the old endpoints to remain active. Below are a few examples I ran a few minutes ago for our existing customer base. It returns incorrect results for nearly 25% of our customer base.

  • GQL: The new GraphQL productVariantsCount
  • API: The variants/count.json endpoint
  • DB: Our real-time synced database

To protect customer privacy, I’ve removed domain names. A difference of 1,500 is significant:

  1. xyz.myshopify.com — Precision: EXACT
    GQL*: 4762 | API: 3260 | DB: 3260
  2. xyz.myshopify.com — Precision: EXACT
    GQL*: 1434 | API: 1272 | DB: 1272
  3. xyz.myshopify.com — Precision: EXACT
    GQL*: 2015 | API: 1776 | DB: 1776