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

magento 1 extension converted in to magento 2 process

Simple Install =================================== Download as a zip below link. unzip and upload it to your public_html or other rootdoc directory. https://github.com/magento/code-migration. login to your server via shell switch to the code-migration-develop directory by running following command   cd code-migration-develop Run command following command in root directory of this toolkit composer instal Before running the migration, the following directories need to be prepared: ===================================== * `<src>` - Directory that contains custom Magento 1.x code that is intended to be migrated. The code must follow the Magento 1.x directory structure.   Magento1.x core files must not be included. * `<dst>` - Empty directory for the toolkit to put the generated Magento 2 code to * `<m1>` - Directory that contains: * Vanilla Magento 1.x codebase, and * Custom Magento 1.x code same as...