Reset ID of the Orders

Hello,

I have to reset the number of orders starting with 1
I have performed the operation on the DB truncate the tables on hikashop_order_product and hikashop_order ... canceled their orders on hikashop but if I'm going to place an order begins with the last order example 17 ..
I have to do something else to reset the id and restart the count of orders / invoices to be 1?

Thank you.

Hi,

If you have well truncate, the id should start at 1 and the order code is based on the id.
As I remember nothing else is required.

www.hikashop.com/forum/4-how-to/76306-so...-database.html#79660

I have the same problem. Isn't there a small how to, which operations on which tables have to be executed? Or even better, build in a reset button for that.

EDIT
Ok, works

what tables should i truncate in order to reset the INVOICE NUMBER as well?

Hello,
Doing it on the table "hikashop_order " should do the job .

I can't get this to work. There are nothing in those tables. Because I allready deleted them from my hikashop order list.
What I want is to start with order number 1. How do I do this?

thanks for link, but I don't understand much french.
So you want me to run a query, for reseting the ordernumber?
And when you say truncate, you mean empty tables right? But they are empty.

Hi,

Yes you indeed have to do a truncate mysql request, this allow to reset the auto increment value.

The table handler does not remember the last used AUTO_INCREMENT value, but starts counting from the beginning.