 |
UbercartOne cart to rule them all... |
|
| Donate | Affiliates | Sponsors | ||
Random order id
Submitted by Karel on Wed, 07/02/2008 - 13:34
Hello, I have a funny problem - I need order id to be completely random, because currently, with a known website start date, clients (and competitors) can count number of store orders just by looking at order id. Unfortunately, the id is quite useful for identifying orders (e.g. over the phone), so I don't want to completely remove it (from users). I would like to make it a random, unique, 6-7 digit number - where should I look? Or is too difficult to accomplish? Thanks, Karel.
OK, sorry. You really should allow Advanced search even for anonymous visitors: You really should allow Advanced search even for anonymous visitors.
Good point. Done. What about just using an md5 of the order id? 32 digits is a bit long, but it would appear random.    order_id is a unique key in the DB. However you compute it, you have to guarantee it's unique, otherwise the insert query will fail and the order won't get stored. MD5 is a good hash, but it is just a hash, meaning there's no guarantee that two order_id numbers won't get hashed to the same value. Shouldn't happen often, but when it does you'll never figure out why the order failed! How's about changing the autoincrement increment in your database. With a little bit of work they could determine the increment, but it'd be a quick sorta-fix. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#opti... Ah, that old thread of mine Just to keep updated, I ended up making the new order numbers out of time(). I did it once and have left it alone, letting the usual db_next_id() function keep track of those order numbers. I would love to be able to use alphanumerical combinations, but I suppose that isn't entirely necessary. Perhaps a "Customer order#" that would be more along the lines of a user-friendly number shown only to customers could be generated using a Contrib module, and this value added to forms and order screens. Not a huge deal, though - at least, not for us. Anymore.
|
|
Joined: 06/13/2008