How to limit Random display on main page to 1 category?

[dreamdaily]

Hello,

The main page by default displays in a tabular format random selection from all categories in the store.
This is perfect for my store, however, I would like to limit the random display to products from only one category.

How can I do that?

or

as an alternative solution: how do I prevent Gift Certificates from showing up in the random selection on the main page?


Thank you,
dreamdaily

[bunyip]

To make the change to the new products set on the main page, edit includes/modules/new_products.php and when done, save it as includes/modules/your_template/new_products.php.

Find this section of code:

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 { 

and add a restriction to the category.
To limit the selections to a single category, modify that code to this:

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 
                           and p.master_categories_id = xx " . $display_limit;
} else { 

where xx is the category id number of the category you want to select from.
To simply remove the gift certificates from the selection, change the code to this:

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 
                           and p.master_categories_id <> yy " . $display_limit;
} else { 

where yy is the category id number of your gift certificates category.

Similar changes can be made for featured products and specials by editing the module files featured_products.php and specials_index.php in the same way and saving them as overide copies.

[dreamdaily]

Thank you, Super Bunny!

[Flower]

BonyIp,

the same question but for Zen Cart 1.38a.

The text in the program is slightly different.

Thanks