It's incredibly frustrating. They encourage you to fill a cart with items that you can't actually buy unless you get extremely lucky. Amazon Fresh has exactly the same problem.
Imagine the collective amount of time wasted by this appalling UX that they have zero incentive to fix.