error message : "message":"Duplicate entry '0' for key 'PRIMARY'" #60500

Hello,
Can you tell us which version of RO CSVI you are using? Can you also post your import file to check?

Hello,
Please update your CSVI to latest 7.14.0 version. This issue has been addressed and fixed with RO CSVI 7.13.0 version.

Hello,

I made the update to 7.14.0 version and started the import process again.

Yes, the "Warning strstr(): Empty needle in...." error is gone with the update.

An error has occured during the import. Below the information received from the server.
Duplicate entry '0' for key 'PRIMARY'

This error could be because of your previous broken import. Debug log has only 20 entries by default so i am not able to find on which record your import is breaking. The error says there is an entry in database table with 0 for primary key. We need to find that entry and delete it. There are quite a lot of VirtueMart tables which are used in VirtueMart Product import. So to find which of your VirtueMart tables has this 0 as entry in it, Go to RO CSVI Dashboard page, click Options button, on Site tab increase Number of lines in log file and run the import. Send the latest import debug log.

Hello,
Looks like you have set debug log entries to 200, there is no error in the latest debug log. So i checked your file in RO CSVI Analyser and could see there is a problem with your import file. See the attached screenshots. There seems to be an extra delimiter around the record with product_sku "A_22_7" . You need to correct your file and run the import. You can also check the database for entries after "A_22_7" as product_sku to check if there is any entry with 0 for duplicate error.

Hello,
I was wrong but it is not the problem with "A_22_7" as product_sku but check all the records with product_sku as number, like "1000000001570". The delimiters are broken for 3 fields at the end. Check the screenshot.

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?

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,
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 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.

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.

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.

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.