Categories
View Replies (2)

Resolved Duplicate entry error with Import

  1. pbrans
    pbrans
  2. RO CSVI
  3. Tuesday, 07 June 2016
  4.  Subscribe via email
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
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
pbrans
pbrans
Accepted Answer Pending Moderation
That was the trick, Thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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