Update products with CSV without deleting old information

[jramirez]

Hi! i need to update the products on our website, add a line to the description without deleting the old description, is this possible with a csv?

 

I'm using 1.6 and have 3215 products, so doing it manually is not the fastest option :s

 

Thanks!

[hakeryk2]

It is possible via mysql aproach. Go to PhpMyAdmin and try 

UPDATE ps_product_lang SET description = CONCAT(IFNULL(description ,''), ' Your text to append') WHERE id_product IN (1,2,3) AND id_lang = 1 AND id_shop = 1;

Ofcourse You need to create backup of this table and in id_product IN those numbers are IDs of products that changes will affect. Get ids from CSV file.