Programmatically Sort Product Collection in Magento

collection;product-collectionsorting

I have a product collection. How does one go about sorting this collection the Magento Way?

Best Answer

easymoden00b,Magento have a magic function addAttributeToSort() which is sort your product Collection on basic of product attribute

Format:

$ProductCollectionObject->addAttributeToSort('attribute_code', 'sort_order')

Example:

$collection = Mage::getResourceModel('catalog/product_collection');
$collection->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds());
$collection->addAttributeToSort('created_at', 'desc');

Here i have filter the product collection by created_at attribute

Related Solutions

Magento – Product collection Sort by Custom attribute with yes/no Option

Make sure the archive attribute is added to the flat product data by setting Used in Product Listing to yes. Also it's probably better to load the product collection via the catalog/category model instead of joining another table.

Also, to have yes come as last make the order ascending instead of descending

$category = Mage::getModel('catalog/category')->load(37);
$collection = $category->getProductCollection()
   ->addStoreFilter(Mage::app()->getStore()->getId())
   ->addAttributeToFilter('type_id', 'configurable')
   ->addAttributeToSort('archive', 'asc');

How to Sort Product Collection by Array Key in Magento

I have done something similar using the MySQL FIELD() function. Maybe it can also help you here.

After you have added the other filters to your collection, call this:

$collection->getSelect()->order(new Zend_Db_Expr('FIELD(sku, "' . implode('","', $skus) . '") DESC'));

Best Answer

Related Solutions

Magento – Product collection Sort by Custom attribute with yes/no Option

How to Sort Product Collection by Array Key in Magento

Related Topic