Broadleaf Commerce Discussion Forums

hi,

I have a product that has productOption (that has multiple values), for each Product-ProductOption (say the Red Shirt), how do I find the SKU#? There is a table for Product_Option_Xref, and SKU_Option_Value_XREF, but I can't seem to find the SKU for Product_Option_Xref.

Thanks,
Mei

A product has multiple product options, a product option has multiple product option values, and a Sku has multiple product option values. You can get to the Sku by looking at permutations of the product option values.