Hi,
I found 1 more easy way to find & replace any text / URL / Hyperlink in Description or in Short Description,
I have kept 1 Calculator link in all products pages under short description, so i need to change the URL so i used this attached PHP file,
I have used this file more than 100 times in wordpress but in Prestashop i have used 1st time & its worked well !!!
Still you are advised to take backup of your Database because there is no UNDO,
Steps:
1) Download Attached searchreplacedb2.zip PHP file (searchreplacedb2.php),
2) Paste it in your Root directory
3) open it in browser like: http://localhost/yourproject/searchreplacedb2.php
4) Fill the Database Details , (See what i filledup, I used In : Server Name: Localhost , Database name: mydb, Username: root , Password: (leave this empty) & click on Submit DB details
5) Now you can keep the text which you want to find & replace ,
for eaxmple keep in find field: http://localhost/aesteironsteelpipes/content/4-steel-pipe-manufacturer.html
& in replace keep below:
http://localhost/aesteironsteelpipes/content/4-ASTM-A106-gradeB-steel-pipes-steel-tubes-supplier.html
Please note: If you have uploaded website on any domain name then also you can easily use it with same steps but also fill Database Password (i mentioned in Point No. 4)
Online example to Find & replace:
1) Same as above
2) Same as above
3) Same as above
4) Same as above but also fill Database Password
5) Example to find & replace:
i wanted to change this URL i manually used in my all products description:
so keep in find field:
http://www.aesteironsteelpipes.com/about-us-4.html
& keep in replace field:
http://www.aesteironsteelpipes.com/astm-a106-sa106-pipe/9-seamlesspipes-type-astm-a106-grb-pipe-carbonsteel-pipe.html