Resolved ERROR Frontend

Server IP address: 93.125.99.98
SSH port: 22
User name: atestroc
Password: Mae9ie6e

Hello Vladimir,
Thank you for posting the site details. I was testing the import and was able to see the error a few times and most of the times import finishes without an error. The first thing i found with import in your site is that the products in VirtueMart don't show correct. See the attached screenshots. It shows 4 children for all products when there is no child products at all. Next thing i see is the ID as 0 for all the 4 products. I clicked on the product to see the details but it shows empty. So i cleaned VirtueMart database using RO CSVI maintenance option. Ran the import again from backend. Checking RO CSVI import debug log shows all 4 products are inserted to English language table and that is because English is the language set in import template. Database also shows the products are in English language table. I am not sure if it is an issue with VirtueMart 3.8.8 version in not loading translation product details.

Then i changed the language to Russian in import template and ran the import. The products are imported to Russian language table and products show correct in VirtueMart. Attached screenshot of that too. In both of these cases with import, i was not able to reproduce the error again on frontend. Since the error happens only sometimes, i am going to keep watching the frontend import so to see if setting up language in template to Russian makes any difference with the error. Would request you to also to test this and let me know if you can see the error again.

Hello Tharuna.
To be honest, I am surprised by the fact that there are children's products. I created the products in the standard VM way.
And where the children came from is a mystery to me.

I saw that you made changes to the template.
and the import is made from a file located on the server. In this case, there are no problems with importing from the backend.


However, when importing from an external server - for example, Google Tables-the import fails.

now the test site has two menu items:
1) IMPORT from googlesheet
2) IMPORT from the server


IMPORT from googlesheet - regularly ends with an error

Hello,

To be honest, I am surprised by the fact that there are children's products. I created the products in the standard VM way.
And where the children came from is a mystery to me.

Yes and that happens when a translation language is set in VirtueMart.

I saw that you made changes to the template.
and the import is made from a file located on the server. In this case, there are no problems with importing from the backend.

Correct, i wanted to test if setting to another source gets the same error or not.

IMPORT from googlesheet - regularly ends with an error

Thats correct, import from Google sheets ends up with an error. I am finding out the cause for the error with Google sheet import on frontend.

Hello Tharuna.
As I can see, the import occurs without errors.
Everything's fine.

Hello Vladimir,
Thank you for confirming the import is working. This fix will be included in our upcoming RO CSVI release.