Hello,
Export is working fine. When I import I get an error:
Duplicate entry '70' for key 'PRIMARY' SQL=UPDATE #__virtuemart_products SET virtuemart_product_id='70',virtuemart_vendor_id='1',product_parent_id='63',product_gtin='abc-pp-02',product_mpn='SM-2-475-54-56',product_weight='150.0000',product_weight_uom='G',product_length='156.0000',product_width='120.0000',product_height='28.0000',product_lwh_uom='MM',product_url='',product_in_stock='1000',product_ordered='0',low_stock_notification='1',product_available_date='0000-00-00 00:00:00',product_availability='',product_special='0',product_sales='0',product_unit='100G',product_packaging='2.0000',product_params='min_order_level="0"|max_order_level="0"|step_order_level=""|product_box="0"|',intnotes='',metarobot='',metaauthor='',layout='0',published='1',pordering='3',created_on='2016-04-25 13:40:50',created_by='471',modified_on='2016-06-07 11:50:04',modified_by='471',locked_on='0000-00-00 00:00:00',locked_by='0' WHERE product_sku='SM-2-475-54-56'
What am I doing wrong?
Thanks for the help
Hello,
You seem to have two products with same SKUs, SKU field must be unique. 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. How many rows do you see?
Select * from #__virtuemart_products where product_sku ='SM-2-475-54-56'
You also check by going to product list in VirtueMart and filter on this SKU.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
That was the trick, Thanks!
Log in to reply to this topic.