Categories
View Replies (2)

Resolved Problems with import files from Lexware pro

  1. Norbert-Wache
    Norbert-Wache
  2. RO CSVI
  3. Thursday, 18 August 2016
  4.  Subscribe via email
Hello,

I can not make it to configure CSV Improve so that I can import new products or update products from Lexware Pro to Joomla! 3.6.2 with VirtueMart 3.0.16.

I want only import product_sku , product_name, product_in_stock, product_gtin.

If the file has only one line it works. But if the file has two or more lines I get this error and nothing happens on VM3

An error has occured during the import. Below the information received from the server.
Duplicate entry '2351' for key 'PRIMARY' SQL=UPDATE `#__virtuemart_products` SET `virtuemart_product_id`='2351',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='5904277569046',`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`='1',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_sales`='0',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`published`='1',`pordering`='0',`created_on`='2015-03-08 00:15:58',`created_by`='0',`modified_on`='2016-08-18 17:08:21',`modified_by`='823',`locked_on`='0000-00-00 00:00:00',`locked_by`='0',`product_medium_image`='',`product_large_image`='',`product_ean`='5904277569046' WHERE `product_sku`='1023415'

I would be very thankful for help

Greatings Norbert
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Norbert,
The error says that you are having two rows of same product_sku in your database, product_sku is a unique field and duplicates are not allowed. You can go to VirtueMart products page and filter with SKU '1023415' to see multiple products with this SKU or 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. That will also list multiple rows with same SKU.

Select * from #__virtuemart_products where product_sku ='1023415'


You need to remove these duplicates first for the import to work.
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
Norbert-Wache
Norbert-Wache
Accepted Answer Pending Moderation
Hello,

thank you, it works now.

Greatings

Norbert
  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!