服务报价 | 域名主机 | 网络营销 | 软件工具| [加入收藏]
 热线电话: #
当前位置: 主页 > php教程 > magento教程 >

批量复制Magento产品分类目录

时间:2013-12-16 01:46来源:未知 作者:最模板 点击:
在使用Magento的时候,由于分类越来越多,有时候想复制一下分类,省点儿事儿,原来的操作有些麻烦, 故写下此,帮助那么想要复制目录的人: ?php if(!is_numeric($_GET))die(Please specify a c
在使用Magento的时候,由于分类越来越多,有时候想复制一下分类,省点儿事儿,原来的操作有些麻烦,
故写下此,帮助那么想要复制目录的人:
<?php


if(!is_numeric($_GET))die('Please specify a category ID');

$catId=$_GET;

$xml=simplexml_load_file('app/etc/local.xml');
$host=$xml->global->resources->default_setup->connection->host;
$username=$xml->global->resources->default_setup->connection->username;
$password=$xml->global->resources->default_setup->connection->password;
$dbname=$xml->global->resources->default_setup->connection->dbname;
$res=mysql_pconnect($host,$username,$password);
mysql_select_db($dbname);




$catsDone=0;
duplicate_entity($catId);
echo$catsDone.' Categories duplicated.';

function duplicate_entity($id,$parent_id=null){
global$catsDone;


// Grab category to copy
$sql="SELECT * FROM catalog_category_entity WHERE entity_id = ".$id;
$query_entity=mysql_query($sql);

$entity=mysql_fetch_object($query_entity);


if(!$parent_id)$parent_id=$entity->parent_id;




mysql_query("INSERT INTO catalog_category_entity (entity_type_id, attribute_set_id, parent_id, created_at, updated_at, path, position, level, children_count)
VALUES ({$entity->entity_type_id}, {$entity->attribute_set_id}, {$parent_id}, NOW(), NOW(), '', {$entity->position}, {$entity->level}, {$entity->children_count})");
$newEntityId=mysql_insert_id();

$query=mysql_query("SELECT path FROM catalog_category_entity WHERE entity_id = ".$parent_id);
$parent=mysql_fetch_object($query);
$path=$parent->path.'/'.$newEntityId;

mysql_query("UPDATE catalog_category_entity SET path='".$path."' WHERE entity_id=".$newEntityId);


foreach(array('datetime','decimal','int','text','varchar')as$dataType){
$sql="SELECT * FROM catalog_category_entity_".$dataType."
WHERE entity_id=".$entity->entity_id;
//die($sql);
$query=mysql_query($sql);
while($value=mysql_fetch_object($query)){
mysql_query("INSERT INTO catalog_category_entity_".$dataType." (entity_type_id, attribute_id, store_id, entity_id, value)
VALUES ({$value->entity_type_id}, {$value->attribute_id}, {$value->store_id}, {$newEntityId}, '{$value->value}')");
}
}


$sql="SELECT entity_id FROM catalog_category_entity WHERE parent_id = ".$id;
$query=mysql_query($sql);

while($entity=mysql_fetch_object($query)){
duplicate_entity($entity->entity_id,$newEntityId);
}
$catsDone++;
}





?>
请把以上代码保存为1.PHP,放置到Magento安装根目录,然后在浏览器里运行://www.zuimoban.com/1.php?id=[您想要复制的分类目录ID]
分类目录ID可在Magento后台分类里查看得到(责任编辑:最模板)
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
栏目列表
热点内容