Magento get all products in a certain category ordered by the 'Position' field

Magento get all products in a certain category ordered by the 'Position' field

August 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento get all products in a certain category ordered by the 'Position' field

Retrieving Products by Category ID in Magento

As a senior developer specializing in e-commerce platforms like Magento, I understand the common challenges faced when trying to fetch products based on specific criteria such as category or order position. In your case, you’re seeking to retrieve all products belonging to a certain category and sorted by their ‘Position’ field as defined in the Magento admin panel.

Understanding Your Current Approach

Your current approach involves loading the Magento application manually using the Mage::app() function and then attempting to filter the product collection based on the specified category ID. However, there are a few key issues with this method:

  1. The addCategoryFilter method is applied incorrectly, as it expects an instance of the Mage_Catalog_Model_Category model, not just an integer representing the category ID.

  2. The ‘Position’ attribute is not selected by default and needs to be explicitly added using the addAttributeToSort method.

  3. When sorting by multiple attributes, Magento uses a complex internal logic that may not always produce the expected results if not configured properly.

Retrieving Products by Category with Position Sorting

To correctly retrieve all products in a specific category ordered by their ‘Position’, you should follow these steps:

  1. First, ensure that your Magento application is loaded properly and the current store view is set accordingly:
require_once $_SERVER['DOCUMENT_ROOT'] . "/app/Mage.php";
umask(0);
Mage::run();
  1. Fetch the category model using the provided cat_id (replace 345 with your actual category ID):
$category = Mage::getModel('catalog/category')->load(345);
  1. Create a new product collection and apply the following filters:
  • Filter products by the specified category.
  • Select all required product attributes, including the ‘Position’ attribute.
  • Sort the collection first by the ‘Category Position’ field in ascending order (0 to 99) and then by the ‘Position’ field in ascending order.

Here’s the corrected code snippet:

$products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addCategoryFilter($category)
    ->addAttributeToSelect('*')
    ->addAttributeToSort('category_position', Varien_Data_Collection_Db::SORT_ORDER_DESC)
    ->addAttributeToSort('position', Varien_Data_Collection_Db::SORT_ORDER_ASC)
    ->load();
  1. Finally, loop through the product collection and retrieve the desired information:
foreach ($products as $product) {
    echo "Product Name: {$product->getName()}<br>";
    echo "Product Position: {$product->getPosition()}<br><hr>";
}

Best Practices

To ensure optimal performance when dealing with large product collections, consider the following best practices:

  1. Use pagination or limit the number of results returned by the collection to avoid memory exhaustion.

  2. Remove unnecessary attribute selection and focus only on the required attributes for your specific use case.

  3. If the category contains a vast number of products, consider querying the database directly using the Magento database interface (Varien_Db_Adapter_Pdo_Mysql) or optimizing your collection filters according to the Magento performance guidelines available at https://laravelcompany.com/magento-performance-optimization.

Conclusion

In this blog post, we explored how to retrieve products from a specific category in Magento and sort them by their ‘Position’ field. By understanding the correct usage of collection filters and attribute sorting methods, you can now easily fetch the desired products while optimizing performance.

Remember that Magento’s internal database operations are optimized for large-scale e-commerce platforms, so it is crucial to follow the best practices mentioned above to ensure a smooth and efficient user experience.

If you found this guide helpful or have any further questions about Magento development or optimization, feel free to explore our other resources on Laravel Company (https://laravelcompany.com), where we provide comprehensive tutorials, guides, and tips for building robust e-commerce solutions.

Happy coding!

Catalog Admin Configuration Orders

Our network