[Magento] Product Import Scripts

   
    


<?php
class WonderFan_ImportProduct_Model_Convert_Adapter_Product extendsMage_Catalog_Model_Convert_Adapter_Product {
 
   
    protected$custom_options = array();

    publicfunction saveRow(array $importData) {
       $product = $this->getProductModel()
               ->reset();

       if (empty($importData['store'])) {
           if (!is_null($this->getBatchParams('store'))){
               $store =$this->getStoreById($this->getBatchParams('store'));
           } else {
               $message = Mage::helper('catalog')->__('Skip importrow, required field "%s" not defined', 'store');
               Mage::throwException($message);
           }
       } else {
           $store =$this->getStoreByCode($importData['store']);
       }

       if ($store === false) {
           $message = Mage::helper('catalog')->__('Skip importrow, store "%s" field not exists', $importData['store']);
           Mage::throwException($message);
       }

       
       $product->setStoreId($store->getId());
       $productId =$product->getIdBySku($importData['sku']);

       if ($productId) {
           $product->load($productId);
       } else {
           $productTypes = $this->getProductTypes();
           $productAttributeSets =$this->getProductAttributeSets();

           
           if (empty($importData['type']) ||!isset($productTypes[strtolower($importData['type'])])) {
               $value = isset($importData['type']) ? $importData['type'] :'';
               $message = Mage::helper('catalog')->__('Skip importrow, is not valid value "%s" for field "%s"', $value,'type');
               Mage::throwException($message);
           }
           $product->setTypeId($productTypes[strtolower($importData['type'])]);
           
           if (empty($importData['attribute_set']) ||!isset($productAttributeSets[$importData['attribute_set']])){
               
           }
           $product->setAttributeSetId($productAttributeSets[$importData['attribute_set']]);

           foreach ($this->_requiredFields as $field) {
               $attribute = $this->getAttribute($field);
               if (!isset($importData[$field]) &&$attribute &&$attribute->getIsRequired()) {
                   $message = Mage::helper('catalog')->__('Skip importrow, required field "%s" for new products not defined',$field);
                   Mage::throwException($message);
               }
           }
       }

       $this->setProductTypeInstance($product);
       //����custom otpion upgrade�r ���}����Ć��}�����Œ���ǰ�Ȅh��֮ǰ��customoption add by jack


       foreach ($product->getOptions() as $opt) {
           $opt->delete();
       }
       // eof add by jack
       if (isset($importData['category_ids'])) {
           $product->setCategoryIds($importData['category_ids']);
       }
       
       if (isset($importData['categories'])) {

           $categoryIds =$this->_addCategories($importData['categories'],$store);
           // echo $cate_name=$importData['categories'];
           //add by jack set imported category img
           



           if ($categoryIds) {
               $product->setCategoryIds($categoryIds);
           }
       }
       foreach ($this->_ignoreFields as $field) {
           if (isset($importData[$field])) {
               unset($importData[$field]);
           }
       }

       if ($store->getId() != 0) {
           $websiteIds = $product->getWebsiteIds();
           if (!is_array($websiteIds)) {
               $websiteIds = array();
           }
           if (!in_array($store->getWebsiteId(), $websiteIds)){
               $websiteIds[] = $store->getWebsiteId();
           }
           $product->setWebsiteIds($websiteIds);
       }

       if (isset($importData['websites'])) {
           $websiteIds = $product->getWebsiteIds();
           if (!is_array($websiteIds)) {
               $websiteIds = array();
           }
           $websiteCodes = explode(',', $importData['websites']);
           foreach ($websiteCodes as $websiteCode) {
               try {
                   $website =Mage::app()->getWebsite(trim($websiteCode));
                   if (!in_array($website->getId(), $websiteIds)){
                       $websiteIds[] = $website->getId();
                   }
               } catch (Exception $e) {
                   
               }
           }
           $product->setWebsiteIds($websiteIds);
           unset($websiteIds);
       }

       foreach ($importData as $field => $value) {

           if (in_array($field, $this->_inventoryFields)){
               continue;
           }
           if (in_array($field, $this->_imageFields)) {
               continue;
           }
           $attribute = $this->getAttribute($field);
           if (!$attribute) {

               if (strpos($field, ':') !== FALSE&& strlen($value)) {
                   $values = explode('|', $value);
                   if (count($values) > 0) {
                       @list($title, $type, $is_required, $sort_order) = explode(':',$field);
                       $title = ucfirst(str_replace('_', ' ', $title));
                       $custom_options[] = array(
                           'is_delete' => 0,
                           'title' => $title,
                           'previous_group' => '',
                           'previous_type' => '',
                           'type' => $type,
                           'is_require' => $is_required,
                           'sort_order' => $sort_order,
                           'values' => array()
                       );
                       foreach ($values as $v) {
                           $parts = explode(':', $v);
                           $title = $parts[0];
                           if (count($parts) > 1) {
                               $price_type = $parts[1];
                           } else {
                               $price_type = 'fixed';
                           }
                           if (count($parts) > 2) {
                               $price = $parts[2];
                           } else {
                               $price = 0;
                           }
                           if (count($parts) > 3) {
                               $sku = $parts[3];
                           } else {
                               $sku = '';
                           }
                           if (count($parts) > 4) {
                               $sort_order = $parts[4];
                           } else {
                               $sort_order = 0;
                           }
                           switch ($type) {
                               case 'file':
                                   break;

                               case 'field':
                               case 'area':
                                   $custom_options[count($custom_options) - 1]['max_characters'] =$sort_order;


                               case 'date':
                               case 'date_time':
                               case 'time':
                                   $custom_options[count($custom_options) - 1]['price_type'] =$price_type;
                                   $custom_options[count($custom_options) - 1]['price'] =$price;
                                   $custom_options[count($custom_options) - 1]['sku'] = $sku;
                                   break;

                               case 'drop_down':
                               case 'radio':
                               case 'checkbox':
                               case 'multiple':
                               default:
                                   $custom_options[count($custom_options) - 1]['values'][] =array(
                                       'is_delete' => 0,
                                       'title' => $title,
                                       'option_type_id' => -1,
                                       'price_type' => $price_type,
                                       'price' => $price,
                                       'sku' => $sku,
                                       'sort_order' => $sort_order,
                                   );
                                   break;
                           }
                       }
                   }
               }

               continue;
           }

           $isArray = false;
           $setValue = $value;

           if ($attribute->getFrontendInput() == 'multiselect'){
               $value = explode(self::MULTI_DELIMITER, $value);
               $isArray = true;
               $setValue = array();
           }

           if ($value &&$attribute->getBackendType() == 'decimal') {
               $setValue = $this->getNumber($value);
           }


           if ($attribute->usesSource()) {
               $options =$attribute->getSource()->getAllOptions(false);

               if ($isArray) {
                   foreach ($options as $item) {
                       if (in_array($item['label'], $value)) {
                           $setValue[] = $item['value'];
                       }
                   }
               } else {
                   $setValue = null;
                   foreach ($options as $item) {
                       if ($item['label'] == $value) {
                           $setValue = $item['value'];
                       }
                   }
               }
           }

           $product->setData($field, $setValue);
       }

       if (!$product->getVisibility()) {
           $product->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE);
       }

