Updating Bin Qtys Using an Import File

Click here for information related to Sellercloud's original interface.

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:Performing an Initial Product Bin Import will zero out quantities of all products in all warehouses included in the import file before Sellercloud does bin adjustments. 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.

 

Understanding 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 just be used the first time you are updating bin quantities. This is because the import will zero out quantities of all products in all warehouses included in the import file before Sellercloud does bin adjustments. Please contact Sellercloud Support before using this feature.

Basic product bin adjustment

Any bin quantity updates following the first, using Initial Product Bin Adjustment, will 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.


 

Updating bin qtys using an import file

  1. Access Inventory > Tools > Import Inventory Info.
  2. Select Import Warehouse Bin Info > Download template. You can choose from Excel, CSV, or TAB Delimited.
  3. 3. Populate file columns.sellercloud initializing bin update via import example excel template
  4. Return to Sellercloud > Click to upload file.
  5. Select an Adjustment Type > Import.

 

Was this article helpful?

Related Articles