Magento Get List of SKUs in Category

Magento Get List of SKUs in Category

September 26, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento Get List of SKUs in Category

Retrieving Category SKUs in Magento: A Comprehensive Guide

As an experienced developer, I often receive queries about fetching category data along with associated product SKUs in Magento. While the core API provides methods to get category collections, obtaining the related SKUs requires a slightly more advanced approach.

Understanding the Magento Category Collection

Firstly, let’s clarify how to fetch a collection of categories using Magento’s built-in resource model:

$categories = Mage::getResourceModel('catalog/category_collection');

This returns an object containing all enabled categories in your store. However, this collection only represents category entities and lacks information about their child products.

Fetching Associated Products for Each Category

To access the SKUs of these products, you need to traverse each category and load its associated product collection. This can be achieved using a loop that iterates through the category tree:

$categories = Mage::getResourceModel('catalog/category_collection')->addAttributeToFilter(
    'is_active', 1 // Only active categories
)->load();

foreach ($categories as $category) {
    $productCollection = Mage::getResourceModel('catalog/product_collection')
        ->addCategoryFilter($category)
        ->addAttributeToSelect('sku'); // Select the SKU attribute

    foreach ($productCollection as $product) {
        echo "SKU: {$product->getSku()}\n";
    }
}

In this example, we first filter for active categories and load them. Then, for each category found, we create a new product collection and apply a category filter to include only the products assigned to that specific category.

We also use addAttributeToSelect('sku') to ensure that the SKU attribute is loaded with the product data, optimizing database queries.

Optimizing Performance for Large Datasets

While this approach works well for smaller stores, it can be resource-intensive for large datasets due to multiple database queries. To optimize performance:

  1. Use Magento’s EAV indexing: Ensure your catalog products are indexed properly by running indexer:reindex in the terminal. This pre-calculates category product assignments.

  2. Avoid loading unnecessary attributes: Only select required attributes (like ‘sku’) to minimize data transferred from the database.

  3. Consider using pagination or limits: If dealing with a massive number of products, implement pagination or limit the number of records returned in each iteration.

Conclusion: Retrieving Category SKUs Efficiently

In summary, fetching category SKUs in Magento involves:

  1. Loading active categories
  2. Iterating through these categories
  3. Creating product collections for each category
  4. Selecting only required attributes (like ‘sku’) to improve performance

Remember to run your indexing and optimize your database queries where possible.

For more advanced topics on Magento optimization, I recommend checking out our in-depth guide at Laravel Company’s Magento Optimization Series.

If you found this tutorial helpful, please share it with your development team and let me know if there are any other Magento concepts you’d like me to cover.

Catalog API

Our network