yashsingh1/xdaforums huggingface dataset:
[Nexus 4 General] PhilipL:
Hi

The assumption here is that the system has an 'ORDER BY OrderDate ASC' when the orders are listed to be picked. Also the order IDs, due to I suspect some load balancing (more than one database) could essentially be random numbers or offset so the IDs can be guaranteed unique across different databases, so if the picking list is ordered by that ID, then depending on which database recorded your order and the ID offset, you will be in the last half of orders regardless of when you placed it. This would explain the seemingly random nature of despatches.

I work with big database systems and IDs are often far from sequential, and a simple ORDER BY can be overlooked.

Regards

Phil
[Nexus 4 General] Richieboy67:
I agree.. next time I will just ignore the whole thing for a month or so.. This is ridiculous.

sent via xda premium with nexus 7-Xbox live-loneleppard add me
[Nexus 4 General] DroidDavi:
Lmao
[Nexus 4 General] ManOnTheMoon:
are you sure? my tracking number says the origin scan was at Kentucky at 11am this morning? it says 2nd day air. im assuming monday delivery...
[Nexus 4 General] ugotproblemz:
is that only in the EU version??

was watching the unboxing and they mentions it didnt come with it and google website states..

What's In The Box

Nexus 4 phone

USB sync/charge cable

AC Adapter and cable

SIM ejection tool

Safety and Warranty information

Quick start guide
[Nexus 4 General] Ast2001:
I also have an ear headset (but the quality seeems very poor).
[Nexus 4 General] Richieboy67:
With regards to the offers being in order.. There are probably a hundred people packing these orders. There is no way they can do it exactly in any order. It just does not work that way but that doesn't meant the earliest orders will get screwed..

sent via xda premium with nexus 7-Xbox live-loneleppard add me
[Nexus 4 General] kzoodroid:
Can someone with a tracking number check and see what the estimated delivery date is. UPS always delivers packages on that date and not a day sooner even if they have to hold the package for a few days.
[Nexus 4 General] vita10gy:
Yes, people who ordered first deserve it first, regardless of "how" it happened. It wasn't available "all night", so that makes little sense.*

I mean, I get what you're saying on SOME level, and certainly no one is rooting for you NOT to get one, but at some point first come first serve is the fairest system. I ordered mine 10 minutes into the sale. I should get mine before one of those people who got a quick "add to cart" and possibly even tricked the system into an order, on their 32243323rd refresh 7 hours later. I don't really see what's "illogical" about that. The alternative is suggesting google should ship based on how bad someone wants it.

*This thinking would kind of be like if Best Buy sold pre orders for the phone and opened at 10. I slept til 9, and got there at 9:45, and reserved one at 10:10. You stayed up all night, were going to go at 5 am, but your car wouldn't start, and by the time you got a ride out there it was 11 and they sold all the preorders they were willing to. (Or they told you that you might not get one of the first shipments) You'd get, and deserve, some "wow man that sucks" from the crowd, but surely you would be hard pressed to expect anyone to think you were somehow "more deserving" of a phone that people reserved fair and square before you got there. Also, clearly dispersing those phones in order of the purchase of those pre orders would be the fairest way.

