blocks|key|4316031|text|我不确定有没有一种简单的方法来做到这一点，而不是深入研究核心代码。然而，我还没有尝试过，但看起来它应该可以工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4316032|创建一个新的日期属性。您将看到在属性选项的底部有一个名为“用于在产品列表中排序”的选项。为此选择Yes。然后将其添加到您的属性组中。然后，当您添加产品时，只需选择当前日期，您就可以使用该日期进行排序。要设置默认值，请进入System+>>+Configuration+>>+Catalog+>>前端，您将在"Product+listing+sort+by“选项中看到您的属性。|4316033|希望这对你有好处。|4316034|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I'm not sure that there is an easy way to do that, without digging into the core code. However, I haven't tried this but it seems like it should work:

Create a new Date attribute. You'll see that there is an option at the bottom of the attribute options called "Used for sorting in product listing". Select Yes for that. Then and add it to your attribute group. Then when you add a product, just select the current date, and you should be able to use that for sorting. To set the default of that, go into System >> Configuration >> Catalog >> Frontend and you'll see your attribute in the "Product listing sort by" option.

Hope that works out for you.

blocks|key|5733416|text|像这样|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5733417|$_newest_productCollection+=+Mage::getResourceModel('reports/product_collection')
->addAttributeToSelect('*')
->addAttributeToFilter('visibility',+$visibility)
->setOrder('created_at',+'desc')
$_newest_productCollection->load();|code-block|syntax|javascript|5733418|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Like this 

<pre><code>$_newest_productCollection = Mage::getResourceModel('reports/product_collection')
-&gt;addAttributeToSelect('*')
-&gt;addAttributeToFilter('visibility', $visibility)
-&gt;setOrder('created_at', 'desc')
$_newest_productCollection-&gt;load();
</code></pre>

blocks|key|4316059|text|如果你同意(不应该)修改核心文件，那么添加一个按日期排序的选项是非常容易的。只需修改app/code/core/Mage/Catalog/Model/Config.php文件，如下例所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4316060|public+function+getAttributeUsedForSortByArray()
{
++++$options+=+array(
++++++++'position'++=>+Mage::helper('catalog')->__('Position'),

++++++++//+HERE+IS+OUR+NEW+OPTION
++++++++'created_at'+=>+Mage::helper('catalog')->__('Date')
++++);
++++foreach+($this->getAttributesUsedForSortBy()+as+$attribute)+{
++++++++/*+@var+$attribute+Mage_Eav_Model_Entity_Attribute_Abstract+*/
++++++++$options[$attribute->getAttributeCode()]+=+$attribute->getStoreLabel();
++++}

++++return+$options;
}|code-block|syntax|javascript|4316061|4316062|如果你不喜欢修改核心文件，那就没那么容易了。在这种情况下，您必须创建以下文件：|4316063|app/etc/modules/Stackoverflow_Catalog.xml|4316064|<?xml+version="1.0"?>
<config>
++++<modules>
++++++++<Stackoverflow_Catalog>
++++++++++++<active>true</active>
++++++++++++<codePool>local</codePool>
++++++++++++<depends>
++++++++++++++++<Mage_Catalog+/>
++++++++++++</depends>
++++++++</Stackoverflow_Catalog>
++++</modules>
</config>|4316065|app/code/local/Stackoverflow/Catalog/etc/config.xml|4316066|<?xml+version="1.0"?>
<config>
++++<global>
++++++++<models>
++++++++++++<catalog>
++++++++++++++++<rewrite>
++++++++++++++++++++<config>Stackoverflow_Catalog_Model_Config</config>
++++++++++++++++</rewrite>
++++++++++++</catalog>
++++++++</models>
++++</global>
</config>|4316067|app/code/local/Stackoverflow/Catalog/Model/Config.php|4316068|<?php

