All Collections
Setup
Location
Import Locations via Excel File
Import Locations via Excel File

How to import your warehouse locations with an Excel file.

mario avatar
Written by mario
Updated over a week ago

In addition to creating locations one by one, you can also upload your warehouse locations in bulk, saving you time during the warehouse setup process.

Step-by-Step Guide

  • To begin, navigate to the Locations screen.

  • Once the Locations screen loads, select Import Locations from the top right of the screen.

  • Click the Download button to save the Excel template you are going to fill out to import your data.

  • Open the Excel template. You will now fill the import file with the details of new locations. You can view the requirements for the template in the second tab, and explanations for each column in the third tab.

  • File preparation requirements:

    • Green-colored columns are required and cannot be left blank.

    • The Warehouse Code must be identical to the code used in Logiwa.

    • Path-related columns (Walking Path Priority, Level, Aisle) and locations' physical measurements (Width, Height, Length) must have numeric values.

    • Locations' function related columns (Receipt, Return, Damaged, Packing) must have True or False values.

    • All columns must have their unique headers as shown in the template. It is not possible to upload data placed under columns with headers that differ in any way.

    • If you prefer to use an existing file rather than the template, ensure the column names are identical to the template's columns in spelling, punctuation, and capitalization.

  • Fill in the template according to these requirements and save it.

  • Once it's ready, upload the Excel file from the Import Location screen. You can either drag and drop your file into the blank space in the center or select Click Here to find the file from local storage.

  • After the Excel file imports, the Upload button becomes available at the bottom right corner of the screen. The imported file can be also seen to the left.

  • Press Upload to continue.

  • Before concluding the upload, an overview screen appears to let you check your imported file one last time.

  • The Matched column will display a green check if Logiwa Fields and File Column Headers match for each column. Otherwise, a red X will indicate a mismatch.

  • The Preview Data column shows the initial 3 rows of your data as a sample.

  • If there is a mismatch between Logiwa and the excel file's columns, you can select which Logiwa field corresponds to your file's column by pressing Choose Field and then selecting from the dropdown menu.

  • As long as the field has not already been used, it can be selected.

Once an unused Logiwa field is selected, the Matched column will change to a check mark.

  • Make sure each section is matched to a Logiwa field, then press the Import button in the bottom right corner to finalize the process.

  • After the import is completed, the outcome is listed on the Import Location screen.

  • Check that all uploaded rows were successfully imported.

  • If your file's error count is anything other than 0, something went wrong with the upload. In order to see the reason for the error, select the Details button:


Couldn’t Find What You Were Looking For?

Visit our Help Center to search for more documents!

Did this answer your question?