Editing Bulk Description

[maria82g]

Tell me what is wrong in the following code!!
statement does get processed but the description does not get updated

UPDATE products_description 
SET products_description = REPLACE(products_description,'you can read our client reviews here at
<a href="https://www.etsy.com/shop/MGDezigns/reviews" target="_blank">Etsy </a> and here at <a href="http://www.################################/reviews/mgdezigns-custom-wedding-invitations-stationery-redwood-city/041a3e52a41c4763.html" target="_blank"> WeddingWire</a>','you can read our client reviews here at
<a href="https://www.etsy.com/shop/MGDezigns/reviews" target="_blank"> Etsy </a>') 
WHERE products_description like '%<a href="https://www.etsy.com/shop/MGDezigns/reviews" target="_blank">Etsy </a> and here at <a href="http://www.################################/reviews/mgdezigns-custom-wedding-invitations-stationery-redwood-city/041a3e52a41c4763.html" target="_blank"> WeddingWire</a>%';

these following lines simply do not get removed from the description!!

 and here at <a href="http://www.################################/reviews/mgdezigns-custom-wedding-invitations-stationery-redwood-city/041a3e52a41c4763.html" target="_blank"> WeddingWire</a>

[swguy]

Don't do this. Use my boilerplate instructions instead.

http://www.thatsoftwareguy.com/zenca...scription.html

[maria82g]

Don't do this. Use my boilerplate instructions instead.

http://www.thatsoftwareguy.com/zenca...scription.html

that seems like too difficult! but I will try... Thanks

[maria82g]

Don't do this. Use my boilerplate instructions instead.

http://www.thatsoftwareguy.com/zenca...scription.html

i tried but it does not tell me how to remove specific part in my description?

I just want to remove few lines with a link from all my descriptions, all product description have this same line!

[swguy]

Yes, I realized that later too. For the removal part, here's what you want (note I replaced your domain name with fooreviews to prevent blocking).

UPDATE products_description
SET products_description = REPLACE(products_description,'you can read our client reviews here at <a href="https://www.etsy.com/shop/MGDezigns/reviews" target="_blank">Etsy </a> and here at <a href="http://www.fooreviews/mgdezigns-custom-wedding-invitations-stationery-redwood-city/041a3e52a41c4763.html" target="_blank"> WeddingWire</a>','');

Then use the boilerplate to add this information back. Or just update your includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php file if you only want it to show up on the product info page.

[maria82g]

Yes, I realized that later too. For the removal part, here's what you want (note I replaced your domain name with fooreviews to prevent blocking).

UPDATE products_description
SET products_description = REPLACE(products_description,'you can read our client reviews here at <a href="https://www.etsy.com/shop/MGDezigns/reviews" target="_blank">Etsy </a> and here at <a href="http://www.fooreviews/mgdezigns-custom-wedding-invitations-stationery-redwood-city/041a3e52a41c4763.html" target="_blank"> WeddingWire</a>','');

Then use the boilerplate to add this information back. Or just update your includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php file if you only want it to show up on the product info page.

totally lost here :/ btw I keep on reading it bipolar instead of boilerplate :/
any how first I should run that code in SQL patches?
then what do I edit in tpl_product_info_display.php ?

[maria82g]

[QUOTE=swguy;1276499]Yes, I realized that later too. For the removal part, here's what you want (note I replaced your domain name with fooreviews to prevent blocking).

UPDATE products_description
SET products_description = REPLACE(products_description,'you can read our client reviews here at <a href="https://www.etsy.com/shop/MGDezigns/reviews" target="_blank">Etsy </a> and here at <a href="http://www.fooreviews/mgdezigns-custom-wedding-invitations-stationery-redwood-city/041a3e52a41c4763.html" target="_blank"> WeddingWire</a>','');

OMG!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1 this worked totally!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!11
Thank You!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1

[swguy]

Thanks for reporting back your success.