sqlstate 23000 integrity constraint violation 1048 column ‘value’ cannot be null magento

How to solve the problem ‘sqlstate 23000 integrity constraint violation 1048 column ‘value’ cannot be null magento’?

This problem is quite hard to identificate, because it’s hard to seek the right column ‘value’. Here is what I did in order to find out the problem.

  • Start the import process and see on which record number the errors occur.
  • Locate these record numbers and find the difference between other records in a spreadsheet program.
  • In my example I found out that on some rows the meta_robots column was empty instead of INDEX, FOLLOW. This caused the error.
  • Fill these rows. This will solve the problem.