Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


Guest

Recommended Posts

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.

 

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`;

 

If you use the wishlist contribution, also include this.

TRUNCATE `customers_wishlist`;

 

Cheers,

Tony

"The price of success is perseverance. The price of failure comes much cheaper."

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...