Resolved conflict between ID and SKU

Hi, I cleared the table (SQL) for variant products and it worked perfectly.

Hi Tiago,

Your screenshot seems to imply that the old relation still exists. If you save the variant without category, does it then work as expected? Is that table entry gone when you do that?

If so, we need to see how that gets filled or how it should be emptied.

Let us know how it goes.

Is the problem in the _virtuemart_product_categories table? I'm attaching an image.

Hi, after doing what you suggested, I have the variant products without categories, but they still appear in the store. I've already cleared the cache. When filtering by category in the Virtuemart back office, the variant products also appear, but when I go into the product page, nothing is selected in the categories field. Somehow it continues to assign a category.

Hello Tiago,

You can duplicate the template you are using now. On the Options tab in your template you can select if you only want to export parent or child products. See the attached image.

For your Child Products template, just remove the category_path field.

On the import side, you would first import the export of the Parent Products and after that run the import of the Child Products.

Let us know how that goes.

Do I create a file to export only variants? Which fields do I assign to it? To ignore the parent products.

Hello,
Ok I see you are exporting from another Joomla site and importing it. I would suggest you do a two step export. First export will get only parent products with category_path field and second export would get only child products without category_path field. You can set to export Parent or child product on Options tab in the export template. Same way as the export, import parent products first and then child products. See if that helps.

How do I leave the category field empty? Do I have to manually edit the file? I'll send the file as an attachment.

Hello,

But then I have another question: how do I import the products with the "categories" fields of the variants empty, as they are in the original Virtuemart?

Variants are child products so for child product rows you can leave category_path field empty in import file. category_path field should be filled only for parent product. That should fix your issue. If you still have any issue post sample of your import file and I will check.

I think I understand how I caused the problem. During the import, the variant products have the "category" field filled in. But in the original Virtuemart, the category fields of the variants are empty, and that's correct. So I executed an SQL query

"DELETE pc
FROM tn9ds_virtuemart_product_categories pc
INNER JOIN tn9ds_virtuemart_products p
ON p.virtuemart_product_id = pc.virtuemart_product_id
WHERE p.product_parent_id > 0;"

in the new Virtuemart database to clear the category field in the variant products. And the error occurred after I executed this SQL query. However, I imported the products again and the error doesn't occur.

But then I have another question: how do I import the products with the "categories" fields of the variants empty, as they are in the original Virtuemart?

Hello,
Post Import debug log and Import file to check. To get the debug log read How to collect debug information? document.

Also please post screenshots from VirtueMart products page after import. That will help us to understand the issue.