E-shop how to erase orders count

[sophocles]

Hi,

I've been making some test orders in order to check the functionality of the e-shop.
Now that i want to go online, i want the counter to start from order 1 (E-1).
Although i erase the orders within the e-shop back end,  the counter keeps counting from the last order.

Where in the eshop database tables can i find the counter and erase it?

Thanks in advance

[datahell]

You must change the orders table's (elx_eshop_orders) primary key (orderid) auto increment value to 1.
First make sure there are no orders in IOS eshop.
Go to your database manager (phpmyadmin) and execute the following SQL command:

Code: [Select]

ALTER TABLE elx_eshop_orders AUTO_INCREMENT = 1;
If you use a different tables prefix than "elx_" change elx_ with your own tables prefix in the above command.

[sophocles]

Precise as always.
Thank you datahell