Magento batch clear products and categories_PHP tutorial-PHP Tutorial-php.cn

Magento batch clear products and categories_PHP tutorial

WBOY

Release： 2016-07-13 17:44:42

Original

888 people have browsed it

When developing magento and debugging templates, you need to add some categories and products. It will be very troublesome when the website is officially launched, so I wrote a php myself to clear products and categories

$path="/var/html" //Website directory

//include("mysql.class.php");

if($_POST[web]){

$web=$_POST[web];

$xml=simplexml_load_file("/$path/$web/app/etc/local.xml");

$dbname=$xml->global->resources->default_setup->connection->dbname;

$password=$xml->global->resources->default_setup->connection->password;

$username=$xml->global->resources->default_setup->connection->username;

echo "dbname:$dbname"."
";

echo "password:$password"."
";

$mysqli=new mysqli("localhost","$username","$password","$dbname");

//The following is the clear statement

$csql1="TRUNCATE TABLE `catalog_category_entity`";

$csql2="TRUNCATE TABLE `catalog_category_entity_datetime`";

$csql3="TRUNCATE TABLE `catalog_category_entity_decimal`";

$csql4="TRUNCATE TABLE `catalog_category_entity_int`";

$csql5="TRUNCATE TABLE `catalog_category_entity_text`";

$csql6="TRUNCATE TABLE `catalog_category_entity_varchar`";

$csql7="TRUNCATE TABLE `catalog_category_product`";

$csql8="TRUNCATE TABLE `catalog_category_product_index`";

$csql9="INSERT INTO `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`POSITION`,`level`,`children_count`) VALUES (1,3,0,0,'0000-00-00 00:00:00','2009-02-20 00:25:34','1',1,0,1),(2, 3,3,0,'2009-02-20 00:25:34','2009-02-20 00:25:34','1/2',1,1,0)";

$csql10="INSERT INTO `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,32,0,2,1),( 2,3,32,1,2,1)";

$csql11="INSERT INTO `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,31,0,1,'Root Catalog' ),(2,3,33,0,1,'root-catalog'),(3,3,31,0,2,'Default Category'),(4,3,39,0,2,'PRODUCTS '),(5,3,33,0,2,'default-category')";

$sqls="$csql1;$csql2;$csql3;$csql4;$csql5;$csql6;$csql7;$csql8;$csql9;$csql10;$csql11";

$dsql="TRUNCATE TABLE `catalog_product_bundle_option`;";

$dsql.=" TRUNCATE TABLE `catalog_product_bundle_option_value`;";

$dsql.=" TRUNCATE TABLE `catalog_product_bundle_selection`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_datetime`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_decimal`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_gallery`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_int`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_media_gallery`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_text`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_tier_price`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity_varchar`;";

$dsql.=" TRUNCATE TABLE `catalog_product_link`;";

$dsql.=" TRUNCATE TABLE `catalog_product_link_attribute`;";

$dsql.=" TRUNCATE TABLE `catalog_product_link_attribute_decimal`;";

$dsql.=" TRUNCATE TABLE `catalog_product_link_attribute_int`;";

$dsql.=" TRUNCATE TABLE `catalog_product_link_attribute_varchar`;";

$dsql.=" TRUNCATE TABLE `catalog_product_link_type`;";

$dsql.=" TRUNCATE TABLE `catalog_product_option`;";

$dsql.=" TRUNCATE TABLE `catalog_product_option_price`;";

$dsql.=" TRUNCATE TABLE `catalog_product_option_title`;";

$dsql.=" TRUNCATE TABLE `catalog_product_option_type_price`;";

$dsql.=" TRUNCATE TABLE `catalog_product_option_type_title`";

$dsql.=" TRUNCATE TABLE `catalog_product_option_type_value`;";

$dsql.=" TRUNCATE TABLE `catalog_product_super_attribute`;";

$dsql.=" TRUNCATE TABLE `catalog_product_super_attribute_label`;";

$dsql.=" TRUNCATE TABLE `catalog_product_super_attribute_pricing`;";

$dsql.=" TRUNCATE TABLE `catalog_product_super_link`;";

$dsql.=" TRUNCATE TABLE `catalog_product_enabled_index`;";

$dsql.=" TRUNCATE TABLE `catalog_product_website`;";

$dsql.=" TRUNCATE TABLE `catalog_product_entity`;";

$dsql.=" TRUNCATE TABLE `cataloginventory_stock`;";

$dsql.=" TRUNCATE TABLE `cataloginventory_stock_item`;";

$dsql.=" TRUNCATE TABLE `cataloginventory_stock_status`;";

$dsql.=" INSERT INTO `catalog_product_link_type`(`link_type_id`,`code`) VALUES (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');";

$dsql.=" INSERT INTO `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) VALUES (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');";

$dsql.=" INSERT INTO `cataloginventory_stock`(`stock_id`,`stock_name`) VALUES (1,'Default')";

echo $sqls."
";

echo $dsql."
";

$sql="$dsql;$sqls";

if($mysqli->multi_query($sql)){

echo "CheckProduct Ok".$mysqli->insert_id."
";

echo "affected_rows".$mysqli->affected_rows."
";

}

else{

echo"CheckProduct false";

}

$mysqli->close();