Parent Category with No products..

I have a category structure that have a few parent categories that have a number of child categories.

Currenlty my parent categories only really act as containers for the child categories and if clicked on do not list any products, this is both visually not what I want but also a problem for the filters sidebar. The filter options appear with counts related to each option, but if an option is selected nothing is shown.



First does anyone have a recommended solution for this situation?



Can a parent category be set to include products from all child categories by default?

This would solve my problem.

Have you tried setting the “Show products from subcategories of the selected category” option in General Settings? Not sure it will do what you want but it is worth a try.



Bob

thanks, but yes… already have that selected. I haven’t seen any change with that option (no Idea how it really works).



Just had another thought on this, it is interesting that the filters seem to work from the home page but not from a parent category (without its own products).

[quote name=‘jobosales’]Have you tried setting the “Show products from subcategories of the selected category” option in General Settings? Not sure it will do what you want but it is worth a try.



Bob[/QUOTE]



Can’t find mentioned “Show products…” option in General Settings.:confused: Please advise. Thanks.

v2.0.12

[quote name=‘nedd’]Can’t find mentioned “Show products…” option in General Settings.:confused: Please advise. Thanks.

v2.0.12[/QUOTE]

It should be an option in the “Catalog” section with Administration->Settings:General settings.



Bob

I found the reason behind my problem… entirely my fault :rolleyes:

I had made a customization according to one of the examples in the KB (regarding the use of hooks and Addons/MyChanges).

This Hook changed the behavior of the page and I had forgotten that I had done it since it was not a feature I was looking for but rather my testing the system out.

After removing the hook override I have things working as expected, and have also customized the layout… very happy :smiley:

[quote name=‘jobosales’]It should be an option in the “Catalog” section with Administration->Settings:General settings.



Bob[/QUOTE]



No, there is not that option. Is it possible that we have different versions of 2.0.12?!?

[quote name=‘nedd’]No, there is not that option. Is it possible that we have different versions of 2.0.12?!?[/QUOTE]

There is only one version of 2.0.12. Is your installation a fresh install or an upgrade from version 1.3.x? Some people have had things missing if they upgraded from version 1.



Bob

[quote name=‘jobosales’]There is only one version of 2.0.12. Is your installation a fresh install or an upgrade from version 1.3.x? Some people have had things missing if they upgraded from version 1.



Bob[/QUOTE]



It’s upgrade from 1.3.5. First it was upgrade to 2.0.8 and later updated until 2.0.12. In general, almost everything went smooth with these upgrades, but now I see that something missing. Any advise how to fix it? Is CS Cart team helpfull in resolving these kind of upgrading bugs/missing features?

I have been fortunate and not needed assistance from the developers; I am not sure how helpful they are.



Verify that the setting exists in the database. In phpMyAdmin, select your database then copy and paste the following into the SQL tab:

SELECT * FROM `cscart_settings` WHERE option_id='7019'



You should see something like the attached file.



Bob

settings_product-subcategories.jpg

[quote name=‘jobosales’]I have been fortunate and not needed assistance from the developers; I am not sure how helpful they are.



Verify that the setting exists in the database. In phpMyAdmin, select your database then copy and paste the following into the SQL tab:

SELECT * FROM `cscart_settings` WHERE option_id='7019'



You should see something like the attached file.



Bob[/QUOTE]



Well, this is what I have as option_id 7019: it’s extended_products_features_search option. (see attached image).



There is no option show_products_from_subcategories at all in cscart_settings.



WTF…

settings-option-7019.jpg

That was the old setting in some previous version - it looks like you this was missed in the update. Do you see the setting for the “Extended search” anywhere? If so, what happens when you check the setting?



When you say "almost everything went smooth with these upgrades, it suggests to me that there were some problems. Do you recall what they were?



Bob

[quote name=‘jobosales’]That was the old setting in some previous version - it looks like you this was missed in the update. Do you see the setting for the “Extended search” anywhere? If so, what happens when you check the setting?



When you say "almost everything went smooth with these upgrades, it suggests to me that there were some problems. Do you recall what they were?



Bob[/QUOTE]



“Extended search” option is in Admin/General/Settings/Catalog. (see attachment/s). That’s already checked. As I see nothing special happens when checked or unchecked. It seems that search by features option doesn’t work.



There was a huge issue with db images links mish-mash after upgrade from 1.3.5 to 2.0.8. That was a pain to manually re-check and update the db images links.



Now, I have no idea what went wrong during the past upgrades from 2.0.8 to 2.0.12 and I can’t recall how it all looked in e.g. 2.0.8. Any advise?

advanced-search.jpg

admin-settings-general-catalog.jpg

You can execute the following SQL statements to see if they fix things for you.



[COLOR=“Red”]** BACKUP THE cscart_settings AND cscart_settings_descriptions TABLES **[/COLOR]



Then, copy and paste the following into the SQL tab in phpMyAdmin:

INSERT INTO cscart_settings (`option_id`, `option_name`, `section_id`, `subsection_id`, `option_type`, `value`, `position`, `is_global`) VALUES ('7019', 'show_products_from_subcategories', 'General', '', 'C', 'N', '150', 'Y')ON DUPLICATE KEY UPDATE `option_id` = `option_id`;
UPDATE cscart_settings_descriptions SET description='Show products from subcategories of the selected category', object_type='O', lang_code='EN', object_string_id='' WHERE object_id='7019' AND object_type='O';




You should then see the proper setting description in the admin. You will need to test if this makes a difference in the storefront.



Bob

[quote name=‘jobosales’]You can execute the following SQL statements to see if they fix things for you.



[COLOR=“Red”]** BACKUP THE cscart_settings AND cscart_settings_descriptions TABLES **[/COLOR]



Then, copy and paste the following into the SQL tab in phpMyAdmin:

INSERT INTO cscart_settings (`option_id`, `option_name`, `section_id`, `subsection_id`, `option_type`, `value`, `position`, `is_global`) VALUES ('7019', 'show_products_from_subcategories', 'General', '', 'C', 'N', '150', 'Y')ON DUPLICATE KEY UPDATE `option_id` = `option_id`;
UPDATE cscart_settings_descriptions SET description='Show products from subcategories of the selected category', object_type='O', lang_code='EN', object_string_id='' WHERE object_id='7019' AND object_type='O';




You should then see the proper setting description in the admin. You will need to test if this makes a difference in the storefront.



Bob[/QUOTE]



Hi Bob, thanks very much for the assistance. I have applied suggested database tables change. Now I have proper setting description in the admin area but there are NO changes in the storefront. Everything is the same, with or without checked setting. Parent categories still doesn’t show products from their subcategories.

I thought that night be the case. At this point, I would have CS-Cart look at the problem.



Bob

[quote name=‘RSW’]I found the reason behind my problem… entirely my fault :rolleyes:

I had made a customization according to one of the examples in the KB (regarding the use of hooks and Addons/MyChanges).

This Hook changed the behavior of the page and I had forgotten that I had done it since it was not a feature I was looking for but rather my testing the system out.

After removing the hook override I have things working as expected, and have also customized the layout… very happy :D[/QUOTE]



I have a fresh install of 2.1 and cannot get child cat poducts to show under the parent in admin, Did you alter anything in the back end?



Thanks

JOhn