Product Options
Posted: Thu Jun 18, 2015 11:39 pm
I am creating all possible "product option values" for colors (are more than 100) in BLC_PRODUCT_OPTION_VALUE. But not all products would have SKUs for all colors. And thats why I have put only selected colors (Product option value) for SKUs in BLC_SKU_OPTION_VALUE_XREF.
But when I see the product detail page, It shows 100 plus swatches (for all colors). I was expecting it to show only those colors which are linked with the SKUs for that product. Moreover just Active SKUs colors.
Having similar issues with other Product Option (Size) - some of our products have sizes like XS, S, M, L, XL, XXL while some products have sizes as 6, 8, 10, 12, 14...
I have 2 rows in BLC_PRODUCT_OPTION (one for color and one for size) but I have hundreds of rows in BLC_PRODUCT_OPTION_VALUE for all possible product option values.
But my BLC_SKU_OPTION_VALUE_XREF has only applicable (related sizes and colors) relation between SKU and Product option values.
I tried to understand how ProductOptionsProcessor works. But apparently it picks all product option values based on BLC_PRODUCT_OPTION_XREF.
My client requirement is just to show those swatches which has ACTIVE SKUs under a selected product.
Thanks for your help.
But when I see the product detail page, It shows 100 plus swatches (for all colors). I was expecting it to show only those colors which are linked with the SKUs for that product. Moreover just Active SKUs colors.
Having similar issues with other Product Option (Size) - some of our products have sizes like XS, S, M, L, XL, XXL while some products have sizes as 6, 8, 10, 12, 14...
I have 2 rows in BLC_PRODUCT_OPTION (one for color and one for size) but I have hundreds of rows in BLC_PRODUCT_OPTION_VALUE for all possible product option values.
But my BLC_SKU_OPTION_VALUE_XREF has only applicable (related sizes and colors) relation between SKU and Product option values.
I tried to understand how ProductOptionsProcessor works. But apparently it picks all product option values based on BLC_PRODUCT_OPTION_XREF.
My client requirement is just to show those swatches which has ACTIVE SKUs under a selected product.
Thanks for your help.