Gsyfuy

I have created custom import script for simple product csv import in magento. It is working fine for the newly products.
But I want to update the products if sku already exists.
How can I achieve this? I am using the below code :

<?php  

error_reporting(0);



ini_set('max_execution_time', 2000);

ini_set('auto_detect_line_endings', true);

require_once('app/Mage.php'); //Path to Magento



umask(0);



Mage::app()->setCurrentStore(Mage::getModel('core/store')->load(0)); 

$data = glob("customupload/*.csv");  

$fileList = array();

foreach ($data as $file) {

    $fileList[filemtime($file)] = $file;

}

ksort($fileList);

$myarray = array();

foreach($fileList as $key => $val){

    $myarray[] = $val;

}

$list=array();

if(count($myarray)){



    /*This will create an array of associative arrays with the first row column headers as the keys.*/

    $csv_map = array_map('str_getcsv', file($myarray[count($myarray)-1]));

    $list = explode('/', $myarray[count($myarray)-1]);

    array_walk($csv_map, function(&$a) use ($csv_map) {

        $a = array_combine($csv_map[0], $a);

    });



    array_shift($csv_map); # remove column header

    /*End*/



    $message = '';

    $count   = 1;

    foreach($csv_map as $data){

        try {



        $product = Mage::getModel('catalog/product'); 



        $entityTypeId = Mage::getModel('eav/entity')

                        ->setType('catalog_product')

                        ->getTypeId();

        $attributeSetName   = $data['attribute set'];

        $attributeSetId     = Mage::getModel('eav/entity_attribute_set')

                                ->getCollection()

                                ->setEntityTypeFilter($entityTypeId)

                                ->addFieldToFilter('attribute_set_name', $attributeSetName)

                                ->getFirstItem()

                                ->getAttributeSetId();



        $product->setAttributeSetId($attributeSetId); // need to look this up 



        $product->setTaxClassId(0); // taxable goods



        $product->setVisibility(4); // catalog, search



        $product->setStatus(1); // enabled



        $product->setWebsiteIDs(1); 



        $product->setStoreId(1);    



        $product->setTypeId('simple');



        $product->setWarranty('Lifetime');



        // assign product to the default website

        $product->setWebsiteIds(array(Mage::app()->getStore(true)->getWebsite()->getId()));  





        // configure stock

        $product->setStockData(array(

            'use_config_manage_stock' => 1, // use global config ?

            'manage_stock'            => 0, // shoudl we manage stock or not?

            'is_in_stock'             => 1 

            /*'qty'                     => 2,*/

        ));  

        $mediaArray = array(

            'thumbnail'   => $data['image'],

            'small_image' => $data['image'],

            'image'       => $data['image']

        );



        // Remove unset images, add image to gallery if exists

        $importDir = Mage::getBaseDir('media') . DS . 'import/product/';



        foreach ( $mediaArray as $imageType => $fileName ) {

            $filePath = $importDir . $fileName;

            if ( file_exists($filePath) ) {

                try {

                    $product->addImageToMediaGallery($filePath, $imageType, false);

                } catch (Exception $e) {

                    echo $e->getMessage();

                }

            } else {

                echo "Product does not have an image or the path is incorrect. Path was: {$filePath}<br/>";

            }

        }

        //set category



        $_category = Mage::getResourceModel('catalog/category_collection')->addFieldToFilter('name', $data['Category'])->getFirstItem();



        $cat1= $_category->getId();

        $expcategory = explode('/',$data['sub category']); 

        $allsubcatid = array();



        foreach($expcategory as $_cat2) 

        {



            $_category = Mage::getResourceModel('catalog/category_collection')->addFieldToFilter('name', $_cat2)->getFirstItem();



            $allsubcatid[] = $_category->getId(); 



        } 

        //echo '<pre>'; print_r($allsubcatid);die;

        $product->setCategoryIds(array($cat1,$allsubcatid));



        $attribute = Mage::getModel('eav/entity_attribute')->loadByCode('catalog_product', 'manufacturer');

        $attributeValue = Mage::getResourceModel('eav/entity_attribute_option_collection')

                        ->setAttributeFilter($attribute->getData('attribute_id'))

                        ->setStoreFilter(0, false);

         foreach($attributeValue as $option)    

        {

            if (strtolower($option['value']) == strtolower($data['manufacturer'])) {

                $manufacturer =  $option['option_id'];

            }

        }

        // finally set custom data



        foreach($data as $key => $val){ 

            if($key != 'Category'){

                $capitalword = ucwords(trim($key));

                $remove_hyphen = str_replace(' ','',trim($capitalword)); 

                $setdata = $remove_hyphen; 

                $setdatas = set.$setdata; 

                $product->$setdatas($val); 

            }

        }

        $product->setManufacturer($manufacturer);   

        $product->save();



        }catch (Exception $e) {



            Mage::log($e->getMessage(), null, 'configurableProductsDataError.log', true);

        }

        $count++;

        $c .= $count."<br>"; 

        if($count ==1){ break; } 

    }



        echo "Success";

}



?>

 <?php



rename("customupload/".$list[1], "customupload/uploaded/".$list[1]);

?>

Try Using

$_product = Mage::getModel('catalog/product')->loadByAttribute('sku',$data['sku']);

Or

$product = Mage::getModel('catalog/product');

$product->load($product->getIdBySku($data['sku']));

If the product is found it will load the product and return you the model. If not it will return you an empty model.