Created
December 4, 2014 14:47
-
-
Save vestman/5d9ce0c51869b33a8f51 to your computer and use it in GitHub Desktop.
Magento - Copy/duplicate Categories
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
if(!is_numeric($_GET['id']))die('Please specify a category ID'); | |
$catId = $_GET['id']; | |
$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); | |
// Fix the children count for all (sub)categories | |
$sql = "CREATE TABLE catalog_category_entity_tmp LIKE catalog_category_entity"; | |
mysql_query($sql); | |
$sql = "INSERT INTO catalog_category_entity_tmp SELECT * FROM catalog_category_entity"; | |
mysql_query($sql); | |
$sql = "UPDATE catalog_category_entity cce SET children_count = ( SELECT count(cce2.entity_id) – 1 as children_county FROM catalog_category_entity_tmp cce2 WHERE PATH LIKE CONCAT(cce.path,'%') )"; | |
mysql_query($sql); | |
$sql = "DROP TABLE catalog_category_entity_tmp"; | |
mysql_query($sql); | |
echo $catsDone . '<p>Categories duplicated.</p>'; | |
function duplicate_entity($id, $parent_id = null) { | |
global $catsDone; | |
mysql_query("SET NAMES 'utf8'"); | |
// 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; | |
$query = mysql_query($sql); | |
while ($value = mysql_fetch_object($query)) if (is_null($value->value)) { | |
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}, NULL)"); | |
} else { | |
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}')"); | |
} | |
} | |
//for Products | |
$sql = "SELECT * FROM catalog_category_product WHERE category_id = " . $id; | |
$query = mysql_query($sql); | |
while ($value = mysql_fetch_object($query)) { | |
$sql = "INSERT INTO catalog_category_product (category_id, product_id, position) VALUES ({$newEntityId},{$value->product_id},{$value->position})"; | |
echo $sql; | |
if(!mysql_query($sql)) | |
echo("Error"); | |
} | |
$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++; | |
} | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment