Excluding 1 Category from New Products

[libracorn]

Sorry... I'm not following that exactly. Didn't you say to run some kind of replace sql statement to modify the dates? It sounds like what you just wrote is something I could put in the actual source code for how the new products are pulled from the database. Is that what you meant here? If so, which file would I add this to?

[Ajeh]

In /includes/modules/new_products.php are 2 select statements:

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;
} 

You need to add another condition to not include the master_categories_id when it is 20 ...

In this case something like:

and p.master_categories_id != 20

to those two statements so that those products with the master_categories_id of 20 are blocked ...

Another way of doing it is to utilize another table, for the products_to_categories but the statement would be more complicated ...

[libracorn]

This should be working... but it's not. It's still displaying the products in that master category.

This is what I have changed it to which looks right... but category 4 products are still displaying in the new products list.

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 != 4" . $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 and p.master_categories_id != 4" . $display_limit;
} 

oh... I also verified in the actual database that the master category ID for the products I'm referring to is 4. I did double check that and in the database it's showing 4 but the products are still in the list.

[Ajeh]

Give more "power" to the master_categories_id constraint ...

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 . "
                           and p.master_categories_id != 4)";
} 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 . "
                           and p.master_categories_id != 4)";
} 

[libracorn]

Okay... it just occurred to me that maybe we're talking about two different things and that's why I'm not seeing this work how I'm envisioning.

I do not see any category 4 products display in the new section of the homepage of the store... so I'm starting to think the code you have here is for just that section - WHICH IS GREAT! PERFECT!

But... how can I also get category 4 products off the new_products listing? So when someone clicks on the "New Products" link in the actual menu and goes to this page

http://www.site.com/index.php?main_page=products_new

I'd like them not to display there either. Is that possible by adding the same kind exclusion parameter to the file that's used to pull the products new listing?

[libracorn]

Is this code also supposed to apply to the New Product Listing page? If not, which file do I modify and add that exclusion parameter to?

Thanks!

[Ajeh]

That was for the center box ...

For the New Listing ... you need to edit the header_php.php for the /includes/modules/pages/products_new

And for the sidebox you would also need to customize the code ...

You didn't think it was an all for one and one for all did you ...