The reason you haul entire shopping carts at once is because the trip to the grocery store is a big planned deal. That’s also the reason people buy bulk items and then let half of them expire.
The “ideal” for bikers and train riders would be easier, quicker trips to small stores to get ingredients for the next few days. I find I’m able to fit most of my needs into one pannier.