import one option simple product and config product

只有一种选项的简单商品和可配置商品

 

例如：某鞋子有尺寸这一可选项: (尺码：35,36,37,38,39)

主要是先创建5个拥有者写属性值的简单商品

然后创建一个可配置商品。

配置好可配置商品的配置项，将简单商品关联到这个可配置商品

 

	/**
	 * 导入有option value 的简单商品
	 */
	public function importMixProduct() {
		//获取这种类型的商品ID;
		$read= Mage::getSingleton('core/resource')->getConnection('core_read');
		$sql = "SELECT product_id,COUNT(*) FROM (
				SELECT product_id,option_id FROM `old_product_option_value`
				GROUP BY product_id,option_id
				) AS t1
				GROUP BY product_id
				HAVING COUNT(*) = 1
				";
		//不在option表里的商品id
		$model=Mage::getModel('eav/entity_setup','core_setup');
		$results = $read->query($sql);
		foreach ($results as $row) {
			$product_id = (int)$row['product_id'];
				//寻找可配置项ID
				$sql = "select option_id
					from old_product_option_value
					where product_id = ?
					group by option_id";
				$results_option_ids = $read->query($sql,array($product_id));
				//查找它的简单商品配置
				$sql = "select * from old_product_option_value where product_id = ?";
				$results_simple = $read->query($sql,array($product_id));
				$productIds = array();
				$_attributeIds = array();
				$att_ids = array();
				$simpleProducts = array();
					
				foreach ($results_simple as $key=>$rs) {
					$simple_sku = $product_id . '_' . $key;
					var_dump($simple_sku);
					//保存简单商品
					//获取产品名
					$sql = "select *
					from `old_data_import`
					WHERE `mid` = ?
					and not `html` is null
					and type = 3
					limit 1";
				
					$product_result = $read->query($sql,array($product_id));
				
				
				
					foreach ($product_result as $row_p) {
							
						$attribute_code = $this->getAttributeCode($rs['option_name']);
						$option_id = $this->getOptionId($attribute_code,$rs['option_value_name']);
						$att_id = $this->getAttributeId($rs['option_name']);
						if (!in_array($att_id,$att_ids)) {
							$att_ids[] = $att_id;
						}
						$_attributeIds[$attribute_code] = $option_id;
						$cateIds = $this->getCategoryIds($product_id);
						var_dump($cateIds);
						//get product name
						$html = new simple_html_dom();
						$html->load($row_p['html']);
						$ret = $html->find('h1.productTitle');
						$product_name = '';
						if (count($ret)) {
							foreach ($ret as $e) {
								$product_name = trim($e->innertext);
								break;
							}
						}
						var_dump('name:' . $product_name);
				
						//get product shortdescription
						$ret_short_desc = $html->find('span.productShortDescription');
						$product_short_desc = '';
						if (count($ret_short_desc)) {
							foreach ($ret_short_desc as $e_short_desc) {
								$product_short_desc= trim($e_short_desc->innertext);
								break;
							}
						}
						var_dump('Short Desc:' . $product_short_desc);
				
						//get product description
						$ret_desc = $html->find('div.productLongDescription');
						$product_desc = '';
						if (count($ret_desc)) {
							foreach ($ret_desc as $e_desc) {
								$product_desc= trim($e_desc->innertext);
								break;
							}
						}
						var_dump('Desc:' . $product_desc);
				
						//get product price
				
						$product_price = 0;
						$sql_price = "select price from old_data_price where product_id=? limit 1";
				
				
						$results_price = $read->query($sql_price,array($row_p['mid']));
						foreach ($results_price as $data_price) {
							$product_price = (float)$data_price['price'];
						}
				
						var_dump('Price:' . $product_price);
					}
				
				
					$sProduct = Mage::getModel('catalog/product')->loadByAttribute('sku',$simple_sku);
					if (!$sProduct) {
						$sProduct = Mage::getModel('catalog/product');
						$sProduct
						->setTypeId(Mage_Catalog_Model_Product_Type::TYPE_SIMPLE)
						->setWebsiteIds(array(1))
						->setStatus(Mage_Catalog_Model_Product_Status::STATUS_ENABLED)
						->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE)
						->setAttributeSetId(4)
						->setCategoryIds($cateIds) // Populated further up the script
						->setSku($simple_sku)
						// $main_product_data is an array created as part of a wider foreach loop, which this code is inside of
						->setName($product_name)
						->setShortDescription($product_short_desc)
						->setDescription($product_desc)
						->setPrice(sprintf("%0.2f", $product_price))
						->setData($attribute_code, $option_id)
						;
				
						// Set the stock data. Let Magento handle this as opposed to manually creating a cataloginventory/stock_item model..
						$sProduct->setStockData(array(
								'is_in_stock' =>1,
								'qty' => 99999
						));
							
							
						$sProduct->save();
						array_push(
						$simpleProducts,
						array(
						"id" =>$sProduct->getId(),
						"price" =>$sProduct->getPrice(),
						"attr_code" =>$attribute_code,
						"attr_id" =>$att_id, // i have used the hardcoded attribute id of attribute size, you must change according to your store
						"value" =>$option_id,
						"label" =>$rs['option_value_name'],
						)
						);
							
						$productIds[]=$sProduct->getId();
						var_dump($sProduct->getSku() . ' saved');
					}
				}
				
				//save config product
				$cProduct = Mage::getModel('catalog/product')->loadByAttribute('sku',"c_" . $product_id);
				if (!$cProduct) {
					$cProduct = Mage::getModel('catalog/product');
					$cProduct
					->setTypeId('configurable')
					->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH)
					->setStatus(Mage_Catalog_Model_Product_Status::STATUS_ENABLED)
					->setWebsiteIds(array(1))
					->setCategoryIds($cateIds)
					->setAttributeSetId(4)
					->setSku("c_" . $product_id)
					->setName($product_name)
					->setShortDescription($product_short_desc)
					->setDescription($product_desc)
					->setPrice(sprintf("%0.2f", $product_price))
					->setUrlKey($product_id)
					;
				
				
				
					// Set stock data. Yes, it needs stock data. No qty, but we need to tell it to manage stock, and that it's actually
					// in stock, else we'll end up with problems later..
					$cProduct->setStockData(array(
							'manage_stock' => 1,
							'is_in_stock' => 1,
							'qty' => 0,
							'use_config_manage_stock' => 0
					));
				
				
					$cProduct->setCanSaveConfigurableAttributes(true);
					$cProduct->setCanSaveCustomOptions(true);
				
					$cProductTypeInstance = $cProduct->getTypeInstance();
					$attribute_ids = $att_ids;
					$cProductTypeInstance->setUsedProductAttributeIds($attribute_ids);
					$attributes_array = $cProductTypeInstance->getConfigurableAttributesAsArray();
					foreach($attributes_array as $key => $attribute_array)
					{
						$attributes_array[$key]['use_default'] = 1;
						$attributes_array[$key]['position'] = 0;
							
						if (isset($attribute_array['frontend_label']))
						{
							$attributes_array[$key]['label'] = $attribute_array['frontend_label'];
						}
						else {
							$attributes_array[$key]['label'] = $attribute_array['attribute_code'];
						}
					}
					// Add it back to the configurable product..
					$cProduct->setConfigurableAttributesData($attributes_array);
				
					$dataArray = array();
					foreach ($simpleProducts as $simpleArray) {
						$dataArray[$simpleArray['id']] = array();
						foreach ($attributes_array as $attrArray) {
							array_push(
							$dataArray[$simpleArray['id']],
							array(
							"attribute_id" => $simpleArray['attr_id'],
							"label" => $simpleArray['label'],
							"is_percent" => false,
							"value_index" => $simpleArray['value'],
							"pricing_value" => $product_price
							)
							);
						}
					}
				
					$cProduct->setConfigurableProductsData($dataArray);
					$cProduct->setCanSaveConfigurableAttributes(1);
				
				
					var_dump($dataArray);
					$cProduct->save();
				
					// Finally...!
				
					var_dump($cProduct->getSku().' data import success');
				
				
					//import product images
					//get images;
					$ret_main_images = $html->find('a.MagicZoom');
					$images = array();
				
					if (count($ret_main_images)) {
						foreach ($ret_main_images as $main_e) {
							$images[]=trim($main_e->href);
						}
					}
				
					//get additionnal images
					$ret_add_images = $html->find('div.productAdditionalImages div.productAdditionalImage img');
					if (count($ret_add_images)) {
						foreach ($ret_add_images as $add_e) {
							$images[] = trim($add_e->src);
						}
					}
				
					$this->importProductImages($images,$cProduct->getSku());
					var_dump($cProduct->getSku() . ' image import successed');
				}
		}
	}