共计 6663 个字符，预计需要花费 17 分钟才能阅读完成。
关于magento的订单删除，好像涉及到法律的问题，所以magento，没有这个功能，虽然本身没有这个功能，也是有插件的，可以实现，但是magento的1.4.2不好用，所以，用sql删除也是不错的选择
通过下面的sql语句进行删除，删除前先备份：
1.4版本：
SET FOREIGN_KEY_CHECKS=0;
TRUNCATE `catalogsearch_query`;
ALTER TABLE `catalogsearch_query` AUTO_INCREMENT=1;
TRUNCATE `sales_flat_creditmemo`;
TRUNCATE `sales_flat_creditmemo_comment`;
TRUNCATE `sales_flat_creditmemo_grid`;
TRUNCATE `sales_flat_creditmemo_item`;
TRUNCATE `sales_flat_invoice`;
TRUNCATE `sales_flat_invoice_comment`;
TRUNCATE `sales_flat_invoice_grid`;
TRUNCATE `sales_flat_invoice_item`;
TRUNCATE `sales_flat_order`;
TRUNCATE `sales_flat_order_address`;
TRUNCATE `sales_flat_order_grid`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sales_flat_order_payment`;
TRUNCATE `sales_flat_order_status_history`;
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_quote_payment`;
TRUNCATE `sales_flat_quote_shipping_rate`;
TRUNCATE `sales_flat_shipment`;
TRUNCATE `sales_flat_shipment_comment`;
TRUNCATE `sales_flat_shipment_grid`;
TRUNCATE `sales_flat_shipment_item`;
TRUNCATE `sales_flat_shipment_track`;
TRUNCATE `sales_invoiced_aggregated`;
TRUNCATE `sales_invoiced_aggregated_order`;
TRUNCATE `sales_order_aggregated_created`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;
ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_status_history` 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_quote_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_aggregated_created` 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;
SET FOREIGN_KEY_CHECKS=1;
老版本，大致，1,3！！
Delete test orders in Magento
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;-- reset customersTRUNCATE`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;-- Reset all ID countersTRUNCATE`eav_entity_store`;ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;SET FOREIGN_KEY_CHECKS=1; |
缺点就是删除的是全部，而不是一部分，所以实用范围为，模板制作测试遗留的订单删除，而不适应于上线的网站！
多乐士
通过摸索发现ssh拉取会报错，直接网页访问下载会报404错误，不知道原因；但是可以通过群晖CM注册表访问下载，其方法如下：
Container Manager-注册表-设置-新增-注册表名称随便写，注册表URL填你的加速地址，勾选信任的SSL自我签署证书，登录信息不填-应用-使用你的地址，这是注册表会显示了，在搜索栏中输入映像名称，搜索结果在每一页的最后一个，你需要划到最后一个进行下载，实测可正常下载安装。
以上供网友参考。
辞了老衲
这个确实有帮助。
渋驀
当然任何时候都可以用curl命令和crontab来实现动态更新DDNS的ip地址：
1、安装crontab之后为root用户创建文件/var/spool/cron/root
2、创建并配置ddnsupdate.sh，放到/usr/bin/文件下，文件内容(以he.net为例）：
Autodetect my IPv4/IPv6 address:
IPV4：curl -4 "http://dyn.example.com:password@dyn.dns.he.net/nic/update?hostname=dyn.example.com"
IPV6：curl -6 "http://dyn.example.com:password@dyn.dns.he.net/nic/update?hostname=dyn.example.com"
3、添加执行权限chomod +x /usr/bin/ddnsupdate.sh
4、编辑root用户的crontab：*/10 * * * * /usr/binddnsupdate.sh，每10分钟执行一次。好了，可以享受你的DDNS了
21410
请问下载链接在那里？
madkylin
不错，不错，谢谢分享了，好东西啊 
feilung
求方法
zengsuyi
应该挺不错的
zise
看看是怎么操作的。。 
