homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / Ecommerce
Forum Library, Charter, Moderators: buckworks

Ecommerce Forum

Order Number - just incremental?
just bought a few books from Amazon

 7:57 am on Jan 21, 2009 (gmt 0)

I bought a few books from Amazon a moment ago and for the first time I noticed they have quite a long order confirmation number. If you have as huge a database as Amazon does, it seems to me a great idea to include some numbers (date+customerid+. . .) which can help you simplify the db queries.

What does your "Order Number" look like?

[edited by: Habtom at 8:00 am (utc) on Jan. 21, 2009]



 8:42 am on Jan 21, 2009 (gmt 0)

Amazon's numbers are probably long because they do include all that info (and much more) in encrypted form.

With an operation their size, no amount of 'human friendly' stuff would really make a lot of difference; their human beings tend to use bar code translators - my Amazon parcels always have at least three different bar codes!


 2:40 pm on Jan 21, 2009 (gmt 0)

they do include all that info (and much more) in encrypted form

I agree. I know this is a not-so-significant issue for smaller businesses, out of curiosity though I would like to hear from someone who found it useful for some reason.


 3:44 pm on Jan 21, 2009 (gmt 0)

I think incremental (sequential?) is great. We're currently around 57,000. When I first went from 9,999 to 10,000 it was a great moment. Reaching 100,000 will be another. We do not distinguish origin of order, but one distributor I work with uses W for web, and SO for sales person generated. Their RMA system uses YYMMDD000.


 5:05 pm on Jan 21, 2009 (gmt 0)

My sites all issue sequential order numbers -- I don't think my customer's know or care what information is contained in the number, just that I am able to look up the order quickly if they reference it. We're about to hit 40,000 on one site and 2,000 on a new, smaller site. I get the same excitement as sun818 when I reach 'milestone' numbers.

We also have a second set of order numbers (we're a wholesaler/distributor with a web outlet). Sales orders start with an 'S' as in S123456 and are followed by a generation/invoice number i.e. S123456.001. Purchase order numbers follow the same style and rotate in sequentially, but start with a P i.e. P123457.001.


 11:25 pm on Jan 26, 2009 (gmt 0)

We imbed the date of the order, then a random number. sequential I believe leaves you open for some security risks. PO numbers are totally left out of it and are separate within our system.


 12:30 am on Jan 27, 2009 (gmt 0)

Many common shopping carts just use sequential order numbers. We've looked at those to see how many orders some competitors take.

We recently kept track of confirmation numbers we get from our merchandise suppliers. They all seem to be purely sequence numbers with nothing else included for info or obfuscation.


 9:46 pm on Jan 28, 2009 (gmt 0)

Our order number has the following structure:

Where XX -- is order number version used (always `01), just in case we want to use different order number structure
CCC -- Currency code (helps to distinguish orders from different countries)
YYYY-YYY -- some random numbers
Z -- validation number (checksum) that is generated from all the numbers from the order number.

P.S. Yes, I love to program complex things :-)


 10:02 pm on Jan 28, 2009 (gmt 0)

As an Amazon merchant, we have never figured out if there is anything significant within the order number that is useful to us. It seems like a random number but I am sure it means something to somebody at Amazon. I will have to ask the next time I am talking to a rep.

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Ecommerce
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved