Magento系统:脱销产品(stock_status=0)不显示在搜索结果里面!
修改:app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext/Collection.php 第59行,在中间添加一个AND条件,代码如下:
AND search_result.product_id in(SELECT product_id FROM cataloginventory_stock_status WHERE stock_status!=0)
也就是把:
'search_result.product_id=e.entity_id AND search_result.query_id=?',
替换为:
'search_result.product_id=e.entity_id AND search_result.product_id in(SELECT product_id FROM cataloginventory_stock_status WHERE stock_status!=0) AND search_result.query_id=?',