productsCount still limited to 10,000 for ACTIVE status products

[Naren1]

On the Jan 15th AMA, we were informed that productsCount limit was lifted. But when I query for ACTIVE status products, the limit is still capped at 10,000

I see a thread discussing this but no resolution.

Use-case:
stores with a million products install our app. We frankly tell them at install that we cannot support them after making a product count api call. We can however support upto 100k but we have no way of knowing the exact active product count beyond 10k. Our billing plans are also based on active product counts so we need to know the exact value at install to present the correct billing plan

[Liam-Shopify]

Hey Naren,

This should be working - I’ve seen it on some stores, eg:

[Naren1]

Hi @Liam-Shopify

I’m referring to the below query from my screenshot that filters for active products only.

total productsCount works without the 10k cap
but 10k cap is applied when filtered by status

query  {
  productsCount(query:"status:ACTIVE") {
    count
  }
}

[Luke]

I believe the change released was only to get the total count without any filters applied.

Reference - productCounts query limitation - #29 by Tim-Shopify

[Liam-Shopify]

Checked internally and @Luke is correct here - this currently only works without filters.

[Naren1]

Thanks @Luke and @Liam-Shopify for the quick reply.

While I understand GraphQL team might have its reasons for capping counts with filters, what it means for app developers is there is no GraphQL alternative now for the filters that used to work nicely in REST api.

Hope this is added to the roadmap to provide true equivalence. In the meantime we’ll work around it for now.