Bulk changing the product meta titles

[homeuk]

HI,

 

I imported and worked on a few hundred products using the CSV import. However, rather stupidly I set all the url names (i.e. apple-iphone-7) to be the meta titles. I really want to set all the meta titles to be the same as the product name (i.e. Apple iPhone 7). Is there a way to do this without buying an export addon, changin in excel and then importing?

 

Using 1.7.2.2.

 

Thanks,

M

[homeuk]

It's okay, just ran this on the database in phpmyadmin and that did it. Deletes all meta-title entries and PS defaults it to the same as the product name so no need to re fill entries.

UPDATE ps_product_lang SET meta_title=''

[RogueWaveLimited]

FYI, if you ever need to change just one field, you can create a CSV with only two fields, one with the id or product sku and one with the data you want to change. 

 

 

[homeuk]

Ah, yeah, hadn't thought of that. Cheers.