No magical this-will-solve-everything solution in this post, as frankly I'm not sure what is the best way to approach it, so I'll just be stating the problem.
Over the years, tons and tons of items have been added. And that's really cool! But as the number of items has grown - and along with it the number of recipes that require them, in addition to features like variable FEPs - so has the amount of effort required to store, organize and retrieve them. Every world I find myself spending more and more time just making sure I can actually keep the countless items I'm acquiring through natural gameplay (despite obviously dropping the uninteresting items), and it keeps taking more and more time to organize all my cupboards so I can actually find the correct items when I need them. (Simple time to retrieve keeps increasing as well even if I know where the item is - I try to keep related items together but sometimes you still need to go up two stairs or head to the other building to retrieve that one item you usually use for that other purpose.) The worst offenders are food ingredients (with a bazillion meats, forageables and fruits having been added since the World 8 launch) and curios, which must both be amassed in large quantities to keep up character growth. Stockpiles ease the problem somewhat (it would have been a massive issue without them; farming especially greatly benefits from them), but they're still far from a perfect solution (being limited to certain items and still taking up space).
I don't know what is the right way to solve this issue. Having an Atelier-style magical container that fits a bazillion items you could filter in many ways would be the most convenient, but that would completely undermine the current storage mechanics and related systems (there would be fewer reasons to build houses, for example). Perhaps a dedicated storage building that has massive capacity? Huge specialty containers for certain items (like a cupboard equivalent of a Wicker Basket)? Some way of seeing what items are in containers on your claim and where, similar to the community fair overview site where bots reported the contents and prices of Barter Stands to? I don't know what would be the best way to do it, but any tedium reduction in this aspect of the game would be welcome.