Resolved CSVI import casuses server error

Hello,
The Php warnings posted in the screenshot are from VirtueMart files and not from CSVI. What fields you are importing? Can you try to import only product_sku and product_name and see if import finishes?

Regarding the 504 error, are you importing external images? Can you post your import debug log to check? To get the debug log check How to get debug information? document.

We exported sample Virtuemart files one by one..(Product/ manufacturer/ categories etc) .. and simply imported these back.. no success.

Hello,
In the Sample VirtueMart Product export template, remove all template fields except product_sku and product_name. Run the export. You will have a export file with two basic fields product_sku and product_name. Now use that basic file to import. See if import works. If not post your import debug log as requested in my previous reply.

Before trying this , kindly give me a guideline.
suppose i have 400 products already with data in many other fields ( other then SKU and product name),. now i export New file with few products and delete all others except product_sku and product_name. and may be Add a few new product_sku and new product_names
- What happens to the existing fields that are NOW blank( in new file) but were there earlier in Virtuemart? now after imported those fileds would be turned Blank?
-- or will get appended (add (something) to the end of a written document.)?

Hello,

What happens to the existing fields that are NOW blank( in new file) but were there earlier in Virtuemart? now after imported those fileds would be turned Blank?

Let me explain. In your Example VirtueMart Product export template, you should have only two template fields, product_sku and product_name. This way you will not have any other fields in your export file. Your export file will have only product_sku and product_name. Now when you import this exported file, no other fields will be updated. RO CSVI will only update the fields which are in your import file. Hope it is clear.

-- or will get appended (add (something) to the end of a written document.)?

With RO CSVI, in VirtueMart product import product_sku field is the needed field. And it is called needed field because we use the value in this field to identify the product in the VirtueMart products table. If the product_sku value is already there in database then the existing product will be updated. If the product_sku value is not in the database then a new product will be created. We are updating only one field the product_name field for the selected or inserted product.

I asked you to test with product_sku and product_name field as product_sku is a needed field and product_name is a basic field which has no processing on import. With this basic import we will know if your import itself has a problem or the fields you are importing are causing the errors. Let me know if you need any more clarification.

We downloaded i.e exported the file CSVI_Example VirtueMart Category Export_12-08-2019_09.49.csv

now we imported back the same file:: via : Example VirtueMart Manufacturer Category Import
Result : SUCCESS
-------------
but this does not work with PRODUCT ; Example virtueMart Producd import templete
The error comes is :
An error has occured during the import. Below the information received from the server.
Duplicate entry '' for key 'slug'

Is there a different procedure.

Hello,
You are having a empty entry for slug field and when another row of empty slug is inserted it throws "Duplicate entry '' for key slug" error. There should be no duplicates for slug field. You should have unique names for slug. If you want RO CSVI to creates slug for you, in your import template on Options tab set Recreate alias to yes, save the template and then run the import. RO CSVI will create slug from product names.

Thanks a ton.. can you please guide me where i find the "Recreate Alias" tab set.

I found the tab set : tab set Recreate alias to yes, then reimorted the file back.. same error happens.
An error has occured during the import. Below the information received from the server.
Duplicate entry '' for key 'slug'
i will continue trying.. kindly see and guide what could be the issue.
Also yeserday i was able to import back One Product data file successfully but immediately afer that the Same file refused to upload.. and i get the same error;
An error has occured during the import. Below the information received from the server.
Duplicate entry '' for key 'slug'
I wonder how that ONe file got through.. ( even i had added severl new product SKUs there.. some 500+ enteires) but now even the Same file that we export is not getting imported.

Hello,
In your import template settings go to Options tab >> Click on Advanced button on top right corner >> Look for Recreate Alias field and set it to Yes >> Save the template. Check attached screenshot for reference.

I tried to import another file.. attached.. that was imported in seconds.. chech the attached file please.
But when i import the Exported file.. there the problem is

Hello,
Can you also send me your exported file which has an issue on import?

This file was exported and without change i tried to import it back.
An error has occured during the import. Below the information received from the server.
Duplicate entry '' for key 'slug'

Hello,
Your exported file went without any errors when i tried import in my local server. I am thinking it should be some thing to do with your database. Can you send me you site login details and database access details to check?

I bought CSVI some few years back.. but then could not use.. paid for it but could not use with my little knowledge and gave up..

after all these years .. now again. i decided to buy again this time thinking i would work hard to make it work. but could not . then i turned to support forum here.
I think with your help this time round it will work. Thanks ..

Joomla https://servomotorexpert.in/administrator/index.php
SUPER USER name: instockspares
SUPER USE password: 1n$t0ck$pare$

Hello,

after all these years .. now again. i decided to buy again this time thinking i would work hard to make it work. but could not . then i turned to support forum here.
I think with your help this time round it will work. Thanks ..

We are here to help, i am sure it won't be difficult once you get to know how to use CSVI.

I am not able to access your administrator link, it says "Access Denied - Sucuri Website Firewall". Please whitelist my ip 124.123.100.156 to access the site.

Also please send me the database access details, that is where i can see how the slug values stored.

and for DATABASE :
Website URL: https://ua.siteground.com/login.htm
Login name:
Login: dubaisensors
Password: R@sAlKh@im@!(^*

go to Cpanel and then you know where to find database.. ( for servomotorexpert.com)

Hello,
The database access details also don't work. It says "Login Failed. Username or Password not recognized."

and for DATABASE :
Website URL: https://ua.siteground.com/login.htm
Login name:
Login: dubaisensors
Password: s1tegr0und

I appologize for mistake.

Hello,

Now when we go to main page: https://servomotorexpert.com/index.php
We see this:
TOO FEW ARGUMENTS TO FUNCTION SHOPFUNCTIONS::CATEGORYLISTTREELOOP(), 0 PASSED IN /HOME/INSTOCKSPARES/PUBLIC_HTML/http://SERVOMOTOREXPERT.COM/MODULES/MOD_NETBASE_VIRTUEMART_SEARCH/HELPER.PHP ON LINE 36 AND AT LEAST 7 EXPECTED

The error you see is not related to CSVI so i cannot help you with that.

The database login details you sent works but I still have problem in accessing administrator side of your site. I see "Access Denied - Sucuri Website Firewall". Can you whitelist my IP so i can access the site?