how do i CHANGE THE ORDER NUMBER?

[minorthreat100]

i've since had to re-install os commerce completely and so the first order will be now given then order number of #001

 

is it possible to edit the system so the first order number allocated begins at #200 for example?

 

thanks in advance!

[Velveeta]

i've since had to re-install os commerce completely and so the first order will be now given then order number of #001

 

is it possible to edit the system so the first order number allocated begins at #200 for example?

 

thanks in advance!

Sure, just go in through phpMyAdmin or whatever you use for your db interface, and do something like this (i.e. if you want the first generated order to be #25):

 

alter table orders auto_increment = 25;

[minorthreat100]

thanks for your help richard!

 

does this mean order numbers will go up in multiples of 25x? (first order #25, second order given number #50???)

 

or am i safe and it'll just go #25, #26, #27 etc...

[Velveeta]

thanks for your help richard!

 

does this mean order numbers will go up in multiples of 25x? (first order #25, second order given number #50???)

 

or am i safe and it'll just go #25, #26, #27 etc...

Nope, it just sets the base number used for auto_increment'ing in the future... I noticed in the original post you wanted them to start at 200, so just change that 25 to 200, and they'll start at 200, then 201, 202, etc...

[minorthreat100]

thank you very very very very much :)

[Velveeta]

thank you very very very very much :)

Not a problem :) I've run into this issue many times in the past for having to reset auto_increment problems on various tables across various project... I know that query by heart now :)

[snipercwf]

Just what i needed too, many thanks for sharing this info :-)