Change order numbers in the database

[jesusruiz]

Hello and thanks for reading this message.

 

I have a problem with a client. From the beginning, he asked me to start the number of orders from a high number (eg 1345).

 

Now he needs, for fiscal reasons, I have to put all the orders already made, starting from 1.

 

In my opinion, is easier, he declared that the orders began another number greater than 1, since we can easily demonstrate.

But this solution does not like, and eventually I'll have to modify the database.

 

Does anyone know the Prestashop database, what are the tables to modify orders already completed?.

Are only these?:

ps_orders

ps_order_detail

ps_order_history

 

 

Thanks and best regards.