# 如何让Zen Cart分类产品排序显示最新

**URL:** <https://www.isharkfly.com/t/zen-cart/5508>\
**Category:** PHP\
**Created:** [August 6, 2012, 1:36am UTC](https://www.isharkfly.com/t/zen-cart/5508 "2012-08-06T01:36:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![honeymoose](https://www.isharkfly.com/user_avatar/www.isharkfly.com/honeymoose/32/20796_2.png) [@honeymoose](https://www.isharkfly.com/u/honeymoose)\
**Post date:** [August 6, 2012, 1:36am UTC](https://www.isharkfly.com/t/zen-cart/5508/1 "2012-08-06T01:36:09Z")

</div>

这个问题调试了好久了，历时也快半年了，之前网上资料一直有限，今天终于找到了解析办法了。

问题解决：  
1： \includes\index\_filters\default\_filter.php  
将case 5的：order by p.products\_date\_added DESC改成：order by p.products\_ordered DESC  
将default的：order by p.products\_ordered DESC改成：order by p.products\_date\_added DESC

2：\includes\modules\product\_listing.php  
Bestselling 跟New Arrival 互换位置

3：\includes\index\_filters\default\_filter.php  
这里比较重要了，决定了是否成功：`// We show them all$listing_sql = “select ” . $select_column_list . ” p.products_id, p.products_type,p.products_status,p.products_price,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products_quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_statusfrom ” . TABLE_PRODUCTS_DESCRIPTION . ” pd, ” .TABLE_PRODUCTS . ” p left join ” . TABLE_MANUFACTURERS . ” m on p.manufacturers_id = m.manufacturers_id, ” .TABLE_PRODUCTS_TO_CATEGORIES . ” p2c left join ” . TABLE_SPECIALS . ” s on p2c.products_id = s.products_idwhere p.products_status = 1and p.products_id = p2c.products_idand pd.products_id = p2c.products_idand pd.language_id = ‘” . (int)$_SESSION['languages_id'].”‘”. $displayOrder. $priceOrder.”and ” . $product_in_categories_sql; `在这段代码的最后一句的；前加入：`. ” order by p.products_date_added DESC” `也就是最后一句改成：`and ” . $product_in_categories_sql. ” order by p.products_date_added DESC”; `