Call-back icon  Questions? Contact our sales team to a request a quote

Magento

eCommerce Software for Online Growth

Magento Forum

   
How to delete orders complete? 
 
Ross
Sr. Member
 
Avatar
Total Posts:  230
Joined:  2007-08-31
Scarborough, North Yorkshire, UK
 
Kerry Hatcher - 17 October 2008 09:42 AM

I just need someway to take canceled orders out of the dashboard reports, any ideas?

I agree that canceled orders should not be included in reports.  I just had a look and noticed a couple of bug reports that mention the issue, why not comment on them to help flag up the issue:

Issue #7582 - http://www.magentocommerce.com/bug-tracking/issue?issue=3564
Issue #7269 - http://www.magentocommerce.com/bug-tracking/issue?issue=3333

 Signature 

Ross Kendall - Web Developer - rosskendall.com
Client Magento websites:
- Out of the Ark Music (UK): a leading publisher of children’s musicals
- Dottie Lottie: children’s clothing boutique

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Guru
 
Avatar
Total Posts:  493
Joined:  2008-04-28
London, UK
 

Still no DELETE button? Seriously??

 Signature 

ExtraCall.com - UK Telecommunications & VOIP

 
Magento Community Magento Community
Magento Community
Magento Community
 
skatingduck
Jr. Member
 
Avatar
Total Posts:  7
Joined:  2008-10-27
Trier, Germany
 

Hey,
for me the solution shown in this blog worked smoothly with the latest magento version. I hope it wasn’t already posted here and I missed it.
http://inchoo.net/ecommerce/magento/delete-test-orders-in-magento/

Cheers

Paddy

 Signature 

http://www.intic.de

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Guru
 
Avatar
Total Posts:  493
Joined:  2008-04-28
London, UK
 

Hey,

That solution sounds good - but I do not want to mess with the database. Why no Delete button? One can delete customers, for example, but not newsletter subscribers or orders. What’s that all about?

 Signature 

ExtraCall.com - UK Telecommunications & VOIP

 
Magento Community Magento Community
Magento Community
Magento Community
 
btbc
Sr. Member
 
Total Posts:  86
Joined:  2008-06-11
 

Okay, my live site has been getting orders, and my dashboard, and reports are not accurate.

I have 2 *closed* test orders factoring into my dashboard.

Is there a way to change the *closed* to *canceled* orders?

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Guru
 
Avatar
Total Posts:  493
Joined:  2008-04-28
London, UK
 

This bug reported below - please comment:

http://www.magentocommerce.com/bug-tracking/issue?issue=3879

Thanks

 Signature 

ExtraCall.com - UK Telecommunications & VOIP

 
Magento Community Magento Community
Magento Community
Magento Community
 
daanlib
Jr. Member
 
Total Posts:  8
Joined:  2008-03-21
 
lisali - 01 November 2008 05:56 AM

This bug reported below - please comment:

http://www.magentocommerce.com/bug-tracking/issue?issue=3879

Thanks

I reported this bug/feature request a month ago:

http://www.magentocommerce.com/bug-tracking/issue?issue=3537

The status is still ‘new’. Some comment from the Magento development team would be greatly apreciated!

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Guru
 
Avatar
Total Posts:  493
Joined:  2008-04-28
London, UK
 

Still no updates on this? Could someone release an extension to add an option to delete orders maybe?

 Signature 

ExtraCall.com - UK Telecommunications & VOIP

 
Magento Community Magento Community
Magento Community
Magento Community
 
ryu007
Sr. Member
 
Avatar
Total Posts:  197
Joined:  2008-03-24
France, Paris
 

Seriously, it is not normal that we don’t have a button to delete orders !

I have 1300 orders on my site magento, and we meet many difficulties to read the customer’s order.

I think you can put in preference order on your todo list, i don’t imagine my order list with > 3000 orders.
Simply impossible!

I have take a look, and it is seems not easy to implement so I can understand why nobody have not yet created this functionnality.

Cheers,
Ilan

 Signature 

Artbambou : Mobilier, meuble, vannerie et décoration.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Guru
 
Avatar
Total Posts:  493
Joined:  2008-04-28
London, UK
 

Gonna keep bumpin’.....

 Signature 

ExtraCall.com - UK Telecommunications & VOIP

 
Magento Community Magento Community
Magento Community
Magento Community
 
daanlib
Jr. Member
 
Total Posts:  8
Joined:  2008-03-21
 

I would really appreciate some comment on this issue from the mageto team!

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Guru
 
Avatar
Total Posts:  493
Joined:  2008-04-28
London, UK
 

We’re all waiting.....

 Signature 

ExtraCall.com - UK Telecommunications & VOIP

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dunc
Member
 
Avatar
Total Posts:  38
Joined:  2008-08-05
 

I am suprised there has been no reply from the team, I’m sure there are plenty of users wanting this option

 Signature 

http://www.electricshowersdirect.com

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Guru
 
Avatar
Total Posts:  493
Joined:  2008-04-28
London, UK
 

I know - we’re all waiting....even if you refund/cancel all orders, they will STILL show and count in the stats. Unacceptable!

 Signature 

ExtraCall.com - UK Telecommunications & VOIP

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kerry Hatcher
Sr. Member
 
Avatar
Total Posts:  92
Joined:  2008-07-15
Macon, GA
 

Early in this thread Moshe replied back with a SQL statement:

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;

Have any of you tried this? If you need help understanding what to do with this code just let me know!

 Signature 

Kerry Hatcher
Webmaster
ShuBee.com

“You can live forever without ever really living”
KerryHatcher.com

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
60006 users|757 users currently online|118853 forum posts