How to import Item Master from Excel File?

1. Prepare an Excel Spreadsheet with the following format. (Download sample from attachment)

2. Save the File as an normal Excel File. 

3. Make sure all the supporting table (e.g. Item category, stock unit, sub category, etc) are already defined in ERPro.

4. In ERPro, go to Inventory -> Maintenance -> Item Master, Click New button. Click the "Import" button and locate the Excel file saved in step 2.

5. Wait until the import process complete.

Jansen Lam,
Feb 6, 2009, 8:31 PM