Joomla 3.4.3
CSVI Pro 6.1.0
Hello Roland,
I have managed to create my first Import Template. I have made some tests and it works great.
I just add an error message during the import process.
In order to update the existing records and to insert the new ones I have, in the “Edit Template” form, tab “File”, setted “Yes” to Overwrite existing data and “No” to Skip new item.
Error Message :
An error has occured during the import. Below the information received from the server.
Duplicate entry '117' for key 'PRIMARY' SQL=UPDATE `jos_virtuemart_products` SET `virtuemart_product_id`='117',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='7680329350289',`product_mpn`='',`product_weight`='70',`product_weight_uom`='G',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2015-08-14 00:00:00',`product_availability`='',`product_special`='1',`product_sales`='0',`product_unit`='KG',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-08-14 12:44:34',`created_by`='516',`modified_on`='2015-08-18 11:27:01',`modified_by`='516',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='10203860'
Please find attached the CSV file + the debug file.
Thank you in advance for your support.
Cheers,
Marc
- webcouleur
- RO CSVI
- Tuesday, 18 August 2015
- Subscribe via email
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!