How to show products in first page

[idanag]

Hi.

I want to cancel the " new product in month...." feature on the first page and I want to be able to show any product/s (multiple) on the first page.

Can anybody tell me how to do that ?
or..maybe how to cancel the date match on the new items in "month.."

10x

Idan

[met00]

so you want every first page to load with a random selection of products?

[idanag]

YEs , That might work.
Do you know how I can do that ?

[met00]

One simple way is to use the new products, but change it so that it picks products from a random month... in this case modify the SQL

Old SQL:

 $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

New SQL

srand(time());
$randmonth = (rand()%12);
 $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' and month(p.products_date_added) = ".$randmonth." order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

Then modify the /includes/languages/english/ files as necessary

This is a simple hack, but it should do what you want. To make it a tad more complex you could

1) load a selection of products (say 50 products by month, by random selection of the fisrt letter in the products name... whatever you want to use to make the selection totally random) into an array
2) select MAX_DISPLAY_NEW_PRODUCTS (assume it will be under 50 ) from the array randomly and insert into another array
3) display the second array

[JohnW]

You might try this contribution that uses featured products that you set in the admin section. I used it on my old OSC site before I switched to oscmax and it was a really easy contribution to load.

osCommerce: Featured Products