Filter `productVendors` by product status

GraphQL Admin API Troubleshooting
1

The productVendors Shopify Admin Query (productVendors - GraphQL Admin) will return a list of vendors added to products. Is there a way to run the query so that it returns vendors added to products who’s status is “active”?

With the recent release for Unlisted Product Status, it would be nice to have the ability for the productVendors query to also filter out vendors who’s products are all unlisted. However looking at the docs it seems the query is not capable of filtering.

The ideal scenario is: vendor “A” has 3/3 products which are all unlisted so the productVendors query would exclude this vendor from the list. Whereas vendor “B” has 2/3 products which are unlisted so the query includes this vendor in the list.

The alternative is to run a products query that checks for status:active, eg:

query GetProductVendors {
  products(first: 250, query: "status:active") {
    edges {
      node {
        vendor
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

But you would need to paginate over the results then deduplicate vendors which can be inefficient for stores with thousands of products.

So just seeing if there’s a way to filter productVendors by their product status?

2

Hi @Philip,

As you’ve noticed, at this time there is no way to currently filter the productVendors query on the GraphQL Admin API.

I do see how this would be a good use case, especially with the new unlisted product status that was just released, and I will be submitting some feedback internally on your behalf to our developers and product managers. While we can’t guarantee when or if this feature will be added, I can assure you that we do take all our partner and merchant developer feedback with great value when determining future features and platform updates.

As for a workaround, I do agree that using the products query with a query filter would be the best method here. I do understand that there is some limitations with regards to deduping the returned product vendors and paginating through the product results.

I do have a work around for the pagination limitation. I would recommend using Bulk Operation Queries to request all products asynronously, so you do not have to worry about API rate limits or result pagination. Though the app would still need to dedup the results after they’re returned.

Additionally I can confirm that the unlisted status is available on the products object, and can be used with the products status query filter as well as of API version 2025-10

2 Likes