Hi, I need to get all active and published products by collection id. I know I can get all Active and published products by doing this: { products (first:50, query:"status:active AND published_status:published") { nodes { id, title, } } } And I know I can get all products …

Hi @pablores , Thanks for your post. Currently there’s not a built in way to achieve that in a single query so we’ve submitted some feedback about it internally, particularly around having some more filters in the Collection.products connection. Hope you have a great day

Hi Pablores! Put this in Query: query Collections ($first: Int!, $reverse: Boolean!, $query: String!){ collections(first: $first, reverse: $reverse, query: $query) { edges { node { id products(first: 250) { edges { …

Is there another way to do this with multiple queries?

You forgot the condition “products is ACTIVE” :disappointed_face:

It’s true, but I am using C#, and because of that I can just use LINQ to filter the returned data super quick. Don’t know what technology you are using, but maybe it has something similar

But in case this collection has the first 250 products as DRAFT, that means at this time no products found in one graphQL query

This should be possible now by using the productVariants graphql query. For example: query getProductVariantsByCollection { productVariants(query:"collection:{your-collection-id} status:ACTIVE" first:10) { nodes { id sku product { title } } } } This wil…

I made a typo in my query… it should actually be ... product_status:active

Graphql API - Get all ACTIVE and PUBLISHED Products by Collection Id

Retired Boards Appdev Graphql Basics And Troubleshooting

LongPC March 7, 2024, 8:15am 5

You forgot the condition “products is ACTIVE”

Topic		Replies	Views
Filter products by collection New Graphql Product Apis Product-Tips , Setting-Up	2	59	June 7, 2024
Query products in a specific market or collection via GraphQL Admin Merchandising Setting-Up	0	108	May 7, 2024
Get (json) list of all products with collections they belong to Graphql Basics And Troubleshooting	1	334	July 9, 2020
StoreFront API Graphql - Query all products using collectionIds Custom Storefronts	4	105	January 26, 2021
graphql query products from collection published on on specific channel Technical Q&A	0	50	April 25, 2023

Graphql API - Get all ACTIVE and PUBLISHED Products by Collection Id

Related topics