Order Numbers - Can this be changed?

[odgoodies]

Hi,

 

Coming from HTML, the OSC was a steep learning curve, but I managed to set-up my store without any glitches and I am now starting to get the hang of things.

 

I note that orders in my shop are numbered from no. 1 onwards. Can I change this to start at say, 18001 onwards? How and where do I make these changes?

 

Thanks in advance for any assistance.

[minorthreat100]

http://www.oscommerce.com/forums/index.php?sho...p;#entry1364033

[odgoodies]

http://www.oscommerce.com/forums/index.php?sho...p;#entry1364033

 

 

Hi Bill,

 

Thanks - I did search for this in the forums but could not trace anything. This post states:

 

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):

 

 

CODE

alter table orders auto_increment = 25;

 

This is a bit Greek to me - I have phpadmin and can access my db, but where and how is this inserted/amended?

 

Thanks.

 

Anton

[♥geoffreywalton]

In phpmyadmin select your db

 

Click on the sql tab

 

paste in the statement aove.

 

click GO

[odgoodies]

In phpmyadmin select your db

 

Click on the sql tab

 

paste in the statement aove.

 

click GO

 

Thank you so much! It was that easy.