We have farmers' markets here too, but if the problem with a supermarket is prices being too high then a trip to the farmers' market is the opposite of a solution. Never mind, of course, that a farmers' market would get cleaned out of everything on sale in a matter of minutes if everyone replaced their supermarket shopping with it.
I would like to know why you think that a supermarket that applies dynamic pricing in a physical shop would not also do the same online
I live in the countryside with fields directly backing onto my house and I still have no way of buying food directly from farmers, the absolute closest you can get is someone with an apple tree leaving apples in a box on their driveway when they have too many to use. Farmers markets are for posh twats.
My local farmers market is only open seasonally and consists of about 1/3 of their booths selling banking services or squishmallows, 1/3 of the booths selling (delicious, but not very storable) ethnic foods, a bread stand, a honey stand that also sells mail order animals by the quarter (butchered, I think), and 3 booths selling scraggly renditions of whatever they’re currently harvesting.
I wish I lived in the same sorts of community conditions where you live, or had the connections to local food producers that you do, but the reality is that I takes whats I can get.
And what I can get is from mega corps that care more about profits than starving a few people.