General info

Import Field relations with general data 

 If you filled in the following columns in the Excel file: 

 

 Cost Code 

 Currencies 

 Product categories 

 Units 

 

 Then this data must exist in the Administration module. 

 All fields in the Excel file must be in text format. 

 For example, if there is a problem after importing inventory with the PartNumber (column C) change the format of this column (Right mouse click on this column, select Format Cells) to the category  General . 

 

 Do not change the top row of the Excel file! If this is changed, the import will fail!