Flexible search query to get variants for a give product

[Former Member]

Hello,

I want to see what are all the available variants for a given product. Could any one help me what is the flexible query that I can use to get all the variants for a given product.

A product can have multiple variants so I want to see all the variants.

Thanks in advance.

[Marko_salonen · Accepted solution]

Hi,

you could try execute following query : select {V.CODE} from {VariantProduct as V JOIN Product as P on {P.PK} = {V.BaseProduct}} where {P.CODE} = 'PRODUCTCODE' Then you will get the code for the products. Replace PRODUCTCODE with the product code that you are interested in

[Former Member]

Thanks for your quick response Marko.