Re-enable archived catalog item

[TeriStevenson]

I have an archived catalog item in WD_WebPackages from 2018 that I need to bring back into being visible.  I can update the PackageVisible to 1 and INSERT INTO WD_Package_Category with the category id I need but the catalog item isn't showing in App Portal under the category.  My sql query f, below finds it so I must be missing something obvious... 

SELECT wp.PackageID, WD_Category.CatName, wp.PackageTitle,wp.FUID, wp.PackageVisible,
wp.CatalogCost, wp.CreatedOn, wp.BriefDescription, wp.Type, pc.CategoryID
FROM WD_Package_Category pc INNER JOIN
WD_WebPackages wp ON pc.PackageID = wp.PackageID INNER JOIN
WD_Category ON pc.CategoryID = WD_Category.CatID

where wp.PackageVisible = '1'
and wd_category.catname = 'Server licenses'

[jdempsey · Accepted solution]

You need to set PackageVisible=1 and Deleted=0.  Deleted=1 means the item has been archived.  PackageVisible=1 means the item has been enabled for request.  You'll likely find that aside from Category, there are probably some other properties that will need to be re-established (workflows?), but it is easier to do all of that in the UI after you've unarchived the item (Deleted=0).

[TeriStevenson]

I remembered the deleted right after I posted this... it's always something obvious 🙂