Replacing the Product_Description?

[SamyT]

Stupid question but I need to make bulk changes to the descriptions of our products. So i backed up the store and basically deleted everything but all the products desc from the downloaded file.

 

I then bulk made the changes I needed to and went to myphpadmin and ran the SQL file and it acts like it changes things but nothing changed - all the descriptions are still the same despite them being different in the SQL file.

 

It starts with:

 

drop table if exists products_description;

create table products_description (

products_id int(11) not null auto_increment,

language_id int(11) default '1' not null ,

products_name varchar(64) not null ,

products_description text ,

products_url varchar(255) ,

products_viewed int(5) default '0' ,

products_info text not null ,

PRIMARY KEY (products_id, language_id),

KEY products_name (products_name)

);

 

insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed, products_info) values ('52', '1', 'Kangaroo Dreaming Tie Dye T-Shirt by Churinga', '<P><FONT face=Verdana size=2>This t-shirt is from our premium range of t-shirts by Churinga. It features burnt orange and brown stripe tie dye with an Aboriginal art print simply titled <STRONG>Kangaroo Dreaming.</STRONG> Kangaroo Dreaming is a detailed dot art image of a kangaroo, turtle, platypus, wombat, echidna and fish.</FONT></P>

<P><FONT face=Verdana color=#281767 size=2><B>Processing Time: </B></FONT><I><FONT face=Verdana size=2>2 - 3 Days</FONT></I></P>

 

 

and continues like this through all of our products

 

Am I doing something wrong? I don't know a lot about databases but would really like to change all of our descriptions without hand editing 1200 products - any help?

[SamyT]

I'm guessing I'm in for hand editing 1200 products then? Can one of you viewers just say yes or no? lol