How to query product variants and their price in one query?

If you know the product ID, is there a way to get its varients and prices in one single query?

My main requirement is to get the item variant information such as name, price and if it’s in stock.

For whoever is struggling with the same issue, there’s no way to get it in a single query.

I had to use two queries and merge the responses.

Promise.all([
wixStores.getProductVariants([PRODUCT_ID], {}),
wixData.query( “Stores/Products” ).eq( “id” , [PRODUCT_ID]).find()
]) .then(values => {

})

Thanks for sharing. This will surely be a useful information.

how do you code this?