Import Error Messages

\# written by liam pyne | last published at december 11, 2023 \# in this article, we are going to go through some of the error messages that may come up during importing via import chains this error occurs when the excel file contains fewer columns than the import template to fix this, match the number of columns in the excel file with the number of template lines also, follow the same sequence that is on the import chain when there is a null value in a column that should not have a null value, this error may come up to fix this, you must add a value to this column in this example, categ id has a null value this error message is related to the file that you are importing not being the correct import type to fix this, you must make sure this file is csv utf (comma delimited) ( csv) if your file is csv (comma delimited) this error message may still come up as the file type needs to be saved as csv utf (comma delimited) ( csv) to save a excel file as csv click file save as then click on the arrow below file name "could not convert string to float" is an error message that comes up when there are characters in the column where there should be numbers (integer and or float) in this example, 'cost price' should be a number, but the import has identified characters within the 'cost price' column string and float are data types to see and learn what the data types mean, please click on this link