My Question is not about how to implement in Product table, I either use Attributes or Descriptors and use a query to get all products
for an Item.
I have a list of Items : ( I1, I2, I3 .... I9) and want to show them as a vertical Menu :
Eeach Item may be populated in several products and each product may contain 0 or more items.
Selecting an Item from a menu will yield to show all product related to item ( using the above query ) and display will be in current Product Summary List format.
So my Question Is :
1- Make a Vertical Menu (block) of Items
2-Make Dynamic SQL Query based on Selected item
3-Display the result set in Product Summary List format.
Thanks,
|