如何Magento以编程方式删除订单_magento教程_php教程

你有没有问自己如何删除在Magento创建的测试顺序？你有Magento的项目，你放一些测试订单，看看是否如预期航运及付款方式工作。一切都显得凉爽，客户希望推出该网站。你启动它。当你推出后进入政府的第一次，你会看到所有的测试订单出现。你知道这些订单应该被删除。怎么会呢？

如果您尝试在后台删除订单，你会发现，你只能将状态设置为“已取消”，订单还是有的。不幸的是，Magento的不使我们能够删除那些通过行政，所以你不会看到任何“删除订单”按钮。这既可以是为开发者和商家很令人沮丧。

在这篇文章中，我们将通过如何删除单笔订单，所有订单

如何删除单笔订单使用phpMyAdmin

您需要在使用phpMyAdmin数据库运行下面的查询：

set @increment_id='200000111';

select @order_id:=entity_id from prefix_sales_order_entity where increment_id=@increment_id;

delete from prefix_sales_order_entity where entity_id=@order_id or parent_id=@order_id;

delete from prefix_sales_order where increment_id=@increment_id;

在上面的例子中，我们正在试图删除的测试订单＃“200000111”。一般人使用前缀，以便改变你已经选择了你的Magento商店前缀上述查询的“prefix_”。

上面的查询将会删除你的Magento商店的单个测试订单，甚至是实际的订单。所有你需要做的就是提供一个订单号码和数据库的前缀。其余将采取自动处理。

删除所有Magento的订单一下子

此步骤仅在新店的准备forproduction，不系统有任何“实际订单”完成的。我会强烈建议采取完整备份，然后再继续。基本上，当你运行下面的查询您的Magento数据库将完成消灭所有的记录和重置的顺序计数器。如果您要放纵，那么请确保你知道你在做什么。

请注意：下面的步骤不能颠倒。

方法1：在Magento的根文件夹中的PHP脚本，这段代码复制到脚本并运行脚本。

