Order Prefix ID

[KenshiroU]

HI all, I have a quick question is there anyway to add a letter to an order ID for example I have site A, B and C

So I would like my order IDs go to

A1 A2 A3
for site B B1, B2, B3
and finally site C which would be C1, C2, C3

is it possible to do this?

[gjh42]

The order id is an auto-incremented integer database key, and it would be dangerous to try to tinker with it unless you are expert in both MySQL and the Zen Cart database structure.

There have been relatively recent threads where this has been discussed, and you can search for ways of making appropriate display modifications. The best method depends on what you want to do with these ids, so more detail on how you want to handle them is important.
Following a link trail from the Similar Threads list at the bottom of this page, I find
http://www.zen-cart.com/showthread.p...omer-Order-Ids
where DrByte has some pertinent suggestions around post 14ff.
I know I have seen newer discussions too.