Skip to main content

Posts

Showing posts from May, 2015

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);

Orders Import using csv and update existing orders

Ever wondered how to import bulk orders programatically? I want import orders using .csv i tried so many sites but i unable get anything related to import using csv i got it by creating programatically. So i tried csv bulk import orders because i have 60K orders so order creation is difficult i have orders data csv.So that i prepared csv and i wrote code related to orders import.Below is code  Copy the below code and create one file in your magento root directory(magento/ordersimports.php)paste the code into the file ........ Next prepare accordingly  ordersimports.csv this csv file also you can place root directory (magento/ordersimports.csv)  after that go to your site in browser run file like this  www.magento.com/ ordersimports.php <?php error_reporting(E_ALL | E_STRICT); ini_set('display_errors', 1); require_once 'app/Mage.php'; umask(0); Mage::app('default'); $arr = array(); if (($handle = fopen("ordersimports.csv"