Import Warehouse Locations
This import is used to create warehouse locations when using the Multi-Location add-on module. To Import Warehouse Locations, go to File > Import Data > Product > Warehouse Locations.
Create an Excel spreadsheet with your column headings for each field name you wish to import. Using Import Data, map the file location for your spreadsheet to the Filename, choose the correct worksheet if you have multiple sheets in your Excel file, name your import, then use the Columns tab in order to map each Column to its corresponding field.
Required fields are Location and Warehouse.
Locations
Data Field | Type(Length) | Notes |
---|---|---|
Active | Yes/No | Indicates whether the warehouse location is active or inactive |
Location | Text(80) | |
New Location | Text(80) | Used to rename locations |
Sequence | Number | |
Warehouse | Text | Warehouse ID or Description as defined in Configuration Manager |
Zone | Text(50) |
Import Data Specs
• Import Balance Adjustments
• Import Customer Information
• Import Customer Product IDs
• Import Inventory Receipts
• Import Inventory Transfers
• Import Lot/Serial Numbers
• Import Products
• Import Product Class
• Import Product Components
• Import Product Prices
• Import Product Type
• Import Alternate Product IDs
• Import Shipments
• Import Warehouse Locations
• Sales Order Import Mapped Fields
• Import Customer Information
• Import Customer Product IDs
• Import Inventory Receipts
• Import Inventory Transfers
• Import Lot/Serial Numbers
• Import Products
• Import Product Class
• Import Product Components
• Import Product Prices
• Import Product Type
• Import Alternate Product IDs
• Import Shipments
• Import Warehouse Locations
• Sales Order Import Mapped Fields