If they don't ship first come first serve then they can't tell the people who just "couldn't get in" from the people that just wandered in late, and that's just plain and simply not fair to the people whom they KNOW ordered it first.
[Nexus 4 General] heat361:
If the Europeans are getting headphones I better get some damn headphone :p
[Nexus 4 General] feelfreetoblameme:
There really seems to be a variance store-to-store, rep-to-rep and online. The stated price online is 9.99 with a 9 dollar discount, which ends up at 99 cents. I ordered one online on Saturday and it was delivered yesterday. Now for the long Nexus wait like almost everyone else.
[Nexus 4 General] tawfiqmp:
I have before also, but that's on 2 day next-air. On 2 day shipping such as amazon prime's 2 day, I've never been able to get it on Saturday in Chicago. Not sure if this is 2 day air or if this is just the regular 2 day.
[Nexus 4 General] DroidDavi:
Let's start with our phones
[Nexus 4 General] dwd3885:
well that's not true. i've often gotten packages a day early.
[Nexus 4 General] liam6576:
screen cap of the email?
[Nexus 4 General] flo7002:
That's not true, I've gotten lots of stuff early before. FedEx never delivered early for me...
[Nexus 4 General] DarkSi08:
Stop trying to math. UTC-8 is Pacific Standard Time. That says you ordered it at 10:41am CST, like you said. :highfive:
[Nexus 4 General] Geo411m:
I said the same thing when I got that email. :mad:
[Nexus 4 General] booyakasha:
Lol I got the same thing and almost chucked my N7 across the office
[Nexus 4 General] heat361:
Haha OK I'll change it

If the Europeans are getting their nexus phones now and headphones I better get my nexus phone now with some damn headphones :p:D
[Nexus 4 General] tawfiqmp:
Me too. I'd like a cheap pair. They always come in handy.
[Nexus 4 General] benderunit9000:
they only deliver on saturday if the shipper paid for that service. it is not part of '2 day air' service unless they pay for it.
[Nexus 4 General] Ast2001:
The headphones.

Envoyé depuis mon GT-N7000 avec Tapatalk
[Nexus 4 General] kzoodroid:
I've never gotten a package from UPS earlier than the estimated delivery date, and I get packages delivered every week.
[Nexus 4 General] Clay:
Just spoke to Google on the phone. They said we can expect a tracking number tomorrow or Monday at the latest if we don't have one already. Something about a lot of people ordering phones or something...
[Nexus 4 General] vita10gy:
First off, I'm fairly certain that's just not even true.

Secondly, even IF true, isn't it more likely that the algorithm for the billion dollar company that estimates the delivery date factors in knowing that it's going to sit behind X packages at this or that distribution center before it's moved to the next step than it is that they arbitrarily sit on the package just for the sake of not being early?
[Nexus 4 General] Plexicle:
I order stuff just as often and half of the time it gets here a day early.

The tracking information changes to "EARLY DELIVERY SCHEDULED FOR:"

I would say half of my shipments end up that way.
[Nexus 4 General] krohnjw:
UTC -8 is pacific time in the US. That's 10:41 am Central, 11:41 Eastern.
[Nexus 4 General] UCFJake:
That last sentence made me laugh super hard. Thank for injecting some levity to this thread!
[Nexus 4 General] ManOnTheMoon:
see attached screenshot.

so basically i can expect this saturday.....
[Nexus 4 General] ruthlesset:
Actually I just called T-mo and they shipped one to me for free this morning
[Nexus 4 General] rehughe:
I'm not sure about about 2 day next air, as I don't think I've ever had anything shipped that method. But I have definitely received Amazon Prime shipments on a Saturday. We order absolutely everything off Amazon Prime, since Cook County is 10% sales tax and Amazon is generally cheaper than most places, so we have at least a couple shipments every week.
[Nexus 4 General] Red Wolf:
I ordered same time as yours, 11:35:52 AM EST but still nothing :eek:
[Nexus 4 General] ny15456:
havent seen anyone with ship estimate 16 Nov. Anyone else out there? Ordered 4PM PST
[Nexus 4 General] chrisnk204:
Idk why ppl are saying that google is waiting to process and charge us they took 400 out my account minutes after my order ive checked my bank account and its still gone also everybody is giving their reason why google is slacking on customer info and support ITS BECAUSE GOOGLE **CKED UP PLAIN AND SIMPLE. Like idiots they didnt alow pre-orders and chose to not let anyone sell it but them. Google really messed this up , idk why they acted so retarded with this but im gettin fed up with this whole process i just hope i get my shipping info TODAY. If not im just gonna wait longer lol theres nothing i can do anyway
[Nexus 4 General] heat361:
Just got a shipping update origin scan Louisville, Kentucky 16gb
[Nexus 4 General] wngmv:
Did you use a debit card or credit card? If you use a credit then it should be "pending". It's usual practice with all online shopping. If you used a debit card then the money is out.
[Nexus 4 General] donkeyhitman:
Funny how most of us would have not have touch the 8GB version with a 10 ft pole prior to the launch, now would readily accept it with open arms. The conspiracy theorist in me says that Google created this mess to train our minds to accept the 8GB version in response to the supposed shortage. I mean there were guys (and gals) who actually celebrated when they were successful in getting the 8GB. Who would have thunk it?
[Nexus 4 General] princebama:
One X Plus if anything
[Nexus 4 General] supersain08:
Thunk?
[Nexus 4 General] amdhunter:
No screw the phone. I just want the headphones. :mad:
[Nexus 4 General] _guzzler_:
Updated: KY to CA!! hope I receive it tomm :)

