Delete orders

[fameart]

Hi,

i want to delete my testing orders and an order of John Doe.

How can I do this?

THANKS!!!

[spott]

Directly from database.
Use phpMyAdmin

[boran]

Hi,

I had the same question, and came up with the following if my order number is '1', and prefix 'ps2':
delete from ps2_orders where id_order=1;
delete from ps2_order_detail where id_order=1;
delete from ps2_order_return where id_order=1;
delete from ps2_order_slip where id_order=1;

As regards ps2_order_history, one could either delete the entries there two, or leave a trace by adding an entry with sate 999 (if we want to use that to mean deleted)
insert into ps2_order_history set id_order=1, id_order_state=999 date_add=now();

Is that enough, are other tables involved?

Hmm, we could also make a stored procedure, to have it available for the future:

DELIMITER //
CREATE PROCEDURE order_delete (i INT)
BEGIN
 delete from ps2_orders where id_order=i;
 delete from ps2_order_detail where id_order=i;
 delete from ps2_order_return where id_order=i;
 delete from ps2_order_slip where id_order=i;
 delete from ps2_order_history where id_order=i;
END //
DELIMITER ;

Then call it with order number as an argument:
call order_delete(1);

[L. Brett Sinclair]

isn't there any statistics tables ?
if you wanted to delete all , you can also change the "where" clause:
where id_order=1;
by
where 1=1;

[boran]

> isn’t there any statistics tables ?

Yes, good point, can someone give information on how to clean up that stats if orders are deleted as noted above?

[L. Brett Sinclair]

BTW - I just read in module (now moved to the new folder BID), this http://www.prestashop.com/forums/viewthread/13369/offer_bids_and_prestations/module_pse_terminator_1_dot_0 : it is not free...I have not tried it, but looks good.

[StoCo]

Hi there,

You will find the latest release of this Terminator module on this page: http://www.storecommander.com/lang-en/prestashop-modules/14-en-pse-terminator.html