问题描述

我用 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. 转到管理>销售>订单
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.";