Quote Originally Posted by Feznizzle View Post
Awesome!

And information is all that is needed, really. This particular site sells parts, all products live 3 categories deep. All categories are structured like this:
Equipment-Type^Manufacturer-List^Model-Number

So my middle category has about 150 duplicate names and there is no way to know which Master they belong to, thus no what to quickly add a description. The real bugger though is that bottom category. Even though there are very few duplicates, that's a list of about 1000 model numbers. Without knowing the parent cats, it's next to impossible to automate the addition of a description, meta info, etc.

I just saw that you put up a solution on GitHub. I haven't tried it yet, but HUGE thanks! I will report back as soon as I have a chance to try it out.

What I was going to do---prior to the new code you just supplied---was export the category table direct from mySQL, then use vlookup over and over until I had it all sorted.

Maaaan that would have been painful. Huge thanks!!!!
No problem, as said, the information makes sense from a usability standpoint, but also leads to the potential of users misunderstanding that modifying it the same way as done with the full product data will provide the same results. I'll incorporate it into the master thread so that others can benefit from the change.