Random Products Display on Homepage

[fbzencart]

Hi

Can someone tell me how to stop the random display of products on the homepage . Ideally I will like it to display the new products added recently not just displaying randomly.

Thanks

[Ajeh]

All of the Centerboxes are based on random display ... which is based on the maximum number of products to look at and the maximum number of products to be displayed ...

You would have to recode them to not have them work in that manner ...

How are you wanting them to display?

[fbzencart]

All of the Centerboxes are based on random display ... which is based on the maximum number of products to look at and the maximum number of products to be displayed ...

You would have to recode them to not have them work in that manner ...

How are you wanting them to display?

I would like the homepage to just display the first five new products at all times

[fbzencart]

How do I recode them and what template?

[fbzencart]

How do I recode them and what template?

PLEASE HELP WITH THIS RECODE... I want just new product to display on the homepage at all time and not randomly.

[Ajeh]

Have you an URL to your site that we can peek at perhaps? It helps to better understand your current display vs what you are trying to accomplish ...

Note: there are settings to set the time period of New Products and settings to select of these New Products how many should be looked at and then settings to set from the New Products found how many should be displayed ...

[poosk]

I was wondering something similar.. I'd need somekind of random product module... I would just need to get four random products (any category,date so on) images and links ofcourse to the product...
I need it to my product display page instead of the customers also bought list.. can I somehow fetch the products from all listing?

[CJJUNE]

Hi Linda

I too want to disable random display? The disadvantage of random display is that it ALSO display my Gift Certificate.

How do I change this?

Thanks

[Ajeh]

If the problem with Random is based on New Products ... check your setting for what New Products are really defined as in the Configuration ... Maximum Values ...

New Product Listing - Limited to ...
Limit the New Product Listing to
0= All Products
1= Current Month
7= 7 Days
14= 14 Days
30= 30 Days
60= 60 Days
90= 90 Days
120= 120 Days

You could then edit the products that you do not want to ever show in there by changing the products_date_added field in the products table to older than your setting ... this can be done via phpMyAdmin ...

[Ajeh]

I would like the homepage to just display the first five new products at all times

You could customize the file:
/includes/modules/new_products.php

And change the select statements to add an order by products_date_added so the new ones are at the top ...

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
  $new_products_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_date_added
                           from " . TABLE_PRODUCTS . " p
                           where p.products_status = 1 " . $display_limit;
} else {
  $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_date_added,
                                           p.products_price
                           from " . TABLE_PRODUCTS . " p
                           left join " . TABLE_SPECIALS . " s
                           on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " .
  TABLE_CATEGORIES . " c
                           where p.products_id = p2c.products_id
                           and p2c.categories_id = c.categories_id
                           and c.parent_id = '" . (int)$new_products_category_id . "'
                           and p.products_status = 1 " . $display_limit;
}