Don't show documents in search results

[MattC]

Hi there,

I would like to remove documents from the search results so that only products show in the results.

Has anyone attempted this?

I think I would have to make changes to:
includes/modules/pages/advanced_search_results/header_php.php

but I can't figure it out. Any help would me much appreciated.

Thanks,
Matt

[Ajeh]

We do not have any switches built in at this time to remove various Product Types from the search ...

You could customize the search select statements to exclude that product type ...

[MattC]

Thanks for the reply Linda.

Am I looking in the right file?
includes/modules/pages/advanced_search_results/header_php.php

Any other clues?

[Ajeh]

Yes for the search you need to customize the WHERE statement to exclude a product type ...

Be careful in how that is written it can be confusing at first ...

[MattC]

I've got it working. Thanks Linda.

I changed this code:

$where_str = " WHERE (p.products_status = 1
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               AND p2c.categories_id = c.categories_id ";

to:

$where_str = " WHERE (p.products_status = 1
               AND p.products_type != 3
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               AND p2c.categories_id = c.categories_id ";

This now excludes documents from the search results.
My store does not have product subcategories.
You might have to add extra code if yours does.