Hi Dynamicweb,
We have an issue with empty groups when using the assortment navigation provider as it does not checks for active products in this query:
SELECT DISTINCT(EcomGroupProductRelation.GroupProductRelationGroupID) as GroupID FROM EcomGroupProductRelation INNER JOIN ( SELECT DISTINCT EcomProducts.ProductID FROM EcomProducts INNER JOIN EcomAssortmentItems AS AssortmentItems ON ( AssortmentItems.AssortmentItemProductID = EcomProducts.ProductID ) INNER JOIN EcomAssortments AS Assortments ON ( Assortments.AssortmentID = AssortmentItems.AssortmentItemAssortmentID AND AssortmentItems.AssortmentItemLanguageID = Assortments.AssortmentLanguageID) AND AssortmentItems.AssortmentItemAssortmentID IN ('SYS_CUST_50000213','SYS_DISC_10%') WHERE EcomProducts.ProductLanguageID = 'LANG1' UNION SELECT DISTINCT EcomProducts.ProductID FROM EcomProducts WHERE EcomProducts.ProductID NOT IN (SELECT DISTINCT EcomAssortmentItems.AssortmentItemProductID FROM EcomAssortmentItems WHERE EcomAssortmentItems.AssortmentItemLanguageID = 'LANG1') AND EcomProducts.ProductLanguageID = 'LANG1' UNION SELECT DISTINCT EcomProducts.ProductID FROM EcomProducts WHERE EcomProducts.ProductLanguageID = 'LANG1' AND EcomProducts.ProductID IN (SELECT DISTINCT EcomAssortmentItems.AssortmentItemProductID FROM EcomAssortmentItems INNER JOIN EcomAssortments ON (EcomAssortmentItems.AssortmentItemAssortmentID = EcomAssortments.AssortmentID AND EcomAssortmentItems.AssortmentItemLanguageID = EcomAssortments.AssortmentLanguageID) WHERE AssortmentActive = 0 AND EcomAssortmentItems.AssortmentItemLanguageID = 'LANG1') ) Products ON EcomGroupProductRelation.GroupProductRelationProductID = Products.ProductID
Can you please add an extra clause with "EcomProducts.ProductActive = true"?
If possible I will appreciate if this can be added to the 8.9-branch? 
Best regards, Anders
