Change the ordernumbers to start from 00501 and not 00001

[cecepee]

Hello

Im gonna set up a shop for a friend now, and she asks if i can change the order number and invoice number so it continues from where she stoped with her old system.

Lets say she has sold 500 orders in her old system, so she then want that first order in her new prestashop shall say order 501 and not order 001. Do you understand what i mean?

I have figured out how to change the invoice numbers, but can find where to change the sequence for the order numbers.

Can someone please point me in the right direction.

Best regards
Peter

[TropischBruin]

The ordernumbers you need to change directly in de DB.
For invoices goto: Order -> Invoices -> Invoice number:

[cecepee]

Thanks.

You mean that i go to for example to myadmin MySQL Server and edit the values inside the DB?

You don't happen to know which of the order entry's i should edit? Its 15 different entry's related to order.

[DaveGetStock]

Thanks.

You mean that i go to for example to myadmin MySQL Server and edit the values inside the DB?

You don't happen to know which of the order entry's i should edit? Its 15 different entry's related to order.

Amazing when its actually simple isnt it I would have done the same thing as you and started poking around in the database!

[TropischBruin]

Thanks.

You mean that i go to for example to myadmin MySQL Server and edit the values inside the DB?

You don't happen to know which of the order entry's i should edit? Its 15 different entry's related to order.

Not sure which tabel you need, just have a look arround.
Just create a order and then change the number directly in de db to be the last one your customer/friend had in her old shop.
The next order will have the follow-up number.

[Peet]

for this.. i have figured out that you only need to change one thing for your order numbers

download your database as sql, open it in text editor, search for "ps_orders" once you finde this place in your sql file, make a new search from where the cursor landed in you first search. now search for "AUTO_INCREMENT=" ... the result of this search will have the value that your next order number will be.. change this to your liking .

thats it

in my case i had to change my order numer from 15 to 28 i changed it like this

AUTO_INCREMENT=15 got changed to AUTO_INCREMENT=28