In a bustling warehouse, you may need to add numerous products simultaneously. Fortunately, Logiwa makes this process simple. Not only can you create locations individually, but you can also import your product locations 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 Products screen.
The Import button is on the right hand side of the screen. Click this button and select Bulk Import Products.
You are now on the Bulk Import Products 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 products.
Green-colored fields are required and cannot be left blank; gray-colored fields are optional and can 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.
All fields are broadly explained in the Field Description sheet.
The Glossary sheet contains information about countries and some of the list values.
This sheet cannot be used to update existing products.
The first line in the template is an example product. 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 Products 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 products, 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!