Page 1 of 1

How to change/add metadata keyword to all products at once?

Posted: Mon May 27, 2019 2:16 am
by Anderltu
Hello. How to change/add same metadata keyword to all products at once using SQL query/queries?

Re: How to change/add metadata keyword to all products at once?

Posted: Mon May 27, 2019 4:59 am
by D3MO
if you interested i have somwhere the module wich one allows you to add unlimited keywords by route multilingual, so you set a route to what pages you want to apply it and simply fill the box and can create any routes you need even custom pages

Re: How to change/add metadata keyword to all products at once?

Posted: Mon May 27, 2019 9:34 am
by letxobnav
/* for empty meta keyword columns */
update PREFIX_product_description set meta_keyword = 'YOUR KEYWORD' where meta_keyword = '' and language_id = 'X';

/* for meta keyword columns with content */
update PREFIX_product_description set meta_keyword = concat(meta_keyword,',YOUR KEYWORD') where meta_keyword != '' and language_id = 'X';

adjust:
PREFIX
YOUR KEYWORD
X