One need to care about couple of things while importing inventory by excel.
1) Must have all the store items and menu items already created in the software. (If any new items are added in the file would not get added).
2) Unit of Menu Items AND unit of Store item, which are already assigned to particular item(s) MUST be the same. (Unit name should be same).
3) Name of menu item name and store item name should be similar, single space can cause a problem.