Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Inventory Importing

The inventory import feature in MiMS allows for inventory to be easily imported to the system to both update existing inventory details and add new inventory items.

The Inventory Importing both updates existing products in MiMS and adds new products into the system. The Inventory Import is a two in one feature. It will both update an existing inventory item and add new inventory items into MiMS. The Inventory Importing feature is located under the Data Management Side menu of the Utilities Menu.

  1. First is the Select File window. This window is where you choose the Price you wish to use for updating\add data into the inventory, select which of the worksheets in the excel file the data is on, and select which Supplier in MiMS the imported data is related too.
  2. The next window is the Column Mapping Window. The Column Mapping window is where you decide which areas in the excel file are related to the MiMS inventory and which key item(s) are used for comparing against.

    **Any items that are marked as KEY items must match exactly for the system to recognize them as existing items and update them.
  3. Next is the Select Data window where you choose which columns of data in the excel file are to be imported into MiMS for updating/adding.
  4. The final window is the Launch window. When the Finish button is clicked on this window MiMS will proceed to do all the comparison and update/add items in the inventory.