Hello Steve, its a known issue of the department widget :(. When a product is added to a children it is NOT counted as part(or added) to its the parent :( this is why the count is not updated and even more .. when you click the parent department it doesn't show the products. However the fix is very easy from your side.. you just need to add each product not only to the child department but ALSO to its parent. Then everything will work and you can use a hierarchical departments without our fix. Checkout the attached screenshots: The product is added only to dep1child without dep1 but it is added both to dep2 and dep2child which makes the second case working correctly. I hope this helps.
See attached Root departments should show sum of the counts of the children, so "Show Empty" doesn't just hide the entire bloody tree :/ Sitefinity is like the only eComm store which doesn't check children (cms-taxonomy wide I guess too). This needs fixing ASAP
Currently we do not have an upgrade script on SQL level which updates that.
however it is very easy to update them using the API.
in short the steps:
//get all master products
//get all departments in the custom field "Department" which contains a list of ids
//get each department
//check if the department have parent if yes assign it to the product and keep checking his parents and so on.
var catManager = CatalogManager.GetManager();
var taxManager = TaxonomyManager.GetManager();
var products = catManager.GetProducts().Where(p => p.Status == ContentLifecycleStatus.Master);
var departmentIds = product.FieldValue<TrackedList<Guid>>(
boolean hasParentDepForAdd =
var taxon = taxManager.GetTaxon(depId);
var contextBag =
AssignParentTaxonToProduct(Product product, ITaxon taxon)