Skip to main content

How to reset voting stars?

More
12 years 4 months ago #154905 by misa22
-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : x.x.x
-- Joomla version -- : x.x
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : XXXXX x.x.x
-- Error-message(debug-mod must be tuned on) -- : Error_message

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #155017 by nicolas
Replied by nicolas on topic How to reset voting stars?
There are two things to do for that.
First, you need to empty the tables hikashop_vote and hikashop_vote_user via your PHPMyAdmin.
Then, you can create a mass action via the menu System->Mass actions and add to it two actions "update the values" on the column "product_average_score" and the column "product_total_vote" with a value of 0. Then, click on the "process" button to launch the process.

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #156107 by misa22
Replied by misa22 on topic How to reset voting stars?
OK voting is reset and it looks ok.
But shema org not showing the vote stars?
why?

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #156108 by misa22
Replied by misa22 on topic How to reset voting stars?
Rating value is 5 of 5 - in hikashop looks normal
but in shema.org
It looks like rating value is 0 of 5

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #156109 by misa22
Replied by misa22 on topic How to reset voting stars?
Ok the have rating done...BUT
When i click rating 4/5 stars
i have 4 stars in hikashop
and i have 4 stars in shema. org

When i click in new product 5/5 strars
i have 5 stars in hikashop
and 4 stars in shema?
So the shema intemrop show in both products the same value.
<span itemprop="ratingValue" style="display:none">4</span>
<span itemprop="bestRating" style="display:none">5</span>

Why is that?

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #156111 by misa22
Replied by misa22 on topic How to reset voting stars?
So it looks like this
Total rating is not good
When i make 10 ratings of one product i will have only one rating
so in System->Mass actions i must do something wrong
product_average_vote = INT value empty
product_total_vote = INT value 0?
And in shema is something bad :D
when i made first product raring 5/5 and next product rating 4/5 i will have bouth products of rating 4/5.

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #156323 by Xavier
Replied by Xavier on topic How to reset voting stars?
Hi,

I just tried on my end, and I don't have problems like that.
Do you have edited anything related on the votes ? like views, etc ?

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #157155 by misa22
Replied by misa22 on topic How to reset voting stars?
No i dont. i just make some css styling - nothing more...
So in the tables
vote user - database is clean. - even user make vote... database is clean...
vote - i clean the database because it shows vote raring vote user published votes etc
then i make this mass action...
1 problem - i cant make voting without comment because total rating not working
2 problem - the rating in shema org is mess up-
I have 3 products - in hika looks ok
FIRST rating 5/5 1 vote
SEC rating 5/5 4 votes
THIRD raing 1/5 1 vote
BUT in Shema :) is like this
FIRST rating 1/5 1 vote
SEC rating 1/5 1 4 votes
THIRD raring 1/5 1vote
What i must reset/ update?

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #157158 by misa22
Replied by misa22 on topic How to reset voting stars?
No i dont. i just make some css styling - nothing more...
So in the tables
vote user - database is clean. - even user make vote... database is clean...
vote - i clean the database because it shows vote raring vote user published votes etc
then i make this mass action...
1 problem - i cant make voting without comment because total rating not working
2 problem - the rating in shema org is mess up-
I have 3 products - in hika looks ok
FIRST rating 5/5 1 vote
SEC rating 5/5 4 votes
THIRD raing 1/5 1 vote

BUT in Shema :) is like this
FIRST rating 1/5 1 vote
SEC rating 1/5 1 4 votes
THIRD raring 1/5 1vote
What i must reset/ update?
Pls help...

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #157244 by misa22
Replied by misa22 on topic How to reset voting stars?
Ok i done everything...
Problem was in module best rated because the products have a stars...
So bewere to have in products page products modules with stars....

Please Log in or Create an account to join the conversation.

Time to create page: 0.210 seconds
Powered by Kunena Forum