nickfromtq Posted June 27, 2011 Share Posted June 27, 2011 Hi, Could someone please tell me how I can add the words Free Delivery to the product title of all my products. I think an SQL Statement would be needed for this. Any help would be very much appreciated. Kind regardsNick 1 Link to comment Share on other sites More sharing options...
shokinro Posted June 27, 2011 Share Posted June 27, 2011 Assume you have only one language and is it for for all products update `ps_product_lang` set name = CONCAT('Free Delivery ', name) CAUTION:PLEASE make a backup of database before run any SQL statement. Link to comment Share on other sites More sharing options...
nickfromtq Posted June 27, 2011 Author Share Posted June 27, 2011 Am i right in assuming that if I wanted Free Delivery after the name in the title it would be. update `ps_product_lang` set name = CONCAT(name ,'Free Delivery ') ThanksNick Link to comment Share on other sites More sharing options...
shokinro Posted June 27, 2011 Share Posted June 27, 2011 Yes you are righy.But put a space or - before the word Free. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now