AbleCommerce Shopping Cart Software

Posted: **Thu Jul 02, 2009 5:35 am**

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?

Posted: **Thu Jul 02, 2009 8:33 am**

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.

AbleCommerce Shopping Cart Software

Orphaned Items. Hidden Items?

Orphaned Items. Hidden Items?

Re: Orphaned Items. Hidden Items?