changing latest products to randow products

[Guest intergemsuk]

Hi, i was wondering how i would change the latest products on the homepage to a random selection of products rather than the latest products added to the store.

Cheers,

Ben.

[Guest]

To make the random products appear on your main page, go to includes/content/index.inc.php

$latestProducts = $db->select("SELECT productId, image, price, name, sale_price FROM ".$glob['dbprefix']."CubeCart_inventory WHERE `showFeatured` = 1 ORDER BY productId DESC LIMIT ".$config['noLatestProds']);

 



to

$latestProducts = $db->select("SELECT productId, image, price, name, sale_price FROM ".$glob['dbprefix']."CubeCart_inventory WHERE `showFeatured` = 1 ORDER BY RAND() DESC LIMIT ".$config['noLatestProds']);

This should do it, i hope

Attention: Remember to backup before you make any changes

If this doesnt work, ask in the .org forum ;)

[Guest intergemsuk]

Very Very Nice

Thanks for your help. Just a simple change but has done exactly what i wanted it to do.

Thank you very much,

Ben.

[Guest]

You are welcome and Merry Christmas to you :D

[Guest Pete_bolton]

Hi, do i need a custom mod if i want to choose which products are featured? ill try .org if so, i would want to choose a category (like xmas) for example, it would rellly matter which prods as long as i could tell it which category, .

Thanks

Pete

[roban]

Hi, do i need a custom mod if i want to choose which products are featured? ill try .org if so, i would want to choose a category (like xmas) for example, it would rellly matter which prods as long as i could tell it which category, .

Thanks

Pete

Yes!