[SOLVED] Resetting DATA

[Rebel Tech]

Good evening.

 

I am just about to go LIVE with my new store.

 

However I need to make sure I don't bugger anything up.

 

After testing with sample customers and products I used PrestaShop Cleaner to remove all the sample Order, Customers, Catalogs, Products etc etc.

 

I need to make sure that Customer ID (and all joining data) is set to 1. 

I need to make sure that Category ID (and all joining data) is set to 1. 

I need to make sure that Product ID (and all joining data) is set to 1. 

 

I also noticed that all additional information (i.e Average Age, Orders per Customer, etc) were reset EXCEPT for Items in Stock, Disabled Products, Average Order Value. Is there a way to reset these?

 

Thanks

 

 

 

Edited July 31, 2014 by Rebel Tech (see edit history)

[Rebel Tech]

Would it be better if I use the Cleaner or

TRUNCATE TABLE `ps_customer`;
TRUNCATE TABLE `ps_customer_group`;
TRUNCATE TABLE `ps_customer_message`;
TRUNCATE TABLE `ps_customer_thread`;
TRUNCATE TABLE `ps_guest`;
TRUNCATE TABLE `ps_orders`;
TRUNCATE TABLE `ps_order_carrier`;
TRUNCATE TABLE `ps_order_cart_rule`;
TRUNCATE TABLE `ps_order_detail`;
TRUNCATE TABLE `ps_order_detail_tax`;
TRUNCATE TABLE `ps_order_history`;
TRUNCATE TABLE `ps_order_invoice`;
TRUNCATE TABLE `ps_order_invoice_payment`;
TRUNCATE TABLE `ps_order_invoice_tax`;
TRUNCATE TABLE `ps_cart`;
TRUNCATE TABLE `ps_cart_product`;


ALTER TABLE `ps_customer` AUTO_INCREMENT = 0;
AlTER TABLE `ps_customer_group` AUTO_INCREMENT = 0;
ALTER TABLE `ps_customer_message` AUTO_INCREMENT = 0;
ALTER TABLE `ps_customer_thread` AUTO_INCREMENT = 0;
ALTER TABLE `ps_guest` AUTO_INCREMENT = 0;
ALTER TABLE `ps_orders` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_carrier` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_cart_rule` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_detail` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_detail_tax` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_history` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_invoice` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_invoice_payment` AUTO_INCREMENT = 0;
ALTER TABLE `ps_order_invoice_tax` AUTO_INCREMENT = 0;
ALTER TABLE `ps_cart` AUTO_INCREMENT = 0;
ALTER TABLE `ps_cart_product` AUTO_INCREMENT = 0;

Or Both?

Edited July 14, 2014 by Rebel Tech (see edit history)

[Rebel Tech]

Solved but doing my own thing.