How to reset the id of the orders generated by Commerce module I just finish a website which include a cart. I'm using the commerce module.

In the development stage I've been making some test. Now I just deleted all these testing order, but now the id of the next order is something like 189. I need to put this number to 1. 

Which database table do I need to truncate to get it done?
The commerce order module defines two tables, commerce_order and commerce_order_revision; you should truncate both of those to clear the data and reset the AUTO_INCREMENT counter.

In MySQL:

TRUNCATE TABLE commerce_order
TRUNCATE TABLE commerce_order_revision


Or using the API:

db_truncate('commerce_order');
db_truncate('commerce_order_revision');