Search does not return results

Question

As i described in the title i don't get any results when i search for a product. I have tried so far:

1. Checking the visibility of the products
2. My products are in stock
3. I have also set the qty to 100 to be sure
4. I have updated the products attributes under catalog->manage products-> select all products.
5. I assigned all the products in the main website for my certain store view.
6. The name attribute can be used for search.

I have also tried to search with the sku but nothing happens again. The odd is that the advanced search with both name and skuworks.

And my problem remains.. Any ideas on how to make my products to appear when searched??

Answer 1

Open your file Mage_CatalogSearch_Model_Layer and in method

public function prepareProductCollection($collection)

before return $this;

Add following rows:

Mage::log($collection->getSelectSQL(1), false, 'search.log', true);
Mage::log((array)Mage::getConfig()->getNode()->global->models->catalogsearch, false, 'search.log', true)

(it's for debug purpose to understand your problem).

Then open your var/log/search.log and put result to your first post (there should be long sql query and array where we can see rewrites).

Answer 2

I've experienced this. My fix was to go to Manage Products and select all products and perform an "Update Attributes" from the dropdown above the grid. In the Update Attributes screen, move to the Websites tab and re-associate with the proper website by checking the checkbox under Add Products To Website.

After this, another Search Index rebuild may be required.

Answer 3

go to

admin->attributs->manage attribute-> search sku - open it -> Frontend Properties-> Use in Quick Search (YES )

, Use in Advanced Search (YES). thats it.

Answer 4

Did you create external modules that required using search? Look at the layout files for something like this

<mdg_giftregistry_search_index>
    <reference name="content">
        <block name="giftregistry.search" type="core/template" template="mdg/search.phtml" as="giftregistry_search"/>
    </reference>
</mdg_giftregistry_search_index>

Answer 5

Another possibility that worked for me is make data reindex!

To do this, go to the Admin Panel > System > Index Management, click "Select All", in field "Action" select "Reindex Data" and click "Submit".

=)

Peace!

Answer 6

Many question Possibleproducts attributes set error. you need

Check each .

Answer 7

You can debug collection object on class Mage_CatalogSearch_Model_Layer below funtion.

public function getProductCollection()
    {
        if (isset($this->_productCollections[$this->getCurrentCategory()->getId()])) {
            $collection = $this->_productCollections[$this->getCurrentCategory()->getId()];
        } else {
            $collection = Mage::getResourceModel('catalogsearch/fulltext_collection');
            $this->prepareProductCollection($collection);
            $this->_productCollections[$this->getCurrentCategory()->getId()] = $collection;
        }

echo $collection->getSelect();die('test');

        return $collection;
    }

Answer 8

I also faced same issue few days back, My issue was i've override the default magento functionality for one extension. So it was having conflictions with my search results. Check all your extensions once may be there any confliction.

Answer 9

I had the same problem & I tried all the suggestions above & none of them worked so I did some google searching of each of my issues & got nothing, then I Googled how to make my products searchable in my Magento store & I came across "Search Terms" which is located in Catalog but not the Catalog in System Configuration but the Catalog when you add a New or edit a product. In the search query you add the title you want to give that search & in the Redirect you put the whole URL address of the product or products you want to come up with that name. I sell sex toys so for example I typed in my search section of Magento Vibrator & none would come up even though I have heaps of different models, so I created a search query named Vibrator & copied the URL from the vibrator category & now when I search for vibrator all my vibrators come up

Answer 10

I have this problem too.

Going to Manage Products and select all products and perform an "Update Attributes" from the dropdown above the grid. In the Update Attributes screen, move to the Websites tab and re-associate with the proper website by checking the checkbox under Add Products To Website.

• this solution works for me but I have literally thousands of products and this would take days to do. Is there another way to do this or a database command I could use to do this? Thank you

Answer 11

If this data is important for you get a backup of this table.

I've experienced this problem several times and solved with this way; Try to truncate catalogsearch_query table.

TRUNCATE TABLE catalogsearch_query;

Answer 12

I assume you followed all comments above apart from that please follow the following too:

1. First Make sure you have max execution time either write in index.php ini_set('max_execution_time', 1800) or set it in php.ini max_execution_time= 1600
2. Increase memory limit ini_set('memory_limit','512M') or set it in php.ini memory_limit=16M