I used to use a 10 to 1 weight to gold ratio. If it weighs 1 but is worth 10g I keep it., otherwise I get too bogged down, or have a fighter carrying 12 sets of armor which I don't like.
Only in this last playthrough did I start using the "Send to Camp" option to deload my merchant goods while campaigning and it has made a HUGE difference. Don't see a good reason not to take everything now. (still avoid rotten food)