What is a Bin?
Storage bins are an important part of the warehouse management system (WMS) to processing the shipping, receiving, put away and picking. A bin describes the position in the warehouse where the item is or can be stored. It is movable and is not necessarily permanent. A coordinate system is used to locate a storage bin. In Shipedge A2-102A01 indicates that the bin is located in row A, bay 2, stack 102, level 1.
After items are scanned in to a bin (bin has sku and quantity), changes to the inventory can be made by CSV or manually. Both these options are discussed below.
Bin tags are generated with in a location. The tags are scannable and allow the warehouse to track and store items by scanning
Inventory changes by csv
Inventory changes by CSV are divided in to Moves and Counts. The CSV file allows bulk inventory recount and multiple activities like renaming bins and locations, create new bins and kill empty bins. All these changes are traced with annotating changes (success and error reports) once the csv is uploaded.
We have 4 independent areas in Shipedge, and each of these areas have complete workflows. These areas are Kill Bin, Recount Quantity, Move to Bin, Move to Location.
All these processes take time and we wanted to reduce the time for our customers. With the complete update, you can do all these four things without entering each area in Shipedge. You can use a csv file (a csv is like an excel file) and place all the information needed, upload it and finish the process in one click.
- Warehouse tab – Using the WMS account, hover with the mouse over inventory and in the drop-down menu select Warehouse (pictured as warehouse below).
- Bin Management – In the Bin List look for Bin Management link and click on it
3. Filter the necessary data for your query. (Filter by content, Sku, Account, Bin…)
4. Click on Export to csv. The new file will be created and downloaded to your computer.
5. The CSV functions
Once you click on export to csv, you will have options to either select Move or Recount. Both these functions are explained in the below sections.
Recount – In addition to moving inventory to another location, recount product in bulk allows you to adjust quantity inside a bin. You can also kill bin (delete a bin you no longer need) and rename bin (change the Bin name).
Move – this file allows you to move inventory from one bin/location to another by adding a new bin/location number. You can also move the quantity in a bin to a different bin.
The CSV file is divided in 3 sections. In these sections you will view reference data, modify data, and description.
5.1.1 Reference Data
Data marked in figure 5.1.1 will work as a reference for the user. Figure 5.1.2 shows the system requirements to help the program with data processing. The optional data shows information useful to the client.
5.1.2 Modify Data
Here the user has different options to complete several processes, like: kill bin, move, or recount all at the same time. Figure 5.2.1 shows 11 options; these options are detailed in figure 5.2.3
Here the user has different options to view additional details on each inventory item and cross referencing once the changes are effective.
5.2.1 Reference data
Data marked in figure Figure 5.2.1 will work as a reference for the user.
5.2.2 Modify Data
Here the user has options to move an item to a new bin/location. For example, when moving from dock area to location. The user has an option to move the entire quantity in the bin by just adding the new bin/location or specify the amount that is being moved.
6. Import CSV
Select the recently modified file
After processing the csv file, the system will show the following message with one or two downloadable files.
Success file has a column at the end called “Message” where you will see the process result for each row
Error file has a column at the end called “Error” where you will see all the errors when processing the row.
The file with errors can be modified and processed again following the previous steps.
Errors and solutions
When modifying the data, you may see errors. The below table shows errors and corresponding adjustments the user may need to make when modifying data.
- Re-Count_Qty: Check format – You may not have made changes to the quantity if you see this error. You can ignore you would like it to remain the same.
- Sku: CurrentBIN: Required or check Current Sku – This error notifies user the Bin does not have Sku. You can only recount or move inventory with Sku.
- New_Bin/Location: Bin in use – If you see this error, you have attempted to move current Bin to a bin with quantity 1 or above. You must find a Bin with zero value or create a new bin
|1||Just kill_current_Bin only when CurrentQty equals zero||Kill_current_Bin is only successful when bin/location is associated with Sku and quantity is equal to zero.|
|2||Move all CurrentQty to New_Bin Kill_Current_Bin||Error|
|3||Move all CurrentQty to Location (The system will create a Bin inside the location) Kill_Current_Bin||You can create new BINs using the CSV file, but you can’t create new locations, you need to use available locations.|
|4||Recount CurrentQty with Re-count_Qty Move all CurrentQty to New_Bin Kill_Current_Bin||Recount CurrentQty with Re-count_Qty is only successful when bin/location is associated with Sku.|
|5||Recount CurrentQty with Re-count_Qty Move all CurrentQty to Location (The system will create a Bin inside the location) Kill_Current_Bin||You can create new BINs using the CSV file, but you can’t create new locations, you need to use available locations. Recount CurrentQty with Re-count_Qty is only successful when bin/location is associated with Sku.|
|6||Recount CurrentQty with Recount_Qty (in this case you can kill bin when the recount equals zero) Kill_Current_Bin||After recount, if the bin still has quantity 1 or more, you cannot kill bin|
|7||Move all CurrentQty to New_Bin||You can only move all CurrentQty to to a new bin or bin with 0 quantity, if you are moving it to a bin with quantity it will give you an error with “New_Bin/Location: Bin in use.”|
|8||Move all CurrentQty to Location (The system will create a Bin inside the location)||If there is an empty bin or bin with zero quantity in the new selected location, the system will move the items to this bin instead of creating a new bin. You can create new BINs using the CSV file, but you can’t create new locations, you need to use available locations.|
|9||Recount CurrentQty with Re-count_Qty Move all CurrentQty to New_Bin||You can only move all CurrentQty to a new bin or bin with 0 quantity You can also create a new bin and assign quantity and move to the new bin|
|10||Recount CurrentQty with Re-count_Qty Move all CurrentQty to Location (The system will create a Bin inside the location)||Recount CurrentQty with Re-count_Qty is only successful when bin/location is associated with Sku. You can create new BINs using the CSV file, but you can’t create new locations, you need to use available locations.|
|11||Recount CurrentQty with Re-count_Qty||Recount CurrentQty with Re-count_Qty is only successful when bin/location is associated with Sku.|
Manual Inventory Changes
You can also make changes to the inventory manually.
- Using the WMS account, hover with the mouse over inventory
- In the drop-down menu select Warehouse (pictured as warehouse below).
- Filter the necessary data for your query. (Filter by content, Sku, Account, Bin…)
- After filtering the data, you can select a particular item line to recount/move
- Select Recount to make changes to the quantity
- Click Move to transfer to a new bin/location
Once you click Recount, you will be taken to a page as below. The details and history of changes are provided at the top of the page.
- Make changes to quantity in Actual quantity bin
- If you do not want to make changes to quantity, simply select Quantities are correct
- Once done with making changes in step 1, click Insert
If you would like to make changes to bin/location, click add bin as shown below.
Once selected, the next window will give you options to make changes to bin/location and volume. Click submit after making the appropriate changes.
Users can also move items manually. By following same steps as above, hover your mouse on Inventory and click Warehouse.
On the top left of the screen you can filter the necessary data for your query. (Filter by content, Sku, Account, Bin…)
- You can select the inventory you would like to modify
- Click recount to make changes to bin/location or quantity
- The move option is also available
Once you click Move, you will see the below page. The page will provide history of changes made and will allow you to make additional changes.
- Here you can click the drop down and select the Bin you would like to move
- You will be able to see the details of the inventory in the Bin- sku, description and quantity
- You can click the drop down and select to the new Bin you would like to move it to
- You can enter the quantity you would like to move to the new Bin
- Click submit& process when you have completed modifying the data