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
Hello Marc,
Do you have any duplicate SKU's in your system? That would be the only scenario I can think of where this error can occur. Unfortunately the log zip is empty, can you copy paste the log in a text file and attach it?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
Please find the log file attached.
Cheers,
Marc
Hi Roland,
Ok I found out I have three time the same PKU in the jos_virtuemart_products table ?! I will empty the vm table and start again and see what happens. I'll keep you posted
Hello Roland,
Problem solved, the Import process work fine now. Existing products are updated and new products are added to the database.
I will now try to create a new template in order to import, update, delete prices.
Congratulation for this fantastic extension!
Cheers,
Marc
Hey Marc,
Sounds good, keep me posted.
Oops you were a little faster than me. Sounds good it is all working now.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.