       $stockData = array();
       $inventoryFields =isset($this->_inventoryFieldsProductTypes[$product->getTypeId()])?$this->_inventoryFieldsProductTypes[$product->getTypeId()]: array();
       foreach ($inventoryFields as $field) {
           if (isset($importData[$field])) {
               if (in_array($field, $this->_toNumber)) {
                   $stockData[$field] =$this->getNumber($importData[$field]);
               } else {
                   $stockData[$field] = $importData[$field];
               }
           }
       }
       $product->setStockData($stockData);

       $imageData = array();
       foreach ($this->_imageFields as $field) {
           if (!empty($importData[$field]) &&$importData[$field] != 'no_selection') {
               if (!isset($imageData[$importData[$field]])) {
                   $imageData[$importData[$field]] = array();
               }
               $imageData[$importData[$field]][] = $field;
           }
       }

       if (Mage::getVersion() < "1.5.0.0") {
           foreach ($imageData as $file => $fields) {
               try {
                   $product->addImageToMediaGallery(Mage::getBaseDir('media'). DS . 'import' . $file, $fields);
               } catch (Exception $e) {
                   
               }
           }
       } else {
           
           $mediaGalleryBackendModel =$this->getAttribute('media_gallery')->getBackend();

           $arrayToMassAdd = array();

           foreach ($product->getMediaAttributes() as$mediaAttributeCode => $mediaAttribute) {
               if (isset($importData[$mediaAttributeCode])) {
                   $file = $importData[$mediaAttributeCode];
                   if (trim($file) &&!$mediaGalleryBackendModel->getImage($product,$file)) {
                       $arrayToMassAdd[] = array('file' => trim($file),'mediaAttribute' => $mediaAttributeCode);
                   }
               }
           }

           $addedFilesCorrespondence =
                   $mediaGalleryBackendModel->addImagesWithDifferentMediaAttributes($product,$arrayToMassAdd, Mage::getBaseDir('media') . DS . 'import', false,false);

           foreach ($product->getMediaAttributes() as$mediaAttributeCode => $mediaAttribute) {
               $addedFile = '';
               if (isset($importData[$mediaAttributeCode . '_label'])) {
                   $fileLabel = trim($importData[$mediaAttributeCode .'_label']);
                   if (isset($importData[$mediaAttributeCode])) {
                       $keyInAddedFile = array_search($importData[$mediaAttributeCode],$addedFilesCorrespondence['alreadyAddedFiles']);
                       if ($keyInAddedFile !== false) {
                           $addedFile =$addedFilesCorrespondence['alreadyAddedFilesNames'][$keyInAddedFile];
                       }
                   }

                   if (!$addedFile) {
                       $addedFile =$product->getData($mediaAttributeCode);
                   }
                   if ($fileLabel && $addedFile){
                       $mediaGalleryBackendModel->updateImage($product,$addedFile, array('label' => $fileLabel));
                   }
               }
           }
       }

       
       try {
           $galleryData = explode(';', $importData["gallery"]);
           foreach ($galleryData as $gallery_img)

           {
               //bof add by jack custom option �ظ��������
                              //eof  add by jack
               $product->addImageToMediaGallery(Mage::getBaseDir('media'). DS . 'import' . $gallery_img, null, false, false);
           }
       } catch (Exception $e) {
           
       }
       

