How to add/import short description?

[Milano2]

I have 20 thousands products into the database, but unfortunately without short description   Is there a simple and quick way to add a short description? Maybe some script like: if empty short desc, display the first 200 characters from full description?

Thanks for any help.

[ZHSoft]

UPDATE `ps_product_lang` SET `description_short`=SUBSTR(`description`,1,200) WHERE `description_short`='';

 

[TehranShop]

4 hours ago, ZhSoft said:

UPDATE `ps_product_lang` SET `description_short`=SUBSTR(`description`,1,200) WHERE `description_short`='';

 

Hi ZHSOFT

where is this code

and how to find it?

 

Thanks

[Maria Kvasnytska]

If you do not want to do it programatically, you can use the free trial version of Store Manager for PrestaShop, there's a possibility to export product ID and short description tables only. Add descriptions to the file and import it back.

[TehranShop]

22 minutes ago, Maria Kvasnytska said:

If you do not want to do it programatically, you can use the free trial version of Store Manager for PrestaShop, there's a possibility to export product ID and short description tables only. Add descriptions to the file and import it back.

Hi Maria Kvasnytska

this way is too long for anybody

maybe export some tables from phpmyadmin and edit it or send some query to DB?

 

Thanks

[JBW]

Just put the SQL statement into phpMyAdmin directly

[ZHSoft]

11 hours ago, TehranShop said:

Hi ZHSOFT

where is this code

and how to find it?

 

Thanks

phpmyadmin，run it.