How to sort productcollection by category and sku?

How to sort productcollection by category and sku?

October 13, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to sort productcollection by category and sku?

Sorting Product Collections in Magento: Category First, SKU Second

Sorting product collections is a common requirement when building custom extensions for Magento. In this guide, we’ll walk you through how to sort products first by category and then within each category by SKU.

Understanding the Current Setup

You’re currently using the following code to retrieve a collection of products:

$this->productCollection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
    ->addFieldToFilter('entity_id', array('in' => $_arrayOfProductIds))
    ->addAttributeToSelect('sku')
    ->setOrder('sku', 'asc')->load();

This code creates a product collection, selects necessary attributes, filters by a list of entity IDs, and loads the SKU attribute. The products are then sorted in ascending order by the SKU.

Sorting By Category

The goal is to sort these products first by category and then within each category by SKU. To achieve this, we need to add a condition to filter by category and use it as the primary sorting criterion.

$this->productCollection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
    ->addFieldToFilter('entity_id', array('in' => $_arrayOfProductIds))
    ->addAttributeToSelect('sku')
    ->joinField(
        'category_id',
        'catalog/category_product',
        'category_id',
        'product_id=entity_id',
        null,
        'left'
    )
    ->setOrder('category_id', 'asc')
    ->setOrder('sku', 'asc')->load();

In this revised code, we’re using the joinField method to join the catalog/category_product table. This creates a relationship between our product collection and the categories it belongs to.

The setOrder('category_id', 'asc') line ensures that products are sorted in ascending order by category ID first. If multiple products share the same category, they will then be sorted in ascending order by SKU within that category.

Sorting Within a Specific Category

If you want to sort only products from a specific category (let’s say with ID 42), you can add an additional filter:

$this->productCollection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
    ->addFieldToFilter('entity_id', array('in' => $_arrayOfProductIds))
    ->addAttributeToSelect('sku')
    ->joinField(
        'category_id',
        'catalog/category_product',
        'category_id',
        'product_id=entity_id',
        null,
        'left'
    )
    ->addFieldToFilter('category_id', 42)
    ->setOrder('sku', 'asc')->load();

In this version, the addFieldToFilter method is used to filter products only for the category with ID 42. The sorting within this specific category remains by SKU in ascending order.

Best Practices and Further Reading

Remember that sorting a large collection of products can be resource-intensive. If performance becomes an issue, consider using Magento’s built-in pagination or limiting the number of products returned from the collection.

For more advanced sorting techniques, such as sorting by multiple attributes or weighting categories differently, I recommend reviewing Magento’s official documentation on collections and joins:

https://laravelcompany.com/docs/1.x/extending-builder/sorting-joining.html

This document provides a deeper dive into the capabilities of Magento’s collection API, which can help you tackle more complex sorting requirements.

Conclusion

Sorting product collections in Magento is a powerful way to organize and present your products to customers. By understanding how to use joins and filters effectively, you can create sophisticated sorting rules that enhance the user experience on your site.

Remember to test your sorting rules thoroughly to ensure they work as expected across different categories and product variations.

With these techniques, you should now be able to sort your products first by category and then within each category by SKU, providing a more intuitive navigation path for your customers.

Catalog Extensions Configuration Orders

Our network