Order ID start at 001?

[designingfresh]

Hello!

I have a unique problem. Due to the type of site that my client has. We need the order number to start out at 001 and continue on to 002, 003 etc. I've tried updating the order number with the double zeros but it just changes back to 1 or 2 even in the database manually. Is there a way to add the double 00's in front via the database or code?

Thanks in advance for any advice on this one!

[DrByte]

There's no quick easy built-in way to do that.
However, a workaround would be to use the Admin->Tools->Store Manager to set the next order number to 101, which is naturally 3 digits, and start from there instead of 001.

[gjh42]

Not in the database; the order id is a numerical auto-incremented value. But any place you want to use the order id for non-numerical purposes, you could edit the display as a string so it showed with minimum 3 digits, padded with zeros if necessary.

[schoolboy]

What happens when you finish processing order number 999 ?