Louisville, KY, United States	11/15/2012	12:59 P.M.	Origin Scan
[Nexus 4 General] osi13:
Did you just receive the email?
[Nexus 4 General] DroidDavi:
Lol
[Nexus 4 General] Geo411m:
Um... this is how I feel. Like that baby :p
[Nexus 4 General] donkeyhitman:
http://en.wiktionary.org/wiki/who'd_have_thunk_it
[Nexus 4 General] Roxy:
KY to CA is most likely 2 business days. ( referring to my Galaxy Nexus order back then )

Sent from my teapot. :3
[Nexus 4 General] kzoodroid:
I've had packages sit at a regional distribution center for 2 days or longer (weekdays) 50 miles from my house. They sit there till the estimated day of delivery then move to the distribution center in my city at 4 am and then show as out for delivery at 6 am. This has happened more than once.

So I don't really care if you believe it or not as I didn't ask your opinion I asked someone who actually had a tracking number to check for the estimated delivery date.
[Nexus 4 General] heat361:
No I received it at 4:10 when a shipping label was created and I just checked my tracking number and it updated with status in Kentucky.
[Nexus 4 General] ninjames:
For the record, very few packages have some kind of "hold" stipulation. UPS, FedEX, DHL, etc will always deliver as early as they can without bumping you up to a faster tier of shipping. I order at least 20 things each month on two-day shipping, and I'd say about half of them arrive within a day. They will NOT hold it, they will deliver as soon as they can.
[Nexus 4 General] rockr4Christ:
After calling Google PLay Support, the follow up email was:

Hello Trevor,

Thank you for contacting us.

Orders are processed within two business days. After processing, it will take an additional two business days for your order to be delivered.

After reviewing your account, I can confirm that your orders will be shipped today. You can check the status of your order any time at https://wallet.google.com/view/receipt?t=1XXXXXXXXX

https://wallet.google.com/view/receipt?t=1XXXXXXXXX

is this standard? or for real?

-trev
[Nexus 4 General] kangxi:
My UPS tracking just updated 4 minutes ago. Origin scan in KY.
[Nexus 4 General] ninjames:
Got a shipping email at 4:03 a.m. eastern, and the tracking number finally updated to show the Kentucky origin scan about 10 minutes ago. I'm expecting it tomorrow, based on my location.
[Nexus 4 General] vita10gy:
As has been stated in the thread 5000 times: Online retailers routinely do an authorization charge, or place a hold, on your card. Otherwise when it came time to ship they could find out you screwed up your credit card number, are over your limit, don't have enough in your account, etc.

When you use a credit card this is reflected as a pending charge which you won't be billed with, but counts toward your limit, until charged or released.

