Product Import Error

[callam_kidsaw]

Hi,

When trying to import a CSV file full of products into our live Magento site, the following error occurs, how can I fix it?

Notice: iconv_strlen(): Detected an illegal character in input string in /var/www/vhosts/website/httpdocs/vendor/magento/framework/Stdlib/StringUtils.php on line 151

I have a site on my local machine under XAMPP with more or less a 1:1 same setup ratio and the CSV file works there.

Site version is 2.2.3 CE

[Manthan Dave]

Hi @callam_kidsaw

its because of there is some illegal character/string in your csv file which is not supported by import function of magento and that's the reason you are facing error.

Here i would suggest you to double check your csv file and remove illegal character which is found in the csv file then save it and import it again - you will not face this kind of error.

also for more details refer this link - https://magento.stackexchange.com/questions/57509/error-importing-csv-detected-an-illegal-character-...

Hope it helps

[callam_kidsaw]

Thanks,

where does he suggest to add Mage::log($string) ? is it above the line in String.php

[Manish Mittal]

Hello @callam_kidsaw

Open your CSV file in Open Office where you have control over the save options. Now save the file specifying UTF-8 and making sure you have the correct field breaks (, or \t). Upload it again now. 

[Manthan Dave]

Hi @callam_kidsaw

That is Mage::log($string) - for magento 1.

but here you just need to correct your csv sheet.

remove the illegal character from the sheet and save it again and upload it again

it will solved your problem

hope it helps