Import Physical Inventory

[accordions id=’6627′]

Understanding physical inventory

Setting a physical inventory refers to setting the actual quantity of the product in a warehouse. The quantity entered is the quantity you have in stock.

You can set the physical inventory on multiple products using a file import. Inventory is stored in warehouses, so the file will reference to which warehouse you are setting the physical inventory.


Importing physical inventory

  1. Select InventoryTools > Import Inventory Info.
  2. Click Import Physical Inventory.
  3. Select your Format > Download a template > Populate the columns.

  4. Save your file > Return to Sellercloud > Click to Upload File. Select your Update Type, Warehouse, and Inventory Date > Import.

Typically, the Update Type should be set to Partial (this is the default selection). Read about Update Types below.

The inventory date and time displayed on this page are the date and time of the import, not the date and time of the actual counting. Both time frames will be logged, but the date entered on the template will take precedence over the page’s time stamp. If there is no date and time entered on the template, then the date and time of the import will be used as the date and time of the physical count.


Understanding and using update types

UPDATE TYPE

DESCRIPTION

Partial 

(Strongly Recommended)  

Import will only set the physical on SKUs that are in the file. No other SKU will be affected. Likewise, it will only affect inventory quantity in the warehouse entered on the file. 

Full 

Will set any SKU in the system that is not in the file to a quantity of zero. Typically, a full update is only done when the count accurately reflects the complete inventory and you want to zero out any other item that is in the system.

Full Update by Warehouse

Open Client Settings and check Enable Warehouse Inventory Import by Warehouse. A warehouse dropdown will display when Full Update is selected. By selecting a warehouse, inventory in the selected warehouse alone will be affected. Inventory in other warehouses will be ignored. This means that any product not in the file will be will be zeroed out in the selected warehouse and inventory in other warehouses will be unaffected. Please note the following conditions:

  • The warehouse in the file must match the warehouse selected. If it does not, an error will appear.

  • The file must have only one warehouse- the matching warehouse. If the file contains additional warehouses an error will appear.


Automating inventory imports

Physical inventory can be imported from an FTP (File Transfer Protocol) using the scheduled task Import Physical Inventory. If the file format matches the Sellercloud format, use the plugin type None. If the file is formatted differently a plugin would need to be created and select on the scheduled task. Read about setting up a scheduled task.


 

Was this article helpful?

Related Articles