Step 1. There is only one way to open the Import Items screen of the Advanced Inventory.

From the left menu by clicking on Advance Inventory -----> Import Item.

Step 2. Users click "Import Items", a new screen open to import the CSV / Excel file records. 

Step 3. Users click on "Click here to down Template File".

Now save data according to the "Template" file format.

Step 4. Users open to download "Template file" and enter data in the "Excel file" sheet.

Step 5. User Select Files and click on the "Attach" button then upload the import file. 

1.Select Files: Users will select CSV & Excel files to be uploaded by clicking on this button.

2.Attach: Users will Upload the file by clicking on this button.

3.Remove Files: User will click this button then file are removed.

4.Upload to Items: Users click the "Upload to Items" button, we have an Excel file uploaded which we can see in the item master screen.

6.Item Code: Users can select one of the 'Item Code' in this dropdown.

7.Item Name: Users can select one of the 'Item Name' in this dropdown.

8.Item Description: Users can select one of the 'Item Description' in this dropdown.

9.Item Type Name: Users can select one of the 'Item Type Name' in this dropdown.

10.Standard Cost: Users can select one of the 'Standard Cost' in this dropdown.

11.Unit Cost: Users can select one of the 'Unit Cost' in this dropdown.

12.Current Cost: Users can select one of the 'Current Cost' in this dropdown.

13.Unit Price: Users can select one of the 'Unit Price' in this dropdown.

14.Item UOM: Users can select one of the 'Item UOM' in this dropdown.

15.UPC Code: Users can select one of the 'UPC Code' in this dropdown.

16.Costing Method: Users can select one of the 'Costing Method' in this dropdown.

17.Account Name: Users can select one of the 'Account Name' in this dropdown.

18.COGS Account Name: Users can select one of the 'COGS Account Name' in this dropdown.

19.Asset Account Name: Users can select one of the 'Asset Account Name' in this dropdown.

20.Purchase Description: Users can select one of the 'Purchase Description' in this dropdown.

21.Qty Allocated: Users can select one of the 'Qty Allocated' in this dropdown.

22.Qty On Production: Users can select one of the 'Qty On Production' in this dropdown.

23.Qty On Purchase Order: Users can select one of the 'Qty on Purchase Order' in this dropdown.

24.Qty Back Order: Users can select one of the 'Qty Back order' in this dropdown.

25.ReOrder Point: Users can select one of the 'ReOrder Point' in this dropdown.

26.Shelf No: Users can select one of the 'Shelf No' in this dropdown.

27.Item Category: Users can select one of the 'Item Category' in this dropdown.

28.Tax Code Name: Users can select one of the 'tax Code Name' in this dropdown.

29.Preffered Vendor Name: Users can select one of the 'Preffered vendor Name' in this dropdown.

30.Parent Item: Users can select one of the 'Parent Item' in this dropdown.

31.Is Active Status: Users can select one of the 'Is Active Status' in this dropdown.

32.Part Number: Users can select one of the 'Part Number' in this dropdown.

33.SKU: Users can select one of the 'SKU' in this dropdown.

34.Purchase Description: Users can select one of the 'Purchase Description' in this dropdown.

35.Standard Stocking level: Users can select one of the 'Standard Stocking Level' in this dropdown.

Step 6. User click "Upload to Items" button then "Excel file" are uploaded.

Go to "Item Master" it will see to saved record in the "Inventory" screen.