Change Starting Order Number?

Store Builder Questions
1

So I have my order numbers been going for a while and are getting too high, so in the settings I changed it back down to a much lower number, that was not used before. But existing orders are still continuing from the old number. How do I switch it? I figure its in sql somewhere, but have no clue where to look? Thanks

2

[quote name='parodius420' timestamp='1412049478' post='193096'] So I have my order numbers been going for a while and are getting too high, so in the settings I changed it back down to a much lower number, that was not used before. But existing orders are still continuing from the old number. How do I switch it? I figure its in sql somewhere, but have no clue where to look? Thanks [/quote]



Please check notes in the following article:

3

Im sure there is a way in sql to edit it for a lower number, which is what I am trying to figure out.

4

You cant set a ordernr. lower then before.

This is not the normal way of orders payment.

Put the year before and change this every year.

20140000200

20150000200


5

[quote name='parodius420' timestamp='1412092297' post='193136']

Im sure there is a way in sql to edit it for a lower number, which is what I am trying to figure out.

[/quote]



If you make a backup of the cscart_orders table and open the generated file, you can find the following string there:



) ENGINE=MyISAM AUTO_INCREMENT=XXX DEFAULT CHARSET=utf8;




Where XXX - will be an ID of your latest order + 1



Try to change this value and restore the file. But do not forget to save original backup just in case.