Orphaned Items. Hidden Items?

[William_firefold]

Sometimes we hide products from public to modify them, but we have so many products that they occasionally get lost in the mix.
There is a admin page in Able for locating orphaned items which have no category attached to them.
How could I modify this page (/Admin/Catalog/OrphanedItems.aspx) so that I have the option to find all hidden or ghosted items?

[mazhar]

You can execute following query get all ghosted products

Code: Select all

SELECT * FROM ac_Products WHERE VisibilityId = 1

or

Code: Select all

ProductCollection ghostedProducts = ProductDataSource.LoadForCriteria(" VisibilityId = 1 ")

A similar code for categories will be required to find out ghosted categories.