Is there a quick way of copying descriptions to all products?

[FireHawk]

Hi,

 

I am wanting to make changes to my short and normal descriptions but as far as i can tell the only way to change them is by going into each product 1 by 1.

 

Is there a way (module or code changes) to copy to all products in 1 go?

I have 1000+ products so going 1 by 1 will take a lot of time.

[MahmutGulerce]

Hi

You can work at ps_product_lang table by your mysql admin (phpmyadmin).

 

Eg: browse ps_product_lang as table than click edit.

[berka.pavel]

import you product

tools > import > import products

 

required field in your case are id (i´m not shure if id is required), name, short description, long description

 

it should works.

[FireHawk]

Hi

You can work at ps_product_lang table by your mysql admin (phpmyadmin).

 

Eg: browse ps_product_lang as table than click edit.

 

Hi,

Thanks for that. But does this mean i still have to paste the same new description in every page 1 by 1 or can i edit all of them here in 1 go?

I did highlight them all and clicked on edit but then not too sure how to proceed further without risking ruining it all.

If this is possible could you do me a quick walk-through?

 

Thanks in advance though.

[FireHawk]

import you product

tools > import > import products

 

required field in your case are id (i´m not shure if id is required), name, short description, long description

 

it should works.

 

Trouble is, all my products are already up and live. They also have been altered from the original excel sheets i uploaded them from so it would be alot of work i imagine to edit my excel sheets to mimic what is there now and add in the new description changes.

Unless i can export all products as they are and then just do a "find and replace" with the descriptions, and re-upload them back?

 

Thanks for the advice so far though

[berka.pavel]

somewhere on the forum i´ve seen some free "export to csv" modules. or you can do your own php script for onetime export (if you know a little php and mysql). anyway if you export your produts into csv/excel and upgrade some of the product details, you can import it back.

 

require field is just the name which you already have in the database. i recomended you the fields ID, NAME and all the fields you plan to upgrade. nothing more. all other details remain the same.

[jhnstcks]

 

Hi,

Thanks for that. But does this mean i still have to paste the same new description in every page 1 by 1 or can i edit all of them here in 1 go?

I did highlight them all and clicked on edit but then not too sure how to proceed further without risking ruining it all.

If this is possible could you do me a quick walk-through?

 

Thanks in advance though.

 

If you export the table you can edit the file in excel then import it back into the database.

[FireHawk]

 

If you export the table you can edit the file in excel then import it back into the database.

 

Now that sounds like a perfect plan.

Going to export 3 items from table and alter to check it works ok. Don't wanna export all 1000+, make changes and everything go wrong.

Many thanks for that. Hopefully will save me hours, if not days editting 1 by 1.

[FireHawk]

Hmmm, just been trying to import back the csv file but it keeps failing.

"Invalid field count in CSV input on line 1."

 

I skip the first line as this is the field names.

 

Just can't seem to get it to import at all with the alterations.

 

I am scared to pick the option of "replace table data with file" on the import screen in case it deletes all existing table data and replaces it by just the two test products. Or is this the main option i need to tick to replace the two lines of the table i have editted and trying to import back?

 

I am not experienced to say the least at myphpadmin, but generally can pick things up with guidence.