Prestashop - Eliminare i dati test per portare online

TRUNCATE TABLE ps_customer;
TRUNCATE TABLE ps_customer_group;
TRUNCATE TABLE ps_address;
TRUNCATE TABLE ps_orders;
TRUNCATE TABLE ps_order_detail;
TRUNCATE TABLE ps_order_discount;
TRUNCATE TABLE ps_order_history;
TRUNCATE TABLE ps_message;
TRUNCATE TABLE ps_cart;
TRUNCATE TABLE ps_cart_product;
TRUNCATE TABLE ps_cart_discount;
ALTER TABLE ps_customer AUTO_INCREMENT = 0;
ALTER TABLE ps_address AUTO_INCREMENT = 0;
ALTER TABLE ps_orders AUTO_INCREMENT = 0;
ALTER TABLE ps_order_detail AUTO_INCREMENT = 0;
ALTER TABLE ps_order_discount AUTO_INCREMENT = 0;
ALTER TABLE ps_order_history AUTO_INCREMENT = 0;
ALTER TABLE ps_message AUTO_INCREMENT = 0;
ALTER TABLE ps_cart AUTO_INCREMENT = 0;
ALTER TABLE ps_cart_product AUTO_INCREMENT = 0;
ALTER TABLE ps_cart_discount AUTO_INCREMENT = 0;



ps
truncate = delete from

fonte: http://www.prestashop.com/forums/viewthread/9045/installation_configuration___upgrade/solved_how_to_reset_or_delete_all_orders_and_customers