Editing Bulk Description

17 Mar 2015, 12:03

#1

New Zenner

Join Date:: Feb 2009
Posts:: 81
Plugin Contributions:: 0

Editing Bulk Description

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>

17 Mar 2015, 12:50

#2

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Editing Bulk Description

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

http://www.thatsoftwareguy.com/zencart_php_in_description.html

17 Mar 2015, 15:19

#3

maria82g

New Zenner

Join Date:: Feb 2009
Posts:: 81
Plugin Contributions:: 0

Re: Editing Bulk Description

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

http://www.thatsoftwareguy.com/zencart_php_in_description.html

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

17 Mar 2015, 15:30

#4

maria82g

New Zenner

Join Date:: Feb 2009
Posts:: 81
Plugin Contributions:: 0

Re: Editing Bulk Description

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

http://www.thatsoftwareguy.com/zencart_php_in_description.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!

17 Mar 2015, 15:50

#5

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Editing Bulk Description

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.

17 Mar 2015, 16:02

#6

maria82g

New Zenner

Join Date:: Feb 2009
Posts:: 81
Plugin Contributions:: 0

Re: Editing Bulk Description

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.

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 ?

17 Mar 2015, 16:08

#7

maria82g

New Zenner

Join Date:: Feb 2009
Posts:: 81
Plugin Contributions:: 0

Re: Editing Bulk Description

[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

17 Mar 2015, 17:40

#8

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Editing Bulk Description

Thanks for reporting back your success.