Hi,

I set up prestashop and modified according to the needs of our business. However, during modification i made too many test orders (more than 100). Thus, i want to delete orders without any trace or causing misbehavior in scripts. Database index number can be at its last value there is no problem with index. Could you offer me a way ?

Regards,
Ali

I have been looking for an answer from an expert

Hi debugginglife!

We already replied thousand of time to that question.
Please do a search inside the forum.

Hi,

As a conclusion from the previous messages, it is obvious that there is no X button for deleting order in back office. However, i am looking for some database editing ( with a tool like phpmyadmin or else), here can be some experts who did such changes before. If i delete both customer and its orders from database, will the script misbehave?

Not being able to delete an order is a good feature to prevent the store form theft or lose of information, but there could be a manual method to remove test orders or bad orders ( like orders from some hacking attempts)

First – all orders need to stored! This is like accounting program, where You need to store all information. When You don’t need this order, then You can cancel that.

But when You still want delete orders – then You can do that at database. Look tables orders and order* tables.

i want to delete test orders too. .what table in mysql??

i’m not responsible if it doesn’t work as expected.
you must create a DB backup before executing this sql commands.

but:
worked for me

Matthieu Biart - 21 November 2008 10:50 PM

Hi debugginglife!

We already replied thousand of time to that question.
Please do a search inside the forum.

Sorry for bringing up this old thread – but I just had to comment.

You say “thousand of time”? That’s the overstatement of the decade. I search for “delete order” and got 72 hits – and four of them was directly related to my search.

If only people who know where to find information replyed, the web would be faster. If you don’t have anything useful to say – don’t say it!

The challenge with forums like this is that there are people from all over the world using it. The spoken languages are many, and not all understand or writes english (or french for that matter) that well – me included!

A little help and understanding is all that is needed for people to smile. And this software is all about smiling, because it’s GREAT!

u can use this sql querry but before that you must create a backup

Thank you mahmutta, that worked for me!
After going back to do some more test orders I received “invalid order state” in the store front, and no orders show in the BO.

Thats because the SQL query above empties 2 important tables

I’m still testing this, but I’d also add the below to the query above

And remember if you get a mysql error, check your table prefix!

Sorry for a duplicate post, but heres the SQL query that does work, tested 10 times over

as mahmutta said, this will delete ALL ORDERS!!!
this will NOT delete customers. but that can be done through the BO.

Also, remeber that some modules use there own tables with order id relations, so be sure to check on those.

I put together a module just for this purpose
http://www.prestashop.com/forums/viewthread/24710/

OK
1-) Open /prestashop site root/admin/tabs/AdminOrders.php via your fav editor.
2-) Find this code about 25th line

Thats all
Now you can delete any of orders at back office regular
i recomend add // comment start of the added line after delete