本文介绍了一个用于Magento平台的PHP脚本，该脚本能够批量导入具有单一可配置选项的简单商品及其对应的可配置商品。脚本通过数据库查询确定商品ID，并自动创建相应的简单商品与可配置商品，同时设置必要的属性如价格、描述等。
只有一种选项的简单商品和可配置商品
例如：某鞋子有尺寸这一可选项: (尺码：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');
}
}
}
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