/**

* @author Dejan Radic <dejan.radic@inchoo.net>

if (version_compare(phpversion(), '5.2.0', '<')===true) {

echo '<div style="font:12px/1.35em arial, helvetica, sans-serif;"><div style="margin:0 0 25px 0; border-bottom:1px solid #ccc;"><h3 style="margin:0; font-size:1.7em; font-weight:normal; text-transform:none; text-align:left; color:#2f2f2f;">Whoops, it looks like you have an invalid PHP version.</h3></div><p>Magento supports PHP 5.2.0 or newer. <a href="http://www.magentocommerce.com/install" target="">Find out</a> how to install</a> Magento using PHP-CGI as a work-around.</p></div>';

exit;

}

error_reporting(E_ALL | E_STRICT);

ini_set('display_errors', 1);

$mageFilename = 'app/Mage.php';

if (!file_exists($mageFilename)) {

echo $mageFilename." was not found";

exit;

}

require_once $mageFilename;

Mage::app();

$executionPath = null;

* determine Magento Edition

if (file_exists('LICENSE_EE.txt')) {

$edition = 'EE';

}elseif (file_exists('LICENSE_PRO.html')) {

$edition = 'PE';

} else {

$edition = 'CE';

}

if(($edition=='EE' && version_compare(Mage::getVersion(), '1.11.0.0.', '<')===true)

|| ($edition=='PE' && version_compare(Mage::getVersion(), '1.11.0.0.', '<')===true)

|| ($edition=='CE' && version_compare(Mage::getVersion(), '1.6.0.0.', '<')===true)

){

$executionPath = 'old';

} else {

$executionPath = 'new';

}

$xpathEntity = 'global/models/sales_entity/entities//table';

if ($executionPath == 'old') {

$xpathResource = 'global/models/sales_mysql4/entities//table';

} else {

$xpathResource = 'global/models/sales_resource/entities//table';

}

$salesEntitiesConf = array_merge(

Mage::getSingleton('core/config')->init()->getXpath($xpathEntity),

Mage::getSingleton('core/config')->init()->getXpath($xpathResource)

);

$resource = Mage::getSingleton('core/resource');

$connection = $resource->getConnection('core_write');

* If you want delete System/Order Statuses (Status and State) you

* should comments below lines (46-51)

$skipTables = array (

$resource->getTableName('sales_order_status'),

$resource->getTableName('sales_order_status_state'),

$resource->getTableName('sales_order_status_label')

);

$salesEntitiesConf = array_diff($salesEntitiesConf, $skipTables);

Multiple RDBMS Support in Magento CE 1.6+ / EE 1.11+

http://www.magentocommerce.com/images/uploads/RDBMS_Guide2.pdf

2.2. Adapters:

... The new Varien_DB_Adapter_Interface was added to sign a contract that all

developed adapters must execute in order to get Magento working on an actual

database. The interface describes the list of methods and constants that can be used by resource models...

Used below in the loop:

* If $executionPath == 'old'

* Varien_Db_Adapter_Pdo_Mysql::showTableStatus()

* Varien_Db_Adapter_Pdo_Mysql::truncate()

* Else

* Varien_Db_Adapter_Interface::isTableExists()

* Varien_Db_Adapter_Interface::truncateTable()

while ($table = current($salesEntitiesConf) ){

$table = $resource->getTableName($table);

if ($executionPath == 'old') {

$isTableExists = $connection->showTableStatus($table);

} else {

$isTableExists = $connection->isTableExists($table);

}

if ($isTableExists) {

try {

if ($executionPath == 'old') {

$connection->truncate($table);

} else {

$connection->truncateTable($table);

}

printf('Successfully truncated the <i style="color:green;">%s</i> table.<br />', $table);

} catch(Exception $e) {

printf('Error <i style="color:red;">%s</i> occurred truncating the <i style="color:red;">%s</i> table.<br />', $e->getMessage(), $table);

}

next($salesEntitiesConf);

}

exit('All done...');

方法2：进入phpMyAdmin的和运行SQL查询

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE `sales_order`;

TRUNCATE `sales_order_datetime`;

TRUNCATE `sales_order_decimal`;

TRUNCATE `sales_order_entity`;

TRUNCATE `sales_order_entity_datetime`;

TRUNCATE `sales_order_entity_decimal`;

TRUNCATE `sales_order_entity_int`;

TRUNCATE `sales_order_entity_text`;

TRUNCATE `sales_order_entity_varchar`;

TRUNCATE `sales_order_int`;

TRUNCATE `sales_order_text`;

TRUNCATE `sales_order_varchar`;

TRUNCATE `sales_flat_quote`;

TRUNCATE `sales_flat_quote_address`;

TRUNCATE `sales_flat_quote_address_item`;

TRUNCATE `sales_flat_quote_item`;

TRUNCATE `sales_flat_quote_item_option`;

TRUNCATE `sales_flat_order_item`;

TRUNCATE `sendfriend_log`;

TRUNCATE `tag`;

TRUNCATE `tag_relation`;

TRUNCATE `tag_summary`;

TRUNCATE `wishlist`;

TRUNCATE `log_quote`;

TRUNCATE `report_event`;

ALTER TABLE `sales_order` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_datetime` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_decimal` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_int` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_text` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_varchar` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;

ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;

ALTER TABLE `tag` AUTO_INCREMENT=1;

ALTER TABLE `tag_relation` AUTO_INCREMENT=1;

ALTER TABLE `tag_summary` AUTO_INCREMENT=1;

ALTER TABLE `wishlist` AUTO_INCREMENT=1;

ALTER TABLE `log_quote` AUTO_INCREMENT=1;

ALTER TABLE `report_event` AUTO_INCREMENT=1;

-- lets reset customers

TRUNCATE `customer_address_entity`;

TRUNCATE `customer_address_entity_datetime`;

TRUNCATE `customer_address_entity_decimal`;

TRUNCATE `customer_address_entity_int`;

TRUNCATE `customer_address_entity_text`;

TRUNCATE `customer_address_entity_varchar`;

TRUNCATE `customer_entity`;

TRUNCATE `customer_entity_datetime`;

TRUNCATE `customer_entity_decimal`;

TRUNCATE `customer_entity_int`;

TRUNCATE `customer_entity_text`;

TRUNCATE `customer_entity_varchar`;

TRUNCATE `log_customer`;

TRUNCATE `log_visitor`;

TRUNCATE `log_visitor_info`;

ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `log_customer` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;

-- Now, lets Reset all ID counters

TRUNCATE `eav_entity_store`;

ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

可选：如果您正在寻找并设置适当的前缀订单，发票，发货，贷项通知单，然后运行下面的查询，以及：

update `eav_entity_store` set `increment_prefix`= 1 where `entity_type_id`='4' and `store_id`='1';

update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='4' and `store_id`='1';

INSERT INTO `YOUR_DB_NAME`.`eav_entity_store` (`entity_store_id` ,`entity_type_id` ,`store_id` ,`increment_prefix` ,`increment_last_id`) VALUES ('2', '16', '1', '2', '000000000');

update `eav_entity_store` set `increment_prefix`= 2 where `entity_type_id`='18' and `store_id`='1';

update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='18' and `store_id`='1';

INSERT INTO `YOUR_DB_NAME`.`eav_entity_store` (`entity_store_id` ,`entity_type_id` ,`store_id` ,`increment_prefix` ,`increment_last_id`) VALUES ('3', '19', '1', '3', '000000000');

update `eav_entity_store` set `increment_prefix`= 3 where `entity_type_id`='24' and `store_id`='1';

update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='24' and `store_id`='1';

INSERT INTO `YOUR_DB_NAME`.`eav_entity_store` (`entity_store_id` ,`entity_type_id` ,`store_id` ,`increment_prefix` ,`increment_last_id`) VALUES ('4', '23', '1', '4', '000000000');

update `eav_entity_store` set `increment_prefix`= 4 where `entity_type_id`='28' and `store_id`='1';

update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='28

如果您遇到任何麻烦吗？随意滴评论，让我知道。

(责任编辑：好模板)