Skip to main content

Reviews import in magento using csv file

I have task with reviews import using csv.I have csv of all reviews so i need to import reviews in our site i written code for import reviews programatically.

i crearted one file in magento root directory (reviewsimport.php) in that file i written the below code

<?php

// Invoke the Magento environment
require_once 'app/Mage.php';
Mage::app();
$fp = fopen("latestreviews.csv", 'r');
$count = 1;
while ($line = fgetcsv($fp)) {
    $product_id = Mage::getModel("catalog/product")->getIdBySku($line[2]);
    $customer = Mage::getModel("customer/customer");
    $customer->setWebsiteId(Mage::app()->getWebsite()->getId());
    $customer->loadByEmail($line[3]);
    $review = Mage::getModel('review/review');
    $review->setEntityPkValue($product_id); //product id 
    $review->setStatusId(1);
    $review->setTitle($line[2]);
    $review->setDetail($line[1]);
    $review->setEntityId(1);
    $review->setStoreId(Mage::app()->getStore()->getId());
    $review->setStatusId(1); //approved 
    $review->setCustomerId($customer->getId()); //null is for administrator 
    $review->setNickname($customer->getName());
    // $review->setReviewId($review->getId()); 
    $review->setStores(array(Mage::app()->getStore()->getId()));
    // print_r($review->getData());
    $review->save();
    $review->aggregate();
    $rating_options = array(
        1 => array(1, 2, 3, 4, 5), // <== Look at your database table `rating_option` for these vals
    );

    // Now save the ratings
    foreach ($rating_options as $rating_id => $option_ids):
        
            $_rating = Mage::getModel('rating/rating')
                    ->setRatingId($rating_id)
                    ->setReviewId($review->getId())
                    ->addOptionVote($option_ids[$line[0] - 1], $product_id);
            //print_r($_rating->getData());
        
    endforeach;
    echo $count;
    $count++;
}
?>

csv formate like this ::

rate,   reviewdes,    sku,          email

5      description        123456    n.pavan37@gmail.com

next i created csv file for rating besed on code it is also placed under magento root directory reviews.csv

example csv with one line 


then run file in to browser.......keep :)



Comments

  1. Thank you for sharing excellent information. Your website is very cool. Fully useful your blog post... Online Shopping Sites In Gujarat

    ReplyDelete
  2. Very useful! You helped me with something that I had a problem with for a long time. Great blog!

    ReplyDelete
  3. Hi i'm new to magento......Full module please.. where i have to locate the file.?

    ReplyDelete

Post a Comment

Popular posts from this blog

Magento 2 product collection Filtering multi-select attribute values

  If you have multi-select attribute of product like below If you want filter value for this option Use below syntax to get product data: ->addAttributeToFilter('store_model', array('finset' => $params['store_model'])) finset key is used for multiselect attribute filter. $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $products = $objectManager->get('Magento\Catalog\Model\Product')         ->getCollection()         ->addAttributeToSelect('*')         ->addAttributeToSelect('store_brand')         ->addAttributeToSelect('store_model')         ->addAttributeToSelect('store_year')         ->addAttributeToFilter('store_brand', array('finset' => $params['store_brand']))         ->addAttributeToFilter('store_model', array('finset' => $params['store_model']))         ->ad...

magento 2 best seller product display based on current category and subcategories

Magento 2 getting best seller based on category wise displaying i have done below for that to implement this functionality it is working fine for me. step 1 create block file in our module folder <?php namespace Pawan\Bestseller\Block; use Magento\Catalog\Api\CategoryRepositoryInterface; class Bestsellercategory extends \Magento\Catalog\Block\Product\ListProduct {     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_collection;     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_productCollection;     /**      * Image helper      *      * @var Magento\Catalog\Helper\Image     ...

order cancel from front end

if you want cancel order from front end create module like this app/etc/modules/<Namespace_Modulename>.xml <config>     <modules>         <Namespace_CustomerOrderCancel>             <active>true</active>             <codePool>community</codePool>             <depends>                 <Mage_Sales />             </depends>         </ Namespace _CustomerOrderCancel>     </modules> </config> app/community/Namespace/Modulename           ------controllers           -------etc           -------Helper if you want cancel button in history page (myorder) need override block file Mage_Sales_Block_Orde...