Hello CSVI,
Thank you for this wonderful product. I am having problem updating my product descriptions on my site.
Joomla 3.5.1, Virtuemart 3.0.16 and CSVI Pro 6.6.0
I first created a sample file of 15 products to update using product_sku and product_desc only.
It worked fine.
So now I am trying to update the remaining 266 products but I keep getting the following error when trying to import.
Duplicate entry '4318' for key 'PRIMARY' SQL=UPDATE #__virtuemart_products SET virtuemart_product_id='4318',virtuemart_vendor_id='1',product_parent_id='3775',product_gtin='',product_url='',product_in_stock='0',product_ordered='0',low_stock_notification='0',product_available_date='0000-00-00 00:00:00',product_sales='0',product_params='min_order_level="0"|max_order_level="0"|step_order_level=""|product_box="0"|',intnotes='',metarobot='',metaauthor='',layout='',published='1',pordering='0',created_on='2016-07-22 00:17:52',created_by='654',modified_on='2016-09-26 01:28:10',modified_by='654',locked_on='0000-00-00 00:00:00',locked_by='0' WHERE product_sku='3800'
CSVI Pro 6.6.0 | Copyright (C) 2006 - 2016 RolandD Cyber Produksi
We are supposed to go live tomorrow and hoping for some help with this at your convenience. Thank you again.
Hello,
You seem to have two products with same product_sku values in your database. If you know, got to phpmyadmin, look for table #__virtuemart_products and on the SQL tab, paste the below query and click Go. Don't forget to replace #_ with your table prefix before running the query. You must be seeing multiple rows. You can also check by going to product list in VirtueMart and filter on this SKU.
Select * from #__virtuemart_products where product_sku ='3800'
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.