Read product variants by product ID

Gets all variants belonging to a specific product. Supply the ProductId in the WHERE clause.

SELECT * FROM ProductVariants Where ProductId='1111111111111'