Populating Star ratings

  • Posts: 279
  • Thank you received: 1
10 years 5 months ago #120742

-- HikaShop version -- : 2.2.1
-- Joomla version -- : 2.5.14
-- PHP version -- : 5.3.3

I am converting a client over from Miva Merchant where he's had a store for many years. All his products already have many ratings and reviews.

Is there any easy way (maybe directly writing to the database) of adding the star ratings? For example, one product had 21 reviews with a rating of about 4.5. I'd like that product, when we launch the new site to reflect those stats.

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

  • Posts: 13201
  • Thank you received: 2322
10 years 5 months ago #120794

Hi,

That can be done via a sql resquest,
The votes are in the table "#__hikashop_product" and the columns to populate are "product_total_vote" for the number of vote, and "product_average_score" for the value of the vote.

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

  • Posts: 279
  • Thank you received: 1
10 years 5 months ago #120907

Great thank you. As there are limited products in the shop, and all have different ratings, I can go and edit by hand.

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

Time to create page: 0.064 seconds
Powered by Kunena Forum