retired products cannot be seen in products by categories view