Copies a product from one language to another

[Jens Pedersen]

I have created a web store with Danish language. I created categories and products in Danish.
Now I also want to offer my shop in English, I have made all the settings in Joomla and virtuemart.
My product categories are automatically translated into English.
But there are not any products in the English language categories, they only exist in the Danish.
My question is. Can i copy a Danish product tothe English part?
And how to do?
I can translate the product when they are copied over to the English language. but all information like price, post settings, image is there...
Thank you all...

[jjk]

Did the instructions how to export/import the database tables in my first reply to you a few days ago not work for you?

[erasme65]

To publish my french products in english I've exported the table xxx_virtuemart_products_fr_fr in an sql file.
Then I've edited the file to change the name 'xxx_virtuemart_products_fr_fr' to 'xxx_virtuemart_products_en_gb'.
And imported my sql file into the xxx_virtuemart_products_en_gb table.

It's ok. Just take care of empty the destination table before import...

[jjk]

It's ok. Just take care of empty the destination table before import...

If you are using phpMyAdmin, you can alternatively enable 'Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT' when you export a table. In this case the old table is replaced by the new one upon import.