Resolved Duplicate entry '0' for key 'PRIMARY'

Hello,
You did not mention which import you are using but looking at the message it says that you have 0 as an value for primary key field. If you are using VirtueMart product import then can you check tables #__virtuemart_products and #__virtuemart_products_XX_XX (where XX_XX is the language) and see if there are any entries with virtuemart_product_id as 0? If you find any rows then delete them and try the import again.

Hi Tharuna,

Thank you for your quick reply. Yes sorry I did not mention it I'm using VirtueMart 3.2.1. and Joomla! 3.7.4. I've attached a screenshot of the csv test file that I'm trying to upload and the template fields that I made, if you mean on the csv file I don't have a 0 value, but there are some categories that aren't in the template fields. I'd really appreciate your help I'm kind of struggling with running the program and importing my products.

Hello,

I think we should start by cleaning up a bit. You have both the category_id and the category_path. Now we do not recommend using the _id field. Having the category_path is enough. Second, the order of the fields in your template is not in the same order as they are in your CSV file. So you need to re-order the fields in the template to follow the same order as they are in your CSV file.

Why is your manufacturer_id abc 1, abc 2, etc? This will result in a 0 because abc isn't a number. If you have no data, it is best to leave it out or use the manufacturer_name field.

That should make things work better. If you still get the error, also post the debug log of your import as explained at the top of this page. This will allow us to help you further.

Hi Roland,

Ok i'll change my files and the order and I'll give it a go again and hopefully works.

Thanks for your help!