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?

Newbie

Posts

Joined
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 | voldemaras@gmail.com
Skype - programanija | Gtalk - voldemaras@gmail.com
Extensions for Opencart @ https://www.opencartextensions.eu / 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

Posts

Joined
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';

adjust:
PREFIX
YOUR KEYWORD
X

Crystal Light Centrum Taiwan
“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.


Active Member

Posts

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

Users browsing this forum: thekrotek and 43 guests