Magento Sort Collection By Product Attribute Value Count

Magento Sort Collection By Product Attribute Value Count

October 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento Sort Collection By Product Attribute Value Count

Sorting Magento Product Collections by Custom Attribute Values

In this post, we’ll guide you through sorting your Magento product collections based on custom attribute values, specifically for products associated with multiple categories. We’re going to focus on the “colour_name” attribute used for knitting yarn.

Understanding the Challenge

The primary goal is to sort products within a category view based on their assigned color attributes’ count. Products with only one color should appear first, followed by those with two colors, three colors, and so on. This approach ensures that customers see the most relevant items when filtering by a specific color.

Sorting in Magento: Basic Concepts

Before diving into the solution, let’s quickly recap how sorting works in Magento:

  1. Product Collection: The core of any product listing is the collection object ($this->getLoadedProductCollection() in your case).

  2. Add Attribute to Selection: To sort by a specific attribute, you need to add that attribute to the collection’s selection before applying the sorting order.

  3. Apply Order By SQL: Magento uses the setOrder method to apply a sorting condition via an SQL query.

Sorting Products Based on Color Count

Here’s how you can achieve this:

  1. Add Custom Attribute as a Selectable Column

First, ensure that your “colour_name” attribute is added to the product collection’s selection. You can do this by using the addAttributeToSelect method in your category view’s PHP file (usually found under app/design/frontend/default/[template_name]/template/catalog/category/view.phtml).

$category = $this->getCurrentCategory();
$_productCollection = $category->getProductCollection()->addAttributeToSelect('colour_name');
  1. Create a Helper Method for Counting Colors

Next, create a helper method to count the number of colors assigned to each product. You can place this in your category model or any utility class.

public function getColorCount($product)
{
    $colors = explode(',', $product->getData('colour_name'));
    return count(array_filter($colors));
}
  1. Apply the Sorting Condition

Now, apply the sorting condition based on the color count calculated in step 2.

$_productCollection->getSelect()->order(new Zend_Db_Expr("FIELD(colour_name, '" . implode("', '", $sortedColors) . "')"));
  1. Reformat the Collection

Since Magento’s FIELD function doesn’t support multiple values directly, you’ll need to create an array of sorted colors first.

$sortedColors = [];
foreach ($_productCollection as $product) {
    $colorCount = $this->getColorCount($product);
    if (!isset($sortedColors[$colorCount])) {
        $sortedColors[$colorCount] = [];
    }
    $sortedColors[$colorCount][] = $product->getData('colour_name');
}

ksort($sortedColors);
$sortedColors = array_map(function ($colors) { return implode("', '", $colors); }, $sortedColors);

Conclusion

Sorting Magento product collections based on custom attribute values involves a combination of selecting the relevant attributes and applying complex sorting conditions. By following this guide, you can create a sorted listing that improves the relevance of products for your customers.

Remember to thoroughly test any changes made to your category view PHP files by running Magento’s built-in tests or manually reviewing the output in your development environment.

For more advanced Magento customizations and tips on optimizing performance, visit our Magento Development Services page. We provide expert guidance to help you maximize the potential of your e-commerce platform.

Catalog Database Orders Customers

Our network