add digitals to invoice number

[bean_2k1]

I have several Zen Cart stores now, and i was wondering is there any way i can add BTR or LEG in front of the invoice of my stores so i can look at the invoice number and tell strange away from the invoice number ?

[schoolboy]

We also looked at this, but I don't think it can be done...


... so we set up the NUMBERING to help us identify the store.


Shop 1 - order numbers STARTED at 1000000
Shop 2 - order numbers STARTED at 4000000
Shop 3 - order numbers STARTED at 8000000

We figured that if we get average 100 orders a day through every shop (far from reality right now) then it would take A HUNDRED AND TEN years before the numbers started overlapping.

And by that stage I wouldn't really need to care about it any more.

[bean_2k1]

is there anyway in the admin section you can do this for admin only ?

[schoolboy]

I don't think so... the order number is a crucial identifier, fundamental to the full workings of the system.

It has to be unique - across the board.

What you could do is export the orders from zencart, then, in something like MS Excel, CONCATENATE the order number with the Alpha prefix.

So. in your excel spreadsheet you have THREE columns:

COLUMN ONE - - - - - COLUMN TWO - - - - - COLUMN THREE
ABC ------------------- 1000--------------------=CONCATENATE(A2,B2)
ABC ------------------- 1001--------------------=CONCATENATE(A3,B3)
ABC ------------------- 1002--------------------=CONCATENATE(A4,B4)

Then, in COLUMN THREE put in the following formula:-

=CONCATENATE(A2,B2)
(assuming that Cell A2 is your first reference point for ABC and cell B2 is the first reference point for the order number)

Copy and paste that formula down the column. It will automatically put in the relevant cell references.

Then you will see:-

COLUMN ONE - - - - - COLUMN TWO - - - - - COLUMN THREE
ABC ------------------- 1000--------------------ABC1000
ABC ------------------- 1001--------------------ABC1002
ABC ------------------- 1002--------------------ABC1003

Now, HIGHLIGHT column 3
Copy the column (ctrl+c)
Using PASTE SPECIAL, Paste using VALUES only, into COLUMN 4

Now you have your orders numbers with the relevant alpha code.