Skip to main content
Eptura Knowledge Center

Import your Inventory

Level: Administrator

The Inventory Import is used to import your inventory into a warehouse.

Step 1. Download our sample file

  1. Navigate to Settings.
  2. From Tools and Support, click on the Import clipboard_e2f7734169606f74f6b9db1dc625fc659.png icon. The Import Tool dialog displays.
  3. Click Inventory.The Part Import Screen displays.

clipboard_ea0c3cd5d7015ffb0f4091578d6a9f082.png

  1. Click on Sample-Log-File.Csv to download the sample import template.

Step 2. Complete the sample file

  1. Open the Sample-Log-File.csv file in Microsoft Excel.
  2. Remember the data in this file is a sample; you must delete these rows as you do not want to import these in.

clipboard_ea18e758c53a150e86ce20a9ba939682d.png

  1. Under each of the Column Headers, complete the row data. For details on the data, see Inventory Import Template Data
  2. After all the data has been entered on the sheet, save the file to your computer.

Step 3. Upload the completed sample file

  1. From the Select a Site drop-down, select a site.
  2. From the Select a Warehouse drop-down, select a warehouse.
  3. Click the Choose File button.
  4. Navigate to the file and select it. The file name displays in the screen.
  5. Click the Map Data button. The import fields displays.

Step 4. Map the data

The Map Data table shows which fields from the import file are being mapped to the fields in the application. Use the Map Data table to align the correct fields from the import file to the application. In this example, Status is mapped to Serial, which needs to be corrected.

  1. Verify that all ManagerPlus Fields are matched with the correct Import File Fields.

clipboard_e2794dd592dccc6a982d1a5420eb99dc2.png

If you find a discrepancy, click on the incorrect import field and the drop-down arrow displays. Then you can click the arrow to select the field to map to.

  1. If need, click the +Add Custom Field link to add any custom fields.
  2. Click the Preview button. The Review Your Data screen displays.

Step 5. Validate and import

Use the Import and Errors tabs to validate and review your data before importing.

  1. The import tab displays successful line items. 

clipboard_e82e1fe1aa1bdb13c5ebb1f78f683debe.png

  1. Click on the Errors tab. The line items with errors display. All records can be edited before importing. 
  2. Review all the data in the import tab and correct any errors. Drag the scroll bar from left to right in the bottom row to view all the mapped fields.

clipboard_e1cd5c1af56e636cfde125a9916710f69.png

Fields highlighted in:

  • Red - Indicates that a required field is missing information and must be filled in. Click in the field and complete the data.
  • Yellow - Indicates that the entered asset type does not exist but will be created upon importing.
  1. Now you are ready to import. Click on the Import button. The inventory data is imported and available in the Inventory module.

clipboard_e21a2ef045643f4ab7090c78d1d122664.png