Product Administration Exception Center - Import From Excel overview

Imported products must already exist in Product Setup and Product Warehouse Product Setup. Products from multiple warehouses can be included in the spreadsheet.

Select the Import From Excel option from the Action menu in Product Administration Exception Center. You must have the security required to perform the import. Select Allow Both Manual List and Excel from the Manual Product List Option in SA Operator Setup-Controls.

Format your spreadsheet to contain two columns only: a Whse column, and a Product column. Both of these values are required for all lines. The first row of the spreadsheet can contain the column headings, but it is processed. When a blank row is encountered, no further records are processed. You can also define a maximum number of lines, or rows, in the spreadsheet that are to be retrieved when you perform the import.

Any errors that are encountered, such as an invalid warehouse or invalid product, are highlighted in your spreadsheet, and a new Column A is added showing the error messages. At this point, you can proceed with the import of only valid records, or you can close the Import From Excel page, correct your spreadsheet, and import again. If you make corrections to the spreadsheet, remove the error Column A before you save the spreadsheet. There is no editing capability on the Import From Excel page.

Your Excel file must not be protected (read-only) or you will not be able to make corrections and save the file.