So I am losing products on my site after overhauling our Departments and Categories. I couldn’t figure out why our ‘Earbuds’ department has 2 items in it (which the BETA navigation detects), but when I view the ‘Earbuds’ category page, there are no items listed.
So I checked our SQL database, and noticed that the new ‘DepartmentID’ took hold, but PAM did not update the ‘CategoryID’ to ‘0’ when the new department was assigned. It should have set ‘CategoryID’ to ‘0’ because there are no categories in the new “Earbuds” department.
So, in short- if a product previously had a ‘Department’ and ‘Category’ assigned, then you assign a new ‘Department’ to the product that has no child categories; PAM retains the old ‘CategoryID’, thus the products are not listed appropriately on your site.
A temporary solution is to assign ‘0’ to CategoryID via SQL queries manually (one product at a time). There does not seem to be a way to remedy this via PAM.