In a bustling warehouse, you may need to define the location and capacity of products in bulk. Fortunately, Logiwa makes this process simple. Not only can you define product capacities individually, but you can also import them in bulk, which saves you a considerable amount of time. This article will show you how.
Step-by-Step Guide
To begin, navigate to the Locations screen under Settings.
The Assign Capacity button is on the right hand side of the screen. Click this button and select Bulk Import Product Capacity.
You are now on the Bulk Import Product Capacity page. If you need to, download the Excel template file via the Download button.
Open the template. You will see some sample data to give you an idea of how to fill out the file. Please make sure to delete this data before uploading it.
File preparation guidelines/information:
This import document can be used to create new location product capacities.
Green-colored fields are required and cannot be left blank; gray-colored fields are optional and should be filled only when needed.
Do not alter the names of the columns, as the columns' distinct headers enable the system to match the Excel data with Logiwa's fields.
This sheet cannot be used to update existing product capacities.
The first line in the template is an example. Please delete this row before starting the import.
When the file is imported, please wait a few seconds, then click on the Refresh List button to see the results of your import.
Click the 3-Dot icon to see the import details. You can view lines that failed to import along with the failure reason.
Fill in the template according to these requirements and save it.
Once it's ready, upload the Excel file from the Bulk Import Product Capacity screen. You can either drag and drop your file into the blank space in the center or select Browse to find the file from local storage.
After you select the file, you should see it listed under file icon. Click the Upload button to continue.
After the file uploads your product capacity, another screen will load with the information you've imported. This is an opportunity to make sure your data matches with the fields in Logiwa.
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.
You will be directed to the upload screen and a message will show that your import was completed.
You can now check the status of your import. The bottom of the screen will display the history of your imports with the following information:
Status: This will say if your import was Successful or Failed
Row Count: This names how many rows were in your import.
Success Count: Count of successfully imported rows
Error count: Count of rows that were not imported due to errors
Uploaded By: User that uploaded the data
Creation Date: The date and time the file was uploaded
You can also click the Actions menu to access links to Details or Download Original File.
Selecting Details will take you to a sidebar that summarizes the upload with more information. If you had errors, this will give more information on the issue.
Couldn’t Find What You Were Looking For?
Visit our Help Center to search more documents!