Ticket : Updateing jCenter and jStore #3A654U-1BK6

Hello Bob,

Please re-enter this API to refresh jStore: API7318V41NYLW1N

This could be because you are still o the older version and the licensing of jStore was still from the paid one from previous release. However jStore is now free so it should be free.

Please let me know if that doesn't work so we can check the api conection.

Regards,

Cheryl

Hello Bob,

Please re-enter this API to refresh jStore: API7318V41NYLW1N

This could be because you are still o the older version and the licensing of jStore was still from the paid one from previous release. However jStore is now free so it should be free.

Please let me know if that doesn't work so we can check the api conection.

Regards,

Cheryl

OK, thank you.

Did it work for you Bob?

Cheryl,

Yes, I was able to update both jStore and jCenter. Thank you for your help with that.

I will buy a new API key for jAuction soon.

I have another question about jStore. I have deleted a lot of products and added a lot of new products. The count of items shown on the front end is no longer accurate for a category. For example there is a category where in the back end it shows I have 187 products, but on the front end, it shows the category as having 338 products. 

Is there a task that corrects this, which goes through the category and gets a current count of the products in that category? Otherwise how can I correct that?

Thank you for your help!

Bob,

The category count is a common issue when the catefory tree is broken due to deletion then adding then deletion.

This query will reset the count, run this in your phpmyadmin or jcenter >> tools >> query;

Change # with your own DB prefix;

UPDATE #_productcat_node AS A SET numpid= ( SELECT COUNT( B.pid ) FROM #_productcat_product AS B WHERE B.catid = A.catid  

OK thank you for your help.

I tried running the query in jCenter -> Tools -> Query, but it said I had an error in my SQL syntax.

The query I tried to run was

UPDATE msb9n_productcat_node AS A SET numpid= ( SELECT COUNT( B.pid ) FROM msb9n_productcat_product AS B WHERE B.catid = A.catid  

I went to phpMyAdmin and ran the query on the database. I did not get any error message, but I did not get any message at all.

After clearing all the caches, I reloaded the category page and it still shows 338 items, when there are only 195 items now.

So something with my query was wrong.

I'm not going to worry about it, this is minor. But thank you for helping!

Sorry I forgot the bracket;

try this:

UPDATE msb9n_productcat_node AS A SET numpid= ( SELECT COUNT( B.pid ) FROM msb9n_productcat_product AS B WHERE B.catid = A.catid );

Please do not put spaces before and after the query.

That worked! Thank you for all your help.