I would like on the homepage, below newest products, a similar listing, but with random products from all over the shop, from all the categories. Anybody tried to insert somenthing like this? It would be great
To select a "random" product, you only need to generate a random number in the range of the minimum and maximum value of actual product_id values in your product table.
In the default installation the minimum is 1 and maximum is 4 so for the sake of example...
To get the data for the "random" product add the following to catalog\controller\home.php
This will give you one random product. Do this for as many times as the number of random products that you want, making sure you ignore any duplicates.
To get them on the home page, you will need to add the following to catalog\controller\home.php
and, modify content\home.tpl in each of the templates that you are using to process 'random_products' similarly to how it already processes 'products'
Hope this helps
In the default installation the minimum is 1 and maximum is 4 so for the sake of example...
Code: Select all
srand ((double) microtime( )*1000000);
$random_number = rand(1,4);
Code: Select all
$random_product_data = array();
// repeat as required
$random_products = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' and p.product_id = '" . (int)$random_product_number . "'");
foreach ($random_products as $random_product) {
$random_product_data[] = array(
'name' => $random_product['name'],
'href' => $url->href('product', FALSE, array('product_id' => $random_product['product_id'])),
'thumb' => $image->resize($random_product['filename'], $config->get('config_image_width'), $config->get('config_image_height')),
'price' => $currency->format($tax->calculate($random_product['price'], $random_product['tax_class_id']))
);
}
To get them on the home page, you will need to add the following to catalog\controller\home.php
Code: Select all
$view->set('random_products', $random_product_data);
Hope this helps
You should just be able to ORDER BY RAND() off of the query bruce provided.
select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' ORDER BY RAND() LIMIT 1
This may or may not work, you might also need to limit it to more than one. So you might want to change the LIMIT 1 to LIMIT 5 for 5 products.
select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' ORDER BY RAND() LIMIT 1
This may or may not work, you might also need to limit it to more than one. So you might want to change the LIMIT 1 to LIMIT 5 for 5 products.
In catalog/controller/home.php I changed:
to:
It seems to work well...please let me know if there are any drawbacks 
from doing it this way?..Thanks in advance..~april
Code: Select all
$results = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' order by p.date_added desc limit 6");
Code: Select all
$results = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' order by RAND() desc limit 6");
Hi April,
the query posted in this thread by paitken generates a correct result.
I tried it on a 2000 product catalog with limit 4 instead of limit 1 and got 4 random products in 0.064 seconds. My concerns about the performance of "order by rand()" are unfounded.
Use the paitken query.
cheers
Bruce
the query posted in this thread by paitken generates a correct result.
I tried it on a 2000 product catalog with limit 4 instead of limit 1 and got 4 random products in 0.064 seconds. My concerns about the performance of "order by rand()" are unfounded.
Use the paitken query.
cheers
Bruce
Who is online
Users browsing this forum: No registered users and 3 guests
