Thanks Ed and Wajo, that all sounds great. One thing that might complicate this a bit is that I've been reevaluating the old notion of marking parts either "figure", "accessory", or "merchandise". It was originally my idea, but I don't think much of it these days, because while it's usually clear which category a part should fall into, often the lines are blurred. For example, an Optimus Prime lollipop is clearly "merchandise", but it's also sort of a "figure". Then you have weird little parts like "Gasket" that you want to tag as being a "figure", but really he reeks of being an "accessory" (I'm also bothered by "figure", as some things aren't a figure, but are nonetheless the principal part in a toy, like a roleplay blaster, or that non-transforming Optimus Prime from Chicchana Omochaya).
I should probably put more thought into this, but what I've done (not checked-in, yet) is set things up such that any part can have any combination of these qualities (and I'm adding a new one, "gestalt"). With luck, I'll have more information on all that this evening, when I check in. Anyway, the complication is that the totals for "figures", "accessories", and "merchandise" will no longer necessarily sum up to match the total number of parts, because there will be parts that are both a "figure" and an "accessory", or a "figure" and a "merchandise", or a "figure" and an "accessory" and a "gestalt" (it happens), etc. I dunno, maybe it's not a complication, and people will understand that there's some overlap, especially if we do a fractional display in the context of each category. We'll see.
But anyway, I quite like the rest of it, especially the bit about having links to each of the conditions. Can't give any concrete ETA on this, as I still need to finish up the gestalt stuff, and Spaceharfang is making me learn his new database interface.