Magento – How to set (in admin) products of a certain category to default sort by date added

admincategorymagento-1.7sorting

I am using Magento 1.7.0.2

I would like to have several the products for several of my categories to be automatically sorted by date added. Currently, in the 'Display Settings' tab for any one of my categories, I am not offered this option in the 'Default Product Listing Sort By" dropdown.

I know 1) how to add this option to the frontend user and I also know 2) how to overwrite a core file to set all categories to sort by entity ID (in descending order) which essentially the same as 'date added'.

However, I want to be able to configure this option for individual categories through the backend. Is there any way to have the 'date added' or 'entity id' added to the 'Default Product Listing Sort By" dropdown in the backend?

Best Answer

you cannot modify the attribute created_at in the backend.
So you need to create a module that just activates the created_at attribute for sorting.

For this you will need the following files:

app/etc/modules/[Namespace]_[Module].xml - the declaration file

<?xml version="1.0"?>
<config>
    <modules>
        <[Namespace]_[Module]>
            <codePool>local</codePool>
            <active>true</active>
            <depends>
                <Mage_Catalog />
            </depends>
        </[Namespace]_[Module]>
    </modules>
</config>

app/code/local/[Namespace]/[Module]/etc/config.xml - the configuration file

<?xml version="1.0"?>
<config>
    <modules>
        <[Namespace]_[Module]>
            <version>1.0.0</version>
        </[Namespace]_[Module]>
    </modules>
    <global>
        <resources>
            <[namespace]_[module]_setup>
                <setup>
                    <module>[Namespace]_[Module]</module>
                    <class>Mage_Catalog_Model_Resource_Setup</class> <!-- Make sure you use this class for setup -->
                </setup>
            </[namespace]_[module]_setup>
        </resources>
    </global>
</config>

app/code/local/[Namespace]/[Module]/sql/[namespace]_[module]_setup/install-1.0.0.php - the install script

<?php
$this->updateAttribute('catalog_product', 'created_at', 'frontend_label', 'Date Added'); //Set a label to the attribute because by default it does not have one
$this->updateAttribute('catalog_product', 'created_at', 'used_for_sort_by', '1'); //mark the attribute as used for sorting.

Clear the cache and refresh any page. Now you should have the Date Added (created_at) attribute available for sorting in any category.

Related Solutions

Magento Enterprise – Sort Products by Creation Date with SOLR

If you are referring to the product created_at and updated_at attributes, then simply commenting out the ->addVisibleFilter() in the Catalog Product Attribute Grid in the admin and simply set the Search and Sort fields to Yes, and re-index, you'll notice the date(s) are now in the catalogsearch_fulltext table which the Enterprise Solr will recognize and add the data to its doc records as well.

NOTE: Don't forgot to remove the core code change or do it via local code pool obviously if you like.

class Mage_Adminhtml_Block_Catalog_Product_Attribute_Grid extends Mage_Eav_Block_Adminhtml_Attribute_Grid_Abstract
{
    /**
     * Prepare product attributes grid collection object
     *
     * @return Mage_Adminhtml_Block_Catalog_Product_Attribute_Grid
     */
    protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel('catalog/product_attribute_collection');
            //->addVisibleFilter();
        $this->setCollection($collection);

        return parent::_prepareCollection();
    }

After this you'll want to let Solr know its a sortable metadata field.

Enterprise/Search/Model/Adapter/Abstract.php you'll notice:

/**
 * Store common Solr metadata fields
 * All fields, that come up from search engine will be filtered by these keys
 *
 * @var array
 */
protected $_usedFields = array('sku', 'visibility', 'in_stock');

You may want to also look over the method: _prepareIndexProductData in

Enterprise/Search/Model/Adapter/Abstract.php

/**
 * Prepare index data for using in search engine metadata.
 * Prepare fields for advanced search, navigation, sorting and fulltext fields for each search weight for
 * quick search and spell.
 *
 * @param array $productIndexData
 * @param int $productId
 * @param int $storeId
 *
 * @return  array|bool
 */
protected function _prepareIndexProductData($productIndexData, $productId, $storeId)

I've only tested the ability to edit the "non-visible" attributes and confirmed the addition to the fulltext table, I don't have Solr running locally at the moment to test it, but in theory should work without any need to mirror redundant data.

Hope this helps!

Magento – How to add custom options for categories product sorting in magento admin

You can just add 2 product attributes with the names you want and make them available for sorting.
If you need a custom logic behind it rewrite the method Mage_Catalog_Model_Resource_Product_Collection::addAttributeToSort and add your own case section to handle your attributes.

Here is an example on how it's done for created_at. You can do something similar for your attributes.

Best Answer

Related Solutions

Magento Enterprise – Sort Products by Creation Date with SOLR

Magento – How to add custom options for categories product sorting in magento admin

Related Topic