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.
- athenacraftsltdltd
- RO CSVI
- Thursday, 09 March 2017
- Subscribe via email