I’ve worked with many clients (and on my own sites) where avoidable structural/data problems add unnecessary complexity to website management.
I say avoidable because they’re usually a result of not asking the right questions upfront before the site is built. It’s a tough task to cover all bases for an ecommerce platform because there are so many factors in play that can affect elements like on-site UX, business reporting, data flows and SEO.
In my experience, it’s a continuous learning curve, picking up insight from specialists along the way to build a (hopefully) thorough knowledge base of what information you need to effectively build a website, what format the data needs to be in and what it needs to do e.g. data field X in the CMS drives site search results.