Created
November 25, 2020 13:26
-
-
Save lewisvoncken/ba007f8cc6ce3a554707a154c8c8d001 to your computer and use it in GitHub Desktop.
Duplicate Category Community (or Enterprise without Staging Modules)
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 | |
// use shell_exec("mysql -e '{$sql}'"); for mysql_query or use pdo or something | |
$catId = 2; | |
$xml = simplexml_load_file('app/etc/local.xml'); | |
$host = ""; | |
$username = ""; | |
$password = ""; | |
$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