---
title: productsCount - GraphQL Admin
description: Count of products. Limited to a maximum of 10000 by default.
api_version: 2025-10
api_name: admin
type: query
api_type: graphql
source_url:
  html: https://shopify.dev/docs/api/admin-graphql/latest/queries/productsCount
  md: https://shopify.dev/docs/api/admin-graphql/latest/queries/productsCount.md
---

# products​Count

query

Requires `read_products` access scope.

Count of products. Limited to a maximum of 10000 by default.

## Arguments

* limit

  [Int](https://shopify.dev/docs/api/admin-graphql/latest/scalars/Int)

  Default:10000

  The upper bound on count value before returning a result. Use `null` to have no limit.

* query

  [String](https://shopify.dev/docs/api/admin-graphql/latest/scalars/String)

  A filter made up of terms, connectives, modifiers, and comparators. You can apply one or more filters to a query. Learn more about [Shopify API search syntax](https://shopify.dev/api/usage/search-syntax).

  * * default

      string

    * barcode

      string

    * bundles

      boolean

    * category\_id

      string

    * collection\_id

      id

    * combined\_listing\_role

      string

    * created\_at

      time

    * delivery\_profile\_id

      id

    * error\_feedback

      string

    - Filter by a case-insensitive search of multiple fields in a document.

    - Example:

      * `query=Bob Norman`
      * `query=title:green hoodie`

      Filter by the product variant [`barcode`](https://shopify.dev/api/admin-graphql/latest/objects/ProductVariant#field-barcode) field.

    - Example:

      * `barcode:ABC-abc-1234`

      Filter by a [product bundle](https://shopify.dev/docs/apps/build/product-merchandising/bundles). A product bundle is a set of two or more related products, which are commonly offered at a discount.

    - Example:

      * `bundles:true`

      Filter by the product [category ID](https://shopify.dev/api/admin-graphql/latest/objects/Product#field-category) (`product.category.id`). A product category is the category of a product from [Shopify's Standard Product Taxonomy](https://shopify.github.io/product-taxonomy/releases/unstable/?categoryId=sg-4-17-2-17).

    - Example:

      * `category_id:sg-4-17-2-17`

      Filter by the collection [`id`](https://shopify.dev/api/admin-graphql/latest/objects/Collection#field-id) field.

    - Example:

      * `collection_id:108179161409`

      Filter by the role of the product in a [combined listing](https://shopify.dev/apps/build/product-merchandising/combined-listings).

    - Valid values:

      * `parent`
      * `child`
      * `no_role`

      Example:

      * `combined_listing_role:parent`

      Filter by the date and time when the product was created.

    - Example:

      * `created_at:>'2020-10-21T23:39:20Z'`
      * `created_at:<now`
      * `created_at:<='2024'`

      Filter by the delivery profile [`id`](https://shopify.dev/api/admin-graphql/latest/objects/DeliveryProfile#field-id) field.

    - Example:

      * `delivery_profile_id:108179161409`

      Filter by products with publishing errors.

  * * gift\_card

      boolean

    * handle

      string

    * has\_only\_composites

      boolean

    * has\_only\_default\_variant

      boolean

    * has\_variant\_with\_components

      boolean

    * id

      id

    * inventory\_total

      integer

    * is\_price\_reduced

      boolean

    * metafields.{namespace}.{key}

      mixed

    * out\_of\_stock\_somewhere

      boolean

    * price

      bigdecimal

    * product\_configuration\_owner

      string

    * product\_publication\_status

      string

    * product\_type

      string

    * publication\_ids

      string

    * publishable\_status

      string

    * published\_at

      time

    * published\_status

      string

    * sku

      string

    * status

      string

    * tag

      string

    * tag\_not

      string

    * title

      string

    * updated\_at

      time

    * variant\_id

      id

    * variant\_title

      string

    * vendor

      string

    - Filter by the product [`isGiftCard`](https://shopify.dev/api/admin-graphql/latest/objects/Product#field-isgiftcard) field.

    - Example:

      * `gift_card:true`

      Filter by a comma-separated list of product [handles](https://shopify.dev/api/admin-graphql/latest/queries/products#argument-query-filter-handle).

    - Example:

      * `handle:the-minimal-snowboard`

      Filter by products that have only composite variants.

    - Example:

      * `has_only_composites:true`

      Filter by products that have only a default variant. A default variant is the only variant if no other variants are specified.

    - Example:

      * `has_only_default_variant:true`

      Filter by products that have variants with associated components.

    - Example:

      * `has_variant_with_components:true`

      Filter by `id` range.

    - Example:

      * `id:1234`
      * `id:>=1234`
      * `id:<=1234`

      Filter by inventory count.

    - Example:

      * `inventory_total:0`
      * `inventory_total:>150`
      * `inventory_total:>=200`

      Filter by products that have a reduced price. For more information, refer to the [`CollectionRule`](https://shopify.dev/api/admin-graphql/latest/objects/CollectionRule) object.

    - Example:

      * `is_price_reduced:true`

      Filters resources by metafield value. Format: `metafields.{namespace}.{key}:{value}`. Learn more about [querying by metafield value](https://shopify.dev/apps/build/custom-data/metafields/query-by-metafield-value).

    - Example:

      * `metafields.custom.on_sale:true`
      * `metafields.product.material:"gid://shopify/Metaobject/43458085"`

      Filter by products that are out of stock in at least one location.

    - Example:

      * `out_of_stock_somewhere:true`

      Filter by the product variant [`price`](https://shopify.dev/api/admin-graphql/latest/objects/Productvariant#field-price) field.

    - Example:

      * `price:100.57`

      Filter by the app [`id`](https://shopify.dev/api/admin-graphql/latest/objects/App#field-id) field.

    - Example:

      * `product_configuration_owner:10001`

      Filter by the publication status of the resource on a channel, such as the online store. The value is a composite of the [channel `app` ID](https://shopify.dev/api/admin-graphql/latest/objects/Channel#app-price) (`Channel.app.id`) and one of the valid values.

    - Valid values:

      * `approved`
      * `rejected`
      * `needs_action`
      * `awaiting_review`
      * `published`
      * `demoted`
      * `scheduled`
      * `provisionally_published`

      Example:

      * `product_publication_status:189769876-approved`

      Filter by a comma-separated list of [product types](https://help.shopify.com/manual/products/details/product-type).

    - Example:

      * `product_type:snowboard`

      Filter by a comma-separated list of publication IDs that are associated with the product.

    - Example:

      * `publication_ids:184111530305,184111694145`

      Filter by the publishable status of the resource on a channel, such as the online store. The value is a composite of either the [channel `app` ID](https://shopify.dev/api/admin-graphql/latest/objects/Channel#app-price) (`Channel.app.id`) or [channel `name`](https://shopify.dev/docs/api/admin-graphql/latest/objects/Channel#field-name) and one of the valid values.

    - Valid values:

      * `online_store_channel`
      * `published`
      * `unpublished`
      * `visible`
      * `unavailable`
      * `hidden`
      * `intended`
      * `visible`

      Example:

      * `publishable_status:published`
      * `publishable_status:189769876-visible`
      * `publishable_status:pos-hidden`

      Filter by the date and time when the product was published to the online store and other sales channels.

    - Example:

      * `published_at:>2020-10-21T23:39:20Z`
      * `published_at:<now`
      * `published_at:<=2024`

      Filter by the published status of the resource on a channel, such as the online store.

    - Valid values:

      * `unset`
      * `pending`
      * `approved`
      * `not approved`

      Example:

      * `published_status:approved`

      Filter by the product variant [`sku`](https://shopify.dev/api/admin-graphql/latest/objects/ProductVariant#field-sku) field. [Learn more about SKUs](https://help.shopify.com/manual/products/details/sku).

    - Example:

      * `sku:XYZ-12345`

      Filter by a comma-separated list of statuses. You can use statuses to manage inventory. Shopify only displays products with an `ACTIVE` status in online stores, sales channels, and apps.

    - Valid values:

      * `active` Default
      * `archived`
      * `draft`

      Example:

      * `status:active,draft`

      Filter objects by the `tag` field.

    - Example:

      * `tag:my_tag`

      Filter by objects that don’t have the specified tag.

    - Example:

      * `tag_not:my_tag`

      Filter by the product [`title`](https://shopify.dev/api/admin-graphql/latest/objects/Product#field-title) field.

    - Example:

      * `title:The Minimal Snowboard`

      Filter by the date and time when the product was last updated.

    - Example:

      * `updated_at:>'2020-10-21T23:39:20Z'`
      * `updated_at:<now`
      * `updated_at:<='2024'`

      Filter by the product variant [`id`](https://shopify.dev/api/admin-graphql/latest/objects/ProductVariant#field-id) field.

    - Example:

      * `variant_id:45779434701121`

      Filter by the product variant [`title`](https://shopify.dev/api/admin-graphql/latest/objects/ProductVariant#field-title) field.

    - Example:

      * `variant_title:'Special ski wax'`

      Filter by the origin or source of the product. Learn more about [vendors and managing vendor information](https://help.shopify.com/manual/products/managing-vendor-info).

      Example:

      * `vendor:Snowdevil`
      * `vendor:Snowdevil OR vendor:Icedevil`

* saved​Search​Id

  [ID](https://shopify.dev/docs/api/admin-graphql/latest/scalars/ID)

  The ID of an existing saved search. The search’s query string is used as the query argument. Refer to the [`SavedSearch`](https://shopify.dev/api/admin-graphql/latest/objects/savedsearch) object.

***

## Possible returns

* Count

  [Count](https://shopify.dev/docs/api/admin-graphql/latest/objects/Count)

  Details for count of elements.

***

## Examples

* ### Retrieve a count of products

  #### Query

  ```graphql
  query {
    productsCount(query: "id:>=1000") {
      count
    }
  }
  ```

  #### cURL

  ```bash
  curl -X POST \
  https://your-development-store.myshopify.com/admin/api/2025-10/graphql.json \
  -H 'Content-Type: application/json' \
  -H 'X-Shopify-Access-Token: {access_token}' \
  -d '{
  "query": "query { productsCount(query: \"id:>=1000\") { count } }"
  }'
  ```

  #### React Router

  ```javascript
  import { authenticate } from "../shopify.server";

  export const loader = async ({request}) => {
    const { admin } = await authenticate.admin(request);
    const response = await admin.graphql(
      `#graphql
    query {
      productsCount(query: "id:>=1000") {
        count
      }
    }`,
    );
    const json = await response.json();
    return json.data;
  }
  ```

  #### Ruby

  ```ruby
  session = ShopifyAPI::Auth::Session.new(
    shop: "your-development-store.myshopify.com",
    access_token: access_token
  )
  client = ShopifyAPI::Clients::Graphql::Admin.new(
    session: session
  )

  query = <<~QUERY
    query {
      productsCount(query: "id:>=1000") {
        count
      }
    }
  QUERY

  response = client.query(query: query)
  ```

  #### Node.js

  ```javascript
  const client = new shopify.clients.Graphql({session});
  const data = await client.query({
    data: `query {
      productsCount(query: "id:>=1000") {
        count
      }
    }`,
  });
  ```

  #### Response

  ```json
  {
    "productsCount": {
      "count": 7
    }
  }
  ```

## Retrieve a count of products

[Open in GraphiQL](http://localhost:3457/graphiql?query=query%20%7B%0A%20%20productsCount\(query%3A%20%22id%3A%3E%3D1000%22\)%20%7B%0A%20%20%20%20count%0A%20%20%7D%0A%7D)

```javascript
import { authenticate } from "../shopify.server";


export const loader = async ({request}) => {
  const { admin } = await authenticate.admin(request);
  const response = await admin.graphql(
    `#graphql
  query {
    productsCount(query: "id:>=1000") {
      count
    }
  }`,
  );
  const json = await response.json();
  return json.data;
}
```

## Response

JSON

```json
{
  "productsCount": {
    "count": 7
  }
}
```