Categories
View Replies (1)

Resolved Error trying to update product descriptions

  1. anthony352
    anthony352
  2. RO CSVI
  3. Monday, 26 September 2016
  4.  Subscribe via email
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.
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


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