How to build a query (GraphQL or regular REST endpoint) which will return the amount of variants in all products in a commercetools project?
I think facets can help, but I'm not entirely sure how.
The best way to get variant counts is using facets on the product projection search api. The trick is to choose a field that is available on all products. I chose variant id (facet=variants.id
) however you could choose any attribute but the resulting facet may have a missing count.
project_id/product-projections/search?staged=true&limit=0&markMatchingVariants=false&facet=variants.id
response:
"type": "terms",
"dataType": "text",
"missing": 0,
"total": 12017,
"other": 0,