Resolved Product_parent_sku remove

Hello,

If you want to delete all the product_parent_sku's the fastest way is to run a single SQL query in PhpMyAdmin for example:

UPDATE X_virtuemart_products SET product_parent_id = 0;

This will remove ALL product parent SKUs.

If you want to use RO CSVI to delete them, the easiest is to use the Custom Table Import where you import either rhe virtuemart_product_id or the product_sku and the product_parent_id set to 0. So your file looks like this:

product_sku;product_parent_id

ABC;0

and in the template you set the Update based on to product_sku and the Table to virtuemart_products.

Let us know if that helps.

Hello,
Thank you for the quick reply. I used ROCSVI.

There is a problem - the product_parent_id is not overwritten
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `product_sku` = '59955'' at line 3

Best regards
DC

Hello,
Please send us import debug log to check. To get the debug log see How to collect debug information? document.

Hello,
I have done the RO CSVI import of these fields, but as a normal VM product import and it works.
Thanks a lot!
DC

Hello,
Glad to know your issue is solved. Let me know if I can set this topic to solved.