Change order number format

[joebunting]

hi guys, i have an online store and i want to change the format of the order number assigned to every sale, at the moment it is: A1057 i need it to be A1057 etc every number needs a A before it,

any help would be greatly appreciated many thanks joe <_<

[joebunting]

...anyone know how i can do this....... :o

[Guest]

...anyone know how i can do this....... :o

I don't think that can be done, atleast not at the database end.

[NodsDorf]

The order number is setup as an Auto Increment integer.

 

As an integer, non-numeric characters are not allowed.

 

The only way I could think of making it appear this way would be to add another field into the database and modifying every occurrence of displaying the order number to concatenate the two fields.

 

Setting the database up to do this would only take a minute, finding every single occurrence of the order number would take awhile.

 

You can alter the order number to like 135500 or something like that so it don't look like you've only had 1k orders.

MySQL-> ALTER TABLE orders AUTO_INCREMENT = 135500