passcat Posted June 19, 2009 Share Posted June 19, 2009 Hi, I have added a new category called for her to my shop, and in that category i have added 4 sub catorgories. When i click on the for her catorgory nothing shows up, it just says There are no products to list in this category. It should show the sub catorgories. Does anyone know what i have done wrong. Please Help. Link to comment Share on other sites More sharing options...
hubcat Posted June 20, 2009 Share Posted June 20, 2009 Do your subcategories show up in the admin panel? Adrienne Link to comment Share on other sites More sharing options...
spooks Posted June 20, 2009 Share Posted June 20, 2009 there is a known bug, if sub cats have no product they will not show Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
passcat Posted June 20, 2009 Author Share Posted June 20, 2009 Hi, Yes the sub categories show up in the admin panel. The sub categories have products in them. Link to comment Share on other sites More sharing options...
passcat Posted June 20, 2009 Author Share Posted June 20, 2009 Hi, I have researched how to add new catergories and sub catergories and have followed the instructions that were given, But i am still not seeing any of the sub catergories, all i am seeing is "There are no products to list in this category". Please can anyone Help. Link to comment Share on other sites More sharing options...
nsassi Posted June 20, 2009 Share Posted June 20, 2009 I have this exact same problem & after going through the whole database cannot work out why it happening..... Have a look at my site http://www.nancysassi.com Ladies Clothing shows subcategories but when you click on Vintage Furniture where there are clearly subcategories nothing is showing. Sorry I can't be of help but if I find a solution I'll post it up on here otherwise I'll have to work ut a way around it. Link to comment Share on other sites More sharing options...
nsassi Posted June 20, 2009 Share Posted June 20, 2009 I have this exact same problem & after going through the whole database cannot work out why it happening..... Have a look at my site http://www.nancysassi.com Ladies Clothing shows subcategories but when you click on Vintage Furniture where there are clearly subcategories nothing is showing. Sorry I can't be of help but if I find a solution I'll post it up on here otherwise I'll have to work ut a way around it. I should say, are you using Easy Populate by any chance?? I thought it might be a bug with that?? Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 20, 2009 Share Posted June 20, 2009 I have this exact same problem & after going through the whole database cannot work out why it happening..... Are there any inactive products in your category 24? The query in the top of index.php assumes there are products to lists when there are product associated with it. But if they are inactive they wouldn't show in the products listing. if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { That count query should probably look at products_status too... Link to comment Share on other sites More sharing options...
nsassi Posted June 20, 2009 Share Posted June 20, 2009 Are there any inactive products in your category 24? The query in the top of index.php assumes there are products to lists when there are product associated with it. But if they are inactive they wouldn't show in the products listing. if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { That count query should probably look at products_status too... They are not inactive but I have 0's in the quantity field (i.e. I am not showing a quantity on the site). Would this make a difference by effectively making them inactive?? Link to comment Share on other sites More sharing options...
nsassi Posted June 20, 2009 Share Posted June 20, 2009 Sorry just checked and it isn't that... Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 20, 2009 Share Posted June 20, 2009 They are not inactive but I have 0's in the quantity field (i.e. I am not showing a quantity on the site). Would this make a difference by effectively making them inactive?? It might if you have a added some code to prevent listing of products that have zero for a quantity. What number do you get when you do the following query in phpMyAdmin: select count(*) as total from products_to_categories where categories_id = '24'; If it is more than zero it confirms my suggestion. Otherwise I wouldn't know either :) Link to comment Share on other sites More sharing options...
nsassi Posted June 20, 2009 Share Posted June 20, 2009 Sorry just checked and it isn't that... Also, it isn't the products that don't show, it's the sub-categories in the middle of the page see http://www.nancysassi.com/catalog/index.php?cPath=24 which should have 8 sub-categories showing in the middle Link to comment Share on other sites More sharing options...
passcat Posted June 20, 2009 Author Share Posted June 20, 2009 Is there a way i could add them manually to the main category page, if there is which file would i have to edit. Link to comment Share on other sites More sharing options...
passcat Posted June 22, 2009 Author Share Posted June 22, 2009 there is a known bug, if sub cats have no product they will not show What do you mean there is a known bug? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.