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

It's not that complex. Just go in your phpmyadmin and click on the "truncate" or "empty" button for the tables hikashop_order hikashop_order_product and hikashop_history and you should be fine.

Having a button to do it is not a good idea. You would be amazed at the number of people clicking on buttons without realizing what they do (even validating the alert popup of the button)

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?

Hi,

Even if you delete the entries in the table order ; the auto_increment is still store by the database (MySQL).
At this moment you have to perform a truncate or a alter of the table to change the auto increment value.

A French thread which provide the SQL queries:
www.hikashop.com/forum/5-support-en-fran...n-des-commandes.html

Regards,

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.