Got two different answers from two different people on our team about how to structure our parts catalog and I'm trying to figure out which way actually makes sense before we commit.
Option A: Flat catalog with everything at top level, use tags and custom fields to categorize. Search handles the rest.
Option B: Hierarchical categories — Category > Subcategory > Part. More structure upfront, more clicking to find things.
We're at about 800 parts now and growing. Don't want to rebuild this in six months because we picked wrong.
What's actually working for people at scale?
Another way to think about it: hierarchy pays off at scale if you have clear operational boundaries. My organization runs three distinct service lines with minimal parts overlap — HVAC, electrical, and plumbing. The hierarchy keeps technicians in their lane and prevents cross-contamination of inventory counts.
That said, flat with tags works well when technicians wear multiple hats and need to discover related parts across categories. The question isn't which structure is better abstractly — it's whether your 800 parts represent one business or several businesses sharing a warehouse. The answer to that shapes the right choice.
In my experience, both of you are overthinking this. I've seen flat catalogs turn into garbage dumps where nobody trusts the data, and I've seen hierarchies so deep that techs create "misc" parts to avoid navigating five levels to log a resistor.
The actual fix: who owns maintenance. Doesn't matter flat or nested if no one's curating. Assign someone to audit monthly, enforce naming standards, and delete duplicates. That's what saves you in six months, not your folder structure.
In my experience, both of you are overthinking this. I've seen flat catalogs turn into garbage dumps where nobody trusts the data, and I've seen hierarchies so deep that techs create "misc" parts to avoid navigating five levels to log a resistor.
The actual fix: who owns maintenance. Doesn't matter flat or nested if no one's curating. Assign someone to audit monthly, enforce naming standards, and delete duplicates. That's what saves you in six months, not your folder structure.