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

What startSetup() and endSetup() methods actually does?

The startSetup() and endSetup() methods are used in setup scripts. They are often at the beginning and the end of an upgrade/install method, like in “upgrade()” method of Magento/Catalog/Setup/UpgradeData.php The question is “do you really need them?” Or does it just “look necessary”? This blog post explores what these functions do and then explains when you do and do not need to use these methods. Let’s see what these methods are doing. First, startSetup(): public function startSetup() {   $this->rawQuery("SET SQL_MODE=''");  $this->rawQuery("SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0");   $this->rawQuery("SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");   return $this;  } 1. Disable foreign keys check. It may be necessary in some rare cases (for example, in a case of cyclic references between tables), but it’s not needed in common situations. It even may lead to hiding real problems...

Magento 2 UI Component Grid Explanation

1) layout file inside Company/Module/view/adminhtml/layout/routerid_controller_action.xml define grid as uiComponent with: 2) uiComponent is defined in Company/Module/view/adminhtml/ui_component/listing_name.xml file. File name must be the same as uiComponent name used in layout file. The structure of the file may seem pretty complex at first sight but as always these are some repeating nodes. To make it simple lets slice it. Main node of the component file is <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">. It is fixed and I believe it requires namespace location attribute. Next there are typically 4 nodes inside <listing /> node: <argument />, <dataSource />, <container /> and <columns />. This is however not a strict setup as <argument /> node might be duplicated to provide more configuration or <container /> as...