Failing to Import Items from Excel - Please Help

Install / Update Setup
1

Hello Team,
I’m trying to import items from excel. I have confirmed from ERPNext team that the excel is filled properly.
But when I try to import, I’m getting the error as below.

Import Log
Import Failed
Error for row (#21) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#22) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#23) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#24) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#25) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#26) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#27) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#28) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#29) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#30) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#31) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#32) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#33) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#34) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#35) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#36) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#37) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#38) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#39) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#40) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#41) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#42) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#43) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#44) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#45) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#46) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#47) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#48) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#49) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#50) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#51) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#52) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#53) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#54) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#55) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#56) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#57) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#58) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#59) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#60) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#61) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#62) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#63) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#64) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#65) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#66) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#67) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#68) : ‘NoneType’ object has no attribute ‘lower’
Error for row (#69) : ‘NoneType’ object has no attribute ‘lower’
Please correct and import again.

2

There is some column that requires text. Did not find this in the product. Do you have a custom app that might be causing this?

3

Hello, no i dont have a custom app. i downloaded the virtualbox image and started customizing. is there a way i can send you the excel file am trying to import? because i filled all the columns that are mandatory.
thanks in advance.

4

@rhacio if you want one-on-one support, you can subscribe to one of our plans.