Magento – How to Change Default Attribute ‘Position’ in Layered Navigation

attributesce-1.9.2.0default valuesposition;

I'm organizing my attributes to show in a specific order in layered navigation. To do this I need to set the 'position' value of them all. Magento defaults them to 0 so to put an attribute (say color) at the top of the list, I'll need to change the position of them all, which can get tedious.

What code can I use to reset all my attributes to 100 and to change the defaults?

Bonus: To exclude specific attributes from being reset such as Mage::getResourceModel('catalog/attributes')->excludeFilter(array('color', 'size')->walk('delete');

Note: Changing the default position of a product has already been discussed. I'm looking to change the position of the attribute itself.

ANSWER:
Thank you saravanavelu for your pointer.

Here is the code I was looking for:

UPDATE `catalog_eav_attribute` SET `position`= 100 WHERE `attribute_id` NOT IN (130, 140, 120)

where the numbers are attribute codes. Attribute codes are found in the URL of the Edit Attribute page.

Best Answer

Try this to change the position,

//72 is description's attribute id
UPDATE `catalog_eav_attribute` SET `position`= 100 WHERE `attribute_id` = 72

Related Solutions

Magento – Sort products by attribute position

I assume that the attribute values are usual values, not from a custom source model.
If that is the case, then the sorting is done in the method Mage_Eav_Model_Entity_Attribute_Source_Table::addValueSortToCollection.
Even if there is a custom source model you still need that method for sorting.
What I advice is to rewrite that method and change the way the sorting is done.
You can make that method look like this:

public function addValueSortToCollection($collection, $dir = Varien_Db_Select::SQL_ASC)
{
    $valueTable1    = $this->getAttribute()->getAttributeCode() . '_t1';
    $valueTable2    = $this->getAttribute()->getAttributeCode() . '_t2';
    $valueExpr = $collection->getSelect()->getAdapter()
        ->getCheckSql("{$valueTable2}.value_id > 0", "{$valueTable2}.value", "{$valueTable1}.value");
    $collection->getSelect()
        ->joinLeft(
            array($valueTable1 => $this->getAttribute()->getBackend()->getTable()),
            "e.entity_id={$valueTable1}.entity_id"
            . " AND {$valueTable1}.attribute_id='{$this->getAttribute()->getId()}'"
            . " AND {$valueTable1}.store_id=0",
            array())
        ->joinLeft(
            array($valueTable2 => $this->getAttribute()->getBackend()->getTable()),
            "e.entity_id={$valueTable2}.entity_id"
            . " AND {$valueTable2}.attribute_id='{$this->getAttribute()->getId()}'"
            . " AND {$valueTable2}.store_id='{$collection->getStoreId()}'",
            array($this->getAttribute()->getAttributeCode() => $valueExpr)
        );
    $collection->getSelect()
        ->order("{$this->getAttribute()->getAttributeCode()} {$dir}");

    return $this;
}

Magento – Change Default Value of ‘Position’ Category Attribute

You need to rewrite the method Mage_Catalog_Model_Resource_Product::_saveCategories
Somewhere in there this is this:

$data[] = array(
    'category_id' => (int)$categoryId,
    'product_id'  => (int)$object->getId(),
    'position'    => 1
);

Replace 1 with 100.
To rewrite the resource model add this to the config.xml of your custom module inside the global tag

<models>
    <catalog_resource>
        <rewrite>
            <product>[Namespace]_[Module]_Model_Resource_Product</product>
        </rewrite>
    </catalog_resource>
</models>

Then create the class [Namespace]_[Module]_Model_Resource_Product that extends Mage_Catalog_Model_Resource_Product, copy the method _saveCategories to it and replace 1 with 100.

Best Answer

Related Solutions

Magento – Sort products by attribute position

Magento – Change Default Value of ‘Position’ Category Attribute

Related Topic