Throughout This Page
You can jump to the specified sections by clicking on these titles.
Navigating to the Inventory Location Import/Export Page
Click the "Settings" icon on the left-hand side of the screen. Next, choose the "Inventory Locations" icon, and then click the "Imports/Exports" button as highlighted below on that page.
Importing
The CSV file import feature for inventory locations provides an efficient method for configuring and managing different categories of inventory storage areas. This capability allows you to establish diverse inventory location types for warehouse management quickly. Instead of manually editing each location, you can make bulk updates by importing a CSV file, streamlining the process, and enhancing your stock management practices. Subsequently, you can associate these customized inventory locations with your existing inventory items to facilitate more organized stock handling.
Importing will overwrite existing data, so please verify your imported data carefully.
In the mapping tool, you can match the headers in your CSV file with the corresponding fields on our platform. It's crucial to ensure accurate mapping to guarantee the correctness of the imported data. If your file's headers align with our platform's expected headers, they will be automatically matched.
Here is an empty file containing all the necessary headers to facilitate your customisation. Fill in the required details according to your specific needs.
When importing inventory locations, you can map the following fields with their corresponding explanations:
| Compulsory Header | Header | Header Description | Example Input |
| YES | Location Name | It specifies the name of the inventory location. This name serves as a unique identifier for the location. | Example Location Name |
|
YES |
Location ID |
It contains a unique identifier (ID) for the inventory location. It aids in accurately associating the location during the import process. |
5001 |
|
NO |
Location Type ID (1: Tote) (3: Shelf) (4: Warehouse) (5: Pallet) (6: Box) (7: Assembly) (9: Faulty Stock) |
This field designates the type of the inventory location using a numerical identifier. The Location Type IDs correspond to specific types such as Tote, Shelf, Warehouse, Pallet, Box, Assembly, and Faulty Stock. |
4 |
|
NO |
Parent Location ID |
It references the ID of a parent location, if applicable. It establishes a hierarchical relationship among inventory locations. | 0001 |
| NO |
Pickable (1 = Yes, 0 = No) |
This field allows you to indicate whether the location is pickable, aiding in efficient order fulfillment. | 0 |
|
NO |
Priority |
This field provides an optional parameter for setting priority levels for specific inventory locations. A smaller number in the "Priority" field indicates a higher priority for the inventory location. |
1001 |
| NO |
Allow Negative (1 = Yes, 0 = No) |
This field determines whether negative stock levels are permissible for the location. | 1 |
| NO |
On Hand Stock (1 = Yes, 0 = No) |
It indicates whether the location contains on-hand stock. | 0 |
| NO |
Allow Box Splitting (1 = Yes, 0 = No) |
It specifies if box splitting is permitted at the location. | 1 |
| NO | Warehouse ID | This field refers to the identifier of the warehouse to which the inventory location belongs. | 2524 |
After mapping the fields from the CSV file to the platform, click the "Submit Mapped Data" button at the bottom of the page.
Exporting
Take advantage of the convenient data export feature to ensure you have a backup of your valuable data. A highlighted text link at the bottom of the page holds the key to safeguarding your information.
With a simple click on this highlighted text, you'll initiate the export process, securing your existing data and providing you with a safety net in case any unexpected changes occur. Having a recent export of your data adds an extra layer of confidence and preparedness to your operations.