responder Posted September 12, 2011 Share Posted September 12, 2011 Hi, how do I delete orders?? Upgraded to 1.4.4.1 and am now unable to check box and delete orders I no longer want, especially when creating orders for testing.Thanks in advance. Link to comment Share on other sites More sharing options...
responder Posted September 12, 2011 Author Share Posted September 12, 2011 Awesome thanks! Link to comment Share on other sites More sharing options...
Nickless Posted December 12, 2011 Share Posted December 12, 2011 Be aware using that method! I used it and it messed up my database. Every time an order was placed, products from older (deleted) orders where automatically added. After a lot of searching I discovered that the deleted orders where still present in the database. So the safe way is to delete unwanted orders from you database using PhpMyAdmin in the ps_orders and ps_orders_detail table. Regards, -Dave Link to comment Share on other sites More sharing options...
gangsar.swapurba Posted March 9, 2012 Share Posted March 9, 2012 thanks Nickless, may it will right until the new warning got appeared. Link to comment Share on other sites More sharing options...
bellini13 Posted March 9, 2012 Share Posted March 9, 2012 the issue is that when you use this method to delete an order, not all order information is deleted, some are but not all. so here is an example to make it more clear let say you have the following orders order 1 order 2 order 3 then you delete order 2. then next order in sequence will be order 4. this will not cause an issue by using this method. however let's say you have the following orders order 4 order 5 order 6 then you delete order 6. then next order in sequence will not be order 7, prestashop will assign order 6 again. so this means the older products from the original order 6, will be associated with the products from the new order 6. 1 Link to comment Share on other sites More sharing options...
thegto Posted April 4, 2012 Share Posted April 4, 2012 Hello, I have tested order a lot but I can't delete them on my PS1.4.7.0 I wonder if this module http://addons.prestashop.com/en/administration-tools/3463-delete-orders.html could do the job easily for me If I have to delete manually from PHPmyAdmin .... what should I delete or is there any step by step to delete that ? Link to comment Share on other sites More sharing options...
BorisAlexandre Posted April 18, 2012 Share Posted April 18, 2012 Hello, I have tested order a lot but I can't delete them on my PS1.4.7.0 I wonder if this module http://addons.presta...ete-orders.html could do the job easily for me If I have to delete manually from PHPmyAdmin .... what should I delete or is there any step by step to delete that ? Be careful with this module... same problem as with using the above mentioned technique happens (Nickless). I had the same weird-ass shit happen to me following using that module... hopefully by deleting all the order details, it will have fixed my problem... I can only hope ! 1 Link to comment Share on other sites More sharing options...
Dumbelo Posted July 21, 2012 Share Posted July 21, 2012 My message here too: I did it, used "delete" in URL line for test orders. And when I made a new test order...them all came back!. So you are not necessary messing your database, but well you are so lost with your orders! (if you are using this method for real orders ) Link to comment Share on other sites More sharing options...
bellini13 Posted October 29, 2012 Share Posted October 29, 2012 @PatriceVigier: have you confirmed that this method will delete all associated records in other order tables, or will it just delete the record in the ps_orders table? Link to comment Share on other sites More sharing options...
mojtabam Posted July 7, 2013 Share Posted July 7, 2013 Then which one is better and working? what rows in which tables should I delete exactly? Thank you very much, Mojtaba Link to comment Share on other sites More sharing options...
vekia Posted July 8, 2013 Share Posted July 8, 2013 well, if you use modification of the controller: this method doesnt clean all tables related to the orders, it just remove it from the main table. Link to comment Share on other sites More sharing options...
Omk Posted September 29, 2014 Share Posted September 29, 2014 (edited) Do NOT EVER use this method in a live system. I used it on our shop deleting our test orders before we launched the store, and it seemed to work fine. BUT: It deletes only the master orders table, but leaves all the others, where the invoice data is kept intact, causing ghost products appearing in invoices, tax calculations get completely wrong, ordered products listings get messed from the actual shopping cart and what was paid etc. So this happened to us after we launched the store. Huge mess! So using "deleteorder" via the URL results in total chaos and hell of work manually editing the DB tables and tracking down all messed up records across the different order related tables. Edited September 29, 2014 by Omk (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted September 29, 2014 Share Posted September 29, 2014 Do NOT EVER use this method in a live system. It deletes only the master orders table, but leaves all the others, where the invoice data is kept intact, causing ghost products appearing in invoices, tax calculations get completely wrong, ordered products listings get messed from the actual shopping cart and what was paid etc. So using "deleteorder" via the URL results in total chaos and hell of work manually editing the DB tables and tracking down all messed up records across the different order related tables. I agree!...I am going to lock this thread and remove any 'unsafe' sort of recommendations. Please read omk's post, do not delete orders manually, only if official PS module and even then it's not recommended. Test orders can simply be canceled, and they will over time age off list. Link to comment Share on other sites More sharing options...
Recommended Posts