Resolved Bulk rename Virtuemart virtuemart_product_id with import/expert

I think I already found the answer. You can change the SKU name, because all records are linked via virtuemart_product_id. So this shouldn't be any problem.

Hello Paul,

is it possible to rename the SKU/virtuemart_product_id with an import/export to a new value?

CSVI does not handle the virtuemart_product_id on import, it is a database auto increment field and it is not possible to change it with CSVI. SKU is the field which is used by CSVI to identify a product in database exists or not. If the SKU in the import file is not in database, a new product record is created else the existing record gets updated. So if you are importing new SKU a new product will be created.

Or is this only on product level and doesn't this change virtuemart_product_id in for instance old order records?

No, CSVI will not update virtuemart_product_id in products table or in order table.

Hello,

I think I already found the answer. You can change the SKU name, because all records are linked via virtuemart_product_id. So this shouldn't be any problem.

Are you looking at changing SKU or virtuemart_product_id?

changing SKU only

Hello,
In that case you can use virtuemart_product_id in your import file and change the SKUs. We don't recommend use of fields ending with _id in import as they are handled by database. Since you are going to use virtuemart_product_id as a reference to update SKU field there is nothing wrong in using it.