Magento Forum

   
How do I list products that are not in any category ? 
 
Loic_LC
Sr. Member
 
Avatar
Total Posts:  194
Joined:  2007-12-19
Paris, France
 

Hello !
is there a way in the backend, or a sql that I could run to point at the products that where not yet associated with any category ?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
jballotti
Guru
 
Avatar
Total Posts:  339
Joined:  2008-04-20
Chicago area
 
Loïc - 16 April 2009 06:28 AM

Hello !
is there a way in the backend, or a sql that I could run to point at the products that where not yet associated with any category ?

Thanks

Creating a category creates a page for the products to be listed on. There is a way to list products on CMS pages (including the home page). What page do you want your products listed on?

oh oh

 
Magento Community Magento Community
Magento Community
Magento Community
 
Loic_LC
Sr. Member
 
Avatar
Total Posts:  194
Joined:  2007-12-19
Paris, France
 

Hi,
thanks for the reply.

I created / imported many products. Some are set to display in a category, but others aren’t yet.
So I just want to sort them, and set them to display in the right category.

thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kara Heinrichs
Guru
 
Avatar
Total Posts:  482
Joined:  2008-01-17
aa, mi, us
 

honestly, I’d just export them all.  In the resulting spreadsheet anything with a blank/null in the category column is one of your unassigned products.  You can then import them back with the category filled in or will at least have a list to check off against for doing it in the Admin Panel.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Loic_LC
Sr. Member
 
Avatar
Total Posts:  194
Joined:  2007-12-19
Paris, France
 

Thanks for the hint smile
I did this, and helped.

Loic

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top