I haven’t run into that at my local HyVee for things I purchase. Generally long term things like canned goods go on sale around a year before their best by date to encourage turnover.

Any locally owned chain will vary in how well their different locations, sucks that yours is not doing well.