Delete all orders and shopping carts data, reset ID to start back from 0

[soulefay]

I know there's plenty of threads regarding this topic, but I see most of them are for previous version, and I'm just too afraid if I followed wrongly and create more errors.

 

I'm currently using version 1.6.0.9

 

I want to reset all my orders and shopping cart to start back from 0. Perhaps via myphpadmin?

 

Not demo datas, I've already turned it off. Real datas. I can't use cleaner either, cause I don't want to delete my customers. Just need to delete orders and shopping carts.

 

Appreciate any help.

 

Many thanks!

[Rolige]

There is a native module for this called "pscleaner", you could clear all you catalog, customers, orders and much more.

 

PD. Try to use the latest version.

[soulefay]

but pscleaner clear orders and customers at the same time. I just want to clear the orders.

[bellini13]

Below are the database tables that the ps_cleaner truncates when you clean the "orders and customers".  I've broken them down for you into 3 groups

 

So you can use phpmyadmin to truncate the tables listed under cart and orders

 

cart:
'cart',
'cart_product',
'wishlist_product_cart',

customer:
'customer',
'customer_group',
'customer_message',
'customer_message_sync_imap',
'customer_thread',
'guest',
'message',
'message_readed',

orders:
'orders',
'order_carrier',
'order_cart_rule',
'order_detail',
'order_detail_tax',
'order_history',
'order_invoice',
'order_invoice_payment',
'order_invoice_tax',
'order_message',
'order_message_lang',
'order_payment',
'order_return',
'order_return_detail',
'order_slip',
'order_slip_detail',
'product_sale',