Importing warehouse bin information enables you to adjust bin quantities for multiple SKUs simultaneously. Rather than manually updating each SKU, you can make the necessary adjustments in a spreadsheet and easily import the file into the Skustack Admin portal to apply the changes.
Import Warehouse Bin Info
Initial Product Bin Adjustment
Basic Product Bin Adjustment
Any bin quantity updates following the Initial Product Bin Adjustment should use the Basic Product Bin Adjustment type.
Enter a simple positive or negative value in the bin quantity field to adjust the amount. For example, if you have 5 items in the bin and want to reduce it to 3, you would enter -2 as the adjustment.
Bin Adjustment Import
To adjust Bin Quantities using a file import through the Skustack Admin portal:
- Navigate to Bins > Import Warehouse Bin Info.
- Click the Download icon to get a template file. Choose the preferred format for the template: Excel, CSV, or TAB Delimited. Populate the file columns with the relevant data.If the Lot Number workflow is enabled for your company and the product/s are set as expirable, you must include a Lot Number and Expiry Date.
- Return to the grid and upload the file.
- Select the Adjustment Type you want to perform and click Import.