Sometimes merchants may have missed selecting categories for the products when creating new products or while importing them. If they want to list them at a later point in time and assign categories to those products, there is no default report in admin.

It will be great if there is such a report for merchants who manage products in Magento admin. We can use the below collection query in a custom module to generate a product report in admin for merchants.

The below product collection resolves the issue and provides us the list of configurable products

  • whose child SKUs are in stock and
  • assigned to none of the categories and
  • that are not assigned to any of the active categories

The below collection result will provide us the following attributes

  • Product ID
  • SKU
  • Name of configurable product

We can add more columns in the $columns array and update the collection JOIN to filter the columns.

Columns can be added / removed and the developer can use this query to generate a report based on the business needs of the merchant.

How to get the products not assigned to any category and not associated with any active category?

Happy Coding!


  • Lavanya

    Lavanya is a Magento Developer Plus certified developer and an Associate Architect with DCKAP. A silent and a soft- spoken person, she prefers her work to do the talking. She is technology agnostic who can learn and work in any technology. She loves reading novels and listening to music.


Ready to drive online revenue

Get In Touch

2 thoughts on “Listing Products Unassigned To Any Category In Magento

  1. Nice post. I was checking constantly this blog and I am impressed! Extremely useful information specially the last part fbdfffcbdcdacegc

Leave a Reply

Your email address will not be published. Required fields are marked *