Product Bin Inventory Management

Overview

Due to warehouse reorganizations, too many products in an existing bin (spillover), or the need to remove damaged items from a bin, you may need to adjust recorded quantities in individual bins and make transfers of quantities between bins. Sellercloud facilitates this through the Warehouse Bins function.


Transfer and Adjust Bin Inventory

  1. Go to Inventory > Manage Inventory. Search for the product and click its SKU.                                     inventory product sku
  2. In the Toolbox, select Warehouse Bins.toolbox warehouse bins
  3. In the Warehouse Bins tab, you can do the following actions:
    1. Adjust Inventory
    2. Transfer Bin Inventory
    3. View Movements

To Transfer Bin Inventory:

  1. Click the Transfer Bin Inventory button. transfer bin inventory
  2. In the Transfer Inventory window, complete Warehouse, MOVE TO, and Qty to Move fields. Click Send, and the bins will reflect their new quantities.

To Adjust Bin Inventory:
  1. Click the Adjust Inventory button.adjust inventory icon
  2. In the Adjust Inventory window, complete the Qty field. You can also complete the optional Reason field. Click Adjust. adjust bin inventory window

Adjustment Types

Sellercloud, through the use of an import file, offers the ability to initialize or update bins using an Excel template. Additionally, if your bin quantities are maintained in a system external to Sellercloud, this is an easy way to update all quantities in Sellercloud at one time.

Initial Product Bin Adjustment

This adjustment type should only be used the first time you are updating bin quantities. This is because the import will set any SKU in the system that is not in the file to a qty of 0 in all bins. Typically, an Initial Product Bin Adjustment is only used when you are sure that what was counted accurately reflects the complete inventory. Please contact Sellercloud Support before using this feature.

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/negative value in the bin quantity you are setting. Example: If you have 5 qty in the bin and want to only have 3, you would adjust -2.


Update Bin Qtys With the Help of an Import File

  1. Access Inventory > Tools > Import Inventory Info.
  2. Select Import Warehouse Bin Info and click Download. Choose the format for the template: Excel, CSV, or TAB Delimited.download template icon
  3. Populate file columns.bin template file
  4. Return to Sellercloud > Click to upload file.
  5. Select an Adjustment Type > click Import.import excel file

 Overview

Due to warehouse reorganizations, too many products in an existing bin (spillover), or the need to remove damaged items from a bin, you may need to adjust recorded quantities in individual bins and make transfers of quantities between bins. Sellercloud facilitates this through the Bins Details function.

Steps to transfer inventory between bins and adjust quantities
  1. Go to the Inventory tab, search for a SKU, click on it.
  1. Click Bin Details to display the Warehouse Bins page.
  1. Here you can:
    1. Do bin transfers by selecting the bin and selecting Transfer from the Select Action drop-down,
    2. Adjust Inventory or Set Physical Inventory.
Transfer
  1. Click the checkbox next to a warehouse and press GO. The Transfer Bin page is displayed..
  2. Enter a Bin Name in Move To Bin.
  3. Enter a quantity in QTY to Move.
  4. Click Transfer Now. The bins reflect their new quantities.
Adjust Inventory (increases/decreases bin quantity)
  1. Select Warehouse.
  2. Enter Bin Name.
  3. Enter Qty to Adjust.
  4. Enter Reason.
  5. Click Adjust Inventory.
Set Physical Inventory (overrides bin quantity)
  1. Select Warehouse.
  2. Enter Bin Name.
  3. Click Set Physical.
Updating Bin Qtys Using an Import File
Understanding bin quantities Sellercloud, through the use of an import file, offers the ability to initialize or update bins using an Excel template. Additionally, if your bin quantities are maintained in a system external to Sellercloud, this is an easy way to update all quantities in Sellercloud at one time. You can either import a basic product bin adjustment or an initial product bin adjustment The following required fields need to be completed for proper bin update:
  • Warehouse
  • BinName
  • ProductID
  • QtyToAdjust (can be positive or negative)
  • Reason

Accessing the import template and import function Home > Search > Manage Inventory > Import Product Info > Import Product Warehouse BIN Info.
Basic Product Bin Adjustment A simple positive/negative value in the bin qty you are setting. Example: If you have 5 qty in the bin and want to only have 3, you would adjust -2.
  1. Complete the ProductWarehouseBinAdjustment.xls template and save it to your local machine.
  2. Click Choose File and locate the file saved in step 1.
  3. Ensure that the Adjustment Type is Basic Product Bin Adjustment.
  4. Click Import Product Warehouse Bin Adjustment.

Initial Product Bin Adjustment
Warning: This adjustment type should only be used the first time you are updating bin quantities. This is because the import will set any SKU in the system that is not in the file to a qty of 0 in all bins. Typically, an Initial Product Bin Adjustment is only used when you are sure that what was counted accurately reflects the complete inventory. Please contact Sellercloud Support before using this feature.
  1. Complete the ProductWarehouseBinAdjustment.xls template > Save your file.
  2. Click Choose File > Select the saved file.
  3. Select Adjustment Type > Initial Product Bin Adjustment.
  4. Click Import Product Warehouse Bin Adjustment.

Was this article helpful?