1. athenacraftsltdltd
  2. RO CSVI
  3. Thursday, 09 March 2017
  4.  Subscribe via email
I'm trying to import product and category data into a new VirtueMart website. I can import the test product file I'm using but the category file is failing. I've hit a number of similar errors so I've tried clearing down the VM database and removing any duplicates from the csv file but to no avail.

The file is pretty big: deduplicated it still contains over 11000 rows. The error occurs when the import show it has processed 9000 rows.

An error has occured during the import. Below the information received from the server.
Duplicate entry 'Products/Bunting/70mm/Decoration & Embellishments/Bunting' for key 'slug' SQL=UPDATE `#__virtuemart_categories_en_gb` SET `category_name`='Bunting',`category_description`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='Products/Bunting/70mm/Decoration & Embellishments/Bunting' WHERE `virtuemart_category_id`='9557'

I do have a log of this processing but in the interests of corporate sensitivity I'd prefer not to post it on a publicly availble forum. Let me know if you need me to send it over somehow.
Accepted Answer Pending Moderation
Hello,
The error is because of duplicates in slug field in your import file. If you want your own slug field then you need to correct these duplicates else if you want CSVI to create slug then you can set Recreate alias to Yes on Options tab in your import template settings. If you don't see this option click on Advanced button on top corner.
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. # 21
Accepted Answer Pending Moderation
Oops!
Joomla is 3.6.5
Virtuemart is 3.0.18
CSVi is 7.1.0 Pro
  1. more than a month ago
  2. RO CSVI
  3. # 22
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!