How to Assign Products to Multiple Picking Locations through Excel Import

1. Create the product spreadsheet. 
Necessary Fields:
SKU
PRODUCT_NAME
WAREHOUSE
PICKING_LOCATION
Sheet Name: Sheet1
File Format: *.xls
Headers: No spaces
 
 
2. Go to Admin > Utilities
 
3. Click Excel Import/Export Tab >> Import Products
 
4. Browse for your file, Map the corresponding headers, and hit Next
 
5. Click Import
 
A prompt message with the reminders on formatting will appear. Confirm if ready.
 
"Data Imported successfully" - Click OK
 
 
6. To verify, go to Products >> Manage Inventory
Search for the Product, Select the Warehouse, and click on the Picking#
 
7. A list of the Picking Locations will be displayed according to the Excel spreadsheet
 
8. Verify if you have multiple warehouses by selecting the next warehouse(s) and Picking #