Listing Products Unassigned To Any Category In Magento

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!

Be the first to Know

Subscribe to our blog to get the latest articles directly to your inbox.

Written By

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.