When you use a bank card there's no such "future balance" to play with, so it is often reflected in reducing your account by that amount, but it's still in limbo. This way google knows you're "good for it" when the time comes and it's not going to find an account with $52 in it. (But it isn't Google's yet either. It's a function of your bank.)
[Nexus 4 General] felito6985:
Disregard...
[Nexus 4 General] zrblnk:
What's the status that displays on your google play orders?
[Nexus 4 General] princebama:
Stop posting those copy n paste standard auto reply emails :(
[Nexus 4 General] rockr4Christ:
"Shipping est. Nov 15" and pending in wallet and on my cc
[Nexus 4 General] _guzzler_:
So end of day tomm i guess for me...
[Nexus 4 General] booyakasha:
Omg we've gone like 3 minutes without a post....is everyone alright? Sound off!
[Nexus 4 General] dale_cooper:
assuming you're talking about ordering a ton of stuff with amazon prime? In which case, you're actually being upgraded to next day saver overnight if you're in ohio like me. Prime packages always get upgraded to next day saver. If you perform "calculate time and cost" on ups website, me being in Columbus it says that for Louisville to Columbus, it still shows Monday as the delivery date for 2 day shipping :(
[Nexus 4 General] ohaaron:
Nope. Dead. ;)
[Nexus 4 General] DroidDavi:
Sorry i was flipping tables
[Nexus 4 General] Roxy:
I don't know how long they'll be holding onto my money if they're not going to ship my order anytime soon:
[Nexus 4 General] sn0warmy:
Same here. I think this is the case for 90%+ of us. All we can do at this point is go about our lives until it arrives. I'm expecting the phone to arrive by Tuesday. If it comes before that it's just a bonus at this point.
[Nexus 4 General] Exel:
I. want. my. tracking. numbers. I:
[Nexus 4 General] brandont218:
Origin Scan: Louisville, KY @ 1.01PM EST

UPS Tracking states that it is shipped by UPS 2nd Day Air

Believe Saturday delivery is a value-added service, only available if shipper requested for it. Looks like it'll be delivered Friday, or Monday at latest.
[Nexus 4 General] neuty:
If we dont get our shipping email from google by tonight, wouldnt that mean that they've violated their 2 day processing time?
[Nexus 4 General] joe_sun:
I have to admit I've been pretty entertained with this thread. There's a lot of butthurt going on.

I'm going to write something that will make some of you cry. I bought this phone as a Christmas gift for my wife so when it arrives I'm going to hide the box and nobody will even touch the phone until December 25th!!!!
[Nexus 4 General] dale_cooper:
Wrong - Monday. Friday is first business day, Monday is 2nd. Calculate transit time for different services on ups.com
[Nexus 4 General] aznsmith:
Awesome! I got my tracking email around 2:30 AM EST. I have a feeling that my package is probably being buried.
[Nexus 4 General] pitchshifter:
they need these little wins the way everything have been going.

why didn't GOOG launch the phone on Monday and give themselves more breathing room?
[Nexus 4 General] booyakasha:
Does, not, compute...
[Nexus 4 General] 2015Ducatimulti:
yeah mine looks the same too, I used my Paypal debit card too.
[Nexus 4 General] billbradford:
I have a shipping notification and tracking number for my 16G wifi Nexus 10, but the N4 is still showing an estimated shipping date of today.
[Nexus 4 General] mafiaboy01:
I mentioned this in the Canadian thread, Would have made more sense to have orders start Sunday or Monday, they they could have everything out by the end of the week.
[Nexus 4 General] nibrwr:
Hahaha
[Nexus 4 General] YoungAceAtlanta:
i really don't understand that if its shipping 2nd day "AIR" then why wouldn't it be here tomorrow.. i mean if its on a airplane KY to NY is like a 1 hour non-stop flight.. wth is that plane going to be making 19 stops before it gets to NY? i can understand UPS deals with 50k-100k packages a day in a single warehouse probly but still..
[Nexus 4 General] booyakasha:
I've watched so many reviews and so many unboxings, already have 4.2 on my 7, read all there is to read about the 4...in a sense, I've had the phone for weeks now.

It'll be 30 seconds of "oooooooo" then I'll need to take a **** or something and it'll be old news. Tuesday works for me.
[Nexus 4 General] lionheart7282:
wow is it just me? my order still says Nexus 4 (16GB)

Nexus 4 (16GB)

Devices

$349.00

November 13, 2012

Shipping estimate: November 15, 2012

Info

Help Center:mad:
[Nexus 4 General] K Rich:
This should be in the OP:good:
[Nexus 4 General] princebama:
Is it possible once you get your UPS tracking number to contact them and pay for Saturday delivery?
[Nexus 4 General] frankied22:
lol so true.
[Nexus 4 General] sn0warmy:
Jesus Christ. Read the thread...
[Nexus 4 General] Exel:
I'm getting so many e-mails today for some reason, and none of them are the ones I want to get. :(
[Nexus 4 General] brandont218:
Let's say the plane leaves at 1.01PM EST. Gets to JFK 2.01PM EST. Unloaded, and packed into trucks by 3.01PM EST. These trucks then deliver to the main hub at Maspeth. Get there at 3.30PM EST. They're not going to send trucks out at 3.30PM. It'd make more sense to hold the parcels, and the trucks and wait for more packages to arrive throughout the day till tomorrow at 7AM, which is when they dispatch for local deliveries..
[Nexus 4 General] amdhunter:
Son of a ...
[Nexus 4 General] lionheart7282:
don't bring Jesus Christ into this:angel: i am not gonna read more than 800 pages thank you.
[Nexus 4 General] ManOnTheMoon:
haha im wondering the same. i am so down to pay a quite bit extra to make sure i get it before the weekend. i would really like to play with my new phone black ops 2, halo 4 and assassins creed.
[Nexus 4 General] Geo411m:
Me too. I just unsubscribed to a ton of stuff.
[Nexus 4 General] KonstantinKeller:
Same.
[Nexus 4 General] YoungAceAtlanta:
That is pretty much what i wrote?

im saying.. if my package is in transit right now.. and like you said if my package leaves KY at 1PM and gets to JFK at 2PM, unloaded and shipped to its local hub around 5PM or so.. then it makes no sense as to why my package won't be deliver early as friday
[Nexus 4 General] akkiman:
naviga diurrel

I'm anxious to receive my order. My status still shows " Shipping on the 15th November"

I just called up google support and they said that it might take another day to process my order.

Am I the only one ?
[Nexus 4 General] MyronJ906:
Finally got my origin scan. A little disappointed since I disillusioned myself into thinking it my arrive today with no scans.

Ordered at 10:33:35 AM CST, got confirmation pretty much immediately (definitely within 5 minutes), and My Orders on Google Play has pretty much always shown as Complete.

I did a shipping calculation from Louisville to my location, and even if I had paid for ground shipping they estimate that it would take...one day, so hopefully tomorrow's the big day.

I'm currently phoneless (sold my One X) and living off of my Nexus 7

EDIT: For anyone wondering, I forgot to state 16 GB Nexus 4
[Nexus 4 General] JNewms:
This is frustrating. I haven't received any tracking info yet. Sad thing is is that I live about 2 hours from Louisville. Wonder if they'd let me just pick it up
[Nexus 4 General] kangxi:
Same here. I have no phone, only my Nexus 7 lol.
[Nexus 4 General] dexter_walrus:
I called them about an hour ago and they told me I should get a shipping confirmation today or tomorrow
[Nexus 4 General] MaxCarnage:
I ordered mine 6 milliseconds before you; WTF!?!?!?

;)
[Nexus 4 General] a5ehren:
Don't get his hopes up. If it doesn't get to your local hub (if you order a bunch of stuff online, you should probably know what your local UPS hub is by now) by the very early hours tomorrow morning (think ~4 AM), you won't get it until Monday.