       $product->setIsMassupdate(true);
       $product->setExcludeUrlRewrite(true);

       $product->save();
       

       if (isset($custom_options)) {
           if (count($custom_options)) {
               foreach ($custom_options as $option) {
                   try {
                       $opt = Mage::getModel('catalog/product_option');
                       $opt->setProduct($product);
                       $opt->addOption($option);
                       $opt->saveOptions();
                   } catch (Exception $e) {
                       
                   }
               }
           }
       }
       return true;
    }

    protected$_categoryCache = array();
   

    protectedfunction _addCategories($categories, $store) {

       $rootId = $store->getRootCategoryId();

       if (!$rootId) {
           
           $storeId = 1;
           $rootId =Mage::app()->getStore($storeId)->getRootCategoryId();
       }

       if ($categories == "")
           return array();
       $rootPath = '1/' . $rootId;
       if(empty($this->_categoryCache[$store->getId()])){
           $collection =Mage::getModel('catalog/category')->getCollection()
                   ->setStore($store)
                   ->addAttributeToSelect('name');
           $collection->getSelect()->where("pathlike '" . $rootPath . "/%'");

           foreach ($collection as $cat) {
               $pathArr = explode('/', $cat->getPath());
               $namePath = '';
               for ($i = 2, $l = sizeof($pathArr); $i < $l; $i++){
                   $name =$collection->getItemById($pathArr[$i])->getName();
                   $namePath .= (empty($namePath) ? '' : '/') . trim($name);
               }
               $cat->setNamePath($namePath);
           }

           $cache = array();
           foreach ($collection as $cat) {
               $cache[strtolower($cat->getNamePath())] =$cat;
               $cat->unsNamePath();
           }
           $this->_categoryCache[$store->getId()]= $cache;
       }
       $cache = &$this->_categoryCache[$store->getId()];

       $catIds = array();
       foreach (explode(';', $categories) as $categoryPathStr) {
           $categoryPathStr = preg_replace('#\s*/\s*#', '/',trim($categoryPathStr));
           if (!empty($cache[$categoryPathStr])) {
               $catIds[] = $cache[$categoryPathStr]->getId();
               continue;
           }
           $path = $rootPath;
           $namePath = '';
           foreach (explode('/', $categoryPathStr) as $catName) {
               $namePath .= (empty($namePath) ? '' : '/') .strtolower($catName);
               if (empty($cache[$namePath])) {
                   $cat = Mage::getModel('catalog/category')
                           ->setStoreId($store->getId())
                           ->setPath($path)
                           ->setName($catName)
                           ->setIsActive(1)
                           ->save();
                   $cache[$namePath] = $cat;
               }
               $catId = $cache[$namePath]->getId();
               $path .= '/' . $catId;
           }
           if ($catId) {
               $catIds[] = $catId;
           }
       }
       return join(',', $catIds);
    }

}