Author
Topic: How to copy value of vm2tags to keywords? (Read 643 times)

In the online shop running Virtuemart 2.0.22d and Joomla 2.5.14 has more than 1200 products. Each of them has filled custom field - Tags. It uses components vm2tags ver 1.2.8.I need to transfer these values to the "Meta keywords".

Thought to solve this problem with SQL query that will be able (considering virtuemart_product_id) to copy information from one place to another.From the table virtuemart_product_customfields (field custom_param, considering custom_value: vm2tags) to the table virtuemart_products_ru_ru (field metakey).

But the problem is that the tags in virtuemart_product_customfields are in that format:

You could do such with csvi component http://www.csvimproved.com/en/. Just export data from tags table, modify it in the open office with regular expressions or just with find&replace function than import it to the meta keywords table.