Thread: Question about Unpublished Catagory

I have unpublished a few subcategories until I get all the product available. I now cannot view the unpublished catagories in the left nav bar. I can, however see them when I go to map a new product. How do I get them back?

If you remember the name of your orphaned entities you can use the admin section search to find them. If you're unsure of the names you can use a simple SQL query to find your orphaned products:

Code:

SELECT CategoryID, [Name] FROM Category WHERE ParentCategoryID IN(
SELECT CategoryID FROM FROM CategoryID WHERE Published = 0)

Dusty
ASPDotNetStorefront Staff

*Please ensure that you have a full, functioning backup before making any code modifications or file changes to your AspDotNetStorefront website, or running any ad-hoc queries against your database. Improperly making code modifications or running queries against your database can cause your website to be non-functional and/or your data to be permanently lost. As part of your disaster recovery plan, you should make regular backups of all files and data, and perform periodic checks to ensure your backups function properly. If you are not sure if your data is adequately protected, contact an IT professional or your hosting provider for assistance.

This is pretty hopeless. If the point was to delete a category, I'd delete them. To "unpublish" means to withdraw the category from showing it to end users, not removing them entirely from view in the admin module. Please remedy this in a better way.

A quick workaround: If you insert a new "test" category at the same level as the ones you have unpublished, the unpublished ones will show briefly in the category tree when the category has been added. Delete the test category afterwards.

Beware: Deleting a category doesn't work either...