Kunden löschen

Aus Wiki | xtcModified eCommerce Shopsoftware

Mit folgenden SQL-Befehlen können alle Kunden, außer Administrator, gelöscht werden.

DELETE FROM address_book WHERE customers_id > 1;
DELETE FROM customers WHERE customers_id > 1;
DELETE FROM customers_basket WHERE customers_id > 1;
DELETE FROM customers_basket_attributes WHERE customers_id > 1;
DELETE FROM customers_info WHERE customers_info_id > 1;
DELETE FROM customers_ip WHERE customers_id > 1;
DELETE FROM customers_memo WHERE customers_id > 1;
DELETE FROM customers_status_history WHERE customers_id > 1;

siehe auch Bestellungen löschen, Artikel löschen