Delete order in prestashop 1.7.7.0

[raicap]

Does anyone know how to cancel annulled orders in prestashop 1.7.7.0?

[Prestachamps]

You can easily delete orders from your store  by running the following SQL command (replace the 9999 with your order ID):

 

delete from ps_message WHERE id_order = 9999;
delete from ps_order_detail WHERE id_order = 9999;
delete from ps_order_history WHERE id_order = 9999;
delete from ps_orders WHERE id_order = 9999;
delete from ps_order_carrier WHERE id_order = 9999;
delete from ps_order_cart_rule WHERE id_order = 9999;
delete from ps_order_invoice WHERE id_order = 9999;
delete from ps_order_return WHERE id_order = 9999;
delete from ps_order_slip WHERE id_order = 9999;

And please do a backup of your DB before doing it!

[raicap]

grazie proverò

[Prestachamps]

Happy to help

[comunicazione]

Hello Prestachamps, I'm trying to use the method you suggest for orders deleting ( PS version 1.7.7.0 ) . Running the SQL query trough BO, I have as response the error message as in screenshot attached. However everythings seems is ok, order is deleted and site have no problem. Any idea about the error message?

[Prestachamps]

Hi,

you should execute the SQL code in an MySQL manager like PhpMyAdmin from cpanel, as the Prestashop's sql manager is for selecting data from database.

If you don't have phpmyadmin on your cpanel then you can ask your hosting o give you option to execute sql from your hosting panel.

Kind regards, Leo

[Futamiya]

Hello,

I want to say also :

- delete from ps_order_invoice_payment where id_order=10101010;

And

- delete from ps_order_payment where order_reference=fafafafa;

 

YOU NEED TO DO THIS BEFORE YOU DELETE ps_order, because we need id_order