Find Product Belonging To Category

My store is very old with last update to 452

I have a category

/supplies/ - 23

and some subcategories

/supplies/somecategories1 - 0

/supplies/somecategories1 - 0

so none of the subcategories has any products, but root shows as there should be 23 but when entering link

dispatch=categories.update&category_id=176

shows nothing, empty.

checkes tables seo names and product categries but cant seem to find them

My store is very old with last update to 452

I have a category

/supplies/ - 23

and some subcategories

/supplies/somecategories1 - 0

/supplies/somecategories1 - 0

so none of the subcategories has any products, but root shows as there should be 23 but when entering link

dispatch=categories.update&category_id=176

shows nothing, empty.

checkes tables seo names and product categries but cant seem to find them

Try using the following query to get IDs of these products:

SELECT * FROM `cscart_products_categories` WHERE `category_id` =176

I had downloaded cscart_products_categories table manually via cs-cart backup and searched for 176 files but none were found.

however in ?dispatch=categories.manage next to Supplies category there was number 23, but if enter inside nothing found..

I had moved all visible stuff out of this category, deleted category, created new one and moved stuff back. Very strange problem..

The mentioned value is calculated only when category is updated. It is stored in the product_count column in the cscart_categories table. Looks like value was not updated correctly during upgrade or import or another action

I wish you have responded earlier :)

honestly you should be hired by cs-cart and paid for support! Thanks again

The mentioned value is calculated only when category is updated. It is stored in the product_count column in the cscart_categories table. Looks like value was not updated correctly during upgrade or import or another action

I wish you have responded earlier :)

honestly you should be hired by cs-cart and paid for support! Thanks again

Thank you for the kind words :)