Forums / Setting Up Categories, Products, Attributes / product hidden in search results

product hidden in search results

Locked

Started by hamelin85 on 28 Jun 2006, 3:12 PM · Views: 1,907

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
28 Jun 2006, 3:12 PM
#1
hamelin85 avatar

hamelin85

New Zenner

Join Date:
Apr 2006
Posts:
11
Plugin Contributions:
0

product hidden in search results

hello and thanks for your support.
how can I make a product invisible to the search?
i thought i have to modify sequel database.

regards

29 Jun 2006, 5:28 AM
#2
bunyip avatar

bunyip

Totally Zenned

Join Date:
Sep 2004
Location:
Western Massachusetts
Posts:
2,361
Plugin Contributions:
1

Re: product hidden in search results

in includes/modules/pages/advanced_search_results/header_php.php,
find this code```php
$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 ";

and add an extra condition
```php
AND p.products_id <> xxx

where xxx is the product id of that which you don't want displayed in the results.

Neville
An assumption is what you arrive at when you get tired of thinking...

29 Jun 2006, 5:44 PM
#3
hamelin85 avatar

hamelin85

New Zenner

Join Date:
Apr 2006
Posts:
11
Plugin Contributions:
0

Re: product hidden in search results

thanks. but it doesn't work. i can see the item in the results. id number is correct.
maybe we have to specify other things?

29 Jun 2006, 5:58 PM
#4
hamelin85 avatar

hamelin85

New Zenner

Join Date:
Apr 2006
Posts:
11
Plugin Contributions:
0

Re: product hidden in search results

now it works. i miss to move a ". thank you very much.

i don't know well php code. how could I add more invisible product?

i mean: AND p.products_id <> xxx and xxx and xxx

thanks for your answers!