Resolved error message : "message":"Duplicate entry '0' for key 'PRIMARY'"

hello, I made the changes, now it work as expected. Many thanks :-)

Hello,
Yes and that is the reason images are not imported for products. Are the images placed in the given location on your server?

/home/httpd/vhosts/lemusse.ch/2020.fabien-bike.ch/images/stories/virtuemart/product

The error shows that RO CSVI is not able to find the images in the location and so it is not able to link it to the product.

please take a look at this error

Hello,

One last problem: I don't see any Image for article and categories.

Can you post the debug log of your product import to check? To get the debug log check How to collect debug information? document.

For categories, you need to use VirtueMart Categories import operation to import images and by using file_url field. VirtueMart Product import will only import images for a product.

I think I found the problem. Now the import template is correct and I can see the right category name and the articles inside the categories with right price.

One last problem: I don't see any Image for article and categories.

Hello, I made the changes to be correct with my import files. But I become an error, the same as before.

Can you take a look at the new xml file?

You need to place custom_title field in the right place in your template fields and run the import again.

can you tell me where? I'm sorry, I'm beginner with this tool and need your assistance

it looks like the product price is imported as the category_path (name)

category name should be something like that

hello,

I see the categories (and the articles inside), but the categories become a number as category name

Hello Raphael,

But I don't see any visible article in Virtuemart.

Do you mean that you are not seeing the imported products on VirtueMart Products page? Can you post a screenshot on what you have on VirtueMart Products page?

something is strange with the new created categories

It is because of order of your template fields. You have added custom_title field in place of category_path and so the fields are messed up. product_price field has been used as category_path. You need to place custom_title field in the right place in your template fields and run the import again.

something is strange with the new created categories

hello, I made this change. Import seems to work now.

But I don't see any visible article in Virtuemart.

Can you help me?

Hello Raphael,
I checked your template and you still have manufacturer_id in the template fields. You need to replace manufacturer_id with Skip field. Check attached screenshot. Please try import after that.

please find the xml

Kind regards
Raphael

Hello,
Before i look into your site, can you send me your template XML file? To get your template XML file, in CSVI maintenance menu select CSVI Pro on first option, backup templates on second option, select your template and download the XML file. Post the XML file so i can check it.

Hello, I did it (set Use file for configuration as No) but still the same error. Maybe the best way is I give you the access to administration?

Hello,
You need to add template fields for your template in the order of column headers as in your import file. Check Adding template fields document to know on how to add template fields. For manufacturer_id you need to add Skip as the template field so RO CSVI will skip this column on import. Also in your import template settings on File tab set Use file for configuration as No so RO CSVI will use the template fields as headers and not the column headers from the import file. Let me know if you need any more clarification.

hello,

ok I can try. But can you explain me how I can skip the manufacturer_id field?

Thanks

Hello,
I was able to reproduce this error with your file and that is because of manufacturer_id field. The entries for manufacturer_id which is the primary key field of manufacturers table goes as 0 in the database and so the error. I see that you have both manufacturer_id and manufacturer_name in your file. You can skip the use of manufacturer_id field in your import, RO CSVI will create manufacturer using manufacturer_name. If there is an existing record with same manufacturer_name, the row will be updated else a new manufacturer row will be created. Can you skip the manufacturer_id field and see how the import goes?