You can import your inventory using an Excel (.xls or .xlsx) file. There is a download template to help you structure your file, with or without headers. The import wizard walks you through the process of mapping the data, identifying the sub location to import the inventory into, and importing.
To import inventory
- On the Inventory tab, click Manage Inventory.
- If necessary, click change location to specify the sub location to which you want to import the inventory.
- Click Import Inventory. The Import Inventory page opens.
- If necessary, click Download template file for inventory import. The file is automatically downloaded.
- Click Choose File. Your browser’s file window opens.
- Locate and click the file, then click Open. The window closes and the file name appears on the page.
- If the file contains column headers, select the corresponding checkbox.
- On the lower right, click Upload. The Import Inventory page opens.
- Map each File Column Name to the appropriate EMSupply Field Name using the list on each row.
- Click Next.
- Click the region, location, and sub location to which you want to import the inventory.
- Click Next. You receive a confirmation with the total number of rows that will be imported to the selected sub location.
- Click Import. The Import Status window opens.
Note: A message identifies the import status. If an error occurs, you can download the error file to make corrections and try the import again.
- Click Close. The Import Inventory page opens.