The free bus service to Tesco in Catterick Garrison is to stop running next month.
The service ran four days a week, picking up in Richmond, Leyburn and villages across Richmondshire, as well as Bedale and Aiskew in Hambleton.
A Tesco spokesperson said: “We regret that we have not been able to make these services work and would like to apologise to those who enjoyed using it.
“We are working hard to support customers affected to find alternative ways of travelling to our store, which is accessible via services offered by commercial operators.”
A spokesman for Proctors, which runs the Dales and District service, confirmed Tesco were cancelling the funding for the service.