How to change Order ID#

jfilardo · #1 08-31-2006, 09:36 AM

Hello all,

I'm trying to figure out how to modify x-cart to display the Order ID# as an alpha-numberic value. Currently my Order ID# is number ic only, counting up from, 1, 2, 3, 4, etc. What I would actually like is something like US1, US2, US3, US4, etc.

I plan on having multiple country specific stores and am trying to avoid duplicate Order ID#'s so the prefix US or CAN before the actual number would be beneficial.

Thaank in advance,
Jason.

Ana · #2 09-21-2006, 09:13 AM

Agreed, an order prefix would be great to separate different stores' orders. When running multiple shops, it can get confusing.

Ana

Ana · #3 09-29-2006, 04:28 PM

I just used a numeric code for each store. there is a 9 prefix for one, 8 for another resulting in 9000001 etc. If you have over 8,999,999 orders in a short amount of time (averaging 24658 orders a day in a year), I would think you might want to pay for some serious programmer to build your own place (by that time, you sure as hell should be able to afford it!)

Just a blonde suggestion.

Ana

jfilardo · #4 10-07-2006, 05:53 AM

Thanks Ana. What I ended up doing is changing the Label Tag for Order ID to Read "Order ID (USA):" and "Order ID (CAN):" in the Languages section in Admin.

Now my orders and Invoices come out looking like... Order ID (USA): #486

Be sure to do a label search for "Order" and change all occurances of the Order ID label. There are several.

Cheers,
Jason.

katoby · #5 10-07-2006, 08:12 PM

Just wondering where you go to change the order ID prefix or starting # (i.e. I don't want my orders starting off at #1)... I want to have the order ID's start where my old shopping cart left off.

carpeperdiem · #6 10-08-2006, 05:54 AM

Quote:

Originally Posted by katoby

Just wondering where you go to change the order ID prefix or starting # (i.e. I don't want my orders starting off at #1)... I want to have the order ID's start where my old shopping cart left off.

A list of things asked a million times

katoby · #7 10-08-2006, 08:10 AM

Thanks!

ARW VISIONS · #8 10-09-2007, 11:39 AM

Is there a way to put an order prefix? I want my orders to be prefixed with AIW-

carpeperdiem · #9 10-09-2007, 01:36 PM

You can make the order prefix separate from the database... if ALL orders in your store begin with AIW- then the way I would do it:

1. Determine where order numbers are displayed.
2. Change the template that dispalys order numbers.

For example - in /skin1/main/orders_list.tpl

find:

Code:

<td><a href="order.php?orderid={$orders[oid].orderid}">#{$orders[oid].orderid}</a></td>

instead of #{$orders[oid].orderid} - you want it to be:

#AIW-{$orders[oid].orderid}

yes?

Find all the other places that an order # is displayed (use webmaster mode) and go to town.

That's the "easy" way. The hard way will be to create a table and append alpha characters to the table and I wouldn't know where to start. Beyond me. This makes your order number a simple display/template fix, not the underlying order number.

Will this work?

ARW VISIONS · #10 10-09-2007, 04:26 PM

Sounds like it might. I'll give it a shot. If I get it to work I'l post my findings here.