How to import item's BIN location?
Using CSV file to assign item's location
Go to Products -> Products
Select Import -> Location
Step 3: Create your csv import file
Download sample location file for the import format.
Edit the file downloaded
CSV file format
sku -> item sku
warehouse_id -> Id of the warehouse where bin location located. See How to find warehouse ID.
location_code -> Bin location code you create for a warehouse. See How to setup warehouse bin location.
quantity -> Item quantity you want to assign to bin location
primary -> Set '1' for Primary, '0' for Secondary.
You can set multible bin location for 1 item, when doing picking, system will show Primary location first.
How to find warehouse ID
Go to Settings > Warehouses
Click on "Edit" button of the Warehouse
On the last section of the page URL last section (On Browser), you will ge the warehouse id
Step 4: Import Option
Option 1: "Empty products locations before import."
If you select this option, all the existing locations for the item will be remove and new location will be assign to it. Select this option only if you want to clear all the location for item
Option 2: "Overwrite existing products location."
If you select this option, if the location exist, it will overwrite it.
Step 5: Upload file
Upload your CSV file and click "Upload" button to import the file.
Updated on: 28/01/2021