Post by Anderltu » Mon May 27, 2019 2:16 am

Hello. How to change/add same metadata keyword to all products at once using SQL query/queries?



Sun Apr 15, 2018 4:16 am

Post by D3MO » Mon May 27, 2019 4:59 am

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

Opencart Expert |
Skype - programanija | Gtalk -
Extensions for Opencart @ / or Opencart Marketplace

Need Custom Module? debug third party module or simply have any question related to Opencart? feel free to contact directly for a live chat session:) - INSTANT LIVE CHAT

User avatar
Active Member


Mon Apr 04, 2011 6:57 am

Post by letxobnav » Mon May 27, 2019 9:34 am

/* 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';


Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

User avatar
Expert Member


Fri Aug 18, 2017 4:35 pm
Location - Taiwan
Who is online

Users browsing this forum: No registered users and 32 guests