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.

READY TO DRIVE SALES?

Request a Quote Today

Request a Quote

Leave a Reply

2 Comments on "Listing Products Unassigned To Any Category In Magento"


Guest
Smithe655
1 year 10 months ago

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

admin
Admin
1 year 10 months ago

Hi Smithe,

Thanks.
Keep reading our blogs.