Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Find Product Belonging To Category Rate Topic   - - - - -

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3214 posts

Posted 28 June 2018 - 07:04 AM #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



 

Posted 28 June 2018 - 08:57 AM #2

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

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3214 posts

Posted 28 June 2018 - 01:26 PM #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..



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18335 posts

Posted 28 June 2018 - 01:32 PM #4

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3214 posts

Posted 29 June 2018 - 05:49 AM #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



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18335 posts

Posted 29 June 2018 - 01:19 PM #6

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 :)


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.