I only ordered twice, day time and certainly not late. Two different houses, in trail version I played (full game just try for 24 hours) he came but didn't bring the Pizza. My Sims were hungry and I was sick of cooking. The Dad went out to get the pizza but no options he never knocked on the door, just stood outside. The kid decided he would go out and just socialize with the pizza guy...I finally had to ask him to leave.
Patched game new files no old saves, new install after deciding to buy the game a month later. He delivered the pizza, no problem. I'm still afraid to order the pizza, afraid it will fail like the first time before the game was ever patched.
ETA: no not a problem with just the Canadian pizza, first time the regular, no pizza, second time in new game delivered the Canadian so not sure it is due to a particular one or not. Or a lack of patches the first time around.