Jump to content

How too change order number in php auto_increment


Recommended Posts

Hi all,


I hope that you can help me.

I've already done this in my other two presta shops, but i can't figure this out.


I want to change the start number "order id" to a higher number than "1".


I am in phpmyadmin-orders-operations-auto_increment and i have tried too change that number and saved many times, but i keeps changing back to number 1. 


What am i doing wrong?


I use vs.





Link to comment
Share on other sites

Yes you are but in screen I see you are in table view, you supposed to be in datebase view after that click to sql. In this view it still will work but this is not necessery to find table what we need to edit, sql statement do that for us. One more thing before you did any change in datebase please make copy just for safty.

Edited by endriu107 (see edit history)
Link to comment
Share on other sites

Maybe my answer is not precision because I am none english user. I mean in your screen you go to table ps_orders and after that you click sql, you didnt need to do that after login to PMA and choose your database you can just click sql button this is much quicker.

Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...