Problem with Meta Tags after updating them in database...

[osdparts]

I searched through all the posts but no luck trying to figure this one out. I have over 6000 porducts on the site but had no meta tags defined for any. So using PHPmyAdmin, I downloaded a csv file of the meta tags from the database and bulk added meta tags to every listing. The problem now is this... before when you went to edit each individual one, the site automatically had all the "Mark What the Product's Meta Tag Title Should Include" boxes for Product Name, Title, Model, Price, and Title/Tagline checked to "YES". Once I bulk edited the database and put my own title in every product, "Mark What the Product's Meta Tag Title Should Include" for every item on the site was apparently changed set to "NO" (see image below). What that basically did was remove the automatically generated META TAG TITLE". Now products aren't showing prominently in searches like they did before. The question is how do I basically bulk turn all the "Mark What the Product's Meta Tag Title Should Include" settings to YES without removing the Keywords and Description info I added? I searched the database selections I could edit and can't find that in there but know it has to be stored somewhere. Any help is greatly appreciated!

[torvista]

These form part of the product record in the products table: "metatags_title_status" etc..

[osdparts]

These form part of the product record in the products table: "metatags_title_status" etc..

Thanks! That isn't in the list of things that can be edited in PHPmyAdmin though. Would I have to edit in the actual complete database or where exactly is that if you know?

[torvista]

? I can edit anything in phpmyadmin. Nonetheless normally I export these fields using Apsona to a csv, then edit with Libreoffice.

[osdparts]

? I can edit anything in phpmyadmin. Nonetheless normally I export these fields using Apsona to a csv, then edit with Libreoffice.

When in PHPMA and I click on the database, out of all the things I have to edit "metatags_title_status" isn't in the list.

[twitchtoo]

What you are looking for is in the products table, see all the columns that start with 'metatags_' and you can set the appropriate status with an update SQL statement.

[osdparts]

What you are looking for is in the products table, see all the columns that start with 'metatags_' and you can set the appropriate status with an update SQL statement.

Thanks that did it! I'm not up on how to edit with a SQL statement but downloaded the products table in csv and changed all the values I needed to change to get it where I want it. Thanks again everyone for the help!