Supprimer les clients :

SET FOREIGN_KEY_CHECKS=0;
— reset customers
TRUNCATE hf_customer_address_entity;
TRUNCATE hf_customer_address_entity_datetime;
TRUNCATE hf_customer_address_entity_decimal;
TRUNCATE hf_customer_address_entity_int;
TRUNCATE hf_customer_address_entity_text;
TRUNCATE hf_customer_address_entity_varchar;
TRUNCATE hf_customer_entity;
TRUNCATE hf_customer_entity_datetime;
TRUNCATE hf_customer_entity_decimal;
TRUNCATE hf_customer_entity_int;
TRUNCATE hf_customer_entity_text;
TRUNCATE hf_customer_entity_varchar;
TRUNCATE hf_log_customer;
TRUNCATE hf_log_visitor;
TRUNCATE hf_log_visitor_info;

ALTER TABLE hf_customer_address_entity AUTO_INCREMENT=1;
ALTER TABLE hf_customer_address_entity_datetime AUTO_INCREMENT=1;
ALTER TABLE hf_customer_address_entity_decimal AUTO_INCREMENT=1;
ALTER TABLE hf_customer_address_entity_int AUTO_INCREMENT=1;
ALTER TABLE hf_customer_address_entity_text AUTO_INCREMENT=1;
ALTER TABLE hf_customer_address_entity_varchar AUTO_INCREMENT=1;
ALTER TABLE hf_customer_entity AUTO_INCREMENT=1;
ALTER TABLE hf_customer_entity_datetime AUTO_INCREMENT=1;
ALTER TABLE hf_customer_entity_decimal AUTO_INCREMENT=1;
ALTER TABLE hf_customer_entity_int AUTO_INCREMENT=1;
ALTER TABLE hf_customer_entity_text AUTO_INCREMENT=1;
ALTER TABLE hf_customer_entity_varchar AUTO_INCREMENT=1;
ALTER TABLE hf_log_customer AUTO_INCREMENT=1;
ALTER TABLE hf_log_visitor AUTO_INCREMENT=1;
ALTER TABLE hf_log_visitor_info AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS=1;

Sites intéressants :

http://www.magikcommerce.com