Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Remove all customers


webnology

Recommended Posts

Posted

Hi all,

 

is it possible to remove all customers at once? It will take me a while to do this via the admini, so I hooped there would be an automatic way, taking care of all relations with the other tables.

 

Many thanks,

M

Posted

truncate (empty) tables via phpmyadmin.

 

customer info is stored in the following tables:

customers

customers_info

customers_basket

customers_basket_attributes

address_book

 

I would also clean up

products_notification

reviewsreviews_description

 

if you have stored orders already, you can empty all tables also starting with "orders" - APART FROM order_status, that is a lookup table from admin and not related to customers

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Archived

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

×
×
  • Create New...