"Integrity constraint violation: 1048 Column 'entity_id' cannot be null" while importing products about import HOT 9 CLOSED

@denvit + @niclashoyer I've another customer who faced this problem today (I think it's the same one). He send me the CSV file so hopefully I'll be able to reproduce the issue. I'll check it today or tomorrow and come back to you :)

from import.

Hi @niclashoyer, is it possible that you provide the file with the products?

from import.

Unfortunately the file is too big to share, I'll try to find a canonical example.

from import.

I found a minimal example just containing one line, I'll send it to you via email

from import.

Oh, further inspection may solve this already: the column for the categories just had / in it, so just the seperator. This might trigger unexpected behavior on import. Removing this resolves this error (I get other SQL errors for duplicate entries in cataloginventory_stock_item but that may not be related to this)

from import.

@niclashoyer did you solved this issue with cataloginventory_stock_item as I'm having the same error?

from import.

@wagnert I'm debugging right now and will let you know on Slack if I've found out something that could help you.

from import.

Hi @niclashoyer, sorry for answering late. I had a look at your file and the categories column contains a simple /, which leads to the problem I think. If you want to use a value - you can also leave it empty for sure, you have to specify the name of the root category, e. g. Default Category. Hope that helps :)

from import.

yes, removing the / fixed it, thanks. A better errors message would be cool.

from import.