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!!!!
Bookmarks