I had a very similar situation not long ago when our product range expanded quite quickly. What helped me was actually reading through a comparison of different PIM platforms and how they handle things like bulk editing, product relationships, and multi-channel distribution. I came across
https://0 and it gave a pretty clear picture of how centralized product data can be managed instead of relying on scattered files. It also explains how PIM systems can reduce errors and improve consistency across channels. After going through that, I started to understand why having a single source of truth really matters. It made the whole idea of managing large SKU volumes feel more structured and less chaotic. Might be worth a look if you're trying to figure out your next step.