Import Bin Locations

To create or edit multiple bin locations at once, we can use the Import Bin Locations function.  Through this import function, we can create a new bin location, assign a Zone location to an existing bin, unassign a Zone location from an existing bin, and change the Zone location to an existing bin.

For information on how to create and edit single bin and zone locations, please see this document.

How to get to the Import Page

To get to the import page, follow these steps:

1. Hover over Configuration and click "locations." 
2. This will direct you to the locations list. Search for the desired depot location where you want to import bins. You can use the filters to search for the location or scroll through the locations list. 
3. Select your desired location by clicking on the location name.

Import Bin

On the Bin locations tab, we have the option to Import Bin Locations. To import a file, we must first create the import file. Please see below for instructions on the import file:

• Open an excel file.
• In the excel file, we will use two columns with the headers: Bin and Zone.
• Enter the details of the bin location and zone locations in the respective columns. Entering a Zone location is optional. In my example file, I have added a new bin (Bin 3) and assigned zone locations to existing bins (Bin 1 and Bin 2). 
• After the data entry is complete, we must save the file in .xls format. Click on File > Save As > Select the destination. Under the Save as type, select Excel 97-2003 Workbook. 
• Now, we can go back to OpenBoxes > Click on Import Bin Location. Choose the saved file and click on Import Bin Locations. Notice how the format is .xls below.
• We will see a message stating that the import has been successful.