Populating Star ratings

-- 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.

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.

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