Categories

Resolved V8.2 fails on Virtuemart product import

  1. gtcnetworking
    gtcnetworking
  2. RO CSVI
  3. Wednesday, 23 February 2022
  4.  Subscribe via email
Hi I just updated from 7.2 to 8.2
also updated virtiuemart plugin and custom fields
Now my product import fails.
was working great in 7.20
error is imdeiate

Duplicate entry '14374-0' for key 'virtuemart_product_id'

same error no matter what file content I try and import.
virtuemart is 3.8.9 - worked with v7.2.
any ideas ?

added error log
its to do with category of the product
Attachments (2)
com_csvi.log.138.zip
gn=plu-3.txt
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The problem is because the column headers in the import file are used as product data in import. See the insert query below which breaks the import. You can see prd_cat is used as value in the query. To solve this, in your import template on File tab set Skip first line to Yes, save the template and run the import. This will skip the headers from the file and process the import from second line.




INSERT INTO `me9g8_virtuemart_product_categories` (`id`,`virtuemart_product_id`,`virtuemart_category_id`) VALUES  ('0','14374','prd_cat')
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.