I have to test things on the live site because my client insists on my doing so. I know that he will want/need to be able to easily remove test orders or any incomplete orders. I really hope that removing orders or resetting the sales related part of the db will become easier to do in future versions of Magento.
FWIW I tried the version posted by Sensi, under 1.1.2, and it appears to have worked. I have not yet processed any orders since then though—will have to wait until I get a real live customer!!
could it be a problem to keep those “old orders” and having the same order-id later? isn’t this just an alias for the order id? when i click on an order in the backend, my order id says 4546377 and the url is /admin/sales_order/view/order_id/21/ --> so I could reset the start increment_id to 4546370 and another 4546377 will be no problem. correct?
anyone know if there is plans to fix this in V1.1.4?
Im just about to upgrade a couple of sites but Il hold of till the next release if you will be able to delete orders.
I know virtually nothing about my-sql but is there anyway someone could adapt the scripts on this thread to selectively delete certain orders and not just all of them?
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;
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 counters TRUNCATE `eav_entity_store`; ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;
Banyaknya order yang tidak di proses malah bikin bingung.
Kalau bisa dihapus saja, tapi bagaimana caranya ????
Delete Order button nya kok belum dibikin.
Please could you let us know what info/data needs to be deleted & in what tables if we want to delete an order.
If I know this ‘officially’ then I can write a module to add a delete button to the orders and the huge over-site of not having a delete order button problem can be solved, I just don’t want to go around deleting things that will break ‘other’ things.
Option to delete entire order, ie. test orders,
Need to be able to delete credit card data for those processing offline, card number & exp date.
ability to set starting order number ie. 0004567 instead of 0000001
Sales: Call 877.832.5289 (N America)|310.295.4144 (International)
