preventing category, and products display in new box

[keneso]

Hi,

is it possible to prevent a specific category, and its products from displaying in the "new products" box?
If yes how can it be done?

On a side note would it be advisable as per SEO?

Thank you

[Ajeh]

You could block them based on the master_categories_id by using your templates and overrides and customizing:
/includes/modules/new_products.php

to the file:
/includes/modules/your_templates_directory/new_products.php

And add to the 2 SELECT statements something like, for example to block categories_id 10, us:

and p.master_categories_id != 10

[keneso]

Thank you.

If you don't mind I would need a little (lot) more info, not being a coder.

I put the snip you suggested like this

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, pd.products_description,
                                p.products_date_added, p.products_price, p.products_type, p.master_categories_id and p.master_categories_id != 66

But it does display the product inserted in that category (id 66), both in the new products box, and in the new products listing page.

Will you kindly tell me how exactly I should add your code?

[Ajeh]

In the first SELECT, to block master_categories_id 10 try using:

  $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
and p.master_categories_id != 10
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and   p.products_status = 1 " . $display_limit;

Then do the same in the other SELECT statement in that file ...

[keneso]

Thank you again.

I copy-pasted the code you posted, but it still displays the new product.

A bit confused on the != 10 is that the category's id number, or it has to be 10?
I tried both, 10 as per your code, and 66 as the category id of the store.

[Ajeh]

If your Category is categories_id 66 and your Products use that as their master_categories_id then you want to use:

and p.master_categories_id != 66

[keneso]

Thank you for your patience.

I added
and p.master_categories_id != 66
to
modules/pages/products_new/header_php.php
as well, and it works fine.

[Ajeh]

Thanks for the update that this is now working for you ...

[keneso]

I need an update of the code please.

I added sub-cats to the category with id 66, and noticed they do display, then I added

and p.master_categories_id != 66
and p.master_categories_id != 67
and p.master_categories_id != 68

to /includes/modules/your_templates_directory/new_products.php
and it works fine.

Question:
is that correct way of doing, or there is a group syntax I'm unaware of, i.e.

and p.master_categories_id != '66 67 68'?

Actually I tried that, and other "creative" combinations, but of course knowing nothing they returned errors.

Thank you

[Ajeh]

You need to be using the master_categories_id of the Products that you do not want to display ...

So if they are in a Category with categories_id 66 then a subcategory where the categories_id is 68, the the master_categories_id is most likely 68 ...

If you are unsure of the master_categories_id ... edit the Product and you will see:
Product Master Category:

and that will list the master_categories_id