Cargo bikes or bike trailers are two of many solutions to this dilemma that immediately sprung to mind. In the Netherlands I have seen grocery stores deliver large deliveries in big tricycles.

There are billions of people that manage their shopping without a car. Millions of them live in North America. Surely, some of them have solved this problem for a family without having to go shopping daily.