Hello,

I am hoping someone will know how to do this. I realize it can be done but I'm not great with SQL.

My clients has over 800 items she has added to her database and after reviewing it with her I realized she didn't add in the keywords into her product name so that is hurting her in SEO.

Here is what I am looking to do, I figure this has to be a script for it

New Product Name = Product Name + Appropriate Category Name (based on the category the specific product is in)

any help would be great

thanks