Magento no té implementada l'eliminació de comandes cancel·lades. L'eliminació de factures, factures de devolució i albarans no és convenient per tenir sempre un històric.

Si tenim una web de prova i volem eliminar totes les comandes, factures, albarans, … de prova que hem introduït fins aquest moment ho podem fer amb (prèviament feu backup de la base de dades):

Magento 1.1

TRUNCATE `mgn_sales_order`;
TRUNCATE `mgn_sales_order_datetime`;
TRUNCATE `mgn_sales_order_decimal`;
TRUNCATE `mgn_sales_order_entity`;
TRUNCATE `mgn_sales_order_entity_datetime`;
TRUNCATE `mgn_sales_order_entity_decimal`;
TRUNCATE `mgn_sales_order_entity_int`;
TRUNCATE `mgn_sales_order_entity_text`;
TRUNCATE `mgn_sales_order_entity_varchar`;
TRUNCATE `mgn_sales_order_int`;
TRUNCATE `mgn_sales_order_tax`;
TRUNCATE `mgn_sales_order_text`;
TRUNCATE `mgn_sales_order_varchar`;
TRUNCATE `mgn_sales_flat_order_item`;
TRUNCATE `mgn_sales_flat_quote`;
TRUNCATE `mgn_sales_flat_quote_address`;
TRUNCATE `mgn_sales_flat_quote_address_item`;
TRUNCATE `mgn_sales_flat_quote_item`;
TRUNCATE `mgn_sales_flat_quote_item_option`;
TRUNCATE `mgn_sales_flat_quote_payment`;
TRUNCATE `mgn_sales_flat_quote_shipping_rate`;
TRUNCATE `mgn_sendfriend_log`;
TRUNCATE `mgn_tag`;
TRUNCATE `mgn_tag_relation`;
TRUNCATE `mgn_tag_summary`;
TRUNCATE `mgn_wishlist`;
TRUNCATE `mgn_wishlist_item`;
TRUNCATE `mgn_log_quote`;
TRUNCATE `mgn_report_event`;

ALTER TABLE `mgn_sales_order` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_datetime` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_decimal` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_entity` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_int` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_tax` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_text` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_order_varchar` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_quote_payment` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
ALTER TABLE `mgn_sendfriend_log` AUTO_INCREMENT=1;
ALTER TABLE `mgn_tag` AUTO_INCREMENT=1;
ALTER TABLE `mgn_tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `mgn_tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `mgn_wishlist` AUTO_INCREMENT=1;
ALTER TABLE `mgn_wishlist_item` AUTO_INCREMENT=1;
ALTER TABLE `mgn_log_quote` AUTO_INCREMENT=1;
ALTER TABLE `mgn_report_event` AUTO_INCREMENT=1;

Magento 1.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_quote`;
TRUNCATE `sales_quote_address`;
TRUNCATE `sales_quote_address_decimal`;
TRUNCATE `sales_quote_address_int`;
TRUNCATE `sales_quote_address_text`;
TRUNCATE `sales_quote_address_varchar`;
TRUNCATE `sales_quote_decimal`;
TRUNCATE `sales_quote_entity`;
TRUNCATE `sales_quote_entity_datetime`;
TRUNCATE `sales_quote_entity_decimal`;
TRUNCATE `sales_quote_entity_int`;
TRUNCATE `sales_quote_entity_text`;
TRUNCATE `sales_quote_entity_varchar`;
TRUNCATE `sales_quote_int`;
TRUNCATE `sales_quote_item`;
TRUNCATE `sales_quote_item_decimal`;
TRUNCATE `sales_quote_item_int`;
TRUNCATE `sales_quote_item_text`;
TRUNCATE `sales_quote_item_varchar`;
TRUNCATE `sales_quote_rule`;
TRUNCATE `sales_quote_text`;
TRUNCATE `sales_quote_varchar`;
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_quote` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_rule` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_quote_varchar` 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;

Si també es vol fer un reset dels clients:

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; 

I després podeu inicialitzar la numeració comandes, factures, albarans, ....