OpenCart Community

How to show "random" products on homepage instead of latest?

Anyone?

Anyone tonight?

change the sql query for getLatestProducts to use order by rand

Qphoria wrote:change the sql query for getLatestProducts to use order by rand

Hi Qphoria,

I'm a new when it comes to php can you please provide an example code of what needs to be change?

Thanks!

EDIT: catalog/model/catalog/product.php

FIND this function: INSIDE THAT Function, FIND: REPLACE WITH:

Qphoria Awesome! much appreciated Thanks!

Thank you Qphoria for your very informative, exact informational post.

Your time and efforts are GREATLY appreciated.

Thank you again!!!

thanks

this is all well and good, but the randomized query gets cached (like all product queries), leaving the same results on the home page (which isn't very random).

you guys know an easy way around this?

derp i'm stupid.

didn't see this line right below the query that you can simply comment out

so i've commented out the cache line and changed the ORDER BY to rand() - and my products are still not randomised - what gives?

delete the cache files in the system/cache folder, then try

Qphoria wrote:delete the cache files in the system/cache folder, then try

Hi, I opened system/cache and I can only see an index.html file, do I delete this whole file? or shall I delete the whole folder etc?

Sorry im new

How do I change this? I went to ftp.oursite.com and it wont let me change it?

-Jason

do not delete the folder..just the files inside system/cache

Qphoria wrote:EDIT: catalog/model/catalog/product.php

FIND this function:

Code: Select all

public function getLatestProducts($limit) {

INSIDE THAT Function, FIND:

Code: Select all

ORDER BY p.date_added

REPLACE WITH:

Code: Select all

ORDER BY rand()

not work for me using OC 1.5.1.3 any idea?

and special products randon

OC 1.5.1.3 any idea?

nulosep wrote:and special products randon

OC 1.5.1.3 any idea?

Seems that
public function getLatestProducts($limit)
is not used any more.

I found catalog/controller/module/latest.php

when you open it, around row 22 you should find:

$data = array(
'sort' => 'p.date_added',
'order' => 'DESC',
'start' => 0,
'limit' => $setting['limit']
);

and you should change it to

$data = array(
'sort' => 'RAND()',
'order' => '',
'start' => 0,
'limit' => $setting['limit']
);

that work perfect for me.

Also, to avoid cashing of random products list, I made another change in catalog/model/catalog/product.php

around line 35 in function

public function getProducts($data = array())

there is a line

$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache);

I changed it with

if ($data['sort'] == 'RAND()') {
$product_data = array();
} else {
$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache);
}

so, if order is random it will create empty array instead of reading product data from cache.