Magento系统:脱销产品(stock_status=0)不显示在搜索结果里面!

来源:互联网 发布:linux赋予文件夹权限 编辑:程序博客网 时间:2024/06/05 23:01
修改: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=?',
原创粉丝点击