Increase order id number

[Tito]

Hi,

how can I make the order/cart id start from fe 100 instead of 1 ?

Because I'm developing a payment module and I get conflicts with duplicate order id's...

Now my next order id = 28, but I want all next orders to start from fe 100...

[d0m1n1k]

change auto_increment in table ps_orders like described at http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

[Tito]

I assume I'll have to edit ps_orders AND ps_cart

is that correct ?

ALTER TABLE `ps_orders` AUTO_INCREMENT = 100;
ALTER TABLE `ps_cart` AUTO_INCREMENT = 100;

Secund question : which tables and their depending tables can be emptied to remove all previous orders and carts ?

[d0m1n1k]

the order id is different from cart id, so you don't have to do this in ps_cart too.

second question:

NEVER use this in a live system, or you'll get troubles with your financial office
delete from ps_cart;
delete from ps_cart_product;
delete from ps_message;
delete from ps_order_detail;
delete from ps_order_history;
delete from ps_orders;