RE: Looking for fast way to delete all clients and orders??

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=228708#228708
----------------------------------------------------------------

If you want to do it via SQL (or phpMyAdmin >> SQL) use the TRUNCATE command.  It's the same as clicking EMPTY.

Just cut and past the following as your SQL statement.
What you see below will also remove all counters, review, etc. so it's a fresh store.

If you ONLY need to remove customers and order, just cut and paste the required customer and orders sections below.

[code]TRUNCATE `address_book`;
TRUNCATE  `banners_history`;
TRUNCATE `counter`;
TRUNCATE `counter_history`;
TRUNCATE `customers`;
TRUNCATE `customers_basket`;
TRUNCATE `customers_basket_attributes`;
TRUNCATE `customers_info`;
TRUNCATE `orders`;
TRUNCATE `orders_products`;
TRUNCATE `orders_products_attributes`;
TRUNCATE `orders_products_download`;
TRUNCATE `orders_status`;
TRUNCATE `orders_status_history`;
TRUNCATE `orders_total`;
TRUNCATE `reviews`;
TRUNCATE `reviews_description`;
TRUNCATE `sessions`;
TRUNCATE `whos_online`;[/code]

If you use the wishlist contribution, also include this.
[code]TRUNCATE `customers_wishlist`;[/code]

Cheers,
Tony