larper Posted January 12, 2010 Share Posted January 12, 2010 I'm new to this osCommerce, I have some experience in SQL table with a close system. My need is, Is there a way to Mass Edit (Find & Replace) the Product Box. I have included in each product some html code and the name of the customers store along with the 1-800 number. what I need is to change that string slightly in all the products. Thanks for helping the newby! Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted January 12, 2010 Share Posted January 12, 2010 update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’); Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
larper Posted February 25, 2010 Author Share Posted February 25, 2010 update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’); Thanks for the reply, however I'm not even sure what is the table that houses the Product & the Field name.... Can you help me here or maybe point me to a self help tutor on this....much thanks for any help... larry Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted February 25, 2010 Share Posted February 25, 2010 Thanks for the reply, however I'm not even sure what is the table that houses the Product & the Field name.... Can you help me here or maybe point me to a self help tutor on this....much thanks for any help... larry Then you are dancing with fire....but... update products_description set products_description = replace(products_description, ‘find this string’, ‘replace found string with this string’); And please back up and even test on a test database... Do you know how to enter this? Where? What access does your host provide to access your database? phpMyAdmin? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
larper Posted February 25, 2010 Author Share Posted February 25, 2010 Then you are dancing with fire....but... update products_description set products_description = replace(products_description, ‘find this string’, ‘replace found string with this string’); And please back up and even test on a test database... Do you know how to enter this? Where? What access does your host provide to access your database? phpMyAdmin? I'm going through cPanel X, phpMyAdmin.... Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted February 25, 2010 Share Posted February 25, 2010 I'm going through cPanel X, phpMyAdmin.... Use phpMyAdmin. But if you have never done anything like this before I would suggest you create another database, preferably a duplicate database for testing purposes, and try simple selects and updates on the test database first.. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
larper Posted March 5, 2010 Author Share Posted March 5, 2010 Thanks for the reply, however I'm not even sure what is the table that houses the Product & the Field name.... Can you help me here or maybe point me to a self help tutor on this....much thanks for any help... larry Well, I finally got a test db made to run the script, but I got a 1064 error on syntax in the replace clause, can you see a error in the below statement. Thanks for your time! update products_description set `products_description`= replace(`products_description`, ‘Fisher Buggies has it All !!! Call Us Toll-Free 800•741•2841’, ‘Greater Protucts Greater Values Greater Global’) Link to comment Share on other sites More sharing options...
larper Posted March 9, 2010 Author Share Posted March 9, 2010 I'm still having a problem, I ran the query, it ran, but did not affect any rows. below is what I ran. update products_description set products_description= replace(products_description, "Fisher Buggies has it All !!! Call Us Toll-Free 800•741•2841", "Greater Protucts Greater Values Greater Global") Again the situation I have, that all my "product description" have Fisher Buggies....." plus other info but I want to just replace the Fisher Buggies...part and insert the "Greater Products....." instead of.... Any help in writting this much appreciated. larper Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.