class+Stackoverflow_Catalog_Model_Config+extends+Mage_Catalog_Model_Config+{
++++public+function+getAttributeUsedForSortByArray()+{
++++++++$options+=+parent::getAttributeUsedForSortByArray();
++++++++if+(!isset($options['created_at']))+{
++++++++++++$options['created_at']+=+Mage::helper('catalog')->__('Date');
++++++++}
++++++++return+$options;
++++}
}|4316069|小贴士:走一条干净的路，从长远来看它会有回报的。|4316070|entityMap^0|16|17|0|0|0|0|0|15|0|0|0|1F|0|0|0|1H|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|16|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|17|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|18|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|H|7|1C|8|@]|D|@]|E|$I|J]]|$1|R|3|S|5|6|7|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|T|3|U|5|H|7|1G|8|@]|D|@]|E|$I|J]]|$1|V|3|W|5|6|7|1H|8|@$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|X|3|Y|5|H|7|1K|8|@]|D|@]|E|$I|J]]|$1|Z|3|10|5|6|7|1L|8|@]|D|@]|E|$]]|$1|11|3|-4|5|6|7|1M|8|@]|D|@]|E|$]]]|12|$]]

It is quite easy to add a sorting by date option if you're OK (you shouldn't be) with modifying core files. Simply modify app/code/core/Mage/Catalog/Model/Config.php file as in example below:

<pre><code>public function getAttributeUsedForSortByArray()
{
 $options = array(
 'position' =&gt; Mage::helper('catalog')-&gt;__('Position'),

 // HERE IS OUR NEW OPTION
 'created_at' =&gt; Mage::helper('catalog')-&gt;__('Date')
 );
 foreach ($this-&gt;getAttributesUsedForSortBy() as $attribute) {
 /* @var $attribute Mage_Eav_Model_Entity_Attribute_Abstract */
 $options[$attribute-&gt;getAttributeCode()] = $attribute-&gt;getStoreLabel();
 }

 return $options;
}
</code></pre>

<hr>

It is not so easy, if you are not into modifying core files. In that case you must create this bunch of files:

app/etc/modules/Stackoverflow_Catalog.xml

<pre><code>&lt;?xml version="1.0"?&gt;
&lt;config&gt;
 &lt;modules&gt;
 &lt;Stackoverflow_Catalog&gt;
 &lt;active&gt;true&lt;/active&gt;
 &lt;codePool&gt;local&lt;/codePool&gt;
 &lt;depends&gt;
 &lt;Mage_Catalog /&gt;
 &lt;/depends&gt;
 &lt;/Stackoverflow_Catalog&gt;
 &lt;/modules&gt;
&lt;/config&gt;
</code></pre>

app/code/local/Stackoverflow/Catalog/etc/config.xml

<pre><code>&lt;?xml version="1.0"?&gt;
&lt;config&gt;
 &lt;global&gt;
 &lt;models&gt;
 &lt;catalog&gt;
 &lt;rewrite&gt;
 &lt;config&gt;Stackoverflow_Catalog_Model_Config&lt;/config&gt;
 &lt;/rewrite&gt;
 &lt;/catalog&gt;
 &lt;/models&gt;
 &lt;/global&gt;
&lt;/config&gt;
</code></pre>

app/code/local/Stackoverflow/Catalog/Model/Config.php

<pre><code>&lt;?php

class Stackoverflow_Catalog_Model_Config extends Mage_Catalog_Model_Config {
 public function getAttributeUsedForSortByArray() {
 $options = parent::getAttributeUsedForSortByArray();
 if (!isset($options['created_at'])) {
 $options['created_at'] = Mage::helper('catalog')-&gt;__('Date');
 }
 return $options;
 }
}
</code></pre>

TIP: Go for a clean way, it will pay of in a long run.

blocks|key|4316092|text|你可以在下面试试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4316093|app/code/core/mage/catalog/model/resource/eav/mysql4/product/collection.php|code-block|syntax|javascript|4316094|在"public+function+addAttributeToSort($attribute,+$dir='asc')“中|offset|length|style|CODE|4316095|之后|4316096|$this->getSelect()->order("cat_index_position+{$dir}");|4316097|添加这个|4316098|$this->getSelect()->order("e.entity_id+desc");|4316099|entityMap^0|0|0|2|1M|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

You can try below

<pre><code>app/code/core/mage/catalog/model/resource/eav/mysql4/product/collection.php
</code></pre>

in "<code>public function addAttributeToSort($attribute, $dir='asc')</code>"

after 

<pre><code>$this-&gt;getSelect()-&gt;order("cat_index_position {$dir}");
</code></pre>

add this

