Is it possible to import the star ratings in a CSV import on Magento? I know I can import/export the reviews, but these exports do not include the star rating (Detailed Rating)

Can someone point me in the direction of a Data Profile that will allow for the import and export of reviews including the ratings please.

1 Answer 1


You can use this extension


This extension allowed to import/export reviews and ratings in csv format from magento dataflow profile .

Or alternatively you can use this code to get ratings of review

 $ratingCollection = Mage::getModel('rating/rating_option_vote')
                    ->setReviewFilter($review->getId()); // your review id

This will give you rating collection of review

  • I'm using that extension currently, it only seems to export the reviews and does not bring the Star Ratings with it. What file would I add that $ratingCollection code to? Commented Nov 6, 2014 at 11:12
  • 1
    option_id is field for ratings
    – Mufaddal
    Commented Nov 6, 2014 at 11:19
  • Ah, got it. Misleading column title - I've renamed this to ratings. Commented Nov 6, 2014 at 11:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.