Order Number

[Eoin Murray]

Hi,

 

My shop is new only last week (www.murraymotorsport.ie) but the order number automatically start from 0+.

 

Because is only a new site when the customer sees the order number it is really low. Is there a way of starting the numbers from 1000+ so my shop looks busy!

 

Thanks

 

Eoin

[hejhog]

Hello,

Install this contribution called UNIQUE ORDER NUMBER.

 

http://www.oscommerce.com/community/contri...ch,unique+order

 

Many Thanks,

Shaun

[Eoin Murray]

Hello,

Install this contribution called UNIQUE ORDER NUMBER.

 

http://www.oscommerce.com/community/contri...ch,unique+order

 

Many Thanks,

Shaun

 

 

Thanks for your help

[gazzzzzza]

Or if you just want to increase the number, you can run a command on the database orders table to set the auto increment value to whatever you want to start it at.

 

I think this may help (should set the current next id to 100001), but backup your database first eh !!

 

ALTER TABLE orders AUTO_INCREMENT = 100000;