Magento - How to delete orders complete? - 'How do I' Questions - eCommerce Software for Growth, Powered by Open Source

Skip to site navigation »
Skip to main content »
Skip to footer content »

Sales: Call 877.832.5289 (N America)|310.295.4144 (International)

Magento Forum

How to delete orders complete?

R.Verheij Total Posts: 16 Joined: 2008-04-08 Amsterdam, Netherlands Ignore user	Hi, I just got the most recent code from above and used it on a 1.1.1 database. Many tables do not exist any more, so I deleted old tables from the script, and will post the script here, but notice that I did not check if any new tables in 1.1.1 should also be truncated 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 `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 `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 customers 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; -- Reset all ID counters TRUNCATE `eav_entity_store`; ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;
	Posted: July 30 2008 \| top \| # 46

roshangmail Total Posts: 28 Joined: 2008-05-18 Ignore user	i m confused in this query which one is the right one to delete the order listing in admin pannel 1 select @order_id:=entity_id from sales_order_entity where increment_id=’100000001’; delete from sales_order_entity where entity_id=@order_id or parent_id=@order_id; 2 select @order_id:=entity_id from sales_order where increment_id=’100000001’; delete from sales_order where entity_id=@order_id or parent_id=@order_id; which one is correct??? Magento ver. 1.0.19870 Signature Want to be a good programer But eva succed!!! :s
	Posted: July 31 2008 \| top \| # 47

I'm Done Total Posts: 32 Joined: 2008-05-08 Ignore user	leeaston - 30 July 2008 12:56 AM Hello, anyone tested the iceburn004 code in 1.1.1? Best wishes Lee Are you saying this option of deleting orders is not available in 1.1.1 yet?!
	Posted: July 31 2008 \| top \| # 48

Sensi Total Posts: 69 Joined: 2008-07-31 Paris, France Ignore user	Hi to everybody! R.Verheij - 30 July 2008 05:46 AM Hi, I just got the most recent code from above and used it on a 1.1.1 database. Many tables do not exist any more, so I deleted old tables from the script, and will post the script here, but notice that I did not check if any new tables in 1.1.1 should also be truncated Thank you R.Verheij, I just had to add the “sales_flat_order_item” table and it looks like that did the trick. 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`; # added 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; # added 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 customers 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; -- Reset all ID counters TRUNCATE `eav_entity_store`; ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1; Signature Friends: Kaipifraise web agency
	Posted: August 1 2008 \| top \| # 49

ALEON™ Total Posts: 10 Joined: 2008-06-09 Ignore user	Hi folks So that means I can run this query and it removes all orders without ghost-entries or death-entries? Cheers
	Posted: August 4 2008 \| top \| # 50

infield Total Posts: 67 Joined: 2007-11-04 San Francisco Ignore user	Anyone know how to make the starting order something besides 10000000? We would like to make it 200000000.
	Posted: August 4 2008 \| top \| # 51

gamelodge Total Posts: 89 Joined: 2007-08-31 Brisbane, Qld, Australia Ignore user	Why are the magento team so quite?
	Posted: August 5 2008 \| top \| # 52

gamelodge Total Posts: 89 Joined: 2007-08-31 Brisbane, Qld, Australia Ignore user	@R.Verheij & Sensi - v1.1.2 SQL query: TRUNCATE `sales_flat_quote` ; MySQL said: Documentation #1217 - Cannot delete or update a parent row: a foreign key constraint fails
	Posted: August 6 2008 \| top \| # 53

Michael Total Posts: 684 Joined: 2007-08-31 Ignore user	infield - 04 August 2008 07:45 AM Anyone know how to make the starting order something besides 10000000? We would like to make it 200000000. Check the eav_entity_store table
	Posted: August 6 2008 \| top \| # 54

ALEON™ Total Posts: 10 Joined: 2008-06-09 Ignore user	Maybe someone is interested. I’ve tested the query (without the reset customers values) on a 1.1.2 version. Do it for you own risk, but it worked all well for me! Regards Sandro
	Posted: August 6 2008 \| top \| # 55

medlington Total Posts: 69 Joined: 2008-04-30 Ignore user	So will this script delete all orders or can I get it to delete only certain ones? I may have to send test orders through again in the future and it would be a real pain if I had to delete all of the stored orders each time. Signature the worlds most portable football goals - 3d animation sheffield - Product design and prototype development - Kenya tourist information - Fable Films - Video Production Sheffield
	Posted: August 8 2008 \| top \| # 56

J.T. Total Posts: 218 Joined: 2008-08-07 Ignore user	Sounds like most of you are testing on your production shop. It’s bad practice and you will live to regret that one day. Always have two installations. Do you development on the second one, whilst the first one is live. Once you are absolutely happy you finished a certain improvement, you copy that over to the production shop, but only after you took a full back-up of the files and database of the production installation. See programs like Beyond Compare etc. to do all of this easily. If you had been testing on your dev install you wouldn;t have this delete issue. Signature Go 1.1.7!
	Posted: August 8 2008 \| top \| # 57

medlington Total Posts: 69 Joined: 2008-04-30 Ignore user	but what about when a customer is directed to paypal and then doesnt complete the order either through choice or a crash. They then might remake the order but there is still the pending order in the list that is reduntant and should be deleted. Also my client has a habbit of sending orders through himslef just to make sure its working and these need to be deleted too. Signature the worlds most portable football goals - 3d animation sheffield - Product design and prototype development - Kenya tourist information - Fable Films - Video Production Sheffield
	Posted: August 11 2008 \| top \| # 58

tartan Total Posts: 23 Joined: 2008-05-09 Ignore user	medlington - 11 August 2008 12:23 AM but what about when a customer is directed to paypal and then doesnt complete the order either through choice or a crash. They then might remake the order but there is still the pending order in the list that is reduntant and should be deleted. Also my client has a habbit of sending orders through himslef just to make sure its working and these need to be deleted too. Exactly.... Signature Josh Denver, CO
	Posted: August 15 2008 \| top \| # 59

Sensi Total Posts: 69 Joined: 2008-07-31 Paris, France Ignore user	gamelodge - 05 August 2008 04:28 PM @R.Verheij & Sensi - v1.1.2 SQL query: TRUNCATE `sales_flat_quote` ; MySQL said: Documentation #1217 - Cannot delete or update a parent row: a foreign key constraint fails Yeah, like mentioned it was meant for 1.1.1, will have to check which changes were introduced by 1.1.2. Signature Friends: Kaipifraise web agency
	Posted: August 18 2008 \| top \| # 60

Magento Community

Magento Community

Back to top

pbm with sub-category menu

Google Analytics

Sales: Call 877.832.5289 (North America) 310.295.4144 (International)