Resolved Import error

Hello,
Can you tell us which version of CSVI you are using? Also please share screenshots of your import template settings.

Hey

please find details attached. I use the latest version 7.3 Thank you.

Hello,
Thank you for posting the screenshot. The error you posted was an issue in importing .ods file and it is fixed in the attached patch file. Please load the patch file and try running the import again.

patch_ods_2017_11_06.zip

Thanks I am trying also with .csv now. II will keep zou upated if it works

Hey,

now I am getting a new probelm. Please see image below. I also added the .csv



I checked: https://csvimproved.com/support/questions-and-answers/854-500-internal-server-error

correct priviliges: do not know where to check & change
I have: about 600 images around 100-150 kb
I have: PHP version 5.6.31
BOM in your file: do not know what that means
I tried: ERROR REPORTING: development but the message did not change.

Thanks for help

Hello,
As explained in the 500 error document check your server error logs for the real error. If you don't have access to it or don't know where to get it, ask your hosting provider and they should help you to get the error log file. Post the error log file here so we can check it. Your import file looks good to me.

Hey there

I managed to solve the 500 error problem: I just split the .csv into smaller pieces so there is not a list 260+ products, but four .csv with each around 50 products. I think the processsing power of the server did not do it.

However I have a new problem with the related products:

In my .csv ist there are three related products, but in the frontend there are now many. Please see the image attached or the link https://casa-eurabia.de/sch%C3%BCsseln/sch%C3%BCssel%E2%80%93marrakesch%E2%80%9326cm-grau-40-detail

Hello,
Check the post linked here with the same problem and solution to solve it. Try and let me know if it helps.

Hey
the post is a little to advanced for me. I do not understand the different terms.

What I found is this, but do not know what to do or where to do the change from 0 to 1:

"For Virtuemart version 3 and above, the field value virtuemart_vendor_id is 0 in #__virtuemart_customs table for related products and related categories(core inserts of Virtuemart). CSVI script checks related products against value 0 and not 1. Changing virtuemart_vendor_id field for related products to 0 will solve the issue of inserting related products repeatedly.

value virtuemart_vendor_id #__virtuemart_customs table
what do you mean by field? where do i find this? is that in the template or options? or under VM > configurations?

Hello,

value virtuemart_vendor_id #__virtuemart_customs table
what do you mean by field? where do i find this? is that in the template or options? or under VM > configurations?

#__virtuemart_customs is a VirtueMart table and you need to look for it in your database. Use the tool with which you access you site database and look for #__virtuemart_customs table in the list(#_ will be your table prefix). In that table records check for rows with entries as "Related Products" and "Related Categories" in custom_title column. For these rows check column virtuemart_vendor_id and change its value to 0 if its entered as 1 and that will solve your issue. Hope it is clear now.

"Use the tool with which you access you site database and look for .."

Do you mean by tool my FileZilla in order to acess all the data where I also drop all the images? If yes, there are many folders and I would like to know which folder contains the file/table "#__virtuemart_customs". Please discribe the path.

Thanks

Hello,
No, i meant a tool for accessing your database tables which is normally PHPMyAdmin. FileZilla is for accessing files and folders of your site and that wont help here.

Hello Julius,
To make it easy for users we have added an option of changing virtuemart_vendor_id field value to 0 from CSVI maintenance menu instead of looking for table in database and changing it manually. You need to load the attached patch file to get this new option. Once the patch file is updated, go to CSVI Pro >> Maintenance page. Select VirtueMart in first drop down and Fix related products/categories duplicates option in the second drop down, click Continue. This will fix the virtuemart_vendor_id value to 0. Now run the import and check if the related products are not duplicated.

patch_vm_maintenance_2017_11_09.zip

Hey,

that worked perfectly. I am very happy thank you !!!

Hello Julius,
Glad to know that it worked. Please leave us a review on Joomla extension directory