I think a lot of people that don't live really close to Louisville will be disappointed when their phone gets to their local hub at like 10am tomorrow and then sits there all weekend.
[Nexus 4 General] lionheart7282:
no you are not the only one, mine says the same.:rolleyes:
[Nexus 4 General] s1lenz:
the first 10 pages of this thread contained as much information as the last 10 pages of this thread..
[Nexus 4 General] cooperaaaron:
I was getting the 8GB version anyway...

I have a 16GB card in my Comet. Guess what ? I have only used 1.5 GB, lol ! So I did not see a need for me to get a 16 GB version, even tho my friend suggested that I should. I will be just as happy with the 8 GB!

On another note, I am wondering if some of these posters are Apple guys who want to piss off the Android community with their postings?

On another note, I just got that email with the little Andy and a shopping cart... but no other emails from Google, lol ! That's what made me laugh! I think Google is watching the postings and decided to send a little something to everyone's email box, I jumped when I seen it was Google, but I then opened it up......and lmao !!!:laugh:
[Nexus 4 General] Red Wolf:
I ordered 2 min after you 11:35AM EST but still waiting :fingers-crossed: but I am enjoying the XDA :eek:
[Nexus 4 General] richteralan:
Called Google CSR. I sense a huge nerd rage explosion coming:

She told me if you haven't receive shipping email by now, your phone won't be shipped today. Mostly tomorrow.

