Initializing / Updating Bin Qtys Using an Import File

Updated 2 months ago

Overview

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.


Access to the import template and import function

Home > Search > Manage Inventory > Import Product Info > Import Product Warehouse BIN Info.


Template fields

The following required fields need to be completed for proper bin update:

  • Warehouse
  • BinName
  • ProductID
  • QtyToAdjust (can be positive or negative)
  • Reason

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 button.

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 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 <Initial Product Bin Import>.
  4. Click Import Product Warehouse Bin Adjustment button.


How did we do?