I am currently assigned to the project of optimizing our site for the first time. I am running into a brick wall trying to figure out how to create keywords for all of our product pages and category pages. The site i am working on has roughly 30,000 product pages, so you can probably understand my frustration. Am i doomed to hand write keywords for all 30,000 products? I would like to know if there is a program out there, or if there is at least logic for one that can auto create keywords for me. The simple logic that i have come up with so far would be some sort of keyword database that i can query somehow using some sort of anchor text? (eg. anchortext=hamburger, keywords=food,beef,cattle,cattlemens association,cow,barbeque... etc).
If a program is not the correct way, does anybody have any advice on how to accomplish this?
Any help on this subject would be greatly appreciated.