Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Change order number format


Recommended Posts

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 <_<

Link to comment
Share on other sites

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.


Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...