Almost daily, I see this question asked in the osCommerce Forum…
How can I have 9 random products showing in the the “New Products For…” box in the front page of my osCommerce site?
The answer is really, really simple – you need to change the SQL that selects the 9 products, like this;
Open up /includes/modules/new_products.php
Upload the file and refresh your index page. You’ll get 9 random products rather than the last 9 added/amended products. A better option in my opinion would be to add a “Featured Products” contribution, as I think that no customer wants to see Random Products.