Magento 2: How to Display Categories in Alphabetical order Programmatically in Frontend

Hello Magento Techs ?,

Greetings of the day! Welcome to the MageComp Technical blog series. Today I am here with the most commendable topic, Magento 2: How to Display Categories in Alphabetical order Programatically in Frontend. Catch over our earlier released blog, How to Set Cart Page Items Custom Notice Message in Magento 2.

Contents

1 Introduction
2 Steps to Display Categories in Alphabetical order Programatically in Frontend
3 Conclusion

Introduction

Products are added to different categories according to their type. Large Magento stores have lots of product categories. Supposing the categories are disorganized. The customer will find it difficult to locate the right product. As a result, the user will leave the site which decreases the business epitome. If these categories are displayed in alphabetical order, it becomes easy for the customers to explore the products. Quick search, quick shopping, and quick returns.

In Magento, sorting product categories from backend is possible with drag and drop. But if you are running with more than 200 categories, drag and drop can be a deadening job. Thus, the store with lots of categories needs to sort in frontend. The following code can help out with How to Display Categories in Alphabetical order Programatically in Frontend. Let’s get started ?

Steps to Display Categories in Alphabetical order Programatically in Frontend

Step 1: Create one file called di.xml in the following path

app\code\VENDOR\EXTENSION\etc\di.xml

And add this code

<preference for="Magento\Catalog\Model\ResourceModel\Category" 
type="VENDOR\EXTENSION\Model\Category"/>

1 2	<preference for="Magento\Catalog\Model\ResourceModel\Category" type="VENDOR\EXTENSION\Model\Category"/>

Step 2: Create another file Category.php in the following path

app\code\VENDOR\EXTENSION\Model\Category.php

And simply add this code

<?php

declare(strict_types=1);
namespace VENDOR\EXTENSION\Model;

class Category extends \Magento\Catalog\Model\ResourceModel\Category
{
   public function getChildrenCategories($category)
   {
       $collection = $category->getCollection();
       /* @var $collection \Magento\Catalog\Model\ResourceModel\Category\Collection */
       $collection->addAttributeToSelect('url_key')
                  ->addAttributeToSelect('name')
                  ->addAttributeToSelect('all_children')
                  ->addAttributeToSelect('is_anchor')
                  ->addAttributeToFilter('is_active',1)
                  ->addIdFilter($category->getChildren())
                  ->setOrder('name',\Magento\Framework\DB\Select::SQL_ASC)
                  ->joinUrlRewrite();
       return $collection;
   }
}
?>

<?php

declare(strict_types=1);

namespace VENDOR\EXTENSION\Model;

class Category extends \Magento\Catalog\Model\ResourceModel\Category

{

public function getChildrenCategories($category)

{

$collection = $category->getCollection();

/* @var $collection \Magento\Catalog\Model\ResourceModel\Category\Collection */

$collection->addAttributeToSelect('url_key')

->addAttributeToSelect('name')

->addAttributeToSelect('all_children')

->addAttributeToSelect('is_anchor')

->addAttributeToFilter('is_active',1)

->addIdFilter($category->getChildren())

->setOrder('name',\Magento\Framework\DB\Select::SQL_ASC)

->joinUrlRewrite();

return $collection;

}

That’s the way.

Conclusion

I hope, now you are well aware of How to Display Categories in Alphabetical order Programatically in Frontend for your Magento 2 store. Any issues feel free to let me know in the comment section below. I would like to solve it for you. Also, share the article with your friends to help them with the same. Stay in the know!

Happy Coding ?

Click to rate this post!

[Total: 8 Average: 4.5]

6 Comments

Richard on March 25, 2023

This is not working at all. main categories and Subcategories are not showing alphabetically.

- MageComp on March 31, 2023
  
  Confirm that you are implementing the solution properly and there is no conflict with other extensions or theme files.
  
Paul on July 25, 2021

Hi
Tried everything step by step and still subcategories are sorted only by ID as it was before

- MageComp on March 31, 2023
  
  Confirm that the extension where you implemented is enabled and it calls our code.
  
Jim Atwood on October 18, 2020

Thanks for the info but actually didn’t work. Followed the exact instructions and the categories are still not in alphabetical order. Perhaps a step is missing here. Thanks anways.

- MageComp on March 31, 2023
  
  The blog is written earlier when the older Magento version has the options.
  Now you can try to replace the line :
  ->setOrder(‘name’,\Magento\Framework\DB\Select::SQL_ASC)
  with
  ->setOrder(‘name’,’ASC’)