Best approach for querying by SKU in a product catalog using Sanity.io and GraphQL.

Hi all. I have multiple document types that together form a product catalog. I will need an easy way to query by SKU, and I am not sure what the best way to proceed. Should I add SKU to individual documents and then use some aggregate query for it? Or should I create a new document type that will hold the unique global SKU and reference the product document types?

Hey Ismayil! To clarify, do each of these product documents have their own SKU or do you want multiple products under one SKU?If they are individual SKUs, I suggest you add an SKU field to each document, then you can use GROQ to query and stitch together the information that you need.

I am not entirely sold on GROQ, as it's some custom technology that no IDE supports, and it doesn't provide any type safety. If we were to use GraphQL what would the better approach be?

Each product has it's own SKU, so a catalog is just a union of multiple document types.

If you’re not sold on GROQ, you can start learning about how to use our GraphQL API here .
As for your structured content approach, I would say that each individual product should be its own document with its own SKU field. Then, to group products into various categories, create a category document that contains an array of references to the relevant product documents. It may be helpful to take a look at these
e-commerce starters to get some ideas on best practices.

If you’re not sold on GROQ, you can start learning about how to use our GraphQL API here .
As for your structured content approach, I would say that each individual product should be its own document with its own SKU field. Then, to group products into various categories, create a category document that contains an array of references to the relevant product documents. It may be helpful to take a look at these
e-commerce starters to get some ideas on best practices.