<pre><code>$this-&gt;getSelect()-&gt;order("e.entity_id desc");
</code></pre>

blocks|key|5733514|text|我通过将app/code/core/Mage/Catalog/Block/Product/List.php复制到app/+code+/local并在其_getProductCollection()方法的末尾添加一些排序代码来解决这个问题：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5733515|//+sort+by+created_at+date+or+entity_id
if(!isset($_GET['order']))+{
++++$this->_productCollection->getSelect()->reset(+Zend_Db_Select::ORDER+);
++++$this->_productCollection->getSelect()->order('e.entity_id+desc');
}
return+$this->_productCollection;|code-block|syntax|javascript|5733516|您可以使用'e.entity_id+desc'或'e.created_at+desc'进行排序。|5733517|entityMap^0|23|N|0|0|5|I|O|J|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

I solved this by copying app/code/core/Mage/Catalog/Block/Product/List.php into app/code/local and adding some sorting code at the end of its <code>_getProductCollection()</code> method:

<pre><code>// sort by created_at date or entity_id
if(!isset($_GET['order'])) {
 $this-&gt;_productCollection-&gt;getSelect()-&gt;reset( Zend_Db_Select::ORDER );
 $this-&gt;_productCollection-&gt;getSelect()-&gt;order('e.entity_id desc');
}
return $this-&gt;_productCollection;
</code></pre>

You can use either <code>'e.entity_id desc'</code> or <code>'e.created_at desc'</code> to sort.

blocks|key|4316165|text|将此代码放入您的local.xml中，无需覆盖任何Magento核心文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4316166|如果在将来覆盖任何Magento核心文件，将会出现升级问题|4316167|<layout>
<catalog_category_default>
++++<reference+name="product_list">
++++++++<action+method="setAvailableOrders"+json="value">
++++++++++++<value><![CDATA[
+++++++++++++++++++++++++++{"created_at"+:+"Latest","price":"Price"}
+++++++++++++++++++]]>
++++++++++++</value>
++++++++</action>
++++</reference>
++++<reference+name="product_list_toolbar">
++++++++<action+method="setDefaultDirection">
++++++++++++<dir>desc</dir>
++++++++</action>
++++</reference>
</catalog_category_default>
</layout>|code-block|syntax|javascript|4316168|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Place this code into your local.xml no need to override any Magento core files.

If you override any Magento core files in future upgrade problem will occur



<pre><code>&lt;layout&gt;
&lt;catalog_category_default&gt;
 &lt;reference name="product_list"&gt;
 &lt;action method="setAvailableOrders" json="value"&gt;
 &lt;value&gt;&lt;![CDATA[
 {"created_at" : "Latest","price":"Price"}
 ]]&gt;
 &lt;/value&gt;
 &lt;/action&gt;
 &lt;/reference&gt;
 &lt;reference name="product_list_toolbar"&gt;
 &lt;action method="setDefaultDirection"&gt;
 &lt;dir&gt;desc&lt;/dir&gt;
 &lt;/action&gt;
 &lt;/reference&gt;
&lt;/catalog_category_default&gt;
&lt;/layout&gt;
</code></pre>

blocks|key|2204185|text|Yust+for+update+(适用于Mage+1.7.0.2)：在自己模块的setupscript中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2204186|$installer+=+$this;
$installer->startSetup();

$productEntityTypeId+=+Mage::getModel('catalog/product')->getResource()->getEntityType()->getId();

//lets+change+created_at+properties
//////////////////////////////////////////////////
$installer->updateAttribute($productEntityTypeId,+'created_at',+array(
++++'visible_on_front'+=>+true,
++++'used_in_product_listing'+=>+true
++++'used_for_sort_by'+=>+1,
++++'frontend_label'+=>+'Created+at'
));

$installer->endSetup();

//+mark+index+as+"reindex+required"
$indexerCodes+=+array(
++++'catalog_product_flat'
);
$indexer+=+Mage::getModel('index/process');
foreach+($indexerCodes+as+$code)+{
++++$indexer->load($code,+'indexer_code')
++++++++->changeStatus(Mage_Index_Model_Process::STATUS_REQUIRE_REINDEX);
}|code-block|syntax|javascript|2204187|在catalog.xml布局句柄中：|2204188|<block+type="catalog/product_list_toolbar"+name="product_list_toolbar"+template="catalog/product/list/toolbar.phtml">
...
<action+method="setDefaultDirection"><dir>desc</dir></action>
</block>|2204189|之后，您可以在系统配置或分类显示设置中选择created_at作为默认分类|2204190|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Yust for update (works with Mage 1.7.0.2):
in an setupscript of an own module:

