I have a multi-store installation on Magento 1.7.0.2 where all stores share the same products; only the language changes.
I have created products tags for one store view which represent machine models. I want to pass those product tags to another store view of the same Magento installation. I would like to avoid updating directly the database table tag_relation by first exporting tag data for the one store_id, and then importing them via SQL statements for the other store_id. Is there any way to do that programmatically?
My main concern is that by using SQL statements, it is not easy to check whether a particular pair for store_id, tag_id already exists in the table tag_relation, so duplicate entries may pass.