Guest Posted December 2, 2006 Share Posted December 2, 2006 I did search. I found that there is supposedly a "quirk" that keeps the count from being correct and there are various fixes.l I just want to know how the count is calculated. What is it reading? I deleted all the items and it retained the count. I looked in various tables. I know one "fix" is to remove the count token from the template, but I was really interested in know where in the database I missed something. Thank you. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 3, 2006 Share Posted December 3, 2006 For each category, there is a "noProducts" field in the category table. This is supposed to be how many products are in the cat. However, if you should delete a product from the database and that value is not decremented, it will be off. That's why I wrote a script ages ago called "fixCatCount". It goes through and makes sure that all the cats show the proper number of products. :) Quote Link to comment Share on other sites More sharing options...
Guest Posted December 8, 2006 Share Posted December 8, 2006 For each category, there is a "noProducts" field in the category table. This is supposed to be how many products are in the cat. However, if you should delete a product from the database and that value is not decremented, it will be off. That's why I wrote a script ages ago called "fixCatCount". It goes through and makes sure that all the cats show the proper number of products. Is the script free? Quote Link to comment Share on other sites More sharing options...
markscarts Posted December 8, 2006 Share Posted December 8, 2006 Yes, it is a free utility. I'll send you a pm with a link to the script :blink: Quote Link to comment Share on other sites More sharing options...
Guest Posted December 8, 2006 Share Posted December 8, 2006 Why not visit .org forum and you might find more interesting free mods :blink: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.