Magento

1) Deleting orders should absolutely be an option available to us.

2) Also - for those using the “Saved Credit Card” method - there ought to be a way to delete the credit card number after the merchant has processed it offline. It is inherently insecure to leave a credit card number sitting there in the database for all eternity!

Super bump

Even if it isn’t necessarily best practice to delete orders, Magento doesn’t need to police that! Let people do what they want.

Secondly, personally I would only use this for deleting / resetting test info, which is super important in any start-up environment.

Need to a way to reset “Products in carts” report since the number of total items does not decrease so you can have 8 pages of no items.

I can’t believe that this topic is so long an Magento team has disappeared. Apart from a quick post from Michael that had not much to do with our issue.

I also need to delete my test and paypal pending orders! It should not be complicated, but we indeed need Magento advice on how to develop an extension for that, if they don’t want to implement it by default.
Again, a community without inputs from the core developer team is not efficient.

Can anyone who is a pro member submit this to their forum?

Keep us posted.

Wow, this is really important to many users. Hmm, and i dont see it included on 1.1.7 Roadmap…

I agree! We need a quick resolution!

Bumpy

Same here… Really need to reset to a clean install order & customer wise. Only want to keep configs, categories & products.
Which tables should I truncate?

VARIEN:  Please post the SQL code to use to delete orders (and other test-data) in Magento 1.1.6

Cheers.

If I may add something to this thread. I am against the delete option of the orders. I mean, at least not ONLY the option to delete. Keeping your orders it’s a security for every owner. And I am not sure if you are required to store them. I saw in another forum, for example, that some guy was forced to store the past 7 years of logs. (Not with Magento. Another appliance)

What I think we need is two things:

1) Test mode: Where you could input an order in test mode (Only available to admins)
2) Archive Mode: Where selected (Or from a criteria) orders and everything related to that order, it’s moved to another database. One that will be only for history and will not affect the performance or use of Magento. You could access or move those databases offline for back up.

Then a couple of options in the admin panel:

- Delete/Archive Test orders.
- Delete Orders
- Archive Orders.

What do you think?

whats going on varien? who’s not responding? very interesting topic something i have also found to be problematic. Clients will always want to test that the site is working.

We also really need the ability to delete orders.

little up.

May an answer could clarify the position of Varien

i need a solution, bumping this one so it stays visible..

To be honest, I think there are more important things for Varien to be worrying about.

- in a running store, orders should not be deleted (canceled maybe, but not deleted)
- I can imagine it would be nice to delete test orders, but such testing would normally be done before the site goes live.

So here is my suggestion.
- do a backup of the database
- place test order(s)
- restore database
- guess what - not test orders left in the system!

Also, (since you forgot to backup your database before placing test orders) if you look back to earlier posts in this thread you will find SQL commands to delete out all orders from the database.  (but don’t forget to backup first!)

Hope that helps someone