In all honesty... Walmart offers exactly what you're talking about[1]. Order your groceries online, pick them up at their store. None of the fancy organic-attitude stuff you talked about, either.
meanwhile I know of at least 2 whole foods i can go to.
walmart is pretty much impractical for people who live in sf even if they have a car.
That said, if you are going there anyway, the store-pickup still seems like an attractive option. Part of the downfall of Walmart is the time spent in the store, searching out things, wading through isles of people, and waiting for the badly staffed registers to get you through the line, only to be checked for stealing on your way out. This is worse if you must bring children with you. One can easily save an hour of time just picking it up.