Bin Location Items Import

Overview
To import items that are assigned to their respective bins.

Mandatory fields:
Bin ID: User has to provide the unique ID in the CSV file and it should not exist already in the binlocation table.Once the items are assigned, then if the bin location is in the store its stored in the Storebalances_binlocations table, if the bin location is in the warehouse then its saved in the warehousebalances_binlocations table.

Item ID : The item ID of the items that is be be placed in the bin are listed.

Quantity: The final quantity of the items in the bin. Example 10 items currently in the bin (adding 20 more), user would enter 30 for the quantity


Note - If there is no quantity of an item (0) then the import will fail. Before importing items into a Bin inventory must be received.

 

 

Actions performed on successful import:

On Successful import data will be inserted into the database under storebalances_binlocation and warehousebalances_binlocations.