In an earlier forum post (archive) I found this SQL:
INSERT INTO `ps_product_lang` SELECT `id_product`, 2015, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later` FROM `ps_product_lang` WHERE `id_lang` = 6;
I wanted to run this in my 1.6 installation but did get some errors.
/* SQL Error (1136): Column count doesn't match value count at row 1 */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
Anyway, I would like to change it a bit and get it running on 1.6. I would like to add:
Products ID form to .... For example 2015 to 2020 (and 5 products will be updated)
Language to copy from For example from Language ID 5 to Language ID 6
I am also running multistore in case this affects the query. Someone any Idea how to achieve this?