Resolved Rename VirueMart categories with RO CSVI

Hello,

You would need to export the virtuemart_category_id and category_name field. After you make your changes to this file you can import it back and the categories will be updated because of the virtuemart_category_id field that is included. This is the only way to rename existing categories.

Ah using custom tables import could do the job.
It does work indeed, only a tiny notice:
The best way to us would be export the categories via VM categories with virtuemart_category_id, category_path, category_name, so I could see all of the parents as well.
But when I import it back I don't need the category_path so I need to remove, because - as far as I can see - there is no 'skip' field when I import to custom tables.
Could you please consider adding a skip field there?

Hello,

You do not need the custom tables import, you can do it using the VirtueMart Category import. This will allow you to skip the field. I understand you would want the category_path as well for context.

Hm
We had a conversation before about some similar topic where I thought virtuemart_category_id can't be a key
https://rolandd.com/support/ro-csvi/import-virtuemart-categories-based-on-virtuemart-category-id

But you're right, it does work, thanks for your help

Nope, it does not work, only with custom table import

Hello,
Yes you need to update only using custom table import. In VirtueMart Category import, category_path field is needed field and you cannot update category_name using category_path field. With custom table import you can run the import with category_path field in import file. You do not need a skip field for it. The only problem would be to see Unsupported fields for category_path field in log details page after import which is fine and will not affect the operation of cleaning the category name.