webnology Posted October 23, 2006 Posted October 23, 2006 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
♥Monika in Germany Posted October 23, 2006 Posted October 23, 2006 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 ...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.