1 Product Per Catergory on Index - possible?

[oky]

Hi there....

 

was just wandering if anyone whould know if this is possible at all

 

 

I want to put 6 or so catergories on the index page of my osc store

 

as in each catergory has 1 product that represents it on the index page, just like the featured items on the index but instead have 6 products one for each catergory and with the catergory heading above each of those items

 

 

i hope this sounds right...

 

any help is much appreciated in advance

 

cheers

 

oky

[Guest]

you could do this by using the product_to_categories sql table. Retrieve the categories listed there. Use the distinct to return a unique category id and limit the query to 6 rows. The product id will indicate which product to fetch from the products table.

 

Once you have the result you could setup the front page layout.