I am magento developer and i know when we worked on test site than there is lot of dummy order and customer created on magento website . We used our local DB to live site db when we will go for live magento website. but before we can't delete dummy order or customer record in data base table. now i wrote a very easy script to delete all orders and customers in magento.
One More Important Thing for we don't need to open phpmyadmin for delete all orders and customers in magento
Note :- Please take a Data Base backup before run this script .
Step1:- Create a deleteCustomerAndOrder.php file in root folder
Step2:- paste below code and save the file.
<?php
require_once ("app/Mage.php");
$app = Mage::app('default');
$config = Mage::getConfig()->getResourceConnectionConfig("default_setup");
$dbinfo = array("host" => $config->host,
"user" => $config->username,
"pass" => $config->password,
"dbname" => $config->dbname
);
$hostname = $dbinfo["host"];
$user = $dbinfo["user"];
$password = $dbinfo["pass"];
$dbname = $dbinfo["dbname"];
$con = mysql_select_db($dbname,mysql_connect($hostname,$user,$password)) ;
$tablePrefix = (string) Mage::getConfig()->getTablePrefix();
// For Delete orders tables
$orderTableName = array (
'sales_flat_order',
'sales_flat_order_address',
'sales_flat_order_grid',
'sales_flat_order_item',
'sales_flat_order_status_history',
'sales_flat_quote',
'sales_flat_quote_address',
'sales_flat_quote_address_item',
'sales_flat_quote_item',
'sales_flat_quote_item_option',
'sales_flat_order_payment',
'sales_flat_quote_payment',
'sales_flat_shipment',
'sales_flat_shipment_item',
'sales_flat_shipment_grid',
'sales_flat_invoice',
'sales_flat_invoice_grid',
'sales_flat_invoice_item',
'sendfriend_log',
'tag',
'tag_relation',
'tag_summary',
'wishlist',
'log_quote',
'report_event'
);
mysql_query('SET FOREIGN_KEY_CHECKS=0');
for($ga=0;$ga<=(count($orderTableName)-1);$ga++){
mysql_query('TRUNCATE `'.$tablePrefix.$orderTableName[$ga].'`');
mysql_query('ALTER TABLE `'.$tablePrefix.$orderTableName[$ga].'` AUTO_INCREMENT=1');
}
// For Delete customer tables
$customerTableName = array (
'customer_address_entity',
'customer_address_entity_datetime',
'customer_address_entity_decimal',
'customer_address_entity_int',
'customer_address_entity_text',
'customer_address_entity_text',
'customer_address_entity_varchar',
'customer_entity',
'customer_entity_datetime',
'customer_entity_decimal',
'customer_entity_int',
'customer_entity_text',
'customer_entity_varchar',
'log_customer',
'log_visitor',
'log_visitor_info',
'log_visitor_info',
'eav_entity_store');
for($gau=0;$gau<=(count($customerTableName)-1);$gau++){
mysql_query('TRUNCATE `'.$tablePrefix.$customerTableName[$gau].'`');
mysql_query('ALTER TABLE `'.$tablePrefix.$customerTableName[$gau].'` AUTO_INCREMENT=1 ');
}
mysql_query('SET FOREIGN_KEY_CHECKS=1');
?>
Step3:- run this script on your browser.
http://yoursiteurl.com/deleteCustomerAndOrder.php
Guys I am always try to learn new things and post on my blog for our magento developers . Please give me your valuable feedback for encourage me to write more programming solutions.
Thanks
GA
One More Important Thing for we don't need to open phpmyadmin for delete all orders and customers in magento
Note :- Please take a Data Base backup before run this script .
Step1:- Create a deleteCustomerAndOrder.php file in root folder
Step2:- paste below code and save the file.
<?php
require_once ("app/Mage.php");
$app = Mage::app('default');
$config = Mage::getConfig()->getResourceConnectionConfig("default_setup");
$dbinfo = array("host" => $config->host,
"user" => $config->username,
"pass" => $config->password,
"dbname" => $config->dbname
);
$hostname = $dbinfo["host"];
$user = $dbinfo["user"];
$password = $dbinfo["pass"];
$dbname = $dbinfo["dbname"];
$con = mysql_select_db($dbname,mysql_connect($hostname,$user,$password)) ;
$tablePrefix = (string) Mage::getConfig()->getTablePrefix();
// For Delete orders tables
$orderTableName = array (
'sales_flat_order',
'sales_flat_order_address',
'sales_flat_order_grid',
'sales_flat_order_item',
'sales_flat_order_status_history',
'sales_flat_quote',
'sales_flat_quote_address',
'sales_flat_quote_address_item',
'sales_flat_quote_item',
'sales_flat_quote_item_option',
'sales_flat_order_payment',
'sales_flat_quote_payment',
'sales_flat_shipment',
'sales_flat_shipment_item',
'sales_flat_shipment_grid',
'sales_flat_invoice',
'sales_flat_invoice_grid',
'sales_flat_invoice_item',
'sendfriend_log',
'tag',
'tag_relation',
'tag_summary',
'wishlist',
'log_quote',
'report_event'
);
mysql_query('SET FOREIGN_KEY_CHECKS=0');
for($ga=0;$ga<=(count($orderTableName)-1);$ga++){
mysql_query('TRUNCATE `'.$tablePrefix.$orderTableName[$ga].'`');
mysql_query('ALTER TABLE `'.$tablePrefix.$orderTableName[$ga].'` AUTO_INCREMENT=1');
}
// For Delete customer tables
$customerTableName = array (
'customer_address_entity',
'customer_address_entity_datetime',
'customer_address_entity_decimal',
'customer_address_entity_int',
'customer_address_entity_text',
'customer_address_entity_text',
'customer_address_entity_varchar',
'customer_entity',
'customer_entity_datetime',
'customer_entity_decimal',
'customer_entity_int',
'customer_entity_text',
'customer_entity_varchar',
'log_customer',
'log_visitor',
'log_visitor_info',
'log_visitor_info',
'eav_entity_store');
for($gau=0;$gau<=(count($customerTableName)-1);$gau++){
mysql_query('TRUNCATE `'.$tablePrefix.$customerTableName[$gau].'`');
mysql_query('ALTER TABLE `'.$tablePrefix.$customerTableName[$gau].'` AUTO_INCREMENT=1 ');
}
mysql_query('SET FOREIGN_KEY_CHECKS=1');
?>
Step3:- run this script on your browser.
http://yoursiteurl.com/deleteCustomerAndOrder.php
Guys I am always try to learn new things and post on my blog for our magento developers . Please give me your valuable feedback for encourage me to write more programming solutions.
Thanks
GA
No comments:
Post a Comment