Magento Forum

   
Deleting orders, invoices, shipments,…. 
 
Michael L.
Jr. Member
 
Total Posts:  7
Joined:  2009-03-12
 

Ho can I delete ALL orders, invoices, shipments, ..... in my magento system? So far I made a lot of tests-orders and now (just before going LIVE) the system is full of these. I want to delete all these transactions. Has somebody got a script or SQL-statements? Thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
SpaceLight
Sr. Member
 
Avatar
Total Posts:  89
Joined:  2008-05-28
France
 

This is the link for the module

http://www.magentocommerce.com/extension/reviews/module/873/delete-orders

but it works only in beta mode in you connect manager

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael L.
Jr. Member
 
Total Posts:  7
Joined:  2009-03-12
 

Thanks. But I have this tools. It doesn’t work 100%: The completed orders cannot be deleted. It says that it must be canceled before. But cancelling does not go in many cases. So I need a better tool.

 
Magento Community Magento Community
Magento Community
Magento Community
 
iiNTENSE
Guru
 
Avatar
Total Posts:  432
Joined:  2008-11-06
Lansing, MI
 

What do you mean by the cancelling does not go?

The only other way would be to manually delete the orders within your MySql database.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael L.
Jr. Member
 
Total Posts:  7
Joined:  2009-03-12
 

You can see it in the 4 screenshots. I tried:
1) DELTE => No Success because of canceling before
2) Canceling => No Success
3) DELETE Again => No Success
4) Just how it was => No Delete

Could you help me, please? Thanks a lot.

Image Attachments
screen_1.jpgscreen_2.jpgscreen_3.jpgscreen_4.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top