Bulk Edit Product Names & Descriptions

[pinksparklegirl]

Hi all, I'm using ZC 139h and need help with a sql script for updating several product titles and descriptions on mass.

I sell pin badges, but am now able to make magnets too so need to update all my product titles to include the word "magnet". I have hundreds of products so cannot do this by hand.

Example of current title "Retro Toy Badge - Care Bears" needs updating to "Retro Toy Badge/Magnet - Care Bears"

I also need to bulk update all the descriptions, which are basically the same thing but with the title included in it.

Example of current description "1980's Care Bear Cousins badge. Measures 45mm." needs updating to "1980's Care Bear Cousins badge or magnet. Measures 45mm."

I've amended a sql script I found on this forum here http://www.zen-cart.com/showthread.p...g-an-SQL-Query, but it failed to work (simple stated "failed").

I changed this (where the forum member wanted "Chord" replaced with "Cord":

UPDATE products_description
SET products_name = REPLACE(products_name,'Cord','Chord')
WHERE products_name like '%cord%'

to this:

UPDATE products_description
SET products_name = REPLACE(products_name,'Retro Toy Badge/Magnet -','Retro Toy Badge -')
WHERE products_name like '%retro toy badge -%'

I also exported my sql database and amended that, but it failed to import when using phpmyadmin (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CREATE TABLE `module_version_tracker` (`ID` int(10) NOT NULL AUTO_INCRE' at line 1 ))

Can anybody help me a sql script for my two updates please? Either for use in Zen Cart or phpmyadmin.

Thanks in advance for any help!

[Limitless]

**** BACK UP YOUR DB BEFORE DOING ANYTHING ****


This query works just fine for product titles:

UPDATE products_description
SET products_name = REPLACE(products_name,'EXISTING','NEW')
WHERE products_name like '%CASEINSENSITIVE EXISTING%'


And this works for changing the text within the description:

UPDATE products_description
SET products_description = REPLACE(products_description,'EXISTING','NEW')
WHERE products_description like '%CASEINSENSITIVE EXISTING%'

[kobra]

Retro Toy Badge/Magnet - Care Bears

Try replacing characters with html escape codes

[maria82g]

This query works just fine for


And this works for changing the text within the description:

UPDATE products_description
SET products_description = REPLACE(products_description,'EXISTING','NEW')
WHERE products_description like '%CASEINSENSITIVE EXISTING%'

so If I have html in my product description and I want to replace that part will I add the html code or just the text?
, which I tried using the code above with html but the SQL patch replied with failed...

[maria82g]

Zen Cart v1.5.1/v1.5.0


what I mean is
I want to edit this 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> <br /><br />

and take out this part from the description above

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

I tried using code
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 '%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>%'

but the SQL patch "Failed"

any help is more than appreciated!
Thanks
Maria

[mc12345678]

Zen Cart v1.5.1/v1.5.0


what I mean is
I want to edit this 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> <br /><br />

and take out this part from the description above

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

I tried using code
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 '%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>%'

but the SQL patch "Failed"

any help is more than appreciated!
Thanks
Maria

Unfortunately "Failed" does not provide enough information to diagnose the specific issue that is identified on your system. Please either provide the specific error message, or if the query was run from within the ZC admin Install SQL patches section, an error log should have been generated in the cache directory if in fact you are still using ZC 1.3.9h... otherwise In the logs directory for ZC 1.5.1 and above. Look for myDebugxxxx related files.. If it is an admin myDebug (which is expected) do not post your admin directory as part of the information (Replace with something else).

[maria82g]

Unfortunately "Failed" does not provide enough information to diagnose the specific issue that is identified on your system. Please either provide the specific error message, or if the query was run from within the ZC admin Install SQL patches section, an error log should have been generated in the cache directory if in fact you are still using ZC 1.3.9h... otherwise In the logs directory for ZC 1.5.1 and above. Look for myDebugxxxx related files.. If it is an admin myDebug (which is expected) do not post your admin directory as part of the information (Replace with something else).

Hi Thanks for responding, it was not in admin folder
but in the directory root of zencart all 3 files, have same text must be because of the three times I attempted sql patch
this is what it says

[04-Mar-2015 15:11:03 UTC] PHP Parse error: syntax error, unexpected '}' in /hermes/bosnaweb10a/b1526/ipg.sitecom/mydirectory/includes/functions/sessions.php on line 16

[mc12345678]

That's actually not directly related to this issue, but trying the sql may have illuminated or helped discover an issue.

Before suggesting how to correct that one, what php version is your store on and what are your plans for upgrading?

[maria82g]

MySQL Version 5.5.32
Perl Version 5.8.8
PHP Version 5.3

No plans of upgrading PHP

[mc12345678]

MySQL Version 5.5.32
Perl Version 5.8.8
PHP Version 5.3

No plans of upgrading PHP

Sorry, should have been clearer on the question, what plans do you have for upgrading zc? I know that using php 5.4 with zc 1.3.9 causes issues, but at the moment not sure about the version currently used.

So it seems like either the sessions.php file has been modified, or in "putting together" the php code to present the page, something had/has an additional right curly bracket } that causes one of them in the sessions file to "close" the file prematurely. Tracking that down could be "fun", but not impossible.

Perhaps could try a very generic SQL statement and see if the same type of error occurs?

select * from products;

There is no "result" expected, but hopefully no failure either. Double check the logs at that point.