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'