<pre><code>$installer = $this;
$installer-&gt;startSetup();

$productEntityTypeId = Mage::getModel('catalog/product')-&gt;getResource()-&gt;getEntityType()-&gt;getId();

//lets change created_at properties
//////////////////////////////////////////////////
$installer-&gt;updateAttribute($productEntityTypeId, 'created_at', array(
 'visible_on_front' =&gt; true,
 'used_in_product_listing' =&gt; true
 'used_for_sort_by' =&gt; 1,
 'frontend_label' =&gt; 'Created at'
));

$installer-&gt;endSetup();

// mark index as "reindex required"
$indexerCodes = array(
 'catalog_product_flat'
);
$indexer = Mage::getModel('index/process');
foreach ($indexerCodes as $code) {
 $indexer-&gt;load($code, 'indexer_code')
 -&gt;changeStatus(Mage_Index_Model_Process::STATUS_REQUIRE_REINDEX);
}
</code></pre>

and in the catalog.xml layout handle:

<pre><code>&lt;block type="catalog/product_list_toolbar" name="product_list_toolbar" template="catalog/product/list/toolbar.phtml"&gt;
...
&lt;action method="setDefaultDirection"&gt;&lt;dir&gt;desc&lt;/dir&gt;&lt;/action&gt;
&lt;/block&gt;
</code></pre>

After this you can select created_at as default sorting in the system configuration or in the catagory display 
settings

blocks|key|1721916|text|我通过重写这个类来做到这一点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1721917|Mage_Catalog_Model_Category_Attribute_Source_Sortby|code-block|syntax|javascript|1721918|and函数：|1721919|public+function+getAllOptions()
{
++++if+(is_null($this->_options))+{
++++++++$this->_options+=+array(array(
++++++++++++'label'+=>+Mage::helper('catalog')->__('Best+Value'),
++++++++++++'value'+=>+'position'
++++++++));
++++++++$this->_options+=+array(array(
++++++++++++'label'+=>+Mage::helper('catalog')->__('Created+At'),
++++++++++++'value'+=>+'created_at'
++++++++));
++++++++foreach+($this->_getCatalogConfig()->getAttributesUsedForSortBy()+as+$attribute)+{
++++++++++++$this->_options[]+=+array(
++++++++++++++++'label'+=>+Mage::helper('catalog')->__($attribute['frontend_label']),
++++++++++++++++'value'+=>+$attribute['attribute_code']
++++++++++++);
++++++++}
++++}
++++return+$this->_options;
}|1721920|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I've done it by rewriting the class:

<pre><code>Mage_Catalog_Model_Category_Attribute_Source_Sortby
</code></pre>

and function:

<pre><code>public function getAllOptions()
{
 if (is_null($this-&gt;_options)) {
 $this-&gt;_options = array(array(
 'label' =&gt; Mage::helper('catalog')-&gt;__('Best Value'),
 'value' =&gt; 'position'
 ));
 $this-&gt;_options = array(array(
 'label' =&gt; Mage::helper('catalog')-&gt;__('Created At'),
 'value' =&gt; 'created_at'
 ));
 foreach ($this-&gt;_getCatalogConfig()-&gt;getAttributesUsedForSortBy() as $attribute) {
 $this-&gt;_options[] = array(
 'label' =&gt; Mage::helper('catalog')-&gt;__($attribute['frontend_label']),
 'value' =&gt; $attribute['attribute_code']
 );
 }
 }
 return $this-&gt;_options;
}
</code></pre>

How can I make Magento sort products in the catalog by the date they were added? This isn't an option in the admin so guessing it needs to be done in the code somewhere.

Thanks.

Magento - Sort by Date Added

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如何让Magento按添加日期对目录中的产品进行排序？这在管理员中不是一个选项，所以猜测它需要在代码中的某个地方完成。谢谢。

问Magento -已添加按日期排序
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Magento -已添加按日期排序EN