Selecting A Category For The Home Page To Select & Rotate Items From ~ osCMax v2.0.4

[corsican]

I have been looking everywhere in my osCMAX v2.0.4 administration to find some way that I can select a certain Category from my category list for the Home Page to grab items from for it's rotation display??

I usually list about 30 new items at the beginning of each month so the Home Page currently selects from the 10 newest items listed to display when a customer first gets to the Home Page. But when a new month starts the Home Page selects items from throughout the website to rotate and display on the Home Page.

Is there some way I select a certain Category and since I already have a Newly Listed category it would be what I would want to use so that the Home Page will continue to select items from that category only to display even after a new month
starts??

Thank You!!

[pgmarshall]

So you want a new infobox to display on the homepage containing a specific category's products?

You could simply copy catalog/includes/modules/new_products.php and rename it to something suitable ... then simply edit the query at the top of the file.

Something like:

select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '{enter your cat_id here}' and p.products_status = '1'
order by p.products_date_added desc limit ". MAX_DISPLAY_NEW_PRODUCTS

Regards,

[corsican]

Thank You again pgmarshall for your quick reply.

I was wanting to be able to select one of my categories (Newly Listed) to display the items in that category on the Main Center Section of the Home Page, "New Products For April". The box is set up to display 10 items that change every time you go to the Home Page. Have those items from that Newly Listed category continue to display even when a new month starts and the Home Page shows "New Products For May" etc.

Are you referring to the main center section on the Home Page as the Info Box?? I have a smaller "What's New" box on the right side of site that is fine as it is.