darius
June 28, 2018, 12:00am
#1
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
darius
June 28, 2018, 12:00am
#3
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
darius
June 29, 2018, 12:00am
#5
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 :)