如何从magento删除测试订单 [英] how can I delete test order from magento

问题描述

我已经在magento建立了一个网站.现在它已经上线了，我想删除所有测试订单.我知道所有这些顺序中都有一些表被存储.但我不知道这些表的名称.如果某个主体具有可以删除所有订单数据的脚本.

I have made a website in magento. Now it is live and I want to delete the all test order. I know there are some table in all these order are stored. but I don't know the name of those table. If some body has any script which can delete the all the order data.

请给我或提及所有存储订单信息的表的名称

Please give me or please mention the name of all the tables which stores the order information

推荐答案

1. 转到admin> sales>订单
2. 写下测试订单的增量ID，例如 100000001,100000002,100000003,100000111,100000112,100000199
3. 现在在magento根目录中创建一个php文件，并将其命名为:remove_test_orders.php

4. 粘贴以下代码:

1. Go to admin>sales>orders
2. Write down your test orders incremental ids, for example 100000001,100000002,100000003,100000111,100000112,100000199
3. now create a php file in magento root directory and name it: remove_test_orders.php

4. Paste the code below:

require 'app/Mage.php';
Mage::app('admin')->setUseSessionInUrl(false);                                                                                                                 
//replace your own orders numbers here:
$test_order_ids=array(
  '100000001',
  '100000002',
  '100000003',
  '100000111',
  '100000112',
  '100000199',
);
foreach($test_order_ids as $id){
    try{
        Mage::getModel('sales/order')->loadByIncrementId($id)->delete();
        echo "order #".$id." is removed".PHP_EOL;
    }catch(Exception $e){
        echo "order #".$id." could not be remvoved: ".$e->getMessage().PHP_EOL;
    }
}
echo "complete.";

现在转到命令行并运行:

Now go to command line and run:

php remove_test_orders.php

php remove_test_orders.php

最后，删除remove_test_orders.php.

At the end, delete remove_test_orders.php.

这篇关于如何从magento删除测试订单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！