I ended up pulling my wp_terms and wp_term_taxonomy into a spreadsheet and editing it manually, a good amount of my category structure is repeatable (basically all child trees under the top-layer repeats for each top-layer). This was the only way I could get my drill-down to work were everything was nicely nestled where it should be…..
I would really like to know if there is a better way do this. I am basically building a very extensive game review website and there are roughly 110 different platforms and systems to cover, each platform should have its own drill-down that is basically the same, Genre 1, Sub-genre 1-1, Sub genre 1-1-1, sub genre 1-1-2, sub genre 1-1-3, sub genre 1-2, sub genre 1-2-1….. and so on and so forth (it comes out to like 90 threaded children and children of children, etc for each platform). I wanted to avoid situations where, say, a user was looking at an Action>Shooter game review under Xbox, and then clicked on ‘Action’ in the drill-down tree and suddenly ended up with simply all posts tagged as action, I wanted to make sure each ‘action’ genre was parented under a ‘platform’.
This method basically gives me something like 10,000 categories when all is said and done. I intend to use conditional tags to make sure each category, sub category, etc has some sort of header page…. but I expect that too will get unwieldy unless I can get the conditionally tags to work dynamically by what category is being displayed, which I hope I can do =D But that’s for the future.
Basically I want to know if anyone has any better suggestions for the clean, solid drill-down I want to achieve, or a better way to manage 10,000 categories other then via direct table injection. Maybe I am missing a referential tag or variable that can hold previous parents in the session and remember where the user is looking until a new parent is selected? I’m a little new to wordpress overall.
I also know that I will eventually need to make or find a widget for the category display in the Admin Panel>Posts Edit/New so that they can be expandable/collapsible (already have mods that make the tree always display hierarchical even after categories are selected, as well as forcefully select parent categories when a child is selected. So if anyone has any suggestions on that it would be great.
