How too change order number in php auto_increment

[peterbjergsted]

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. 1.6.1.4

 

Regards

Peter

 

[endriu107]

Hi, go to your sql menager like phpmyadmin and add new sql statement:

 

ALTER TABLE `ps_orders` AUTO_INCREMENT = 150;

 

150 is the number cart id, so put there what number you want.

Edited April 3, 2016 by endriu107 (see edit history)

[peterbjergsted]

Hi endrii107,

 

Thanks for your quick answer.

I'm still a bit newbie in this, so i want too be 100% that i do the wright thing.

 

Am i in the right place?

[endriu107]

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 April 2, 2016 by endriu107 (see edit history)

[peterbjergsted]

Okay, one step closer

 

I'm sorry to ask you again, but how do i come in to the database instead if table view?

[endriu107]

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.

[endriu107]

One more thing in your screen I see you have different table prefix so sql statement should look little different:

 

ALTER TABLE `ps_orders` AUTO_INCREMENT = 150;

 

In ps_orders change ps_ to your table prefix.

[peterbjergsted]

Okay, I am in table now, but if i click on id_order an after that sql, then i come too the same as in the first picture?

 

Sorry, i might be tired or really slow in the head

[peterbjergsted]

I'm so sorry too waste your evening, but i dont understand what shall do?

 

In the other shops, i could just go to the operations at auto_increment and then it was fixed.

[endriu107]

I did video tutorial for you, watch how to do it fast and little slower

 

[peterbjergsted]

Hi again,

 

That did it!

 

Thank you very much for your patience and your time.

 

 

Regards Peter

[tobyisabelle]

Hi! Sorry to hijack this thread. i've watched the video and followed the instructions however i am getting an error:  #1146 - Table 'shoprepu_pres513.ps_orders' doesn't exist

 

 

What am i doing wrong?

 

 

[endriu107]

You use other PREFIX change ps_ to psap_ and try again.

[tobyisabelle]

Thank you for that! Such a silly mistake! : )