How to solve the problem ‘sqlstate 23000 integrity constraint violation 1048 column ‘value’ cannot be null magento’?
- 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.