How is right way to delete test orders?

[Detelin Markov]

Hi everyone

 

After successfully upgrade from 1.5.6.1 to 1.6.0.5 i made several test orders to be sure in checkout process. But now how is right way to delete these orders?

 

Presta again don`t want to add button "delete order"

 

I try with vekia  "Delete orders free" module but not work on 1.6 may be soon will be supported but i want now to delete my test orders.

 

I can delete all orders from pscleaner module but i don`t want to delete all orders (for now).

 

I can delete it from MSQL, only from one table or i need to delete it from several?

 

Thanks

[PhpMadman]

all orders are place in the all of the tabels called ps_orders_* and the base is in ps_orders

But deleting it like that is not recomended, since if you miss anything, you will break your shop.

And also, you need to reset the auto_increment on order id, to match the last real order+1, assuming that is you goal.

To remove the test orders and make the id be  same as your first test order.

 

Personally I don't see any reason to delete them.

Just credit slip them and cancel them. Your customers will never know...

[jaro61]

Use module Database cleaner

[BoKr]

Officially, you should not use it with 1.6.

You may have to wait until Vekia clears it for 1.6 if he hadn't already. But that I have missed.

[jjryeste]

not found in prestashop 1.6

[El Patron]

warning, do not use cleaners, ever.  it can in some cases cause unrecoverable errors in your shop.  please like if you understand this warning...end of warning.

 

simply cancel the test orders, with all the orders you going to be making they will page off soon enough.

 

believe me now thank me later.

[jjryeste]

ok ok, work , googd