Hello,
I can not make it to configure CSV Improve so that I can import new products or update products from Lexware Pro to Joomla! 3.6.2 with VirtueMart 3.0.16.
I want only import product_sku , product_name, product_in_stock, product_gtin.
If the file has only one line it works. But if the file has two or more lines I get this error and nothing happens on VM3
An error has occured during the import. Below the information received from the server.
Duplicate entry '2351' for key 'PRIMARY' SQL=UPDATE #__virtuemart_products SET virtuemart_product_id='2351',virtuemart_vendor_id='1',product_parent_id='0',product_gtin='5904277569046',product_weight='0.0000',product_weight_uom='KG',product_length='0.0000',product_width='0.0000',product_height='0.0000',product_lwh_uom='M',product_url='',product_in_stock='1',product_ordered='0',low_stock_notification='0',product_available_date='0000-00-00 00:00:00',product_availability='',product_sales='0',product_params='min_order_level="0"|max_order_level="0"|step_order_level=""|product_box="0"|',published='1',pordering='0',created_on='2015-03-08 00:15:58',created_by='0',modified_on='2016-08-18 17:08:21',modified_by='823',locked_on='0000-00-00 00:00:00',locked_by='0',product_medium_image='',product_large_image='',product_ean='5904277569046' WHERE product_sku='1023415'
I would be very thankful for help
Greatings Norbert
Hello Norbert,
The error says that you are having two rows of same product_sku in your database, product_sku is a unique field and duplicates are not allowed. You can go to VirtueMart products page and filter with SKU '1023415' to see multiple products with this SKU or If you know how to do, go to phpmyadmin, look for table #__virtuemart_products and on the SQL tab, paste the below query and click Go. Dont forget to replace #_ with your table prefix before running the query. That will also list multiple rows with same SKU.
Select * from #__virtuemart_products where product_sku ='1023415'
You need to remove these duplicates first for the import to work.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
thank you, it works now.
Greatings
Norbert
Log in to reply to this topic.