Incorrect collection productsCount (somehow negative)

GraphQL Admin API Troubleshooting
1

When querying (with GraphQL) the products count of a collection, in rare instances we return a negative number - which is obviously incorrect and causes a large number of issues for us.

query checkAssets {
        collection(id: "gid://shopify/Collection/285327196259") {
            productsCount {
                count
                precision
            }
            updatedAt
            products(first: 250) {
                pageInfo {
                    hasNextPage
                    endCursor
                }
                edges {
                    node {
                        id
                        title
                    }
                }
            }
        }
    }

This negative productsCount is also on the /collections/collection-handle.json version of the collection frontend:

Screenshot 2025-01-24 at 22.26.35
Screenshot 2025-01-24 at 22.26.35788×412 32.2 KB

The collection I’ve referenced has over 1000 products.

What is going on here?

2

Hi - thanks for flagging this, connecting with the relevant product team on this.

3

@Liam-Shopify

Here is another case. Can you confirm that it’s an internal issue?

I query that way:

collection(id: $id) {
  title
  productsCount {
    count
    precision
  }
}

And I get: { title: 'test456', productsCount: { count: 26, precision: 'EXACT' } }

On the admin the same collection has 24 products:

image
image976×119 1.83 KB

I double checked that I used the right collection ID to query it.

Also note that after adding/removing products using the graphql api, the value is now correct

4

Hi - our devs have identified there is an issue on our side, and are working on a fix.

1 Like
5

Hi @Liam-Shopify

Is there any update on this?

6

Hi - our team are still actively working on this, but no ETA to share just yet.

7

@Liam-Shopify Some of the user of our app are wondering why these value are mismatching. May I ask if you’ve got any news for this one?

8

@Liam-Shopify
Do we have an update on this bug? The list of merchants experiencing this is increasing every day.

1 Like
9 
await admin.graphql(`query {
      productsCount(query: "") {
         count
      }
   }`
)

This also returns a wrong number for some stores!

1 Like
10

Hi @Liam-Shopify , far from me the intention to disturb you, but did you have a chance to get any news on this? It’s a point of concern for some of our users, so it would be very helpful to hear from Shopify on this one

11

No update on this yet