Categories
View Replies (3)

Resolved Another Error importing csv file

  1. anthony352
    anthony352
  2. RO CSVI
  3. Monday, 14 November 2016
  4.  Subscribe via email
Hello,

Its that time to make some updates again and Im getting an error when trying to import. Im pasted error message below.
Joomla 3.6.4
Virtuemart 3.0.18.1
CSVI Pro 6.6.4

Im just trying to update the short and long descriptions. Ii used product_sku and product_name to make sure descriptions were applied to correct product. All other pricing and weights, images, etc are already correct on server.

Appreciate any help with this. Thank you.

An error has occured during the import. Below the information received from the server.
Duplicate entry '4450' for key 'PRIMARY' SQL=UPDATE `#__virtuemart_products` SET `virtuemart_product_id`='4450',`virtuemart_vendor_id`='1',`product_parent_id`='0',`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`='0',`product_ordered`='0',`product_stockhandle`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`pordering`='0',`created_on`='2016-09-26 01:21:11',`created_by`='654',`modified_on`='2016-11-14 01:31:55',`modified_by`='654',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='6496'
0
Responses (3)
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 ='6496'


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
anthony352
anthony352
Accepted Answer Pending Moderation
Thank you so much! Another question. Does the import change any special characters? My import has trademark symbol and registered symbol in some of the text and my import file shows correctly but when uploaded to site it changes the symbols to "?"'s.

Any idea if this is due to a wrong setting or something else Im over looking?
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Is your file UTF-8 encoded? That could be one reason the special characters are changed after import. You can follow the Save a CSV file as UTF-8 tutorial. That will get you a file that is UTF-8 encoded.
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. # 3
  • Page :
  • 1


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