Now let the rage begin!!(or table flippin)
[Nexus 4 General] illmatic90:
Just received my transit info, shows "in transit" from Kentucky. Looks like they got the packages moving finally, since a I've seen a bunch of people receive their updates as well.
[Nexus 4 General] AngryHog:
Not today

Went out for lunch, was behind the UPS truck leaving my neighborhood. No phone for me today. :(

-AngryHog™
[Nexus 4 General] luckylui:
Just got off the phone with a Google rep. She told me my shipment shipped out today 15th. Will arrive at my door step on either the 17th or 19th! I would advise all to call. My order stayed at pending, never said preordered or ship. Just pending.. But its actually already on its way. Will receive a confo with tracking tonight!! :)
[Nexus 4 General] tengen:
So much for shipping by the 15th <_<
[Nexus 4 General] neuty:
If that's the case ill ask for a shipping refund, period.
[Nexus 4 General] drew_grant:
I got it around 4am central time.
[Nexus 4 General] raptir:
Same here. Oddly enough, my replacement Nexus 7 16GB WiFi order hasn't shipped yet either.
[Nexus 4 General] joshyy_rey:
Then search it..... we have enough repetitive info in here already ;)
[Nexus 4 General] laverdure#1:
Somebody already asked for and got a refund apparently:

http://xdaforums.com/showthread.php?t=1989367&page=142
[Nexus 4 General] amdhunter:
You can call them to put a hold on it and you can pick it up yourself at the end of the day. That's probably a better bet. I did this once, but had to wait a few hours (yes HOURS) for the delivery guy to show up with the package. Granted, I did this 5 years ago...
[Nexus 4 General] AntonJart:
I got my email at 1:38 PST. I hope its here by saturday!
[Nexus 4 General] zander145:
UPS has updated with info for me now!
[Nexus 4 General] Geo411m:
I'm a hardcore nerd? Sir, I have never been in an adult film.. :p

JK aside, I have to agree that this phone isn't being advertised all that much and I don't believe it will sellout in a day. Having said that, I'm ordering as soon as it's released because I sold my note 2 and I'm now using a tiny Nexus One and I'm hopeful I'll receive it by friday.
[Nexus 4 General] Ace42:
I wish UPS wasn't the shipping carrier because they tend to always come at a time when no one is home(early morning);not to mention I don't live close to a UPS center so I have to travel a good distance to reach one, whereas I live close to multiple USPS locations. This is why I hope Amazon will carry the phone so that I can have USPS as the carrier.
[Nexus 4 General] ctowne:
Sold my Gnex on CL a week ago for $275 because I didn't want it to lose value when the Nexus 4 came out. Bought an unlocked S3 for $300 to tie me over until I get my shiny new N4 and then I'll probably sell the S3 for $350. I can't wait to not have a physical home button, it's terrible!